Microsoft Power Platform + Dynamics 365 Core Certification Bootcamp

Only £2,500


Course Details

Title:DA-100T00: Analyzing Data with Microsoft Power BI
Duration: 4 Days
Price: £2,500

Please note: course content subject to change

About this Course:
This course is intended for data professionals involved with modelling, visualising, and analysing data with Power BI. The topics include:
- Ingesting, cleaning and transforming data
- Data modelling requirements for performance and scalability
- Designing and creating reports for data analysis
- Advanced reporting analytics
- Managing and sharing report assets
- Creating paginated reports in Power BI

The course is aligned to the exam requirements for the Microsoft Data Analyst Associate certification exam DA-100. If you require the exam, we can provide a complete package including an extra day of exam prep, Measureup practice test if available and an exam voucher for an additional fee.

Audience Profile
Data professionals such as Data Analysts, Business Analysts

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

Some knowledge of relational databases and Azure skills equivalent to AZ-900