Get in Touch
 Duration 14 hours

Course Outline

Getting Started with Power BI

  • Exploring the Power BI ecosystem
  • Navigating the Power BI Desktop workspace
  • Establishing connections to standard data sources

Data Cleansing and Transformation

  • Leveraging Power Query for data hygiene
  • Reshaping and modifying data structures
  • Consolidating and managing multiple queries

Core Principles of Data Modeling

  • Defining relationships across tables
  • Handling data types and structural hierarchies
  • Constructing efficient star schemas

Crafting Effective Visualizations

  • Choosing appropriate visuals for specific data types
  • Tailoring the appearance of charts and elements
  • Utilizing slicers and filters to refine views

Foundations of DAX

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

Advanced Analytical Techniques

  • Implementing drill-through capabilities and tooltips
  • Enhancing dashboard complexity with advanced visuals
  • Applying dynamic conditional formatting

Distribution and Collaboration

  • Publishing completed reports to Power BI Service
  • Administering workspaces and user permissions
  • Distributing dashboards to cross-functional teams

Performance Tuning and Governance

  • Optimizing the efficiency of data models
  • Adhering to governance and compliance standards
  • Setting up automated dataset refresh schedules

Recap and Future Learning Paths

Requirements

  • A solid grasp of fundamental data concepts
  • Practical experience working with spreadsheets or tabular data
  • Basic knowledge of reporting workflows

Target Audience

  • Business analysts
  • Corporate professionals engaged in data management
  • Team members responsible for generating dashboards and reports

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories