Content
This course will cover:
- Advanced Data Modeling: Managing multiple date dimensions and role-playing dimensions
- DAX Deep Dive: Mastering filter context manipulation and complex evaluation logic
- Dynamic Governance: Implementing scalable Dynamic Row-Level Security (DRLS)
- High-End Report Engineering: Utilising drill-through, custom tooltips, and advanced navigation patterns
- Enterprise Design: Streamlining report creation and performance optimization
Outcomes
- Master advanced DAX techniques for modifying filter context in complex scenarios
- Confidently architect models with multiple date-dimension tables and role-playing dimensions.
- Implement dynamic row-level security for robust, automated data governance.
- Design sophisticated, interactive reports using drill-through and custom navigation
- Elevate organizational analysis through superior report design and design-thinking.
Who Should Attend
Individuals with intermediate Power BI skills, including experience with Power Query, visualisations, basic data modeling, and standard row-level security.
Benefits to You and Your Organisation
Individual Benefit: Gain a deep understanding of DAX measure evaluation and advanced Desktop features to enhance professional BI career pathways.
Organisational Benefit: Enable streamlined, high-performance report creation and robust dynamic security, leading to sophisticated data insights and safer decision-making.
Group Bookings
**For groups of five or more, IPAA SA can tailor the training to suit your organisation. Group bookings may also be eligible for a preferential rate. Complete the form, and our team will be in touch to discuss options. **
Learn about our speakers
Jagmohan (Jagg) Singh
Trainer
-
Jagmohan (Jagg) Singh is a premier Software and Professional Development Trainer with over 18 years of global experience across the IT, Insurance, and Hospitality sectors. Jagg specializes in transforming training from a functional task into a strategic differentiator that drives measurable business results.
He has a remarkable track record of empowering over 57,000 professionals (50,000+ in India and 7,000+ in Australia), helping them master complex technical skills while refining their professional demeanor for maximum organizational impact.
Key Qualifications:
Microsoft Certified Trainer (MCT): Specialist in Microsoft 365, Teams Administration, and Data Analytics.
Certified Professional: Cert IV in Training and Assessment (TAE) and Diploma in Financial Planning (Australia).
Academic Foundation: MBA in Sales & Marketing; BSc in Computer Science.
Areas of Expertise:
End-to-End L&D Strategy: Expert in Training Need Analysis (TNA), content development, and delivery planning that aligns with C-Suite objectives.
Software & Data Mastery: Bridging the gap between complex data/software tools (Microsoft 365, Power BI) and practical business application.
Sales & Leadership Coaching: Developing high-performance teams through behavioral competency modeling and integrated coaching (Classroom + Field Monitoring + E-Learning).
Evidence-Based Results: Dedicated to showcasing training effectiveness through clear ROI and productivity metrics.
Format
Face-to-face
Duration
1 full-day
9:00am - 4:30pm (8:45am registration)
Inclusions
Resources, morning tea, lunch and refreshments
Location
12 Pirie Street, Adelaide, SA 5000
(please visit registration links for further information)
View map
Costs
Personal Member $575
State Govt Employee Member $615
Corporate Member $625
Non-Member $725
This course is also available in-agency. Please contact us for further information
