Microsoft Power BI Data Analyst (PL-300)
This content is part of the LDI Data Analyst Role Path and is organised around the syllabus of the Microsoft PL-300 Exam which allows you to become a Certified Microsoft Power BI Data Analyst. Data Analysts enable businesses to maximize the value of their data assets by using Microsoft Power BI. As a subject matter expert, Data Analysts are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations
Note that the quizzes here are generally more challenging than the exam and under no circumstances should be viewed as an “exam dump” but rather as a way to identify and fill knowledge gaps in what is a very broad subject area
Quizzes
Quiz Prepare the Data: 5 Questions
This 5 Question PL-300 quiz, drawn from 101 questions in total, focuses on module “Prepare The Data" (15 -20% of the exam). Topics include Get data from different data sources, Clean, transform, and load the data data from different data sources.
5 Tokens
Quiz Prepare the Data: 10 Questions
This 10 Question PL-300 quiz, drawn from 101 questions in total, focuses on module “Prepare The Data" (15 -20% of the exam). Topics include Get data from different data sources, Clean, transform, and load the data data from different data sources.
10 Tokens
Courses
No courses to display.
E-Books
No E-Books to display.
Resources
No resources to display.
Using Data Profiling Tools
The data profiling tools provide new and intuitive ways to clean, transform, and understand data in Power Query Editor.
Combining Files in Power Query
With Power Query, you can combine multiple files that have the same schema into a single logical table.
This feature is useful when you want to combine all the files you have in the same folder. For example, if you have a folder that contains monthly files with all the purchase orders for your company, you can combine these files to consolidate the orders into a single view.
Data Sources for Power BI Service
In this article, we're going to cover the data source types you can connect to from the Power BI service.
Using DirectQuery in Power BI
You can connect to all sorts of different data sources when using Power BI Desktop or the Power BI service, and make those data connections in different ways. You can import data to Power BI, which is the most common way to get data, or connect directly to data in the original source repository, which is known as DirectQuery.
How to Migrate Queries from Power BI
If you already have queries in Power Query, either in Power BI Desktop or in Excel, you might want to migrate the queries into dataflows. The migration process is simple and straightforward. In this article, you'll learn the steps to do so.
How to Optimise your Data Analysis in Power BI
This article provides guidance that enables developers and administrators to produce and maintain optimized Power BI solutions. You can optimize your solution at different architectural layers.
Introduction to Dataflows
Dataflows are a self-service, cloud-based, data preparation technology. Dataflows enable customers to ingest, transform, and load data into Microsoft Dataverse environments, Power BI workspaces, or your organization's Azure Data Lake Storage account.
What is Query Diagnostics?
With Query Diagnostics, you can achieve a better understanding of what Power Query is doing at authoring and at refresh time in Power BI Desktop.
What is Query Folding?
This article targets data modelers developing models in Power Pivot or Power BI Desktop. It describes what Power Query query folding is, and why it's important in your data model designs.
Fixing Performance Issues in Power BI
Occasionally, organizations will need to address performance issues when running reports. Power BI provides the Performance Analyzer tool to help fix problems and streamline the process.
What is Power Query?
Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations. Using Power Query, you can perform the extract, transform, and load (ETL) processing of data.
Using DirectQuery in Power BI Desktop
With Power BI Desktop, when you connect to your data source, it's always possible to import a copy of the data into the Power BI Desktop. For some data sources, an alternative approach is available: connect directly to the data source using DirectQuery. This Article introduces this method of data storage.
Selecting a Storage Mode in Power BI
The most popular way to use data in Power BI is to import it into a Power BI dataset. Importing the data means that the data is stored in the Power BI file and gets published along with the Power BI reports. However, this approach might not work for all organizations. This article explores other methods of storage.
Getting Data from Files
Power BI Desktop allows you to get data from many types of files. You can find a list of the available options when you use the Get data feature in Power BI Desktop.
What is Microsoft Purview?
Microsoft Purview is a unified data governance service that helps you manage and govern your on-premises, multi-cloud, and software-as-a-service (SaaS) data.
Connect to and manage a Power BI tenant in Microsoft Purview
This article outlines how to register a Power BI tenant in a same-tenant scenario, and how to authenticate and interact with the tenant in Microsoft Purview.
How Does Azure Purview Work?
Here's where we'll take a look at how Microsoft Purview works, behind the scenes. You'll learn the core operational theory behind the functioning of Microsoft Purview for mapping and scanning your data sources.
In this video, Chris Webb (A seasoned Power BI expert who works for the Power BI Customer Advisory Team) runs through the fundamentals of the M language which is behind the Power Query
Query Overview in Power BI Desktop
A high level introduction to the Query Editor in Power BI Desktop from Microsoft Docs
Collect, Combine, and Transform Data Using Power Query in Excel and Power BI - Gil Raviv
This book is a comprehensive overview of how to achieve complex transformation activities in Power BI, written by former MVP Gil Raviv
No resources to display.
No resources to display.
Quizzes
Quiz Model the Data: 5 Questions
This 5 Question PL-300 quiz, drawn from 112 questions in total, focuses on module “Model The Data" (30-35% of the exam). Topics include Design a Data Model, Develop a Data Model, Create model calculations by using DAX and Optimise Model Performance.
5 Tokens
Quiz Model the Data: 10 Questions
This 10 Question PL-300 quiz, drawn from 112 questions in total, focuses on module “Model The Data" (30-35% of the exam). Topics include Design a Data Model, Develop a Data Model, Create model calculations by using DAX and Optimise Model Performance.
10 Tokens
Courses
No courses to display.
E-Books
No E-Books to display.
Resources
Time Intelligence and Measures in DAX
This articles covers the fundamentals of time intelligence and measures in DAX. It includes practical examples and walkthroughs of different scenarios.
Using the AVERAGE function
This article covers the basic functionality and usage of the function AVERAGE in Power BI.
Using the CALENDERAUTO function
This article covers a time intelligence function in DAX known as CALENDERAUTO. It covers how and when to use it as well as what it does.
What are Semi-Additive Measures?
This article covers how to use and create semi-additive measures that can be useful in certain situations.
Using USERELATIONSHIP in Power BI
This article covers how to use relationships more effectively. More specifically, it covers certain commands related to using relationships such as USERELATIONSHIP.
Using the Calculate Function
The CALCULATE function in DAX is one of the most important functions that a data analyst can learn. The function name does not adequately describe all it is intended to do.
This article covers the fundamentals behind using the CALCULATE function.
Introduction to DAX
Data Analysis Expressions (DAX) is a programming language that is used throughout Microsoft Power BI for creating calculated columns, measures, and custom tables. It is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. You can use DAX to solve a number of calculation and data analysis problems, which can help you create new information from data that is already in your model.
What is Data Granularity?
Data granularity is the detail that is represented within your data, meaning that the more granularity your data has, the greater the level of detail within your data.
Data granularity is an important topic for all data analysts, regardless of the Power BI tools that you are using. Defining the correct data granularity can have a big impact on the performance and usability of your Power BI reports and visuals.
Creating a Date Table
During report creation in Power BI, a common business requirement is to make calculations based on date and time. Organizations want to know how their business is doing over months, quarters, fiscal years, and so on. For this reason, it is crucial that these time-oriented values are formatted correctly. Power BI autodetects for date columns and tables; however, situations can occur where you will need to take extra steps to get the dates in the format that your organization requires.
How to Work with Tables
When users see fewer tables, they will enjoy using your data model considerably more. For example, suppose you've imported dozens of tables from many data sources and now the visual appears disorderly. In this case, you need to ensure that, before you begin working on building reports, your data model and table structure are simplified.
The following sections further explain how you might work with your tables to ensure a simple and readable table structure.
Introduction to Model the Data
Creating a great data model is one of the most important tasks that a data analyst can perform in Microsoft Power BI. By doing this job well, you help make it easier for people to understand your data, which will make building valuable Power BI reports easier for them and for you. This article briefly covers the key fundamental basics you will need to understand or familiarise yourself with early on.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
Quizzes
Quiz Visualize the Data: 5 Questions
This 5 Question PL-300 quiz, drawn from 100 questions in total, focuses on module “Visualize and Analyze the Data" (25 -30% of the exam). Topics include data visualisation covering topics such as creating interactive reports and dashboards.
5 Tokens
Quiz Visualize the Data: 10 Questions
This 10 Question PL-300 quiz, drawn from 100 questions in total, focuses on module “Visualize and Analyze the Data" (25 -30% of the exam). Topics include data visualisation covering topics such as creating interactive reports and dashboards.
10 Tokens
Quiz Analyse the Data: 5 Questions
This 5 Question PL-300 quiz, drawn from 60 questions in total, focuses on module “Visualize and Analyze the Data" (25 -30% of the exam). Topics include data analysis covering topics such as identifying patterns and trends.
5 Tokens
Quiz Analyse the Data: 10 Questions
This 10 Question PL-300 quiz, drawn from 60 questions in total, focuses on module “Visualize and Analyze the Data" (25 -30% of the exam). Topics include data analysis covering topics such as identifying patterns and trends.
10 Tokens
Courses
No courses to display.
E-Books
No E-Books to display.
Resources
No resources to display.
Importing Custom Visuals
This articles introduces how to import a custom visual into Power BI.
Choosing an Effective Visualisation
This article will introduce different types of visuals and elaborate on its suitability depending on the type of data you are using and the questions you are seeking to answer.
Tour the Report Editor in Power BI
In Power BI Desktop and in the Power BI service, the report editor is where you design the reports your consumers see, with charts, tables, maps, and other visuals. This article covers how to use this section of Power BI effectively.
Key Performance Indicators
This articles introduces the advantages and uses of utilising Key Performance Indicators in reports.
Tour the Filters Pane
This article takes a look at the report Filters pane in the Power BI service. Use the filters to discover new insights in your data.
Slicers in Power BI
This article walks through creating and formatting a basic slicer, using the free Retail Analysis Sample. It also covers controlling which visuals are affected by a slicer, syncing with slicers on other pages, and filtering and formatting slicers.
Adding Filters to Reports in Power BI
This article explains how to add a visualization filter, page filter, or report filter to a report in Power BI. You need to be able to edit a report to add filters. The examples in this article are in the Power BI service, and the steps are almost identical in Power BI Desktop.
Add Visualisation Items to Reports
Power BI has a variety of visuals that you can use to report on the data in your data model. Visuals allow you to present the important information and insights that you discovered in the data in a compelling and insightful way. The report consumers rely on these visualizations as a gateway to the underlying data. This article introduces basic usage of visuals.
Introduction to Power BI Visuals
Power BI visuals are attractive charts and graphics that you can use to revitalize your data. Visuals allow you to share data insights more effectively and increase comprehension, retention, and appeal. Visuals are a fundamental part of your report because they help your report audience connect and interact with the information to make informed decisions quickly.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
Quizzes
Quiz Deploy & Maintain Assets: 5 Questions
This 5 Question PL-300 quiz, drawn from 100 questions in total, focuses on module “Visualize and Analyze the Data" (25 -30% of the exam). Topics include data analysis covering topics such as Manage files and datasets, Manage workspaces.
5 Tokens
Quiz Deploy & Maintain Assets: 10 Questions
This 10 Question PL-300 quiz, drawn from 100 questions in total, focuses on module “Visualize and Analyze the Data" (25 -30% of the exam). Topics include data analysis covering topics such as Manage files and datasets, Manage workspaces.
10 Tokens
Courses
No courses to display.
E-Books
No E-Books to display.
Resources
No resources to display.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
No resources to display.
