This course introduces participants to data analytics using Microsoft Power BI, from connecting and preparing data to developing interactive reports and business dashboards. Participants learn to transform raw data into structured models, create calculations using Data Analysis Expressions (DAX), visualize key performance indicators, and communicate actionable insights.
The course covers Power BI Desktop for data preparation, modeling, and report development, and the Power BI service for publishing, dashboard creation, and sharing. A practical capstone brings these skills together through a business reporting scenario.
Duration 5 Days – 35 hrs.
Objectives
- Explain the role of data analytics and business intelligence in decision-making.
- Connect Power BI to common data sources, including Excel, CSV files, and relational databases.
- Clean, transform, and combine data using Power Query.
- Build data models using relationships, fact tables, dimension tables, and date tables.
- Create DAX measures for business calculations and performance indicators.
- Design interactive reports using appropriate visuals, filters, and navigation.
- Analyze trends, comparisons, contributions, and performance against targets.
- Publish reports and create dashboards in the Power BI service.
- Apply foundational data security, sharing, and refresh practices.
- Develop a business dashboard that communicates findings and supports decisions.
Target Audience
- Data analysts and aspiring data analysts.
- Business analysts and business intelligence professionals.
- Managers, supervisors, and team leaders who monitor business performance.
- Finance, sales, marketing, operations, and human resources professionals.
- Reporting specialists and Excel users transitioning to Power BI.
- Professionals responsible for preparing management reports and dashboards.
Prerequisites
- Basic computer skills and familiarity with Microsoft Windows.
- Working knowledge of Microsoft Excel, including tables, formulas, sorting, and filtering.
- Basic understanding of business data, such as sales, costs, customers, and performance targets.
- Familiarity with basic mathematical concepts, including percentages, averages, and ratios.
- No previous Power BI, DAX, or programming experience required.
- Access to a Windows computer with Power BI Desktop installed.
- Access to the Power BI service with appropriate organizational permissions and licensing for publishing, sharing, and dashboard activities.
Course Outline
Day 1: Data Analytics Foundations and Data Preparation
Module 1: Introduction to Data Analytics and Power BI
- Data analytics and its role in business decision-making.
- Translating business questions into analytical requirements.
- Understanding metrics and key performance indicators.
- Power BI components and the reporting workflow.
- Differences between reports, dashboards, and semantic models.
- Navigating Power BI Desktop.
Module 2: Connecting to Data Sources
- Connecting to Excel workbooks and CSV files.
- Introduction to relational database connections.
- Understanding Import and DirectQuery connectivity options.
- Selecting tables and reviewing source data.
- Configuring data source settings and credentials.
Module 3: Cleaning and Transforming Data with Power Query
- Profiling data and identifying quality issues.
- Assigning appropriate data types.
- Handling missing values, duplicates, and errors.
- Splitting, merging, and replacing column values.
- Pivoting and unpivoting data.
- Merging and appending queries.
- Loading prepared data into Power BI.
Day 2: Data Modeling and DAX Fundamentals
Module 4: Building an Effective Data Model
- Understanding fact tables and dimension tables.
- Designing a star schema.
- Creating and managing table relationships.
- Understanding cardinality and filter direction.
- Creating and configuring a date table.
- Organizing fields, formats, and hierarchies.
Module 5: Introduction to DAX
- Understanding DAX syntax and expressions.
- Distinguishing measures from calculated columns.
- Creating aggregation measures using SUM, AVERAGE, COUNTROWS, and DISTINCTCOUNT.
- Using DIVIDE for ratios and percentages.
- Applying conditional logic with IF and SWITCH.
- Using variables to improve calculation clarity.
Module 6: Business Calculations and Filter Context
- Understanding row context and filter context.
- Modifying filter context with CALCULATE.
- Calculating revenue, costs, profit, and profit margin.
- Calculating contribution percentages.
- Creating actual-versus-target measures.
- Validating calculations against source data.
Day 3: Report Design and Analytical Exploration
Module 7: Designing Clear and Effective Reports
- Identifying report audiences and information needs.
- Selecting appropriate charts and visuals.
- Using cards, tables, matrices, and KPI visuals.
- Applying consistent layouts, themes, and number formats.
- Using color and conditional formatting purposefully.
- Incorporating accessibility and readability principles.
Module 8: Building Interactive Reports
- Configuring visual-level, page-level, and report-level filters.
- Adding slicers and synchronizing selections across pages.
- Managing visual interactions.
- Implementing drill-down and drill-through.
- Creating report tooltips.
- Using bookmarks, buttons, and page navigation.
Module 9: Analyzing Business Performance
- Comparing results across products, regions, and customer segments.
- Analyzing trends using a date table and time-intelligence measures.
- Calculating year-to-date results and prior-period comparisons.
- Identifying top and bottom performers.
- Exploring contributors using decomposition trees.
- Communicating findings through focused report narratives.
Day 4: Dashboard Development, Publishing, and Management
Module 10: Creating Dashboards in the Power BI Service
- Navigating the Power BI service.
- Publishing reports and semantic models.
- Understanding workspaces and their purpose.
- Creating dashboards by pinning report visuals.
- Organizing dashboard tiles around business priorities.
- Designing dashboard summaries with access to supporting reports.
Module 11: Sharing and Securing Power BI Content
- Understanding workspace roles and access permissions.
- Sharing reports and dashboards with intended audiences.
- Introducing Power BI apps for content distribution.
- Understanding licensing considerations for collaboration.
- Defining and testing row-level security roles.
- Applying responsible data access and distribution practices.
Module 12: Refresh, Performance, and Maintenance
- Understanding data refresh requirements.
- Configuring scheduled refresh and data source credentials.
- Understanding when an on-premises data gateway is needed.
- Identifying common refresh issues.
- Improving model efficiency by removing unnecessary data.
- Reviewing report performance with Performance Analyzer.
- Maintaining clear names and documentation.
Day 5: Capstone—Business Performance Dashboard
Module 13: Defining the Business Dashboard Requirements
- Selecting a sales or operational performance scenario.
- Identifying users, business questions, and reporting priorities.
- Defining KPIs, targets, and comparison periods.
- Reviewing source data and identifying preparation requirements.
- Planning the data model and report layout.
Module 14: Developing the End-to-End Power BI Solution
- Importing, cleaning, and combining project data.
- Building a star-schema data model.
- Creating DAX measures for business performance.
- Developing an executive summary and supporting detail pages.
- Adding filters, navigation, and drill-through functionality.
- Checking data accuracy, calculation consistency, and usability.
Module 15: Publishing and Communicating Business Insights
- Publishing the completed report to a workspace.
- Creating a dashboard from selected report visuals.
- Configuring relevant access and refresh settings.
- Summarizing trends, performance gaps, and contributing factors.
- Documenting KPI definitions, assumptions, and data limitations.
- Preparing recommendations supported by the dashboard findings.
Capstone Deliverable: A Power BI report and dashboard featuring prepared data, a structured data model, DAX measures, interactive visuals, and a concise business insights summary.

