Get in Touch
 Duration 14 hours

Course Outline

Fundamentals of the Power BI Platform

  • Exploring the components of the Power BI ecosystem
  • Mastering navigation within the Power BI Desktop interface
  • Establishing connections to various data sources

Preparing and Transforming Data

  • Utilizing Power Query for efficient data cleaning
  • Refining and reshaping raw data
  • Consolidating and managing multiple queries

Core Principles of Data Modeling

  • Defining relationships across different tables
  • Handling data types and establishing hierarchies
  • Constructing effective star schema models

Developing Visualizations

  • Choosing appropriate visuals for specific data types
  • Customizing charts and visual elements
  • Implementing slicers and filters for interactive exploration

DAX Fundamentals

  • Distinguishing between calculated columns and measures
  • Applying standard DAX functions
  • Incorporating time intelligence concepts

Advanced Analytics and Reporting Techniques

  • Designing drill-through capabilities and tooltip pages
  • Enhancing dashboards with complex visual elements
  • Applying rules for conditional formatting

Distributing and Sharing Insights

  • Deploying reports to the Power BI Service
  • Administering workspaces and user access controls
  • Distributing dashboards across different teams

Performance Optimization and Governance

  • Refining data model performance
  • Adhering to governance and compliance standards
  • Setting up strategies for dataset refreshes

Conclusion and Future Steps

Requirements

  • A foundational grasp of data concepts
  • Proficiency with spreadsheets or tabular data structures
  • Experience with fundamental reporting tasks

Target Audience

  • Business analysts
  • Corporate professionals engaged in data-related work
  • Individuals responsible for generating dashboards and reports

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories