microsoft partner logo color
8245  Reviews star_rate star_rate star_rate star_rate star_half

Comprehensive Data Analytics using Power BI

In this Power BI course, participants learn how to implement best practices for modeling, visualizing, and analyzing data with Power BI. They gain hands-on experience accessing and processing data...

Read More
Course Code WA3717
Duration 5 days
Available Formats Classroom

In this Power BI course, participants learn how to implement best practices for modeling, visualizing, and analyzing data with Power BI. They gain hands-on experience accessing and processing data from various sources, including relational and non-relational databases. Participants also learn how to manage and deploy reports and dashboards for sharing and content distribution.

  • Note: This course is a combination of the official Microsoft course PL-300 and custom content.

Skills Gained

  • Ingest, clean, and transform data
  • Model data for performance and scalability
  • Design and create reports for data analysis
  • Apply and perform advanced report analytics
  • Manage and share reports
  • Work with datasets and dataflows
  • Work with calculation groups
  • Use DAX Studio and Tabular Editor tools to optimize report performance
  • Create paginated reports in Power BI

Prerequisites

All attendees must have experience working with data in the cloud, specifically:

  • Understanding core data concepts
  • Experience working with relational and non-relational databases
  • Knowledge of data analysis and visualization concepts

Course Details

Software Requirements

  • A computer with an internet connection is required.
  • A remote lab VM with all necessary accounts will be provided to participants.

Get Started with Microsoft Data Analytics

  • Data Analytics and Microsoft
  • Getting started with Power BI
  • Getting started in Power BI Desktop
  • Exploring the different roles in data
  • Identifying the tasks performed by a data analyst
  • Describing the Power BI landscape of products and services
  • Using the Power BI service

Prepare Data in Power BI

  • Getting data from various data sources
  • Preparing data in Power BI Desktop
  • Identifying and retrieving data from different data sources
  • Understanding connection methods and their performance implications
  • Connecting to a data flow

Clean, Transform, and Load Data in Power BI

  • Shaping data using transformations and custom columns
  • Addressing quality by removing duplicates and fixing issues
  • Combining datasets with Merge Queries; appending multiple sources
  • Analyzing data with Column Distribution, Quality, and Profile tools
  • Performing advanced transformations like conditional columns and splits
  • Loading data into the Power BI model and optimizing performance

Design a Data Model in Power BI

  • Basics of data modeling in Power BI
  • Understanding components of a typical data model
  • Importance of proper data structure for performance
  • Fact vs. dimension tables
  • Snowflake and star schemas
  • Create Model Calculations using DAX in Power BI
  • Introduction to DAX
  • Creating columns, tables, and measures
  • Working with basic DAX functions (aggregations, IF(), RELATED(), DISTINCT(), and DIVIDE())
  • Working with time intelligence using CALCULATE, SAMEPERIODLASTYEAR, and PARALLELPERIOD

Create Reports in Power BI

  • Designing a report
  • Enhancing the report
  • Configuring visual fields and format properties
  • Enhancing reports with interaction and formatting

Create Dashboards in Power BI

  • Creating and configuring dashboards
  • Pinning visuals to a dashboard
  • Configuring a dashboard tile alert
  • Using Q&A to create a dashboard tile

Perform Advanced Analytics in Power BI

  • Advanced analytics
  • Data insights through AI visuals
  • Using scatter charts, decomposition trees, and key influencers visual

Implement Security in Power BI

  • Understanding security in Power BI
  • Securing workspaces, reports, and datasets
  • Implementing row-level security
  • Implementing object-level security

Create Calculation Groups

  • Exploring how calculation groups work
  • Maintaining calculation groups in a model
  • Using calculation groups in a Power BI report

Optimize Model Performance in Power BI

  • Optimizing the model for performance
  • Import vs. DirectQuery vs. Composite models
  • Query folding
  • Performance analyzer
  • Aggregations
  • Incremental refresh

Create and Manage Scalable Power BI Dataflows

  • Describing Power BI dataflows and use cases
  • Describing best practices for implementing Power BI dataflows
  • Creating and consuming Power BI dataflows

Understanding Scorecards and Metrics in Power BI

  • Scorecards and metrics in Power BI
  • Examples of scorecards and metrics
  • License requirements for metrics
  • Accessing the Metrics Hub page
  • Creating manual and connected metrics
  • Sharing and subscribing to a scorecard

Understanding Apps in Power BI

  • What is an app in Power BI?
  • Sample app in Power BI
  • License requirements for apps in Power BI
  • Accessing the published app
  • The process for publishing an app in Power BI
  • Distributing the app
  • Updating an app
  • Deleting an app
  • Manually installing an app

Distribution and Sharing Options

  • Distribution and sharing options
  • Using the share option with dashboards and reports
  • Embedding live data in PowerPoint
  • Using the share option with scorecards and apps
  • Using the export option with reports
  • Analyzing in Excel
  • Exporting reports to PDF
  • Using the subscribe option
  • Embedding in Teams, SharePoint Online, and websites
  • Generating a QR code

Paginated Reports using Power BI Report Builder

  • Overview of paginated reports
  • Creating paginated reports
  • Working with parameters
  • Defining a data source and dataset
  • Publishing a paginated report