PL-300T00: Microsoft Power BI Data Analyst

Learn how to use Microsoft's Power BI tools to create and communicate powerful, compelling data analysis from online and internal datasets.

TrainACE's Power BI training course will teach data analysts how to use its suite of tools to deliver actionable insights from disparate data sources.

This hands-on training is delivered live by Microsoft experts with industry experience. This three day class will give you everything you need to pass the Power BI certification

 

 

Learn More About Power BI Data Analyst

 

 

Why Take Microsoft Power BI Data Analyst Training?

Washington DC, Maryland, and Virginia organizations continue to gather increasingly large volumes of data in various formats and applications. Data analysts with the knowledge and skills to gather, manipulate and present this business intelligence in a meaningful way are very much in demand.

Power BI is part of the Microsoft Power Platform and was developed by Microsoft to enable interactive data visualization, primarily for business intelligence purposes.

Power BI is a suite of apps, software, and connectors used to manipulate unrelated data sources into cohesive, visual, and interactive insights. By uploading data into the Power BI tools directly from databases, webpages, or structured files such as spreadsheets, CSV, XML, and JSON, data analysts can quickly help drive critical business decisions.

TrainACE's Power BI training course will teach data analysts how to use its suite of tools to deliver actionable insights from disparate data sources. Data analysts will learn to use Power BI to communicate with stakeholders, identify business requirements, clean data, and build data models.

On successful completion of the course, you will understand how to:

• 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 report assets

 

 

What you need to know before taking Microsoft Power BI training

There are no specific prerequisites for this class, but we recommend that candidates for Microsoft Power BI have some experience working with data in the cloud.

More specifically, data analysts with an understanding of core data concepts, working knowledge of relational and non-relational databases in the cloud, and experience working with data analysis and visualization will benefit from this class.

Exam and Certification Requirements:

The PL-300 Microsoft Power BI exam covers four skill areas. Data preparation comprises 15-20 percent of the exam, modeling data thirty to thirty-five percent, data visualization, and analysis 25-20 percent, and asset deployment and maintenance 20-25 percent.

The passing score for this Power BI exam is 70% or 700 out of 1,000 points. Note that the questions in this exam are weighted according to their difficulty, so the number of questions you answer correctly may not equate to a pass. The exams were created by a group of subject matter experts who considered the difficulty of the questions being asked and how the question demonstrates knowledge and skill in a particular topic area.

Who needs Microsoft Power BI classes in the DMV?

This Microsoft Power BI training and certification is ideal for data analysts, business analysts, and other data professionals. It is beneficial for people who need to analyze and visualize data sets from different data sources, both in the cloud and on-premises.

What will I learn in this Microsoft Power BI class?

Our instructors will teach you how to manipulate and visualize large datasets pulled from diverse data sources. Whether your data is held in in-house databases, the web, or other non-traditional repositories.

 

We'll teach you:

 

How to get started with Microsoft data analytics.

In this module, you'll discover the range of roles in the data space and the essential roles and responsibilities that Data Analysts play, and we'll show you the Power BI portfolio of tools.

Lessons: Data Analytics and Microsoft, Getting Started with Power BI

Upon completion of this module, you will have explored different data roles and identified tasks that data analysts undertake. You'll be able to describe the products and services available within the Power BI toolset and will have used the Power BI service.

 

Power BI and gathering data

In this part of the training, students will learn how to identify and pull data from a range of different data sources. You'll be shown different ways to connect and store data and learn how connecting directly to data sources versus importing data it makes affects performance.

Lessons: Data Analytics and Microsoft, Optimize Performance, Resolve Data Errors

Power BI Lab: Preparing Data in Power BI Desktop - Prepare Data

Upon completion of this part of the training, you'll be able to identify and retrieve data from a range of data sources, you'll explore connection methods and their performance implications, utilize Microsoft Dataverse, and connect to a data flow.

 

Using Power BI to clean, transform, and load data

In this part of the training, you'll learn how to profile and understand the condition of data. You'll be taught to recognize data anomalies, study the shape and size of their data, and conduct the appropriate data cleaning and transformation processes, thereby preparing your data for data modeling.

Lessons: Shaping Data, Profiling Data, Enhance the data structure

Power BI Lab: Loading Data in Power BI Desktop - Loading Data

On completion, you'll know how to apply data shape transformations, enhance data structure, and perform data profiling and examination.

 

Using Power BI to design data models

You'll learn the fundamental concepts used to design and create data models, paying attention to performance and scalability. You'll also be taught how to solve common data modeling issues, such as security, relationships, and security.

Lessons: Data modeling fundamentals, Working with tables, Hierarchies and Dimensions

Power BI Lab: Data Modeling in Power BI Desktop - Create Model Relationships - Configure Tables and Column Properties - Create hierarchies

On completion, you'll understand data modeling fundamentals, you'll know how to define relationships and their cardinality, and you'll be able to implement hierarchies and dimensions.

 

DAX in Power BI and how to make model calculations using it.

During this section of the training, we'll introduce you to DAX. Your instructor will take you through aggregations and introduce the concepts of calculated columns, tables, and Measures. They will also demonstrate Power BI's Time Intelligence functions to solve calculation and data analysis problems.

Lessons: DAX introduction, Real-time dashboards, Advanced DAX

Power BI Lab: Introduction to DAX in Power BI Desktop - Create calculated tables - Create calculated columns - Create measures.

Power BI Lab: Advanced DAX in Power BI Desktop - Use the CALCULATE() - Function to manipulate filter context - Use Time Intelligence functions

Upon completion of this module, you'll understand DAX and how to use it for creating simple formulas and expressions. You'll have learned how to build calculated tables and measures and have worked with Time Intelligence and Key Performance Indicators.

 

Power Bi and Model Performance Optimization

You'll be taught how to optimize an enterprise-level data model for performance.

Lessons: Optimize the data model for performance, Optimize DirectQuery Models.

By completing this class, you will understand the importance of variables, how to improve a data model, and how to optimize the storage model.

Using Power BI to create reports

Your analysis is only as good as how you communicate it to others, so we'll teach you how to use Power BI's functionality to design and create compelling reports, including utilizing graphics, laying out pages, and applying basic but critical functionality, including formatting your report for accessibility.

Lessons: Designing a report, Enhance the report.

Power BI Lab: Enhancing reports with interaction and formatting in Power BI Desktop - Create and configure Sync Slicers - Create a drill through the page - Apply conditional formatting - Create and use Bookmarks

Power BI Lab: Designing a report in Power BI Desktop - Design a report - Configure visual fields and format properties

On completion of this section of the training, you will be able to design a report page layout, utilize compelling graphics, include basic report functionality, and include interactions and navigation within your reporting.

 

Using Power BI to create dashboards

In this part of the training, we'll teach you the importance of telling a story with your analysis using dashboards. You'll make good use of the various navigation tools available to guide your audience through your story. You'll learn how to use Power BI's functionality to enhance the usability and insights of your data models and analysis.

Lessons: Dashboard Creation, Real-time Dashboards, Dashboard Enhancement

Power BI Lab: Creating a Dashboard in Power BI Service - Create a Dashboard - Pin visuals to a Dashboard - Use Q&A to create a dashboard tile

On completion of this module, you will have learned how to create a dashboard, you'll understand real-time dashboards, and you'll be able to use Power BI functionality to enhance your dashboard usability.

Identify Patterns and Trends in Power BI

You'll learn how Power BI's additional features can be used to improve your reporting of analytical insights in the data. You'll understand what steps you need to take to create reports for real data analysis. We'll show you how to conduct advanced analytics using AI visuals, giving deeper and more meaningful data insights.

Lessons: Advanced Analytics, Data Insights through AI visuals

Power BI Lab: Data Analysis in Power BI Desktop - Create animated scatter charts - Use the visual to forecast values.

On completing this part of the class, you'll have learned how to use the Analyze feature, use Power BI functionality to identify data outliers, understand how to use AI visuals, and compile advanced analytics.

 

Using Power BI to create and manage Workspaces

Here you'll be taught how to utilize Workspaces in Power BI. We'll show you how to create and maintain them, how to share content, and how to share Apps.

Lessons: Creating Workspaces, Sharing and Managing Assets

On completing this part of the training, you'll be able to create and maintain workspaces as well as collaborate, monitor workspace usage and performance and distribute Apps.

Manage Files and Datasets in Power BI

Here you'll learn about datasets and parameters. We'll teach you about managing datasets and parameters, building dynamic reports with parameters, and setting dataset refresh options.

Lessons: Parameters, Datasets

After this training, you'll be able to manage datasets and parameters, use parameters in the creation of reports, schedule dataset refresh, and troubleshoot gateway service connectivity.

 

Using Power BI for row-level security

The last part of the training focuses on teaching row-level security using static and dynamic methods.

Lessons: Security in Power BI

Power BI Lab: Enforce Row-Level Security - Configure many-to-many relationships - Enforce row-level security

Upon completing this training, you'll be able to set up and configure row-level security using Static and Dynamic methods.