Online Training
Power BI Advanced
Take your Power BI skills to the next level and tackle complex data challenges
December 2 & 6, 2024
11:00 AM - 3:00 PM EST
Next intake: December 2 & 6, 2024 | 11:00 AM - 3:00 PM EST
Overview
The Power BI Advanced course is designed to take your Power BI skills to the next level, equipping you with advanced techniques and best practices to tackle complex data challenges. Whether you’re a seasoned Power BI user or looking to enhance your data analytics skills, this program offers a deep dive into advanced data modelling, DAX measures, data visualization, and Power BI administration.
This practical and hands-on course facilitates learning through a mix of lectures, demos, hands-on labs and Q&A.
The course will explore critical tools and function to enable its participants to become Power BI superusers, including:
- Data Ingestion & Data Modelling
- Advanced Data Transformations in Power Query
- Conceptual Modelling including star and snowflake schema
- CALCULATE Modifiers and FILTER functions
- Rolling Totals and Time Intelligence Functions
- DAX performance tuning using variable
- And much more!
These skills will empower an analyst to create powerful, optimized, and insightful Power BI reports and dashboards, allowing for deep data analysis and decision-making.
Who Should Attend?
Students with active working knowledge of PowerBI includingLearning Outcomes
Online Training
Power BI Advanced
Session details
- In-depth exploration of advanced topics, ensuring you leave with a thorough understanding of complex Power BI functionalities.
- Acquire advanced tools and techniques that you can apply directly to your current projects, enhancing your productivity and the quality of your outputs.
- Benefit from the shared experiences and insights of fellow advanced Power BI users.
Level: Advanced
Familiarity with the topic is required
Key Sessions
The session will run from 11am to 3pm ET, with a 30 min break and time for Q&A.
Getting data from different sources
- Live Connections
- Direct Query
- Folder Connector
- Using Parameters
Advanced Data Shaping
- Advanced Data Transformations in Power Query
- M Transformations
- Query Folding
- Building the Aggregate Table
- Data Profiling Tools and Techniques
- Table Normalization
Advanced Data Modelling
- Conceptual Modelling (star and snowflake schema)
- Fact and Dimensional Modelling
- Navigating Direct-Query
- Creating Data Hierarchy
- Understanding relationships and filter propagation
DAX Measures
- Building aggregate measures
- Working with Iterator functions
- Working with logic functions
- Understanding CALCULATE
- CALCULATE Modifiers and FILTER functions
- Rolling Totals and Time Intelligence Functions
- DAX performance tuning using variables
Advanced Data Visualizations
- Advanced Data Storytelling Principles
- Visual layout and planning
- Spatial Mapping
- What IF scenarios
- Custom Tooltips
- Page Navigation & Bookmarks
- Implementing Row-Level-Security
- Data Refresh Management
Meet Your Facilitator
Shannon Lynch
The PowerBI Coach
Register Today
Join this training for professionals working within the Public Sector
Additional discounts are available for group registrations of 10 or more. For group or payment enquiries or custom training solutions, please contact [email protected]
Customised in-house options available for teams
Interested in any of our online trainings?
You can also choose to have them delivered in house. We will work closely with our inspiring session facilitators to tailor the content around the key development areas your team are prioritising, shape the learning outcomes around your core departmental challenges and make the most of your L&D and upskilling budget.
Enquire here for more informationCan't see what you need?
Download our training catalogue to review all available topics
Download full catalogue
