GRC-102FT: Conquering DAX 2019 [Fastrack]

3 Days

From RM 14,000*

Remark:

Excluding labs & exams (if applicable, need to add-on)
Private in-house training at employer's venue
Minimum 5 pax up to maximum 25 pax per session (depending on the trainer)
HRDC Claimable Course

GRC-102FT: Conquering DAX 2019 [Fastrack]

This comprehensive 3-day DAX workshop delivers in-depth mastery of the formula language that powers Microsoft's business intelligence suite including Power BI, Power Pivot for Excel, and SSAS Tabular models. Designed for users with basic data modeling knowledge, the course systematically builds analytical capabilities from foundational concepts to advanced techniques.

During the training, you'll explore data types, calculated columns, measures, and core functions for aggregation, counting, and error handling. The course then progresses to powerful table manipulation techniques, teaching you to filter data effectively, work with relationships, and leverage functions like DISTINCT and ALLSELECTED.

A significant portion focuses on evaluation contexts—the cornerstone of DAX proficiency—where you'll learn to navigate filter and row contexts to avoid common errors. The CALCULATE function, described as the most important formula in DAX, receives dedicated attention with multiple examples and applications.

The training advances to sophisticated concepts including iterators, time intelligence functions for trend analysis, hierarchies, segmentation strategies, and solutions for complex many-to-many relationships. Throughout the course, ten comprehensive lab exercises reinforce learning with practical scenarios like calculating percentages, creating dynamic rankings, implementing running totals, and building year-over-year comparisons.

Upon completion, you'll possess the skills to create sophisticated business calculations, develop advanced analytical models, and implement complex data transformations. This expertise will immediately enhance your daily work by enabling more accurate reporting, deeper data insights, automated KPI tracking, and the ability to solve challenging business scenarios that basic Excel formulas cannot address.

Trainer Details

Industry Practitioners: Trainers with hands-on experience in the field, bringing real-world applications to the training.
Corporate Training Specialists: Professional trainers with a strong track record in corporate learning and development.
Executive Coaches & Thought Leaders: Elite trainers who have coached senior executives and industry leaders.

Gerald Hoong

Executive Coaches & Thought Leaders

Private in-house training at employer's venue
Minimum 5 pax up to maximum 25 pax per session

Gerald Hoong is the founder and CEO of GemRain Consulting, a Malaysia-based firm specializing in Microsoft technologies and AI solutions. With over 27 years in the IT training industry, Gerald stands out as one of Southeast Asia's most sought-after Microsoft certified trainers.

His impressive credentials include 35+ Microsoft certifications spanning Azure, Power Platform, Data Science, and AI technologies. As a certified prompt engineer, Gerald has mastered various AI platforms including ChatGPT, Microsoft Copilot, Google Gemini, and Claude AI.

Gerald's international reach extends across Asia Pacific and Europe, where he's conducted specialized workshops for clients in Denmark, Sweden, Czech Republic, Germany, and France. His speaking engagements at global conferences highlight his thought leadership in the industry.

Recognized for excellence with the Global Outstanding Leadership Award (Education 2.0 Conference, Dubai 2022), Gerald combines technical mastery with exceptional teaching abilities. His multilingual skills, including Japanese language proficiency and translation certification, further enhance his global training capabilities.

GemRain Consulting reflects Gerald's commitment to cutting-edge technology education, focusing on cloud platforms, data science, and AI—preparing professionals for tomorrow's technological challenges through expert-led training and consultation.

Alex Ooi

Industry Practitioners

Private in-house training at employer's venue
Minimum 5 pax up to maximum 25 pax per session

Alex Ooi is a data analytics expert with over seven years of specialized experience transforming complex business requirements into actionable technical solutions. With his unique blend of accounting background and technical expertise, Alex empowers organizations to make data-driven decisions with confidence.

As a Microsoft Power BI Data Analyst Associate and Associate Chartered Management Accountant (ACMA), Alex combines financial acumen with technical proficiency to deliver exceptional results. His track record includes developing Python-based automation tools that significantly reduced operational time and implementing robust data infrastructures that strengthened marketing effectiveness.

Throughout his career at industry leaders like Heineken Malaysia, Coca-Cola, and EY Analytics, Alex has consistently delivered measurable results—including a proprietary profitability analysis adopted across Heineken's APAC region and automation processes that saved 60+ man-hours monthly at Coca-Cola.

Alex excels in creating sustainable data ecosystems that minimize technical debt while maximizing business value. His consultancy focuses on three key pillars: enabling clients to control their data narratives, shifting organizational perspectives, and facilitating entry into new data horizons through hands-on workshops and training.

For organizations seeking to enhance visibility, efficiency, and profitability through data, Alex delivers purpose-driven solutions that transform complex information into strategic assets for meaningful business growth.

Get in touch with us

Fill in your details, and we’ll provide you with a customized quotation, detailed trainer profiles, and a comprehensive course outline. Select your preferred trainer category to find the perfect fit for your team’s needs!