Get in Touch
 Duration 14 hours

Course Outline

Introduction to Power BI

  • Exploring the Power BI ecosystem
  • Navigating the Power BI Desktop interface
  • Establishing connections to common data sources

Data Preparation and Transformation

  • Utilizing Power Query for efficient data cleaning
  • Shaping and transforming data structures
  • Managing and integrating multiple queries

Data Modeling Fundamentals

  • Establishing relationships between tables
  • Managing data types and hierarchical structures
  • Constructing effective star schemas

Building Visualizations

  • Selecting optimal visuals for specific data types
  • Customizing charts and visual elements
  • Implementing slicers and filters for enhanced interactivity

DAX Essentials

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

Advanced Analytics and Reporting

  • Developing drill-through and tooltip pages
  • Augmenting dashboards with advanced visual components
  • Utilizing conditional formatting for emphasis

Publishing and Sharing Insights

  • Distributing reports via Power BI Service
  • Administering workspaces and access controls
  • Collaboratively sharing dashboards across teams

Optimizing Performance and Governance

  • Enhancing data model performance
  • Adhering to governance and compliance standards
  • Configuring effective dataset refresh strategies

Summary and Next Steps

Requirements

  • A foundational grasp of data concepts
  • Proficiency with spreadsheets or tabular data structures
  • Basic experience with reporting tasks

Target Audience

  • Business analysts
  • Corporate professionals engaged with data
  • Indivduals required to generate dashboards and reports

Number of participants


Price per participant (excl. VAT)

Testimonials (1)

Upcoming Courses

Related Categories