PL-300T00 | Microsoft Power BI Data Analyst

• Understand the fundamentals of data analysis and visualization.
• Learn to navigate the Microsoft Power BI interface and ecosystem.
• Acquire skills to import and clean data from various sources.
• Master the creation of interactive and dynamic dashboards and reports.
• Develop proficiency in data modeling and manipulation techniques.
• Gain insights into advanced features such as DAX (Data Analysis Expressions) and Power Query.
• Apply data analysis concepts to real-world scenarios and business cases.

The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.

Successful Data Analysts start this role with experience of working with data in the cloud.

Specifically:

• Understanding core data concepts.
• Knowledge of working with relational data in the cloud.
• Knowledge of working with non-relational data in the cloud.
• Knowledge of data analysis and visualization concepts.

You can gain the prerequisites and a better understanding of working with data in Azure by completing Microsoft Azure Data Fundamentals before taking this course.

Course Outline:

Introduction to Data Analysis and Visualization

• Understanding the importance of data analysis in decision-making
• Overview of data visualization principles and best practices
• Introduction to Microsoft Power BI and its key features
• Exploring Power BI interface and workspace
• Getting familiar with data sources and connections

• Importing data from various sources (Excel, SQL Server, CSV, etc.)
• Understanding data types and formatting
• Data cleaning and transformation using Power Query Editor
• Creating calculated columns and measures
• Managing data relationships and hierarchies

• Creating visualizations (charts, graphs, maps, etc.) in Power BI
• Formatting and customizing visuals for better insights
• Designing interactive dashboards and reports
• Adding filters, slicers, and drill-down capabilities
• Tips for effective dashboard layout and design

• Understanding data modeling concepts (star schema, snowflake schema)
• Creating calculated tables and columns using DAX expressions
• Introduction to time intelligence functions
• Handling complex data relationships and scenarios
• Optimizing data models for performance

• Overview of DAX (Data Analysis Expressions) language
• Writing DAX formulas for calculated columns and measures
• Aggregation functions and iterators in DAX
• Using DAX for advanced calculations and analysis
• Practical exercises and examples to reinforce DAX skills

• Applying effective visualization techniques
• Using color, formatting, and layout to enhance communication
• Storytelling with data: Creating narratives in Power BI reports
• Designing reports for different audiences and purposes
• Reviewing and optimizing existing reports for clarity and impact

• Applying Power BI skills to real-world business scenarios
• Analyzing sales data, marketing performance, financial trends, etc.
• Creating dynamic and interactive dashboards for decision support
• Addressing challenges and constraints in data analysis projects
• Presenting findings and recommendations to stakeholders

• Collaborative capstone project applying all learned concepts
• Group presentations of capstone projects
• Final assessment and certification distribution
• Feedback session for continuous improvement

*Minimum 5 registrations required for public batches