Course Outline
Module 1: Foundations of Microsoft Data Analytics
This module examines the diverse roles within the data sector, detailing the specific responsibilities of a Data Analyst, and provides an overview of the Power BI product landscape.
Lessons
- Data Analytics and Microsoft
- Intro to Power BI
Lab: Initial Setup
- Getting Started
Upon completing this module, learners will be able to:
- Explore the various roles in the data field
- Identify key tasks performed by data analysts
- Describe the Power BI product and service ecosystem
- Navigate and utilize the Power BI service
Module 2: Data Preparation in Power BI
This module focuses on identifying and extracting data from multiple sources. Participants will explore connectivity options and data storage methods, gaining an understanding of the performance implications of direct connections versus data import.
Lessons
- Fetching data from diverse sources
- Performance optimization
- Resolving data errors
Lab: Data Preparation in Power BI Desktop
- Data Preparation
Upon completing this module, learners will be able to:
- Identify and retrieve data from various sources
- Understand connection methods and their impact on performance
- Optimize query execution
- Resolve issues related to data import
Module 3: Cleaning, Transforming, and Loading Data in Power BI
This module guides learners through profiling and assessing data conditions. Participants will learn to identify anomalies, analyze data size and structure, and execute appropriate cleaning and transformation steps to prepare data for model ingestion.
Lessons
- Data shaping
- Improving data structure
- Data Profiling
Lab: Data Transformation and Loading
- Data Loading
Upon completing this module, learners will be able to:
- Apply data shape transformations
- Enhance the underlying data structure
- Profile and inspect data quality
Module 4: Data Model Design in Power BI
This module covers the essential principles of designing and developing data models optimized for performance and scalability. It also addresses common modeling challenges, including relationship management, security, and performance tuning.
Lessons
- Introduction to data modeling
- Managing tables
- Dimensions and Hierarchies
Lab: Data Modeling in Power BI Desktop
- Establishing Model Relationships
- Table Configuration
- Reviewing the Model Interface
- Generating Quick Measures
Lab: Advanced Data Modeling in Power BI Desktop
- Setting up many-to-many relationships
- Implementing row-level security
Upon completing this module, learners will be able to:
- Grasp the fundamentals of data modeling
- Define relationships and cardinality
- Implement Dimensions and Hierarchies
- Generate histograms and rankings
Module 5: Developing Measures with DAX in Power BI
This module introduces DAX, highlighting its power in enhancing data models. Learners will explore aggregations, the concepts of Measures, calculated columns and tables, and Time Intelligence functions to address complex calculation and analysis needs.
Lessons
- DAX Fundamentals
- DAX Context
- Advanced DAX Techniques
Lab: DAX Basics in Power BI Desktop
- Creating calculated tables
- Creating calculated columns
- Developing measures
Lab: Advanced DAX in Power BI Desktop
- Leveraging the CALCULATE() function to manipulate filter context
- Applying Time Intelligence functions
Upon completing this module, learners will be able to:
- Understand DAX syntax and logic
- Apply DAX for simple formulas and expressions
- Create calculated tables and measures
- Develop basic measures
- Utilize Time Intelligence and Key Performance Indicators
Module 6: Optimizing Model Performance
This module presents the steps, processes, and best practices necessary to optimize data models for enterprise-grade performance.
Lessons
- Performance optimization strategies
- Optimizing DirectQuery Models
- Creating and managing Aggregations
Upon completing this module, learners will be able to:
- Recognize the importance of variables
- Enhance the data model architecture
- Optimize the storage model
- Implement aggregations
Module 7: Report Creation
This module covers the core principles of report design, including selecting appropriate visuals, structuring page layouts, and implementing essential functionalities. It also emphasizes critical design considerations for accessibility.
Lessons
- Report design principles
- Report enhancement techniques
Lab: Report Design in Power BI
- Establishing a live connection in Power BI Desktop
- Designing a report layout
- Configuring visual fields and format properties
Lab: Enhancing Power BI Reports with Interactivity and Formatting
- Creating and configuring Sync Slicers
- Developing drillthrough pages
- Applying conditional formatting
- Creating and utilizing Bookmarks
Upon completing this module, learners will be able to:
- Design effective report page layouts
- Select and integrate impactful visualizations
- Implement basic report functionalities
- Add navigation and interactive elements
- Improve report performance
- Design with accessibility in mind
Module 8: Dashboard Creation
In this module, learners will discover how to craft compelling narratives using dashboards and leverage navigation tools for enhanced user experience. It covers features and techniques to boost dashboard usability and drive deeper insights.
Lessons
- Building Dashboards
- Real-time Dashboards
- Dashboard Enhancement
Lab: Dashboard Design in Power BI Desktop - Part 1
- Creating a Dashboard
- Pinning visuals to a Dashboard
- Setting up Dashboard tile alerts
- Using Q&A to generate dashboard tiles
Upon completing this module, learners will be able to:
- Create functional Dashboards
- Understand the capabilities of real-time Dashboards
- Enhance Dashboard usability
Module 9: Paginated Reports in Power BI
This module explains the concept of paginated reports and their role within the Power BI ecosystem. It guides learners through the process of building and publishing these reports effectively.
Lessons
- Paginated report overview
- Developing Paginated reports
Lab: Building a Paginated Report
- Utilizing Power BI Report Builder
- Designing multi-page report layouts
- Defining a data source
- Defining a dataset
- Creating report parameters
- Exporting reports to PDF
Upon completing this module, learners will be able to:
- Explain the purpose and use of paginated reports
- Create a paginated report
- Set up data sources and datasets
- Manage charts and tables
- Publish reports to the service
Module 10: Advanced Analytics
This module equips learners with the skills to apply advanced features for deeper analytical insights, enabling practical data analysis within reports. It also covers the use of AI visuals to uncover complex and meaningful patterns in the data.
Lessons
- Advanced Analytics Techniques
- Deriving Data Insights via AI visuals
Lab: Data Analysis in Power BI Desktop
- Creating animated scatter charts
- Utilizing the forecasting visual
- Applying the Decomposition Tree visual
- Leveraging the Key Influencers visual
Upon completing this module, learners will be able to:
- Analyze statistical summaries
- Utilize the Analyze feature
- Detect outliers in datasets
- Perform time-series analysis
- Incorporate AI visuals
- Use the Advanced Analytics custom visual
Module 11: Workspace Management
This module introduces Workspaces, covering their creation and management. It also details the processes for sharing content, such as reports and dashboards, and distributing Apps to broader audiences.
Lessons
- Setting up Workspaces
- Sharing and Managing Assets
Lab: Publishing and Sharing Power BI Content
- Assigning security principals to dataset roles
- Sharing a dashboard
- Publishing an App
Upon completing this module, learners will be able to:
- Create and manage Workspaces
- Understand workspace collaboration dynamics
- Monitor workspace usage and performance
- Distribute Apps effectively
Module 12: Dataset Management in Power BI
In this module, learners will explore the management of Power BI assets, including datasets and workspaces. It covers publishing datasets to the Power BI service, as well as strategies for refreshing and securing them.
Lessons
- Working with Parameters
- Managing Datasets
Upon completing this module, learners will be able to:
- Create and utilize parameters
- Manage datasets effectively
- Configure dataset refresh schedules
- Troubleshoot gateway connectivity issues
Module 13: Row-Level Security
This module outlines the procedures for implementing and configuring security within Power BI to protect assets and ensure data integrity.
Lessons
- Security frameworks in Power BI
Upon completing this module, learners will be able to:
- Understand the components of Power BI security
- Configure row-level security roles and group memberships
Requirements
Aspiring Data Analysts typically enter the field with experience handling data in cloud environments.
Specifically, the following competencies are required:
- A solid grasp of core data concepts.
- Familiarity with manipulating relational data in the cloud.
- Understanding of non-relational data management in the cloud.
- Knowledge of data analysis and visualization principles.
To solidify your prerequisites and deepen your understanding of Azure data operations, it is recommended to complete Microsoft Azure Data Fundamentals prior to enrolling in this course.
Target Audience
This course is designed for data professionals and business intelligence specialists seeking to enhance their ability to perform accurate data analysis using Power BI. It is also ideal for individuals who develop reports to visualize data from platform technologies deployed in both cloud and on-premises environments.
Job Role: Data Analyst
Certification Preparation: DA-100
Distinctive Features: None
Testimonials (5)
The coding and analysis, how the information come together in a report which will be useful for my work
Nokuthula Dhludhlu - National Transmission Company South Africa
Course - Analyzing Data with Power BI
opened my thinking on how to apply the knowledge gained.
Gabriel Govender - National Transmission Company South Africa
Course - Analyzing Data with Power BI
I liked that it demonstrated practical examples that I can apply in my day-to-day work which will improve my reports.
Nondumiso Mthembu - National Transmission Company South Africa
Course - Analyzing Data with Power BI
Blessing made sure that he knows every one , and referred every candidate by their name which is excellent. He is a well experienced Trainer and has patience, and very helpful to all the candidates. Trainer like him make the training more interesting. Wish to have him allocated to my next training that I will be doing with your company.
Alfred Mashala - National Transmission Company South Africa
Course - Analyzing Data with Power BI
I loved everything about the training especially the dashboard presentations
