Course Overview

This bootcamp is designed by industry professionals to help you master Power BI. As a part of this bootcamp, you’ll get to work on multiple real-life projects. You will gain job-ready Power BI expertise in this skill-building hands-on applied learning approach bootcamp.

Key Learning Areas

  • 12 hours of Instructor-Led training
  • 12 hours of project-based labs
  • 1:1 personalized training
  • Real-world project-based exercises

Course Outline

Getting Started with Power BI

  • Introduction to Power BI
  • Business Intelligence and Data Analytics Overview
  • Power BI Offerings and Pricing
  • Architecture of Power BI
  • Introduction to Power BI Desktop
  • Installing Power BI Desktop
  • Exploring Key Features of Power BI Workflow

Data Extraction and Preparation

  • Overview of Power BI Data Sources
  • Connecting Data using SaaS Connections
  • Query Editor Layout and Functionality
  • Working with Azure Sqldata Sources
  • Creating Relationships in Your Data Model
  • Introduction to Power Query Editor
  • Query Dependency Editor

Data Shaping & Transformation

  • Shaping Data using Power Query Editor
  • Formatting Data
  • Transformation of Data Understanding of Data Types
  • Data Profiling for Data Quality Check
  • Naming Conventions
  • Identify and Create Appropriate Keys for Joins
  • Working with Parameters
  • Merge Query

Data Modelling & Optimize Model Performance

  • Introduction to Relationship in Power BI
  • Creating relationships in Power BI
  • Introduction to DAX
  • Exploring DAX syntax, Context, and Functionalities
  • Identifying and Optimizing the Model for Performance
  • Measures using DAX
  • Calculated Tables using DAX
  • Advanced DAX Features in Power BI

Developing Reports & Dashboards

  • Exploring Power BI Data Visualization Components
  • Understanding Power Views and Power Maps
  • Design a Report Page Layout
  • Select and Add Effective Visualizations
  • Page Navigation
  • Creating Power BI Template for Design Reusability
  • Creating a Sales Analysis Report
  • Monitoring Performance of Report

Creating Well-Managed Workspaces in Power BI

  • Introduction to Power BI Service
  • Introduction of Workspaces
  • Creating & Configuring Dashboards
  • Dashboard Theme
  • Reports vs. Dashboards
  • Building Workspace
  • Understand Workspace Collaboration,
  • Monitor Workspace Usage and Performance
  • Apps Sharing Reports & Dashboards

Perform Advanced Analytics using Power BI

  • Advanced Analytics
  • Data Insights through AI Visuals
  • Create Animated Scatter Charts
  • Use the Visual to Forecast Values
  • Work with Decomposition Tree Visual
  • Work with the Key Influencers Visual
  • Configure Row-Level Security Roles and Group Memberships

Who Benefits

The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.

Prerequisites

Successful Data Analysts start this role with experience of working with data in the cloud. Specifically:

  • Understanding core data concepts
  • Knowledge of working with relational data in the cloud
  • Knowledge of working with non-relational data in the cloud
  • Knowledge of data analysis and visualization concepts