Course Brief
About this Course
This course provides comprehensive training on Power BI Desktop for data analysis. Learn how to connect, transform, model data, and create interactive reports and dashboards using Power BI. Gain the skills to efficiently analyze data and communicate insights using powerful visualizations.
Master Power BI Desktop and build data analysis skills for actionable insights.
Eligibility
Requirements
- Basic understanding of data and analytics.
- Familiarity with Excel (recommended but not required).
- A computer with Power BI Desktop installed.
- Willingness to learn advanced data visualization techniques.
Training Plan
Learning Roadmap
01
Foundation Studio: Connect and Transform the Raw Source Data
- Introduction to the Course
- Practice excel vs power bi through a guided digital skills practice activity.
- How to install Power BI
- Change default settings
- Practice power bi workflow through a guided digital skills practice activity.
- Display of final dashboard
- Back end vs front end
- Types of data connectors
- Introduction to Power Query
- Query editing tools
- Power query interface
- guided portfolio activity Exercise- 01
02
Practical Lab: Connect and Transform the Raw Source Data Part 02
- Assignment with solution
- Extracting data from web
- Data profiling column quality
- Practice numeric tools through a guided digital skills practice activity.
- Date and time tools
- Practice change locale type through a guided digital skills practice activity.
- Index and conditional columns
- Grouping aggregating
- Pivoting and unpivoting
- Practice merge queries through a guided digital skills practice activity.
- Practice append queries through a guided digital skills practice activity.
- guided portfolio activity Exercise- 02
03
Applied Workflow: Design and Build a Relational Model
- Practice data modeling through a guided digital skills practice activity.
- Practice data normalization through a guided digital skills practice activity.
- Fact and dimension tables
- Primary and foreign keys
- Star and snowflake schema
- Active and inactive relationships
- Relationship Cardinality
- Connecting multiple fact tables
- Filter context and flow
- guided portfolio activity Exercise- 03
04
Professional Practice: Analyze the Data with Calculated Columns and Measures
- Introduction to DAX
- Practice calculate columns through a guided digital skills practice activity.
- Practice dax measure through a guided digital skills practice activity.
- Practice quick measures through a guided digital skills practice activity.
- Practice filter context through a guided digital skills practice activity.
- DAX Syntax and operators
- Basic Math and stats functions
- Practice counting functions through a guided digital skills practice activity.
- Basic logical functions
- Practice switch functions through a guided digital skills practice activity.
- guided portfolio activity Exercise- 04
05
Portfolio Sprint: Analyze the Data with Calculated Columns and Measures Part 02
- Practice text functions through a guided digital skills practice activity.
- Basic date and time function
- Practice related function through a guided digital skills practice activity.
- Practice calculate function through a guided digital skills practice activity.
- Practice all function through a guided digital skills practice activity.
- Practice filter function through a guided digital skills practice activity.
- Practice iterator function through a guided digital skills practice activity.
- Practice time intelligence through a guided digital skills practice activity.
- guided portfolio activity Exercise- 05
06
Career Readiness: Design Custom Interactive Reports and Dashboards
- Visualizing data (3 Questions)
- Dashboard design framework
- Practice power bi interface through a guided digital skills practice activity.
- Adding report pages and objects
- Building and formatting charts
- Practice line charts through a guided digital skills practice activity.
- Practice kpi card through a guided digital skills practice activity.
- Bar and donut chart
- guided portfolio activity Exercise- 06
07
Foundation Studio: Design Custom Interactive Reports and Dashboards Part 02
- Basic filter option
- Table for Top N products
- Practice top n text cards through a guided digital skills practice activity.
- Practice map visuals through a guided digital skills practice activity.
- Practice report slicers through a guided digital skills practice activity.
- Practice gauge charts through a guided digital skills practice activity.
- Practice report interaction through a guided digital skills practice activity.
- Donut charts with visual filter
- Practice adding bookmarks through a guided digital skills practice activity.
- guided portfolio activity Exercise- 07
08
Portfolio Sprint: Digital Skills Practice Review
- Review the major digital skills practice concepts through a guided recap.
- Organize class practice into a simple portfolio-ready workflow.
- Apply the learned process on a realistic task with instructor guidance.
- Prepare next-step notes for continued practice after course completion.