Power BI Intermediate (Level 2)

Topics

• Introductions, Overview & Objectives
• Recap of Core Concepts
  • Data loading and basic visualisation
• Advanced Data Transformation
  • Power Query deeper dive
  • Merging and appending queries
• Data Modelling
  • Creating and managing relationships
  • Star schema basics
• Working with DAX (Introduction)
  • Calculated columns vs measures
  • Common functions (SUM, CALCULATE, COUNT)
• Enhancing Visualisations
  • Advanced visuals and formatting
  • Drill-down and drill-through features
• Interactive Reporting
  • Bookmarks and buttons
  • Creating dynamic user experiences
• Performance & Best Practice
  • Optimising reports
  • Structuring data models effectively
• Publishing & Sharing
  • Power BI Service overview
  • Dashboards and collaboration
• Q&A, Review & Close

Instructor Led Live Webinar or onsite session.

Product Description

This Power BI Level 2 session is designed for users who are already familiar with Power BI and want to enhance their reporting, data modelling, and analytical capabilities. The focus is on creating more dynamic reports, working with data relationships, and introducing key DAX calculations.

Awarding Body: Optima Training & Consulting Ltd

National Framework of Qualifications Level: N/a

Certification: Optima Training & Consulting Ltd Certificate of Completion

Renewal: N/a

Entry Requirements:
Minimum age- 18 years old

Minimum English requirements: Leaners must be able to understand and convey the concepts contained in the programme content.

Assessment Details: Class Interaction

Cost Per Person:
The fee is inclusive of all training courseware materials, certificate of completion and 3 months after training support.

Progression Opportunities: Please see related courses

Protection for Enrolled Students: N/A

Should a course not proceed, any payment received will be refunded within 48 hours