PL-300 Certification: Microsoft Power BI Data Analyst
PL-300: Microsoft Power BI Data Analyst
18 hours
592 €
Tutored
Description of the course
This intensive course immerses you in the world of data analysis with Power BI, equipping you with the skills and knowledge necessary to effectively model, visualize, and analyze data.
You'll learn how to leverage the power of Power BI to access and process data from a variety of sources, both relational and non-relational, transforming it into valuable and actionable insights.
Profile of Access
This course is designed for data professionals and business intelligence enthusiasts looking to master data analysis techniques with Power BI. It is ideal for those who:
They want to create impactful reports that visualize data clearly and concisely.
They seek to develop high-level data analysis skills to make data-driven strategic decisions.
They need to manage and implement interactive dashboards to share information with stakeholders.
They are transitioning into data analyst or data scientist roles.
Objectives of the Course
✓ Connecting to Data Sources: Learn how to connect Power BI to a wide range of data sources, including relational databases, CSV files, APIs, and cloud services.
✓ Data Modeling: Develop your ability to efficiently model and transform data, creating clean and organized data structures for accurate analysis.
✓ Data Visualization: Master data visualization techniques to create interactive charts, graphs, and dashboards that communicate information clearly and compellingly.
✓ Data Analysis: Learn to perform in-depth data analysis, using measures, filters, and DAX functions to extract valuable insights from your data.
✓ Deployment and sharing: Learn how to deploy and share your reports and dashboards with stakeholders using Power BI Desktop, Power BI Service, and Power BI Pro.
Contents of the Course
MODULE 1. Introduction to Microsoft Data Analytics
- Data analysis and Microsoft.
- Introduction to Power BI.
MODULE 2. Data preparation in Power BI
- Data analysis and Microsoft.
- Optimize performance.
- Resolve data errors.
MODULE 3. Data cleansing, transformation, and loading in Power BI
- Shaping the data
- Improve the data structure
- Generate data profiles
MODULE 4. Designing a data model in Power BI
- Introduction to data modeling.
- Working with tables.
- Dimensions and Hierarchies.
- Create model relationships.
- Configure tables.
- Review of the model interface.
- Create hierarchies.
MODULE 5. Create model calculations using DAX in Power BI
- Introduction to DAX.
- DAX context.
- Advanced DAX.
- Create calculated tables.
- Create calculated columns.
- Create measures.
- Use the CALCULATE() function to manipulate the filter context.
- Use Time Intelligence functions.
MODULE 6. Optimizing model performance in Power BI
- Optimize the data model for performance
- Optimize DirectQuery models
- Create and manage aggregations
MODULE 7. Create reports in Power BI
- Design a report.
- Improve the report.
- Create a dynamic connection in Power BI Desktop.
- Configure visual fields and formatting properties.
- Create and configure Sync Slicers.
- Create a drill-down page.
- Apply conditional formatting.
- Create and use Bookmarks.
MODULE 8. Creating dashboards in Power BI
- Create a board.
- Real-time dashboards.
- Improve a panel.
- Create a board.
- Pin visuals to a board.
- Use Questions and Answers to create a board mosaic.
MODULE 9. Identify patterns and trends in Power BI
- Advanced analysis.
- Data insights through AI imaging.
- Create animated scatter charts.
- Use the visual to forecast values.
MODULE 10. Create and manage workspaces in Power BI
- Creating workspaces.
- Share and manage assets.
MODULE 11. Managing files and datasets in Power BI
- Parameters.
- Data sets.
MODULE 12. Row-level security in Power BI
- Security in Power BI.
CERTIFICATIONS:
PL-300: Microsoft Power BI Data Analyst
