Course Overview:
The Power BI Course is designed to equip participants with comprehensive skills to leverage the full potential of Microsoft Power BI for end-to-end business intelligence solutions. This course covers a range of topics, from basic concepts to advanced techniques, enabling participants to become proficient in both the technical and business aspects of Power BI development.
Capstone Project: Participants will work on a hands-on capstone project that integrates all the skills learned throughout the course. This project will simulate a real-world scenario where participants can showcase their ability to develop end-to-end Power BI solutions.
Assessment and Certification: Participants will be assessed through quizzes, assignments, and the successful completion of the capstone project. Upon completing the course, participants will receive a certification indicating their proficiency in Full Stack Power BI.
This Power BI Course is suitable for business analysts, data analysts, BI professionals, and anyone interested in harnessing the power of Microsoft Power BI for comprehensive business intelligence solutions. The course combines theoretical knowledge with practical applications to ensure participants are well-prepared for real-world challenges in the field of business intelligence.
Curriculum
- 8 Sections
- 108 Lessons
- 10 Weeks
- 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