0% found this document useful (0 votes)
66 views15 pages

Study Plan PBI

The document outlines a study program for preparing for the Power BI Data Analyst certification exam (PL-300). It lists the main topics covered by the exam and skills needed under each topic, including preparing and cleaning data, modeling data, optimizing model performance, visualizing and analyzing data, and deploying and maintaining assets. The skills range from connecting to data sources and transforming queries to creating DAX calculations, optimizing visualizations, and configuring workspaces. The study program provides a comprehensive overview of the key areas examined in the PL-300 certification.

Uploaded by

Fillipe Tahim
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
66 views15 pages

Study Plan PBI

The document outlines a study program for preparing for the Power BI Data Analyst certification exam (PL-300). It lists the main topics covered by the exam and skills needed under each topic, including preparing and cleaning data, modeling data, optimizing model performance, visualizing and analyzing data, and deploying and maintaining assets. The skills range from connecting to data sources and transforming queries to creating DAX calculations, optimizing visualizations, and configuring workspaces. The study program provides a comprehensive overview of the key areas examined in the PL-300 certification.

Uploaded by

Fillipe Tahim
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

1 25

1 16
5 12
4 20
1 52

12 125 60

Requerido 14 5

Dias 26
Horas por Dia 3

Subtotal de horas 78

Dias F.D.Semana 6
Horas adicionais 3
Subtotal de horas 18

Total de Horas 96
Microsoft Resoures
https://learn.microsoft.com/en-us/shows/exam-readiness-zone/preparing-for-pl-300-prepare-the-data-1-of-4
https://learn.microsoft.com/en-us/certifications/exams/pl-300

https://www.youtube.com/watch?v=hWhEIhHUicg
https://www.youtube.com/watch?v=Tfk3ae0qz3A
https://www.youtube.com/watch?v=zpzQc07uaUU
https://www.youtube.com/watch?v=7TC8H6duEiU

https://youtu.be/I3IGm97Q60s

https://www.youtube.com/watch?v=CitJpfKc4eI

https://www.youtube.com/watch?v=vG2mXST1PK0&list=PLp4MAoTwZIfcBPbzGrQlCbUZqIl36n8vy

https://www.youtube.com/watch?v=3Ax8Y7JzAK4

https://www.youtube.com/watch?v=LUZNFLISygA&t=2434s

https://www.youtube.com/watch?v=MrLnibFTtbA&t=31s
https://www.youtube.com/watch?v=VO-MyVMKUC4&pp=ugMICgJwdBABGAE%3D
https://www.youtube.com/watch?v=8FSgpJ-S95w
https://www.youtube.com/watch?v=5IYZR921toc&pp=ugMICgJwdBABGAE%3D
https://www.youtube.com/watch?v=VmA5e5XEbcA

https://www.youtube.com/watch?v=QJw4HkagVWc&list=PLcwrIWK7WBcRvRITYhWrMt0Y2BmEPVy8e

https://www.youtube.com/watch?v=xQxPznGGjcs

https://www.youtube.com/watch?v=ZmA8SqbfFts

https://www.youtube.com/watch?v=j0C3xdln7jw

https://www.youtube.com/watch?v=12g_o4NrovY

https://www.youtube.com/watch?v=e3784kHrljI
https://www.youtube.com/watch?v=RGXBev3jyJ4

https://www.youtube.com/watch?v=O2y2OGmAJYg

https://www.youtube.com/watch?v=8U5wn4Fgi6Q

https://www.youtube.com/watch?v=Z-KoowH0oU4
https://www.youtube.com/watch?v=UXhGRVTndQA

Main Subject Language Type https://skillcertpro.com/?s=power+bi&post_type=prod


Exam Prep English
Exam Prep English https://global3.mindhub.com/search?query=power+b

https://www.youtube.com/@PavanLalwani
How is the exam Portuguese
Prepare for the Exam English https://www.udemy.com/course/simulado-pl-300-ana
Prepare for the Exam English
Storage Modes English https://www.udemy.com/course/70-778-analyzing-an

https://www.udemy.com/course/pl-300-da-100-micro

Power BI Course English https://www.udemy.com/course/microsoft-power-bi-i

Direct Query vs Import Data Portuguese

Prepare for the Exam English

Prepare for the Exam English

Project Documentation English

Model the Data English


Model the Data English
Model the Data English
Model the Data English
Model the Data - Performance

DAX English

Full Course (Beginner)] English

PL 300 - Questions and Answers English

PL 300 - Exam Simulation Spanish

PL 300 - Sample questions English

PL 300 - Sample questions English


Exam Tips English

PL 300 - Sample questions English

Exam Tips English

Interview Questions and Answers English


e.com/watch?v=UXhGRVTndQA

om/?s=power+bi&post_type=product&dgwt_wcas=1

hub.com/search?query=power+bi&categoryId=11273

e.com/@PavanLalwani

.com/course/simulado-pl-300-analista-de-dados-do-microsoft-power/

.com/course/70-778-analyzing-and-visualizing-data-with-power-bi/

.com/course/pl-300-da-100-microsoft-power-bi-data-analyst-exam-prep/

.com/course/microsoft-power-bi-introduction/
STUDY PROGRAM

88 73
On Jan 31st, 2023 and on (CHANGES ONLY FOR ENGLISH)?

Prepare the data (25–30%)


Get data from data sources
• Identify and connect to a data source x
• Change data source settings, including credentials, privacy levels, and data source lo x
• Select a shared dataset, or create a local dataset x
• Choose between DirectQuery, Import, and Dual mode x
• Change the value in a parameter x

Clean the data


• Evaluate data, including data statistics and column properties x
• Resolve inconsistencies, unexpected or null values, and data quality issues x
• Resolve data import errors x

Transform and load the data


• Select appropriate column data types x
• Create and transform columns x
• Transform a query x
• Design a star schema that contains facts and dimensions x
• Identify when to use reference or duplicate queries and the resulting impact x
• Merge and append queries x
• Identify and create appropriate keys for relationships x
• Configure data loading for queries x

Model the data (25–30%)

Design and implement a data model


• Configure table and column properties x
• Implement role-playing dimensions x
• Define a relationship's cardinality and cross-filter direction x
• Create a common date table x
• Implement row-level security roles x
Create model calculations by using DAX
• Create single aggregation measures x
• Use CALCULATE to manipulate filters x
• Implement time intelligence measures x
• Identify implicit measures and replace with explicit measures x
• Use basic statistical functions x
• Create semi-additive measures x
• Create a measure by using quick measures x
• Create calculated tables x

Optimize model performance


• Improve performance by identifying and removing unnecessary rows and columns x
• Identify poorly performing measures, relationships, and visuals by using Performanc x
• Improve performance by choosing optimal data types x
• Improve performance by summarizing data x

Visualize and analyze the data (25–30%)

Create reports
• Identify and implement appropriate visualizations x
• Format and configure visualizations x
• Use a custom visual x
• Apply and customize a theme x
• Configure conditional formatting x
• Apply slicing and filtering x
• Configure the report page x
• Use the Analyze in Excel feature x
• Choose when to use a paginated report x

Enhance reports for usability and storytelling


• Configure bookmarks x
• Create custom tooltips x
• Edit and configure interactions between visuals x
• Configure navigation for a report x
• Apply sorting x
• Configure sync slicers x
• Group and layer visuals by using the Selection pane x
• Drill down into data using interactive visuals x
• Configure export of report content, and perform an export x
• Design reports for mobile devices x
• Incorporate the Q&A feature in a report x

Identify patterns and trends


• Use the Analyze feature in Power BI x
• Use grouping, binning, and clustering x
• Use AI visuals x
• Use reference lines, error bars, and forecasting x
• Detect outliers and anomalies x
• Create and share scorecards and metrics x

Deploy and maintain assets (15–20%)

Create and manage workspaces and assets


• Create and configure a workspace x
• Assign workspace roles x
• Configure and update a workspace app x
• Publish, import, or update assets in a workspace x
• Create dashboards x
• Choose a distribution method x
• Apply sensitivity labels to workspace content x
• Configure subscriptions and data alerts x
• Promote or certify Power BI content x
• Manage global options for files x

Manage datasets
• Identify when a gateway is required x
• Configure a dataset scheduled refresh x
• Configure row-level security group membership x
• Provide access to datasets x
98 82
PRIOR to Jan 31st, 2023 and on

Prepare the data (15–20%)


Get data from different data sources
• Identify and connect to a data source x
• Change data source settings x
• Select a shared dataset or create a local dataset x
• Select a storage mode x
• Use Microsoft Dataverse x
• Change the value in a parameter x
• Connect to a data flow x

Clean, transform, and load the data


• Profile the data x
• Resolve inconsistencies, unexpected or null values, and data qua x
• Identify and create appropriate keys for joins x
• Evaluate and transform column data types x
• Shape and transform tables x
• Combine queries x
• Apply user-friendly naming conventions to columns and querie x
• Configure data loading x
• Resolve data import errors x

Model the data (30–35%) https://www.youtube.com/watch?v=MrLnibFTtbA


https://www.youtube.com/watch?v=VO-MyVMKU
Design a data model
• Define the tables x
• Configure table and column properties x
• Design and implement role-playing dimensions x
• Define a relationship's cardinality and cross-filter direction x
• Design a data model that uses a star schema x
• Create a common date table x

Develop a data model


• Create calculated tables x
• Create hierarchies x
• Create calculated columns x
• Implement row-level security roles x
• Use the Q&A feature x
Create model calculations by using DAX https://www.youtube.com/watch?v=QJw4HkagVW
• Create basic measures by using DAX x
• Use CALCULATE to manipulate filters x
• Implement Time Intelligence using DAX x
• Replace implicit measures with explicit measures x
• Use basic statistical functions x
• Create semi-additive measures x
• Use quick measures x

Optimize model performance


• Remove unnecessary rows and columns x
• Identify poorly performing measures, relationships, and visuals x
• Reduce cardinality levels to improve performance x

Visualize and analyze the data (30–35%)

Create reports
• Add visualization items to reports x
• Choose an appropriate visualization type x
• Format and configure visualizations x
• Use a custom visual x
• Apply and customize a theme x
• Configure conditional formatting x
• Apply slicing and filtering x
• Configure the report page x
• Use the Analyze in Excel feature x
• Choose when to use a paginated report x

Create dashboards
• Manage tiles on a dashboard x
• Configure mobile view x
• Use the Q&A feature x
• Add a Quick Insights result to a dashboard x
• Apply a dashboard theme x
• Pin a live report page to a dashboard x

Enhance reports for usability and storytelling


• Configure bookmarks x
• Create custom tooltips x
• Edit and configure interactions between visuals x
• Configure navigation for a report x
• Apply sorting x
• Configure Sync Slicers x
• Group and layer visuals by using the selection pane x
• Drilldown into data using interactive visuals x
• Export report data x
• Design reports for mobile devices x

Identify patterns and trends


• Use the Analyze feature in Power BI x
• Identify outliers x
• Choose between continuous and categorical axes x
• Use groupings, binnings, and clustering x
• Use AI visuals x
• Use the Forecast feature x
• Create reference lines by using the Analytics pane x

Deploy and maintain assets (10–15%)

Manage files and datasets


• Identify when a gateway is required x
• Configure a dataset scheduled refresh x
• Configure row-level security group membership x
• Provide access to datasets x
• Manage global options for files x

Manage workspaces
• Create and configure a workspace x
• Assign workspace roles x
• Configure and update a workspace app x
• Publish, import, or update assets in a workspace x
• Apply sensitivity labels to workspace content x
• Configure subscriptions and data alerts x
• Promote or certify Power BI content x
e.com/watch?v=MrLnibFTtbA&t=31s
e.com/watch?v=VO-MyVMKUC4&pp=ugMICgJwdBABGAE%3D
e.com/watch?v=QJw4HkagVWc&list=PLcwrIWK7WBcRvRITYhWrMt0Y2BmEPVy8e

You might also like