Curriculum
- 8 Sections
- 108 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Introduction to Data Analytics & Power BI10
- 1.1Introduction to Power BI
- 1.2Introduction to Data Analytics
- 1.3Installation of Power BI Desktop
- 1.4Installation and configuration of Sql Server
- 1.5Installation and configuration of SSMS
- 1.6Power BI Kick off Session
- 1.7Recap of Analytics
- 1.8How to Access Study Materials
- 1.9Power BI Architecture
- 1.10Power BI Kick off Session 2
- Connecting to Various Data Sources21
- 2.1How to Load csv files
- 2.2Loading data from CSV to SQL Server and how to connect to Sql Server via Power bi
- 2.3How to Connect to GitHub
- 2.4How to Scrape Data from website
- 2.5How to Connect to Google Drive
- 2.6How to Connect to Sql server
- 2.7How to execute sql query from power bi
- 2.8How to Execute Sql Query in Sql Server
- 2.9How to execute Stored Procedure query from power bi
- 2.10How to invoke a Stored Procedure in SQL Server
- 2.11Recap Invoke a Stored Procedure in SQL Server
- 2.12What is XML file , difference between XML and JSON file , loading the xml file in PBI
- 2.13JSON Data
- 2.14How to load Multiple files in one-go using folder Connector
- 2.15How to Connect Google Analytics from Power BI
- 2.16How to load Parquet file in Power BI
- 2.17Storage Types in Power Bi
- 2.18Types of Storage Mode
- 2.19Composite/ Dual Storage Mode
- 2.20Dual Storage Mode
- 2.21Data Verse in Power bi
- Power Query Editor22
- 3.1Introduction to Power Query Editor
- 3.2What is the Initial Filter Context for this Particular Cell?
- 3.3Storage Mode – Import & Direct Query Mode in Power BI
- 3.4Types of Storage Modes – Dual or Composite Mode in Power BI
- 3.5Live Mode in Power BI
- 3.6Power Query Editor – Performing common and basic data preprocessing
- 3.7Performing Group by and Fuzzy Grouping in Power Query Editor
- 3.8Data Profiling in Power BI
- 3.9Recap of Previous session – Quizzes
- 3.10Custom Column
- 3.11Conditional Column
- 3.12Column from Examples
- 3.13Custom Function
- 3.14Theorey – How to perform merge in Power Query Editor ? – Types of Merges, Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Left Anti Join, & Right Anti Join
- 3.15Demo of Merging the Datasets using different Types of Merges such as Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Left Anti Join, & Right Anti Join in PQ
- 3.16Append Data
- 3.17Query Parameter & Its Use Cases
- 3.18Information Functions
- 3.19Common Data Transformation
- 3.20Query Editor Data Transformations
- 3.21Odata feed
- 3.22Merge Prerequisites and limitations
- Data Modeling9
- Data Visualization24
- 5.1Data Visualization in Power bi
- 5.2Matrix Visual
- 5.3Table Visual
- 5.4Slicer visual in Power bi
- 5.5Map visual
- 5.6Types of Charts
- 5.7Line Chart
- 5.8Area Chart
- 5.9Bar & Column Chart
- 5.10Scatter plots & Bubble Chart
- 5.11Combo Charts
- 5.12Pie & Doughnut Chart
- 5.13Funnel Chart
- 5.14Drillthrough Filter
- 5.15Gauge Chart & Single Card
- 5.16Python Visual
- 5.17Ribbon Chart in Power BI
- 5.18Waterfall Chart in Power BI
- 5.19When to use Which types of Charts
- 5.20Bookmarks in Power bi
- 5.21Sync Slicer in Power Bi
- 5.22Decomposition tree in power bi.
- 5.23Filter Functions
- 5.24Evaluation Context in Power Bi
- DAX19
- 6.1Data Analytics Expression (DAX)
- 6.2Count Functions in DAX
- 6.3SUM, SUM X, Average Function
- 6.4Calculated Column and Calculated measure, Calculated table in Dax
- 6.5CALCULATE TABLE in DAX
- 6.6Comparison Operators in DAX
- 6.7Use Cases All, All Selected, & All Except
- 6.8Query Editor Data Transformations
- 6.9Time intelligence Functions Part 1
- 6.10Dealing with Missing Values
- 6.11TopN, Rankx, Summarize part 1
- 6.12Time Intelligence Functions Part 2
- 6.13How to use opening losing balance in DAX
- 6.14Rolling moving Average
- 6.15How to Perform Comparison over different time periods in Power bi
- 6.16How to display last N months Sales Dynamically using Power bi
- 6.17Information Functions in DAX
- 6.18How to load TopN, RankX, Summarize
- 6.19TopN, RankX, Summarize Part 2
- Microsoft Sql Server Course3
- Power Bi Interview Questions1