We are the Best Consulting web site as part of the annual WebAward Competition!

(832) 981-4635
info@datacrafters.io
img
Language

English

Power BI Free Learning Path

Power BI is a business intelligence and data visualization tool developed by Microsoft. The Power BI Free learning path offers a comprehensive and cost-effective way to learn how to use Power BI and gain valuable skills in data analysis, reporting, and visualization. This learning path provides access to a variety of resources, including tutorials, video courses, and hands-on exercises to help you master the tool and become proficient in data-driven decision-making. Whether you’re a beginner or looking to enhance your existing skills, Power BI Free learning path is a valuable investment for your professional development and growth.

Prepare the Data (15-20%)

1. Get data from different data sources

SerialTopicResource 1Resource 2Resource 3
1Identify and connect to a data sourceY. TubeMultiple Data SourceMS.Doc
2Change data source settingsY. TubePBI CommunityWEB
3Select a shared dataset or create a local datasetY. TubeWEBLearning Path
4Select a storage modeM. DocY.TubeLearning Path
5Use Microsoft DataverseY. TubeDocLearning Path
6Change the value in a parameterY. TubeDocLearning Path
7Connect to a data flowY. TubeDocLearning Path

2. Clean, transform, and load the data

SerialTopicResource 1Resource 2Resource 3
1Profile the dataY.TubeM.Doc
2Resolve inconsistencies, unexpected or null values, and data quality issuesY.TubeLearning Path
3Identify and create appropriate keys for joinsWebWEBWEB
4Evaluate and transform column data typesWeb<Web
5Shape and transform tablesDocWEBBlog
6Combine queriesDocWEBBlog
7Apply user-friendly naming conventions to columns and queriesDocWEBBlog
8Configure data loadingM. DocY.TubePBI Com
9Resolve data import errorsY.TubeWEBM.Doc

Model the Data (30—35%)

1. Design a data model

SerialTopicResource 1Resource 2Resource 3
1Define the tablesDocsqlbi
2Configure table and column propertiesDocLabWEB
3Design and implement role-playing dimensionsY.TubeWEBWEB
4Define a relationship’s cardinality and cross-filter directionDocY.TubeWEB
5Design a data model that uses a star schemaDocWEBY.Tube
6Create a common date tableY.TubeDataCampY.Tube

2. Double-click this headline to edit the text.

SerialTopicsResource 1Resource 2Resource 3
1Create calculated tablesDocY.Tubesqlbi
2Create hierarchiesDocY.TubeWEB
3Create calculated columnsDocY.Tubesqlbi
4Implement row-level security rolesDocY.TubeWEB
5Use the Q&A featureDocY.Tube

3. Create model calculations by using DAX

SerialTopicResource 1Resource 2Resource 3
1Create basic measures by using DAXDocY.TubeWEB
2Use CALCULATE to manipulate filtersDocsqlbiDaxGuide
3Implement Time Intelligence using DAXY.TubeM.DocWEB
4Replace implicit measures with explicit measuresY.TubeWEBWEB
5Use basic statistical functionsY.TubeWEB
6Create semi-additive measuressqlbidaxpattern
7Use quick measuresY.TubeM.Doc

4. Optimize model performance

SerialTopicResource 1Resource 2Resource 3
1Remove unnecessary rows and columnsDocWEBWEB
2Identify poorly performing measures, relationships, and visualsY.TubeM.Doc
2Reduce cardinality levels to improve performanceY.TubeWEBWEB

Visualize and Analyze the Data (25—30%)

1. Create reports

SerialTopicResource 1Resource 2Resource 3
1Add visualization items to reportsPL-300DocM.Doc-1
2Choose an appropriate visualization typeM. DocY. TubePL-300
3Format and configure visualizationsPL-300M.Doc
4Use a custom visualPl-300Y.Tube
5Apply and customize a themeY. TubeM.Doc
6Configure conditional formattingM. DocWEBY.Tube
7Apply slicing and filteringY. TubeM.DocWEB
8Configure the report pageM. DocWEBY.Tube
9Use the Analyze in Excel featureM. DocsqlbiY.Tube
10Choose when to use a paginated reportBlogM.DocWEB

2. Create dashboards

SerialTopicResource 2Resource 2Resource 3
1Manage tiles on a dashboardY. TubeM.DocM.Doc-1
2Configure mobile viewY. TubeM.DocPL-300
3Use the Q&A featureY. TubeM.Doc
4Add a Quick Insights result to a dashboardY. TubeM.Doc
5Apply a dashboard themeY. TubeM.Doc
6Pin a live report page to a dashboardY. TubeM.DocY.Tube

3. Enhance reports for usability and storytelling

SerialTopicResource 2Resource 2Resource 3
1Configure bookmarksM.DocY.TubeWEB
2Create custom tooltipsM.DocWEBY.Tube
3Edit and configure interactions between visualsM.DocY.TubeWEB
4Drilldown into data using interactive visualsM.DocWEB
5Configure navigation for a reportM.DocWEBY.Tube
6Apply sortingM.DocY.TubeY.Tube
7Configure Sync SlicersM.DocY.Tube
8Group and layer visuals by using the selection paneM.DocWEB
9Export report dataM.DocWEBWEB
10Design reports for mobile devicesM.DocM.Doc

4. Identify patterns and trends

SerialTopicResource 1Resource 2Resource 3
1Use the Analyze feature in Power BIY.TubeY.TubeM.Doc
2Identify outliersDocWEBEDNA
3choose between continuous and categorical axesWEBWEB
4Use groupings, binnings, and clusteringDocY.TubeY.Tube
5Use AI visualY.TubeQ&ALearning Path
6Use the Forecast featureY.TubeWEBWEB
7Create reference lines by using the Analytics pane

Y.TubeM.DocWEB

Deploy and Maintain Assets (20—25%)

1. Manage files and datasets

SerialTopicResource 1Resource 2Resource 3
1Identify when a gateway is requiredY.TubeWEBWEB
2Configure a dataset scheduled refresh

Y.TubeWEBWEB
3Configure row-level security group membership

Y.TubeWEBWEB
4Provide access to datasets

DocY.TubeY.Tube
5Manage global options for files

Y.TubeM.Doc

2. Manage workspaces

SerialTopicResource 1Resource 2Resource 3
1Create and configure a workspace

Y.TubeM.Doc
2Assign workspace rolesY.TubeM.DocY.Tube
3Configure and update a workspace appY.TubeM.DocWEB
4Publish, import, or update assets in a workspacePBI ComWEBY.Tube
5Apply sensitivity labels to workspace contentY.TubeWEB
6Configure subscriptions and data alertsM.DocY.Tube
7Promote or certify Power BI contentWEBWEBWEB
8Power BI LabPracticeY.Tube

Microsoft Provided Exam Ready Zone Episodes

Preparing for the PL-300 certification involves mastering four key components: preparing the data, modeling the data, visualizing and analyzing the data, and deploying and maintaining assets. In the first step, preparing the data, one needs to acquire and clean data, making it ready for modeling and analysis. In the second step, modeling the data, one needs to develop a data model that is suitable for the analysis and reporting requirements. In the third step, visualizing and analyzing the data, one needs to create visualizations and perform analysis to uncover insights from the data. Finally, in the fourth step, deploying and maintaining assets, one needs to deploy the data model and visualizations in a production environment and ensure their performance and security.

Preparing for PL-300 – Prepare the Data (1 of 4)

Preparing for PL-300 – Model the Data (2 of 4)

Preparing for PL-300 – Visualize and Analyze the Data (3 of 4)

Preparing for PL-300 – Deploy and Maintain Assets (4 of 4)