Power BI Data Analyst Course

Power BI Data Analyst Course – Curriculum

Module 1: Introduction to Power BI Desktop

• Introduction to Microsoft Power BI and Business Intelligence
• Overview of Power BI Desktop and its key components
• Installing and launching Power BI Desktop
• Understanding the Power BI interface and workspace
• Exploring the core areas of Power BI
• Understanding the Power BI development workflow
• Introduction to data loading, transformation, modeling, and visualization
• Understanding the Power BI report development process

Module 2: Connecting to Data Sources and Loading Data

• Understanding data sources supported by Power BI
• Connecting to Microsoft Excel workbooks
• Importing CSV and text files
• Connecting to databases
• Extracting data from web pages
• Loading data into Power BI Desktop
• Understanding data preview and navigation
• Exploring data import options
• Managing queries and data sources
• Understanding the fundamentals of data refresh

Module 3: Data Transformation Using Power Query

• Introduction to Power Query Editor
• Understanding queries and the Applied Steps pane
• Renaming, reordering, and removing columns
• Sorting and filtering data
• Removing duplicate records
• Identifying and handling error records
• Changing column names and data types
• Filtering rows and selecting relevant data
• Understanding query steps and transformation sequences
• Preparing structured datasets for reporting and analysis

Module 4: Data Cleaning, Shaping, and Data Mashup

• Detecting and changing data types
• Replacing values and handling inconsistent data
• Transforming column contents
• Filling values down and up
• Promoting the first row as column headers
• Grouping and aggregating data
• Duplicating and referencing queries
• Splitting and merging columns
• Creating custom and index columns
• Merging queries using different join options
• Appending multiple queries
• Combining files from a source folder
• Pivoting and unpivoting data
• Restructuring datasets for analytical reporting
• Understanding data mashup and query dependencies

Module 5: Data Modeling and Relationships

• Introduction to data modeling in Power BI
• Understanding fact tables and dimension tables
• Designing an effective star schema
• Understanding primary keys and foreign keys
• Creating relationships automatically and manually
• Understanding one-to-many, one-to-one, and many-to-many relationships
• Managing relationship cardinality and filter direction
• Editing, deleting, and deactivating relationships
• Understanding active and inactive relationships
• Building a reliable data model for accurate reporting

Module 6: Data Analysis Expressions (DAX)

• Introduction to DAX and its role in Power BI
• Understanding calculated columns, measures, and calculated tables
• Working with basic DAX syntax and expressions
• Aggregation functions: SUM, COUNT, and related functions
• Iterator functions: SUMX, COUNTX, AVERAGEX, and others
• Filter functions: CALCULATE, CALCULATETABLE, FILTER, KEEPFILTERS, REMOVEFILTERS, and ALL
• Logical functions: IF, AND, OR, SWITCH, and TRUE
• Relationship functions: RELATED, RELATEDTABLE, and USERELATIONSHIP
• Table manipulation functions: ADDCOLUMNS, CROSSJOIN, NATURALINNERJOIN, SUMMARIZE, TOPN, and GENERATEALL
• Understanding row context and filter context
• Writing reusable DAX measures for business reporting
• Applying DAX calculations to practical analytical scenarios

Module 7: Date Tables and Time Intelligence

• Understanding date tables and their importance
• Creating date tables using DAX
• Using CALENDAR and CALENDARAUTO
• Working with date and time functions such as DATE, DATEDIFF, EDATE, and EOMONTH
• Marking and applying a date table
• Calculating Month-to-Date (MTD), Quarter-to-Date (QTD), and Year-to-Date (YTD) values
• Using time-intelligence functions such as TOTALMTD, TOTALQTD, TOTALYTD, DATESMTD, and DATESQTD
• Working with opening and closing balance calculations
• Applying date-range analysis using DATESBETWEEN
• Comparing current-period and previous-period performance
• Performing month-over-month, quarter-over-quarter, and year-over-year analysis

Module 8: Creating Data Visualizations in Power BI

• Understanding the report canvas, Visualizations pane, and Fields pane
• Creating tables and matrix visualizations
• Designing multi-row card visuals
• Understanding chart selection and formatting
• Creating column charts and bar charts
• Designing line charts and trend visualizations
• Creating pie charts and donut charts
• Building funnel charts and 100% stacked charts
• Creating scatter charts and bubble charts
• Designing waterfall charts and dual-axis visualizations
• Working with multiple data values in charts
• Formatting titles, labels, legends, axes, and data colors
• Using drill-down and hierarchical analysis
• Exploring the Play Axis feature for bubble charts
• Improving report readability and visual storytelling

Module 9: AI-Powered Visuals, Maps, and Advanced Analytics

• Introduction to AI-powered visualizations in Power BI
• Creating map and filled map visuals
• Working with geographical data
• Configuring and formatting map displays
• Creating treemap visualizations
• Using Q&A visuals to explore data with natural-language questions
• Applying Key Influencers to identify factors affecting business outcomes
• Using decomposition trees to investigate contributing factors
• Selecting suitable visuals for analytical requirements
• Presenting insights effectively through visual analysis

Module 10: Filtering, Slicers, and Report Interactivity

• Understanding filters in Power BI
• Applying visual-level filters
• Applying page-level filters
• Applying report-level filters
• Managing and clearing filters
• Understanding filter hierarchy and interactions
• Creating and formatting slicers
• Configuring slicer selection options
• Controlling interactions between visuals
• Choosing suitable filtering techniques for different reporting scenarios
• Developing interactive reports for business users

Module 11: Publishing and Sharing Reports Using Power BI Service

• Introduction to Power BI Service
• Understanding Power BI workspaces
• Publishing reports from Power BI Desktop
• Navigating published reports in Power BI Service
• Organizing and managing workspace content
• Sharing reports with users and stakeholders
• Understanding report access and sharing permissions
• Overview of cloud-based report consumption and collaboration
• Understanding the Power BI Desktop-to-Service deployment workflow