Content
This course will cover:
- Advanced Power Query: Mastering “M” techniques for complex data shaping and transformation.
- Sophisticated Modelling: Building efficient, high-performance data models for large-scale analysis.
- DAX Mastery: Developing complex measures and time-intelligence calculations
- Security Governance: Implementing Row Level Security (RLS) to manage data access.
- Advanced Visualisation: Designing intelligent, interactive dashboards with deep-drill capabilities.
Outcomes
- Master advanced Power Query techniques for intricate data preparation.
- Develop efficient, scalable data models that support deep-dive analysis.
- Write sophisticated DAX expressions to solve complex business logic requirements
- Implement Row Level Security to ensure data privacy and organisational compliance
- Design and publish intelligent interactive dashboards for secure web-based collaboration.
Who Should Attend
Individuals with a foundational understanding of Power BI Desktop who are ready to move beyond basic visuals into complex calculations and secure data management.
Benefits to You and Your Organisation
Individual Benefit: Ability to work with diverse data sources, build complex calculations, and produce intelligent dashboards that enhance professional influence.
Organisational Benefit: Enhanced analytical depth, improved data security through RLS, and seamless, collaborative insight-sharing across the enterprise.
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
