Course Outline
Note: This course content is subject to changes and updates
Module 1: Get Started with Microsoft Data Analytics
- Data Analytics and Microsoft
- The tasks of a Data Analyst
- Getting Started with Power BI
- Lab : Getting Started
Module 2: Prepare Data in Power BI
- Get data from multiple data sources such as SQL Server, Azure Cosmos DB, Azure Analysis Services
- connection methods and their performance implications
- options for data storage
- Optimize query performance
- Resolve data import errors
- Lab : Preparing Data in Power BI Desktop
- Connecting to data sources and inspecting data with Power Query Editor
Module 3: Clean, Transform, and Load Data in Power B
- Identify data anomalies
- Data shaping
- Apply data shape transformations
- Enhance the data structure
- Data Profiling
- Data cleaning
- Lab : Transforming and Loading Data
- Querying and transforming data sets
- Loading data
Module 4: Microsoft Teams collaboration features
- Introduction to data modelling
- Data relationships
- Performance implications
- Data security
- Working with tables
- Dimensions and Hierarchies
- Create histograms and rankings
- Lab : Data Modelling in Power BI Desktop
- Create Model Relationships
- Configure Tables
- Review the model interface
- Create Quick Measures
- Lab : Advanced Data Modelling in Power BI Desktop
- Configure many-to-many relationships
- Enforce row-level security
Module 5: Create Measures using DAX in Power BI
- Introduction to DAX
- DAX context
- Using DAX for simple formulas and expressions
- Advanced DAX
- Working with Time Intelligence and Key Performance Indicators
- Lab : Introduction to DAX in Power BI Desktop
- Create calculated tables
- Create calculated columns
- Create measures
- Lab : Advanced DAX in Power BI Desktop
- Use the CALCULATE() function to manipulate filter context
- use Time Intelligence functions
Module 6: Create Reports
- Optimise the data model for enterprise-level performance
- Achieving efficiency by using variables
- Data modelling best practices
- Optimise DirectQuery Models
- Create and manage Aggregations
Module 7: Microsoft Teams Integrations overview and examples
- Design a report page layout
- Enhance the report with visualisations
- Report navigation and interactions
- Use Performance Analyzer to improve efficiency of queries
- Lab : Designing a report in Power BI
- Create a live connection in Power BI Desktop
- Design a report
- Configure visual fields and format properties
- Lab : Enhancing Power BI reports with interaction and formatting
- Create and configure Sync Slicers
- Create a drillthrough page
- Apply conditional formatting
- Create and use Bookmarks
Module 8: Create Dashboards
- Graphical representation of data insights
- Create a Dashboard
- Navigation tools
- Real-time Dashboards
- Enhance a Dashboard
- Lab : Designing a report in Power BI Desktop - Part 1
- Create a Dashboard
- Pin visuals to a Dashboard
- Configure a Dashboard tile alert
- Use Q&A to create a dashboard tile
Module 9: Create Dashboards
- Paginated report overview
- Create Paginated reports
- Lab : Creating a Paginated report
- Use Power BI Report Builder
- Design a multi-page report layout
- Define a data source
- Define a dataset
- Create a report parameter
- Export a report to PDF
Module 10: Perform Advanced Analytics
- Advanced Analytics
- Statistical functions
- Identifying outliers
- Conduct time-series analysis
- Using the Analyze feature
- Use advanced analytics custom visuals
- Data Insights through AI visuals
- Lab : Data Analysis in Power BI Desktop
- Create animated scatter charts
- Use the visual to forecast values
- Work with Decomposition Tree visual
- Work with the Key Influencers visual
Module 11: Create and Manage Workspaces
This module will introduce you to Workspaces, including how to create and manage them. You will also learn how to share content, including reports and dashboards, and then learn how to distribute an App.
- Creating Workspaces
- Understand workspace collaboration
- Assigning user roles and security
- Distribute an App
- Sharing and Managing Assets
- Monitor workspace usage and performance
- Lab : Publishing and Sharing Power BI Content
- Map security principals to dataset roles
- Share a dashboard
- Publish an App
Module 12: Manage Datasets in Power BI
In this module you will learn the concepts of managing Power BI assets, including datasets and workspaces. You will also publish datasets to the Power BI service, then refresh and secure them.
- Create dynamics reports with parameters
- Configuring a dataset refresh schedule
- Managing Power BI assets
- Manage and promote datasets
- Troubleshoot gateway connectivity
Module 13: Row-level security
This module teaches you the steps for implementing and configuring security in Power BI to secure Power BI assets.
- Security in Power BI
- Configure row-level security roles and group memberships
- Test roles in Power BI Desktop
