Course Overview:
The Full Stack 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 Full Stack 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
- 1 Section
- 26 Lessons
- 10 Weeks
- Full Stack Power BI Course26
- 1.1Introduction to Data Analytics
- 1.2Power BI Architecture
- 1.3Download Resources
- 1.4Installation of Power BI Desktop
- 1.5Installation and configuration of Sql Server
- 1.6Installation and configuration of SSMS
- 1.7Classroom Session-Connecting to sql server from power bi
- 1.8Types of Storage Mode in Power bi
- 1.9Commonly performed Data Transformation in ETL Process
- 1.10Group by and Fuzzy Grouping
- 1.11Custom Function in Power Query Editor
- 1.12How to Perform Group by and Fuzzy Grouping in Power Query Editor & PBI Cloud Services
- 1.13Query Parameter in Power Query Editor with Use Cases
- 1.14Week3-Sat-Data Modeling Part 1 Session
- 1.15Week3-Sat-Data Modeling Part 1 Continuation 1
- 1.16Week3-Sat-Data Modeling Part 1 Continuation 2
- 1.17Week3-Sun-Many to Many Relationship
- 1.18Week3-Sun-Many to Many Relationship Continuation
- 1.19Star & Snow flake Schema
- 1.20Matrix Visual
- 1.21Scatter Plots & Bubble Chart
- 1.22Data Visualization Part -2
- 1.23Box and whisker plots
- 1.24Introduction to DAX
- 1.25Data Types and Operators in DAX
- 1.26Difference between ALL, ALLSELECTED, ALLEXCEPT, KEEPFILTERS