Get in Touch

Course Outline

Introduction to Power BI

  • Comprehending the Power BI ecosystem
  • Navigating the Power BI Desktop interface
  • Connecting to standard data sources

Data Preparation and Transformation

  • Employing Power Query for data cleansing
  • Structuring and transforming data
  • Managing and merging queries

Fundamentals of Data Modeling

  • Establishing relationships between tables
  • Working with data types and hierarchical structures
  • Constructing star schemas

Creating Visualizations

  • Choosing appropriate visuals for specific data sets
  • Customizing charts and graphical elements
  • Effectively utilizing slicers and filters

Essentials of DAX

  • Understanding calculated columns and measures
  • Applying common DAX functions
  • Implementing time intelligence concepts

Advanced Analytics and Reporting

  • Creating drill-through pages and tooltip interactions
  • Enhancing dashboards with sophisticated visuals
  • Applying conditional formatting techniques

Publishing and Sharing Insights

  • Publishing reports to the Power BI Service
  • Managing workspaces and user access permissions
  • Sharing dashboards across different teams

Optimizing Performance and Governance

  • Enhancing the performance of data models
  • Adhering to governance and compliance best practices
  • Implementing strategies for dataset refreshes

Summary and Future Steps

Requirements

  • A foundational understanding of data concepts
  • Previous experience working with spreadsheets or tabular data
  • Familiarity with fundamental reporting tasks

Target Audience

  • Business analysts
  • Corporate professionals dealing with data analysis
  • Individuals responsible for creating dashboards and reports
 14 Hours

Number of participants


Price per participant

Testimonials (2)

Provisional Upcoming Courses (Require 5+ participants)

Related Categories