Big Data Training & Consulting

Analyzing Data with Microsoft Power BI (Exam DA-100)

The "Analyzing Data with Microsoft Power BI" course (Exam DA-100) is designed to provide participants with the skills and knowledge required to analyze and visualize data using Microsoft Power BI. This course covers various aspects of data analysis, including data preparation, modelling, visualization, and collaboration. Participants will learn how to connect to data sources, transform and shape data, create relationships between tables, design interactive reports and dashboards, and share insights using Power BI.

Course Duration: 4 Days

Course Objectives:

• Understand the Power BI ecosystem and its components.
• Connect to and import data from various sources into Power BI.
• Prepare and transform data using Power Query Editor.
• Design and implement data models using Power BI Desktop.
• Create and format visuals to effectively communicate data insights.
• Implement calculations and measures using DAX expressions.
• Collaborate and share reports and dashboards using Power BI service.

Course Outline:

Module 1: Introduction to Power BI

• Overview of Power BI and its components.
• Understanding data analysis and visualization concepts.
• Exploring the Power BI ecosystem.

Module 2: Connecting to Data Sources

• Connecting to on-premises and cloud-based data sources.
• Importing data into Power BI Desktop.
• Transforming data using Power Query Editor.

Module 3: Data Modeling in Power BI

• Understanding data modeling concepts in Power BI.
• Creating relationships between tables.
• Implementing calculations and measures using DAX.

Module 4: Designing Reports and Dashboards

• Visual design principles for effective data presentation.
• Creating and formatting visuals in Power BI Desktop.
• Designing interactive reports and dashboards.

Module 5: Advanced Data Analysis Techniques

• Utilizing advanced calculations and measures in DAX.
• Implementing time intelligence functions.
• Applying statistical functions and analysis.

Module 6: Collaboration and Sharing

• Publishing reports and dashboards to Power BI service.
• Creating and managing workspaces.
• Collaborating and sharing insights with others.

Module 7: Data Refresh and Security

• Configuring data refresh settings.
• Implementing row-level security and data security measures.
• Understanding data governance and compliance in Power BI.

Module 8: Power BI Service Administration

• Monitoring and managing Power BI workspaces.
• Configuring access and security settings.
• Troubleshooting common issues in Power BI.

Note: The course outline provided above is a general guideline and can be customized or adjusted as per the specific requirements and needs of the training program.