• Power BIIntroduction
• Data Visualization,Reporting
• Business Intelligence(BI), Traditional BI, Self-ServicedBI
• Cloud Based BI, On PremiseBI
• Power BIProducts
• Power BI Desktop (Power Query, Power Pivot, PowerView)
• Flow of Work in Power BIDesktop
• Power BI Report Server, Power BI Service, Power BIMobile
• Flow of Work in Power BI / Power BIArchitecture
• A Brief History of PowerBI

• Power BI Desktop Installation
• Building Blocks of PowerBI
• Datasets, Visualizations, Reports, Dashboards,Tiles
• Power BI Desktop UserInterface
• Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab,Canvas
• Overview of Power Query / Query Editor – Extract, Transform & LoadData
• Connecting to Data Sources, Establish connection to the Excelsource
• Importing Data into Power BI or QueryEditor
• Transforming the Data using PowerQuery
• Model the Data using Power Pivot – RelationshipView
• Creating New Measures and New Columns using DAX – DataView
• Visualizing the Data using Power View and Power Maps – ReportView
• Saving and Publishing the Visuals orReports
• Logon to Power BIService
• View the Reports in PBI Service and Share thereports

• Data Transformation, Benefits of DataTransformation
• Shape or Transform Data using PowerQuery
• Overview of Power Query / Query Editor, Query Editor UserInterface
• The Ribbon (Home, Transform, Add Column, ViewTabs)
• TheQueriesPane,TheDataView/ResultsPane,TheQuerySettingsPane,FormulaBar
• Advanced Editor – Complete ETLCode
• Saving Your Work – Appling ETL Changes – Loading into Power PivotModel
• Power QueryConceptually

• Remove Columns / Remove OtherColumns
• Name / Rename aColumn
• Reorder Columns or SortColumns
• Add Column / CustomColumn
• SplitColumns
• MergeColumns
• PIVOT, UNPIVOTColumns
• TransposeColumns

• Header Row or Use First Row asHeaders
• Keep Top Rows, Keep BottomRows
• Keep Range ofRows
• Keep Duplicates, KeepErrors
• Remove Top Rows, Remove Bottom Rows, Remove AlternativeRows
• Remove Duplicates, Remove Blank Rows, RemoveErrors
• Group Rows / GroupBy

Append Queries / Union Queries

• AppendQueries
• Append Queries asNew
• Append 2 or more files individually with different queries
• Appending multiple files of same type from a folder using single query
• QueryOptions
• Copy Query, PasteQuery
• Delete Query, RenameQuery
• Enable Load, Include in reportRefresh
• Duplicate Query, Reference Query
• Move to Group, Move Up, MoveDown

Merge Queries / Join Queries

• • Merge Queries, Merge Queries asNew
  • Default Types of Joins / Join Kinds / MergeType
    • Left Outer (all from first, matching from second)
    • Right Outer (all from second, matching fromfirst)
    • Full Outer (all rows from both)
    • Inner (only matching rows)
    • Left Anti (rows only infirst)
    • Right Anti (rows only in second)
  • Cartesian Join or CrossJoin

• Data ModelingIntroduction
• Relationship, Need ofRelationship
• Relationship Types / Cardinality inGeneral
• One-to-One, One-to-Many (or Many-to-One),Many-to-Many
• AutoDetect the relationship, Create a new relationship, Edit existing relationships
• Make Relationship Active or Inactive
• Delete a relationship
• Cross filter direction (Single, Both), Assume ReferentialIntegrity

• What is DAX, Calculated Column,Measures
• DAX Table and Column NameSyntax
• Creating Calculated Columns, CreatingMeasures
• Implicit Vs ExplicitMeasures
• Calculated Columns VsMeasures
• DAX Syntax & Operators
• DAX Operators
• Types ofOperators
• Arithmetic Operators, Comparison Operators, Text Concatenation Operator, Logical Operators

• Date and TimeFunctions
• LogicalFunctions
• TextFunctions
• Math & Statistical Functions
• FilterFunctions
• Time IntelligenceFunctions

• YEAR, MONTH,DAY
• WEEKDAY, WEEKNUM
• FORMAT (Text Function) 🡪Month Name, WeekdayName
• DATE, TODAY,NOW
• HOUR, MINUTE, SECOND,TIME
• DATEDIFF, CALENDAR
• Creating Date DimensionTable

• LEN, CONCATENATE(&)
• LEFT, RIGHT,MID
• UPPER,LOWER
• TRIM, SUBSTITUTE,BLANK

• INT
• ROUND, ROUNDUP,ROUNDDOWN
• DIVIDE
• EVEN,ODD
• POWER, SIGN
• SQRT, FACT
• SUM, SUMX
• MIN,MINX
• MAX, MAXX
• COUNT, COUNTX
• AVERAGE, AVERAGEX
• COUNTROWS,COUNTBLANK

• Time IntelligenceIntroduction
• TOTALMTD, TOTALQTD,TOTALYTD
• PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER,PREVIOUS YEAR
• NEXTDAY, NEXT MONTH, NEXT QUARTER,NEXT YEAR
• SAMEPERIODLASTYEAR
• YOYGrowth
• MOMGrowth

• Report View UserInterface
• Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab,Canvas
• VisualInteractions
• Interaction Type (Filter, Highlight,None)
• Visual Interactions Default Behavior, Changing theInteraction

• Report View UserInterface
• Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab,Canvas
• VisualInteractions
• Interaction Type (Filter, Highlight,None)
• Visual Interactions Default Behavior, Changing theInteraction

• FilterTypes
• Visual Level Filters, Page Level Filters, Report Level Filters, Drill ThroughFilters
• Filter SubTypes
• Basic Filtering, Advanced Filtering, Top N, Relative DateFiltering
• Numeric field filters, Text field filters, Date and Time fieldFilters

• Grouping and BinningIntroduction
• Using grouping, Creating Groups on TextColumns
• Using binning, Creating Bins on Number Column and DateColumns
• Sorting Data inVisuals
• Changing the Sort Column, Changing the SortOrder
• Sort using column that is not used in theVisualization
• Sort using the Sort by Columnbutton

• Hierarchy Introduction, Default DateHierarchy
• Creating Hierarchy, Creating Custom DateHierarchy
• Change HierarchyLevels
• Drill-Up and Drill-DownReports
• Data Actions, Drill Down, Drill Up, Show Next Level, Expand NextLevel
• Drilling filters other visuals option

• Visualizing Data, WhyVisualizations
• Visualization types, Field Wells
• Visuals for Filtering, Visualizing Categorical Data, Visualizing TrendData
• Visualizing KPI Data, Visualizing Tabular Data, Visualizing GeographicalData
• Leveraging Power BI CustomVisuals

• Slicer Visualization
• When to use aSlicer
• Create and format SlicerVisualization
• Hierarchy Slicer (CustomVisualization)
• When to use a HierarchySlicer
• Create and format HierarchySlicer
• Advantages of HierarchySlicer

• Create and Format Bar and ColumnCharts
• Create and Format Stacked Bar Chart Stacked ColumnChart
• Create and Format Clustered Bar Chart, Clustered ColumnChart
• Create and Format 100% Stacked Bar Chart, 100% Stacked ColumnChart
• Create and Format Pie and DonutCharts
• Create and Format the Tree MapVisual
• Create and Format ScatterCharts

• Line and AreaCharts
• Create and Format Line Chart, Area Chart, Stacked AreaChart
• ComboCharts
• Create and Format Line and Stacked Column Chart, Line and Clustered ColumnChart
• Create and Format Ribbon Chart, Waterfall Chart, FunnelChart

• Create and Format Gauge Visual, KPIVisual
• Create and Format Card Visualization, Multi RowCard

• Create and Format Table Visual, MatrixVisualization
• Create and Format Map Visual, Filled Map Visual, Arc GIS MapsVisual
• Create and Format R ScriptVisual

• Power BI Service Introduction, Power BI CloudArchitecture
• Creating Power BI Service Account, SIGN IN to Power BI ServiceAccount
• Publishing Reports to the Power BI service, Import / Getting the Report to PBIService
• My Workspace / App WorkspacesTabs
• DATASETS, WORKBOOKS, REPORTS,DASHBOARDS
• Working with Datasets, Creating Reports in Cloud using PublishedDatasets
• Power BI Datasets Live Connection usingDesktop
• Working with Workbooks, working with Reports, SharingReports

• CreatingDashboards
• Pin Visuals and Pin LIVE Report Pages toDashboard
• Advantages ofDashboards
• Interacting withDashboards
• Adding Tiles toDashboards
• Web Content, Image, Text Box, Video
• FormattingDashboard
• SharingDashboard

• Introduction to DataGateways
• How Data Gateways Work
• Connect to an on premise Data Source by using a DataGateway
• Download DataGateway
• Installing a DataGateway
• Types ofGateways
• On-premises Data Gateway, On-premises Data Gateway (personal mode)
• Manage DataGateway
• Add and RemoveAdministrators
• Add Data Source, Add or Remove Users to a DataSource
• Refresh On PremiseData
• Configuring Automatic Refresh usingSchedules

• Introduction to AppWorkspaces
• Create an AppWorkspace
• Add Members to App Workspace toCollaborate
• App WorkspaceAccess
• Admin, Member,Contributor

• Introduction toApp
• Publish anApp
• Update a PublishedApp
• Manage Content inApp
• Include in App, Exclude inApp
• SharingApp
• Entire Organization, Specific individuals or group
• Un publishing anApp
• Content PackIntroduction
• Create ContentPack
• Sharing ContentPacks
• Specific Groups, My Entire Organization
• Selecting the Content / Items to Publish orShare

• Introduction to Row LevelSecurity
• Row Level Security (RLS) withDAX
• Manage Roles, Creating Roles, TestingRoles
• Adding Members to Roles in Power BIService
• Dynamic Row LevelSecurity
• Creating Users Table and Adding to theModel
• Capturing users using UserName () or UserPrincipalName () DAXFunctions

• Real-time ProjectHands On.
• ResumePreparation
• Interview QuestionsDiscussions
• MockInterviews