PowerBI Certification Training - eLearning

PowerBI Certification Training - eLearning

This Power BI training course will help you get the most out of Microsoft’s Power BI, a suite of tools that lets you build interactive dashboards for analyzing data and extracting business insights. This course will help you master the development of dashboards from published reports, discover greater insights from your data with Quick Insights, and learn practical applications for Power BI tasks, such as gathering and analyzing data. You will also learn valuable Power BI troubleshooting tips.

Key Features

• Course and material are in English
• Beginner - Intermediate level for professionals
• 12 months access to the eLearning (self-paced)
• 6 hours total video content
• 30 hours study time recommended
• Official Exam Not Included But Curriculum aligned with PL-300: Microsoft Power BI Data Analyst certification
• PL-300 Microsoft Power BI Training Certification of completion

Power BI features

• Data Connectivity: Connects to diverse data sources, including Excel, SQL Server, Azure, SharePoint, Google Analytics, and more.
• Data Transformation: Cleans, prepares, and organizes raw data into a usable format with Power Query.
• Data Visualization: Provides a wide range of visual elements like charts, graphs, maps, and custom visuals for interactive dashboards.
• Advanced Analytics: Supports calculations using DAX (Data Analysis Expressions) and provides AI-driven insights.
• Collaboration and Sharing: Allows users to publish and share reports via the Power BI Service and embed them in apps or websites.
• Real-Time Monitoring: Offers live dashboards with real-time data updates, making it ideal for tracking metrics and KPIs.

Learning Objectives

This course will enable you to:

• Understand Power BI concepts like Microsoft Power BI desktop layouts, BI reports, dashboards, and Power BI DAX commands and functions
• Gain a competitive edge in creating customized visuals and deliver a reliable analysis of vast amount of data using Power BI
• Learn how to experiment, fix, prepare and present data quickly and easily
• Create a sales analysis report and a project management report
• Utilize Power BI's AI-driven insights and analytics. Implement advanced data visualization techniques
• Learn to publish and share reports with stakeholders using the Power BI Service

Who Should Enroll in this Program?

This Power BI course is ideal for people who want to understand how to use Power BI tools and create customized visuals with Power BI developer tools. It is also suitable for business intelligence (BI) and reporting professionals, data analysts, and professionals working with data in any sector.

• Business Intelligence Analyst
• Data Analysts
• Reporting Analyst
• Data Visualization Specialist
• Managers and Executives
• IT Professionals

Prerequisites

There are no prerequisites for taking this Power BI certification training.

• Additionally, a curiosity for data visualization and a desire to explore the applications of Power BI in data science is highly encouraged.

Course Outline

Course Introduction

• Skills covered
• Business Intelligence and Data Analytics high level overview
• Introduction to Power BI
• Different Power BI Offerings
• Installing Power BI

Lesson 1: Get Data From Different Data Sources

• Identify and connect to a data source
• Change data source settings
• Select a shared dataset
• Overview of storage modes
• Select a storage mode
• Choose an appropriate query type
• Use Microsoft Dataverse
• Use parameters
• Use or create a PBIDS file

Lesson 2: Profile the data

• Examine data structures
• Interrogate Column Properties
• Interrogate data statistics

Lesson 3: Clean Transform and Load the Data

• Overview of data transformation
• Resolve inconsistencies unexpected or Null Values and Data quality issues
• Apply user-friendly value replacements
• Evaluate and transform column data types
• Apply data shape transformations to table structures
• Combine queries
• Apply user-friendly naming conventions to columns and queries
• Leverage advanced editor to modify power query M code

Lesson 4: Design a Data Model

• Define the tables
• Configure table and column properties
• Flatten out a parent child hierarchy
• Define Role playing dimensions
• Create a common date table
• Defining relationship cardinality and cross filter direction

Lesson 5: Develop a Data Model

• Overview of DAX
• Overview of row and filter context
• Apply cross-filter direction and security filtering
• Create calculated tables
• overview of measures
• Create calculated colums
• Implement row-level security roles
• Set up the Q and A feature

Lesson 6: Optimize Model Performance

• Remove unnecessary rows and columns
• Identify poorly performing measures relationships and visuals
• Improve cardinality levels
• Optimize DirectQuery models
• Create and manage aggregations
• Use query diagnostics

Lesson 7: Create reports

• Add visualization items to reports
• Choose an appropriate visualization type
• Format and configure visualizations
• Apply slicing and filtering
• Add an R or Python Visual

Lesson 8: Create Dashboards

• Set mobile view
• Manage tiles on a dashboard
• Configure data alerts
• Use the Q and A feature
• Add a dashboard theme
• Pin a live report page to a dashboard

Lesson 9: Enhance Reports to Expose Insights

• Perform Top N Analysis
• Explore statistical summary
• Use the Q and A visual
• Add a quick insights result to a report
• Use the Play axis feature of a visualization
• Personalize visuals

Lesson 10: Perform Advanced Analysis

• Identify data anomalies
• Identify outliers
• Conduct time series analysis
• Use groupings and binnings
• Use the key influencers to explore dimensional variances
• Use the decomposition tree visual to break down a measure
• Apply AI insights

Lesson 11: Manage Semantic Models

• Configure a dataset scheduled refresh
• Configure row-level security group membership
• Configure incremental refresh settings
• Promote or certify PowerBI Datasets