Learn Power BI and become a Microsoft-certified Power BI Data Analyst with Seven Learning’s course Power BI Data Analyst. The course has well descriptive interactive lessons containing knowledge checks, quizzes, flashcards, and glossary terms to get a detailed understanding of preparing, modelling, visualising and analysing the data in Power BI. The live labs present in the course will give you a hands-on experience of data analysis in Power BI.
What do you get:
Microsoft Power BI Data Analyst focuses on using Microsoft Power BI for data analysis. The PL-300 exam covers various topics such as getting data from different data sources, and profiling, cleaning, transforming, and loading the data, data modeling: designing, developing, and optimizing a data model, visualising and analysing data, such as creating reports and dashboards, as well as performing advanced analysis.
Lessons 1: Introduction
- Organisation of this course
- Microsoft certifications
Lessons 2: Prepare the data
- Skill 1.1: Get data from different data sources
- Skill 1.2: Profile the data
- Skill 1.3: Clean, transform and load the data
Lessons 3: Model the data
- Skill 2.1: Design a data model
- Skill 2.2: Develop a data model
- Skill 2.3: Create measures by using DAX
- Skill 2.4: Optimise model performance
Lessons 4: Visualise the data
- Skill 3.1: Create reports
- Skill 3.2: Create dashboards
- Skill 3.3: Enrich reports for usability
Lessons 5: Analyse the data
- Skill 4.1: Enhance reports to expose insights
- Skill 4.2: Perform advanced analysis
Lessons 6: Deploy and maintain deliverables
- Skill 5.1: Manage datasets
- Skill 5.2: Create and manage workspaces
Hands-on LAB Activities
Prepare the data
- Creating a Data Connection
- Profiling Data in Power BI
- Using the Transpose Feature
- Shaping Data for Analysis
- Cleaning, Transformings and Loading Connected Data
Model the data
- Configuring and Managing Data Relationships
- Creating a Calculated Table
- Creating and Managing Data Hierarchies
- Creating Calculations with DAX
- Creating Conditional Columns
- Creating Calculated Measures
Visualise the data
- Reviewing Custom Visuals and Apps
- Filtering and Slicing Reports
- Customising Visuals in Power BI
- Charting Data in Power BI
- Creating Visualisations
- Configuring the Mobile Layout
- Incorporating Tooltips to Enhance Data Analysis
- Saving and Exporting Files in Power BI
Analyse the data
- Enhancing Reports
- Enhancing Visuals with Statistical Analysis
- Performing Advanced Analysis
Deploy and maintain deliverables
- Configuring Row-level Security
- Publishing Reports and Refreshing Data
- Enhancing Dashboards
Exam FAQs
FAQ's are not Available for this course.Summary
Standard:
Power BI Data
Lessons:
6+ Lessons
Delivery Method:
Online
Language:
English