Power BI is a business intelligence tool developed by Microsoft that helps users collect, analyze, and visualize data to make better decisions. It allows you to connect data from different sources such as Excel, databases, and online services, clean and transform the data, and create interactive reports and dashboards. Power BI is easy to use for beginners, supports powerful data analysis through DAX formulas, and enables sharing insights securely through the Power BI Service.
Module 1: Introduction to Power BI
Content:
• What is Business Intelligence (BI)?
• What is Power BI?
• Why Power BI is used
• Benefits of Power BI
Module 2: Connecting to Data Sources
Content:
• Connecting to Excel files
• Connecting to CSV / Text files
Module 3: Power Query – Data Cleaning
Content:
• What is Power Query?
• Power Query Editor interface
• Data transformation techniques:
• Remove columns & rows
• Rename columns
• Change data types
• Filter rows
• Sort data
• Split & merge columns
Module 4: Data Modeling Basics
Content:
• Understanding tables
• Primary key & foreign key (basic)
• Creating relationships
• Handling null & duplicate values
• Apply & Close
Module 5: Introduction to DAX (Basic Level)
Content:
• What is DAX?
• Difference between:
• Calculated Column
• Measure
• Basic DAX functions:
• SUM
• COUNT
• COUNTROWS
• AVERAGE
• MIN / MAX
Module 6: Creating Visualizations
Content:
• Table & Matrix visuals
• Column & Bar charts
• Line chart
• Pie & Donut charts
• Card visuals
• Map visual (basic)
• Selecting the right visual
Module 7: Filters, Slicers & Interactions
Content:
• Visual-level filters
• Page-level filters
• Report-level filters
• Slicers:
• Date slicer
• Dropdown slicer
• Cross-filtering & highlighting
Module 8: Formatting & Report Design
Content:
• Formatting charts
• Titles, labels & legends
• Colors & themes
• Aligning visuals
• Page layout & background
• Basic best practices for dashboards
Pre-Requisites
Student need to bring a Laptop which has Microsoft Power BI installed. Power BI is currently only compatible with PC/Windows (not available for Mac).
Visit https://powerbi.microsoft.com/en-us/get-started/ for software.
There are no prerequisites for this Power BI Course - it is open and accessible to all individuals that wish to enhance their knowledge of Power BI.
