We may earn an affiliate commission when you visit our partners.
Eugene Meidinger

DAX is a popular language for any sort of analytical reporting in the Microsoft BI stack. Whether you are using Power BI, Power Pivot, or SSAS, this course will teach you how to model your data with DAX.

Read more

DAX is a popular language for any sort of analytical reporting in the Microsoft BI stack. Whether you are using Power BI, Power Pivot, or SSAS, this course will teach you how to model your data with DAX.

If you want to use Power BI, Power Pivot, or SSAS (tabular mode), you'll need to learn DAX. In this course, Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS, you'll learn the basics of the DAX language. First, you'll learn how DAX works and why it has such good performance. Next, you'll explore how to encapsulate business logic using calculated columns and measures. Finally, you'll discover a variety of ways to manipulate filters or analyze your data. When you're finished this course, you'll have the skills and knowledge of DAX to model and analyze your data with the DAX expression language.

Enroll now

Here's a deal for you

We found an offer that may be relevant to this course.
Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

What's inside

Syllabus

Course Overview
Understanding What Makes DAX so Unique
Planning Your Data Governance: Power BI, Power Pivot, or SSAS Tabular?
Thinking in Columns, Not Rows
Read more
Adding Business Logic with Calculated Columns and Measures
Filtering Data Using CALCULATE
Looping Over Data with Iterators
Analyzing History with Time Intelligence

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Introduces DAX, which is standard in Microsoft's BI stack, notably for Power BI, Power Pivot, and SSAS
Taught by Eugene Meidinger, who is recognized for his work in DAX
Develops foundational skills in DAX, which is necessary for advanced data modeling and analysis in Microsoft's BI stack
Builds a strong foundation for beginners in DAX
Emphasizes practical skills, such as encapsulating business logic using calculated columns and measures, analyzing history with time intelligence, and loop over data with iterators
This course explicitly requires learners to come in with extensive background knowledge first

Save this course

Save Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS with these activities:
Review Relational Databases
Review basic relational database concepts to ensure a solid foundation for learning DAX.
Browse courses on Relational Databases
Show steps
  • Read up on the basic concepts of relational databases, such as tables, columns, and relationships.
  • Review examples of relational database schemas.
Practice DAX Syntax
Reinforce your understanding of DAX syntax through repetitive exercises.
Browse courses on DAX Language
Show steps
  • Complete online DAX syntax quizzes.
  • Practice writing DAX expressions to solve simple data analysis problems.
Guided Tutorials on Power BI and DAX
Enhance your DAX skills by following structured tutorials.
Browse courses on Power BI
Show steps
  • Enroll in online tutorials that provide step-by-step guidance on using Power BI and DAX.
  • Complete the tutorials to gain hands-on experience in creating and manipulating data models.
One other activity
Expand to see all activities and additional details
Show all four activities
Practice Data Modeling with DAX
Apply your DAX knowledge to create and improve data models.
Browse courses on Data Modeling
Show steps
  • Design and build a data model using DAX in Power BI or Power Pivot.
  • Analyze the data model and identify opportunities for optimization.

Career center

Learners who complete Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS will develop knowledge and skills that may be useful to these careers:
Operations Research Analyst
Operations Research Analysts use data to solve problems in business and industry. They use a variety of techniques, including mathematical modeling and simulation, to develop solutions that can improve efficiency and productivity. DAX is a powerful language that can be used to analyze and model data, which is essential for Operations Research Analysts. This course will teach you the basics of DAX, so you can use it to gain insights from data and make better business decisions.
Statistician
Statisticians collect, analyze, and interpret data. They use this data to make predictions and draw conclusions. DAX is a powerful language that can be used to analyze and model data, which is essential for Statisticians. This course will teach you the basics of DAX, so you can use it to gain insights from data and make better decisions.
Data Analyst
Data Analysts use data to solve business problems. They collect, clean, and analyze data, and then use that data to make recommendations for how to improve business processes. DAX is a powerful language that can be used to manipulate and analyze data, which is essential for Data Analysts. This course will teach you the basics of DAX, so you can use it to gain insights from data and make better business decisions.
Sales Analyst
Sales Analysts analyze sales data to identify trends and opportunities. They use this data to make recommendations for how to improve sales performance. DAX is a powerful language that can be used to analyze and model sales data, which is essential for Sales Analysts. This course will teach you the basics of DAX, so you can use it to gain insights from data and make better sales decisions.
Business Analyst
A Business Analyst works in a problem-solving role that bridges the gap between business and IT. They discover business needs and translate these into technical requirements for IT to build. Business Analysts need to understand both the business and IT worlds, so they can communicate effectively with both sides. DAX is a powerful language that can be used to analyze and model data, which is essential for Business Analysts. This course will teach you the basics of DAX, so you can use it to gain insights from data and make better business decisions.
Systems Analyst
Systems Analysts design and implement computer systems. They work with businesses to identify their needs and develop systems that meet those needs. DAX is a powerful language that can be used to analyze and model data, which is essential for Systems Analysts. This course will teach you the basics of DAX, so you can use it to design and implement better systems.
Web Analyst
Web Analysts analyze data to improve the performance of websites. They track website traffic and user behavior to identify areas for improvement. DAX is a powerful language that can be used to analyze and model data, which is essential for Web Analysts. This course will teach you the basics of DAX, so you can use it to gain insights from data and make better website decisions.
Management Consultant
Management Consultants help businesses improve their performance. They work with businesses to identify problems and develop solutions. DAX is a powerful language that can be used to analyze and model data, which is essential for Management Consultants. This course will teach you the basics of DAX, so you can use it to gain insights from data and make better business decisions.
Financial Analyst
Financial Analysts use data to make recommendations for investment decisions. They analyze financial data, such as stock prices and earnings reports, to make predictions about future financial performance. DAX is a powerful language that can be used to analyze and model financial data, which is essential for Financial Analysts. This course will teach you the basics of DAX, so you can use it to gain insights from financial data and make better investment decisions.
Risk Analyst
Risk Analysts identify and assess risks to businesses. They develop and implement strategies to mitigate risks. DAX is a powerful language that can be used to analyze and model data, which is essential for Risk Analysts. This course will teach you the basics of DAX, so you can use it to gain insights from data and make better risk decisions.
Product Manager
Product Managers are responsible for the development and launch of new products. They work with engineers, designers, and marketers to bring new products to market. DAX is a powerful language that can be used to analyze and model data, which is essential for Product Managers. This course will teach you the basics of DAX, so you can use it to gain insights from data and make better product decisions.
Market Researcher
Market Researchers collect and analyze data about consumers and markets. They use this data to help businesses understand their customers and make better marketing decisions. DAX is a powerful language that can be used to analyze and model data, which is essential for Market Researchers. This course will teach you the basics of DAX, so you can use it to gain insights from data and make better marketing decisions.
Data Scientist
Data Scientists use data to build models that can predict future outcomes. They use a variety of techniques, including machine learning and statistics, to build models that can be used to make better business decisions. DAX is a powerful language that can be used to manipulate and analyze data, which is essential for Data Scientists. This course will teach you the basics of DAX, so you can use it to build models that can predict future outcomes.
Quantitative Analyst
Quantitative Analysts use data to make investment decisions. They build models to predict future financial performance. DAX is a powerful language that can be used to manipulate and analyze data, which is essential for Quantitative Analysts. This course will teach you the basics of DAX, so you can use it to build models that can predict future financial performance.
Software Engineer
Software Engineers design, develop, and maintain software applications. DAX is a powerful language that can be used to analyze and model data, which is essential for Software Engineers. This course will teach you the basics of DAX, so you can use it to build better software applications.

Reading list

We've selected eight books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS.
Is an essential resource for anyone who wants to use DAX. It covers a wide range of topics, from the basics of DAX to advanced techniques for solving complex business problems.
Applies mathematical concepts and techniques to real-world business analytics problems using DAX. It teaches patterns to empower you to write flexible, robust, and reusable DAX code.
A collection of recipes that demonstrate how to use DAX to solve common business problems.
This cookbook collection of recipes that can be used to solve common business problems using DAX. It is an excellent resource for anyone who wants to learn how to use DAX in a practical setting.
A collection of recipes that demonstrate how to apply DAX patterns to solve real-world business problems.
Provides a solid foundation for learning Power BI. It's especially helpful if you want to set up your system to best integrate with DAX later on.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser