Learn LIVE with

Dimitar Shutev

The Complete DAX Training

Empower your team to solve complex calculations quickly with Microsoft’s native formula and query language.

3h-5h
Beginner
English
Certificate
Sign Up

Simplify Business Logic and Translate Complex KPIs Into Expressions

Tracking KPIs is crucial for business success but calculating them is difficult and time-consuming. Tools like Power BI, Analysis Services, and Power Pivot in Excel facilitate the calculations. Still, to use them effectively, your team needs to learn DAX. This powerful formula language helps simplify business logic and translate complex KPIs into expressions. More importantly, it will save your Business Intelligence or Analytics teams valuable time. Once they master the required formulas and functions, they can reuse them, which will save them hours of manual work. DAX is a formula language that includes simplified programming concepts. A few DAX formulas can produce the same results as several pages of code. This makes it powerful yet relatively easy to learn even without any coding or Excel experience. Still, behind its simple syntax lie many hidden concepts. To obtain the correct results from an expression, one needs to know the ins and out of the formula language. This training covers everything from basic concepts to advanced functions and applications. It will teach your team how to use DAX to improve and optimize their calculations and analyses.

Empower Your Team with Trustworthy Data Practices

Gain Complete Control Over Data

DAX offers the flexibility of a programming language without its complexity. With it, your teams can translate complex KPIs into expressions.

Build a Team with Strong Analysis Skills

Your team will learn how to create calculated columns, measures, and custom tables, and evaluate past performance.

Save Hours of Manual Work

Provide your teams with the skills and knowledge to simplify business logic and perform complex calculations more quickly.

Sign Up
„Say goodbye to the endless Excel sheets and repetitive tasks. This training will change the way you work with data and save you hours of manual work.”

Dimitar Shutev

Who Is This Course For

Data Engineers

You seek to build data systems that help organizations make sense of raw data and generate actionable insights

Business Analysts

You guide organizations into adopting data-driven strategies that optimize business processes and functions

Marketing Experts

You strive to develop long-term marketing strategies that boost revenue growth and company reputation

Level Of Difficulty

Beginner
The Complete DAX Training is a beginner-level training with no prerequisites. All professionals, regardless of their background, experience, and current skill level are welcome to join without any self-preparation in advance.
Dimitar Shutev

Meet Dimitar Shutev

Proficient in Power BI, Tableau, and Sisense, Dimitar is a versatile Senior Data Engineer who has worked with some of the largest UK retailers such as Boots, Tesco, and Hobbycraft

7+years of experience
Microsoft certified Power BI trainer

Here’s What Your Team Will Learn

  • How to translate complex KPIs into expressions
  • Time intelligence functions to assess past KPIs
  • Table functions to gain complete control over data
  • Different types of evaluation contexts and context errors
  • Complex calculations and data queries in related tables and columns in tabular models
  • The skills and knowledge to simplify business logic
Sign Up

Curriculum

  • 4 hours
    • Introduction 10 min
    Working with Table Functions 50 min
    Understanding Evaluation Contexts in DAX 50 min
    Understanding How the CALCULATE Function Works 50 min
    Time Inteligence or How to Get the Maximum of Your Data 50 min
    Q&A Session 30 min
    See More

    Frequently Asked Questions

    How long does a live training last?

    The instructor predetermines the length of a live training session. A single live training can last from a few hours to several days and include multiple sessions. The duration can also be adapted to your team’s needs upon request. To learn more, complete the signup form or contact us at team@365datascience.com.

    Does my team need any relevant qualifications or experience to join a live training session?

    No prior experience or qualifications are required to attend live training sessions. Each training has a dedicated page with all the details you need to make the right choice for your team—including information on what your team can expect, level of difficulty (beginner, intermediate or advanced), top benefits, and areas of expertise.

    When does the live training usually take place?

    We offer a great deal of flexibility concerning the dates and times of the live training. Sessions are scheduled according to your team's and instructor's availability.

    How can I become a live training instructor?

    If you possess outstanding qualifications in data science and enjoy sharing your knowledge with others, we’d love to hear from you. As a member of our community of industry-leading live training instructors, you’ll be delivering an excellent learning experience to our shared clients. We’ll manage all the admin—including integrating your training into our line-up and scheduling them according to availability. Use our contact form to get in touch.

    How can I book a live training session?

    Our live training sessions are open to all corporate clients who wish to accelerate their team’s progress through direct online coaching from industry leaders. Prices vary depending on the level of expertise you want your teams to acquire and the length of the training. Sign up using the contact form on the individual live training pages for more information on pricing and how to book.

    Will my team have access to real-time conversations with industry experts?

    Yes, direct communication with the instructors forms the backbone of our live training. Your team will have the opportunity to actively participate in the training, ask any questions relevant to their specific roles, and tap into the industry-leading expertise of our instructors. The goal is to boost engagement with the content and enable team members to pick up new skills quicker. 

    Attending live training sessions as a team will equip your employees with new practical skills and boost their professional confidence. Moreover, internal upskilling opportunities are an excellent way to create a sense of belonging in the workplace and improve job satisfaction.

    How many team members can join a live training session?

    Our live training sessions can host up to 100 participants. If you wish to invite more team members, specify the number of attendees as a comment on your request form or contact us at team@365datascience.com. We’ll always do our best to accommodate your needs.

    Get Access to Live Training

    Sign up for a live training session and powershift your data-fueled workflow optimization with real-time, skills-based learning by top industry-leading instructors.

    • Renowned Industry Experts
    • Community-Fostered Active Learning
    • Training for All Skill Levels and Expertise
    • Certificates of Achievement
    Sign Up

    Other Live Training

    Shashank Kalanithi

    From Excel to Tableau: Transform Your Spreadsheets Into Powerful Visualizations

    with Shashank Kalanithi

    Empower your teams to make the switch from Excel to Tableau and reach new standards in data organization, presentation, and sharing.
    1
  • Intermediate
    • Shashank Kalanithi

    Machine Learning at Light Speed: Rapidly Deploy Applications to The Cloud

    with Shashank Kalanithi

    Upskill your teams in cloud-based ML optimization tools that will energize your predictive analytics with agile models on hand.
    1
  • Advanced
    • Avery Smith

    Extract Value From Your Data

    with Avery Smith

    Improve how your teams tackle key challenges with company data at hand in this practical live training and become an agile industry leader.
    2
  • Intermediate
    • Avery Smith

    Data Visualizations & Dashboards That Will 10x Your Business

    with Avery Smith

    Upskill your teams with the visualization and dashboarding tools that will transform your company into a data-first enterprise.
    2
  • Beginner
    • Ajay Halthor

    SQL for Solving Problems

    with Ajay Halthor

    Gain hands-on experience with a fundamental data science tool and learn to leverage its functionalities for alleviating crucial business pain points.
    2
  • Intermediate
    • Ajay Halthor

    Optimize Your Business the Machine Learning Way

    with Ajay Halthor

    Empower your teams to think computationally, devise future-proof solutions to strategic problems, and develop intuition for business-defining machine learning models.
    1
  • Beginner
    • Ajay Halthor

    Mathematics for Data Scientists & Machine Learning Engineers

    with Ajay Halthor

    Equip your teams with the mathematical intuition they need to master cutting-edge problem-solving tools and thrive in a data-first future.
    1
  • Intermediate
    • Richmond Alake

    Computer Vision with Neural Nets

    with Richmond Alake

    Master the end-to-end machine learning workflow and learn how to apply ML functionalities to solve key computer vision problems.
    2
  • Intermediate
    • Jordan Morrow

    Data Literacy

    with Jordan Morrow

    Strengthen your organization by reshaping its data mindset. Give your team the confidence to interpret data and ask the right questions to gleam valuable insights.
    1
  • Beginner
    • Jordan Morrow

    Build a Data-driven Organization

    with Jordan Morrow

    Master the data-driven approach. Learn how to lead your organization into the future with evidence-based decision-making in order to achieve your operational goals.
    2
  • Intermediate
    • Tina Huang

    How to Use Data to Grow Your Business

    with Tina Huang

    Scale your organization with the power of data! Learn how you can bring FAANG data strategies to bear on the success of any size venture directly from an industry insider.
    1
  • Advanced
    • Ken Jee and Tina Huang

    How to Create Data Content

    with Ken Jee and Tina Huang

    Devise an actionable content strategy around your company’s products to gain traction in the market and within your organization.
    1
  • Beginner
    • Ken Jee

    Data Science for Non-Technical People

    with Ken Jee

    Build a better understanding of data across your organization. Upskill your team in data science and drive business growth through an insight-driven approach.
    1
  • Beginner
    • Ken Jee

    Designing Ethical AI Systems

    with Ken Jee

    Master the cutting-edge frameworks of top technology companies and get your organization on the path to ethical, value-oriented digital transformation.
    1
  • Intermediate
    • Gilbert Eijkelenboom

    Communication Skills for Data Professionals

    with Gilbert Eijkelenboom

    Data scientists may have the best insights, but what matters more is their outcomes. Equip your data team with the skills to communicate their analytics and maximize impact.
    1
  • Intermediate
    • Gilbert Eijkelenboom

    MindSpeaking: From Data to Business – The Complete Training Program

    with Gilbert Eijkelenboom

    Empower your data team with top-level communication and persuasion skills to turn your business goals into reality.
    5
  • Intermediate
    • Davis Balaba

    Create a Stimulating Environment for Your Data Talent

    with Davis Balaba

    Empower your data scientists by giving them a seat at the table. Learn how to effectively integrate data teams into your organization.
    1
  • Intermediate
    • Davis Balaba

    Growth Framework

    with Davis Balaba

    Reap the benefits of your data integration by following Facebook’s actionable framework for building successful products and achieving meaningful ROI growth.
    1
  • Beginner
    • Shailvi Wakhlu

    Data Quality: How to Prevent, Diagnose, and Cure Bad Data

    with Shailvi Wakhlu

    Invest in a low-quality data prevention strategy to make better long-term business decisions and supercharge positive outcomes.
    1
  • Intermediate
    • Lee Feinberg

    Design To Act®: Scale Data Literacy and Storytelling within Your Organization

    with Lee Feinberg

    Upskill your data teams with crucial storytelling abilities and harness the power of data-driven business insight. Challenge long-standing practices and drive innovation.
    3
  • Intermediate
    • Dimitar Shutev

    Building Reports in Power BI

    with Dimitar Shutev

    Upskill your team with strong visual data storytelling skills so they can create interactive, useful, and informative business reports in Power BI.
    2
  • Beginner
    • Dimitar Shutev

    Shape Your Data with Power Query

    with Dimitar Shutev

    Prime your team with Microsoft’s all-in-one data transformation tool, Power Query, and optimize the workflow in favor of your business reporting needs.
    2
  • Beginner
    • Vinayak Deshpande

    Data Science in Banking and Financial Services

    with Vinayak Deshpande

    Accelerate growth in key areas of your business with cutting-edge data science practices and gain a competitive edge in the finance sector.
    6
  • Beginner
    • Vinayak Deshpande

    Data Science in HR

    with Vinayak Deshpande

    Shape your company’s future success with high-performing talent. Employ data-driven strategies to recruit and retain your best team members.
    6
  • Beginner
    • Vinayak Deshpande

    Data Science in Retail and FMCG

    with Vinayak Deshpande

    Accelerate growth in key areas of your business with cutting-edge data science practices and gain a competitive edge in the Retail and FMCG sector.
    6
  • Beginner
    • Marios Prifti

    How to Master User Stories

    with Marios Prifti

    Get a firm grasp on user story fundamentals to facilitate trouble-free product development and provide high-quality value to your customers.
    1
  • Intermediate
    • Manuj Aggarwal

    Data-Smart Marketing: Make Data-Driven Marketing Decisions

    with Manuj Aggarwal

    Master the art of human-centered data-driven marketing and drive profitable campaigns. Learn the basics of mass psychology and leverage this knowledge to harness the latest data science techniques and drive successful marketing strategies as a Chief Marketing Officer.
    1
  • Intermediate
    • Sujata Suvarnapathaki

    Data Science in Insurance

    with Sujata Suvarnapathaki

    Drive innovation in your products, analyze the risks, and provide personalized services to your clients with industry-specific data science techniques.
    6
  • Beginner
    • Vamsi Nellutla

    Data Science and Machine Learning in Healthcare: Solving Real-Life Business Problems

    with Vamsi Nellutla

    Help employees understand how to apply data science and machine learning principles to solve real-life healthcare business problems.
    6
  • Intermediate
    • Shailvi Wakhlu

    Thoughtful Analytics: How to Drive Business and Product Success

    with Shailvi Wakhlu

    Transform your data into energy, and fuel your company’s growth with a robust framework designed to produce powerful outcomes.
    1
  • Intermediate
    • Manuj Aggarwal

    Revolutionizing Sales Outcomes: A Data-Driven Experience for Sales Leaders

    with Manuj Aggarwal

    Scale your business and revenue growth by designing data-driven sales strategies with the four-step diffusion of innovation framework.
    2
  • Intermediate