Expert
powerbi remote

Power BI - Data Analyst #Remote #Learning

Andries Andries
Overview
Curriculum
  • 18 Sections
  • 35 Lessons
  • 32h Duration
Collapse All
PL-300 - Power BI - Data Analyst
4 Days - Starts @ 08:00 Ends @ 15:00 (UTC+2) - Starts Monday
Day 1: Introduction to Power BI and Data Preparation
Module 1 - Introduction to Power BI
3 Lessons
  1. Overview of Power BI
  2. Key components: Power BI Desktop, Service, and Mobile Apps
  3. Power BI Licensing (Free vs. Pro)
Module 2 - Connecting to Data Sources
3 Lessons
  1. Connecting to various data sources (Excel, SQL, etc.)
  2. Managing data connections and sources
  3. Introduction to Power Query
Module 3 - Data Transformation using Power Query
4 Lessons
  1. Cleaning and transforming data
  2. Removing errors and duplicates
  3. Combining data (Merging and Appending Queries)
  4. Shaping data for analysis
Day 2: Data Modeling in Power BI
Module 4 - Data Modeling Fundamentals
3 Lessons
  1. Introduction to data modeling concepts
  2. Creating and managing relationships
  3. Star schema and snowflake schema design
Module 5 - DAX (Data Analysis Expressions) Basics
3 Lessons
  1. Introduction to DAX
  2. Creating calculated columns and measures
  3. Using basic DAX functions like SUM, AVERAGE, and IF
Module 6 - Advanced DAX Calculations
3 Lessons
  1. Time intelligence functions (e.g., DATEADD, TOTALYTD)
  2. Working with filters and context
  3. Using variables in DAX
Day 3: Data Visualization and Report Building
Module 7 - Creating Visuals
3 Lessons
  1. Types of visuals: bar charts, line charts, tables, and more
  2. Choosing the right visuals for data
  3. Using slicers, filters, and drill-through
Module 8 - Designing Effective Reports
1 Lesson
  1. Best practices for report design
Module 9: Advanced Visuals
3 Lessons
  1. Using maps, key influencers, and decomposition tree visuals
  2. Customizing visuals for advanced insights
  3. Cross-filtering and cross-highlighting between visuals
Day 4: Sharing and Deploying Power BI Reports
Module 10 - Publishing and Sharing Reports
3 Lessons
  1. Publishing reports to Power BI Service
  2. Sharing reports and dashboards securely
  3. Embedding reports in SharePoint and other platforms
Module 11 - Data Refresh and Security
3 Lessons
  1. Setting up data refresh schedules
  2. Configuring Row-Level Security (RLS)
  3. Dynamic RLS for flexible access control
Module 12 - Power BI Administration and Governance
3 Lessons
  1. Managing workspaces and datasets
  2. Auditing and monitoring report usage
  3. Power BI governance best practices

PL-300: Microsoft Power BI Data Analyst

PL-300 course focuses on equipping data professionals with the skills needed to analyze, visualize, and share data insights using Microsoft Power BI. You'll learn how to prepare data for analysis, build and optimize data models, create interactive reports, and share your findings across your organization. This course will guide you through practical, hands-on exercises, giving you the knowledge to leverage Power BI for business intelligence and data analytics.

This training is remote online, attend from anywhere on any device.

Key Takeaways:

  • Clean, transform, and load data into Power BI.
  • Build and optimize data models for efficiency.
  • Create compelling visual reports and dashboards.
  • Apply DAX (Data Analysis Expressions) to perform calculations.
  • Share and publish reports securely through Power BI Service.

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Related Courses

Expert
functional-consultant powerapps remote

Power Apps - Functional Consultant

Andries Andries

Overview of Microsoft Power Platform

Building Canvas Apps

Automating Workflows with Power Automate

40h
44
Buy Now
Scroll to Top