Adding Value Consulting

Start the Year Right with 10% Off! Use code "AVCFOREVER10" and begin your learning journey today!

PL-300 Microsoft Power BI Certification Training - eLearning
Data Analysis

PL-300 Microsoft Power BI Certification Training - eLearning

450,00 EUR

  • 30 hours
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

Language

Course and material are in English

Level

Beginner - Intermediate level for professionals

Access

12 months access to the eLearning (self-paced)

6 hours total video content

with 30 hours study time recommended

Official Exam Not Included

But Curriculum aligned with PL-300: Microsoft Power BI Data Analyst certification

Certification

PL-300 Microsoft Power BI Training Certification of completion

Hero

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 Outcomes

At the end of this PowerBI eLearning Course, you will be able to:

Power BI concepts

Understand Power BI concepts like desktop layouts, BI reports, dashboards, and Power BI DAX commands and functions

Visualization

Gain a competitive edge in creating customized visuals and deliver a reliable analysis of vast amount of data using Power BI

Experiment

Learn how to experiment, fix, prepare and present data quickly and easily

Report

Create a sales analysis report and a project management report

Advanced features

Utilize Power BI's AI-driven insights and analytics. Implement advanced data visualization techniques

Report Sharing and Collaboration

Learn to publish and share reports with stakeholders using the Power BI Service

Course timeline

Hero

  1. Course Introduction

    Lesson 01

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

  2. Get Data From Different Data Sources

    Lesson 02

    • 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

  3. Profile the data

    Lesson 03

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

  4. Clean Transform and Load the Data

    Lesson 04

    • 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

  5. Design a Data Model

    Lesson 05

    • 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

  6. Develop a Data Model

    Lesson 06

    • 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

  7. Optimize Model Performance

    Lesson 07

    • 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

  8. Create reports

    Lesson 08

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

  9. Create Dashboards

    Lesson 09

    • 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

  10. Enhance Reports to Expose Insights

    Lesson 10

    • 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

  11. Perform Advanced Analysis

    Lesson 11

    • 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

  12. Manage Semantic Models

    Lesson 12

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

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

Start course now

Prerequisites

  • Learners need to possess an undergraduate degree or a high school diploma. 
  • Additionally, a curiosity for data visualization and a desire to explore the applications of Power BI in data science is highly encouraged.

Statements

Licensing and accreditation

PL-300 Microsoft Power BI Certification Training course is offered by Simplilearn according to Partner Program Agreement and complies with the License Agreement requirements. AVC Promotes this course on behalf of Simplilearn.

Equity Policy

Simplilearn does not provide accommodations due to a disability or medical condition of any students. Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.

Frequently Asked Questions

certification training

Need corporate solutions or LMS integration?

Didn't find the course or program which would work for your business? Need LMS integration? Write us, we will solve everything!

;