Get in Touch

Course Outline

Introduction to Power BI

  • Gaining an understanding of the Power BI ecosystem.
  • Navigating the Power BI Desktop interface.
  • Establishing connections to common data sources.

Data Preparation and Transformation

  • Utilizing Power Query for data cleansing.
  • Shaping and transforming data structures.
  • Managing and combining various queries.

Data Modeling Fundamentals

  • Establishing relationships between tables.
  • Working with data types and hierarchies.
  • Constructing star schemas.

Creating Visualizations

  • Choosing the appropriate visuals for specific data types.
  • Customizing charts and visual elements.
  • Effectively utilizing slicers and filters.

Essential DAX Concepts

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

Advanced Analytics and Reporting

  • Creating drill-through pages and tooltips.
  • Enhancing dashboards with advanced visual components.
  • Applying conditional formatting rules.

Publishing and Sharing Insights

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

Performance Optimization and Governance

  • Enhancing data model performance.
  • Adhering to governance and compliance best practices.
  • Implementing effective dataset refresh strategies.

Summary and Next Steps

Requirements

  • A foundational understanding of data concepts.
  • Hands-on experience with spreadsheets or tabular data.
  • Basic familiarity with reporting tasks.

Target Audience

  • Business analysts.
  • Corporate professionals engaged in data management.
  • Users responsible for creating dashboards and reports.
 14 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories