Microsoft Power BI Data Analyst

This course will analyze different methods and best practices aligned with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. It will also show how to access and process data from a variety of data sources, including both relational and non-relational data. The course will also explore how to implement appropriate security standards and policies across the Power BI spectrum, including datasets and groups.

It will analyze how to manage and implement reports and dashboards to share and distribute content. Finally, it will show you how to create paginated reports within the Power BI service and publish them to a workspace to include them in Power BI.

After completing the course, participants will have learned to:

• Ingest, clean, and transform data.
• Model data for performance and scalability.
• Design and create reports for data analysis.
• Apply and perform advanced report analysis.
• Manage and share report assets.
• Create paginated reports in Power BI.

The target audience for this course includes data professionals and business intelligence professionals who want to learn how to perform accurate data analysis using Power BI. This course is also aimed at individuals who create reports that visualize data from data platform technologies, both in the cloud and on-premises.

Qualified data analysts begin this role with experience working with data in the cloud.

Specifically:

• Understanding of basic data concepts.
• Knowledge of how to work with relational data in the cloud.
• Knowledge of how to work with non-relational data in the cloud.
• Knowledge of the concepts of visualization and analysis of data.

A copy of the official Microsoft course material.

Active and participative course delivered through demonstrations, practical exercises, and clinical analysis based on all the theoretical topics taught by the instructor to address real cases related to the product. The trainer will also use different dynamics to enable group work in the classroom, such as challenges, assessment exams, and real-life cases to prepare for the associated Microsoft certification exam, if applicable.

This course is certified by Microsoft®.

Assessment based on group and individual activities. The trainer will provide continuous feedback to each participant at the end of the activities.

During the course, participants will complete an assessment test that they must pass with a score of over 75%. They will have one hour to complete the test.

The terms of additional certification services are subject to those established by the license owner or the authorized certification body.

A Certificate of Attendance will be issued only to participants with an attendance above 75%, and a Diploma of Achievement will be awarded if they also pass the assessment test.

1. Introduction to Microsoft Data Analytics

• Data analysis and Microsoft
• Introduction to Power BI

2. Data preparation in Power BI

• Obtain data from multiple data sources

3. Data cleaning, transformation, and loading in Power BI

• Shape data
• Improve data structure
• Generate data profiles

4. Designing data model in Power BI

• Introduction to data modeling
• Working with tables
• Dimensions and hierarchies

5. Creating model calculations with DAX in Power BI

• Introduction to DAX
• DAX context
• Advanced DAX

6. Optimizing model performance in Power BI

• Optimize the model for performance
• Optimize DirectQuery models
• Create and manage aggregations

7. Creating reports in Power BI

• Design a report
• Improve a report

8. Creating dashboards in Power BI

• Create a dashboard
• Real-time dashboards
• Improve a dashboard

9. Improving reports for usability and storytelling in Power BI

• Overview of paginated reports
• Create paginated reports

10. Performing advanced analytics in Power BI

• Advanced analytics
• Conclusions from data using AI visual objects

11. Managing datasets in Power BI

• Parameters
• Datasets
• Security in Power BI

12. Creating and managing workspaces in Power BI

• Create workspaces
• Share and manage resources

PL-300 / PL 300