DAX is essential for working with data and data models in Excel and Power BI. Many analysts start building complex DAX formulas, without a solid grounding in DAX basics, context manipulation, and time intelligence.
In this course, we’ll quickly review the basics of DAX formulas for creating Measures and Calculated Columns. We’ll explore the difference between DAX functions that return a scalar value, and those that return a table. With this deep understanding of scalar values and tables, we'll show you the ins and outs of data modeling and context manipulation.
Read more
DAX is essential for working with data and data models in Excel and Power BI. Many analysts start building complex DAX formulas, without a solid grounding in DAX basics, context manipulation, and time intelligence.
In this course, we’ll quickly review the basics of DAX formulas for creating Measures and Calculated Columns. We’ll explore the difference between DAX functions that return a scalar value, and those that return a table. With this deep understanding of scalar values and tables, we'll show you the ins and outs of data modeling and context manipulation.
DAX is essential for working with data and data models in Excel and Power BI. Many analysts start building complex DAX formulas, without a solid grounding in DAX basics, context manipulation, and time intelligence.
In this course, we’ll quickly review the basics of DAX formulas for creating Measures and Calculated Columns. We’ll explore the difference between DAX functions that return a scalar value, and those that return a table. With this deep understanding of scalar values and tables, we'll show you the ins and outs of data modeling and context manipulation.
Additionally, we'll demonstrate how DAX Studio can integrate with Excel and Power BI, speeding up your DAX development process. If you want to get better at using Excel and Power BI, and understand the power of DAX Studio, this course is for you. We keep it simple, clear, and focused, so you can learn fast and start applying your new skills right away.
By the end of the course, you should be able to:
Recall the core concepts of DAX: measures, calculated columns, row & filter Context
Apply functions that return a single, scalar value of various data types
Manipulate source data with Table Functions
Apply DAX concepts and functions on a Data Model
Analyze data over time with Date & Time Intelligence functionality
This DAX course is perfect for anyone who would like to build up their understanding of Business Intelligence in Excel and Power BI. This course is designed to equip anyone who desires to supercharge their career in data analysis, business intelligence, or other areas of finance with the fundamental knowledge of DAX.
What's inside
Syllabus
Getting Started
In this course, we’ll review the basics of DAX formulas for creating Measures and Calculated Columns. We’ll explore the difference between DAX functions that return a scalar value, and those that return a table. With this deep understanding of scalar values and tables, we'll show you the ins and outs of data modeling and context manipulation.
Read more
Syllabus
Good to know
Save this course
Save
Activities
Review concepts of Power BI and Excel DAX basics
Show steps
Refresh your understanding of the basic concepts of DAX, including measures, calculated columns, and context manipulation, to prepare for this course's more advanced topics.
Show steps
-
Review online tutorials on DAX basics
-
Create a simple DAX measure in Power BI or Excel
Complete the Microsoft DAX tutorial
Show steps
Follow Microsoft's structured tutorial to gain a solid understanding of DAX syntax, functions, and best practices.
Show steps
-
Set up your environment for the tutorial
-
Go through the guided exercises in the tutorial
-
Complete the tutorial's assessment
Solve DAX practice problems
Show steps
Test your understanding of DAX by solving practice problems that cover various concepts and functions.
Show steps
-
Find online DAX practice problems
-
Attempt to solve the problems on your own
-
Review solutions and learn from your mistakes
Five other activities
Expand to see all activities and additional details
Show all eight activities
Create a DAX cheat sheet
Show steps
Consolidate your DAX knowledge by creating a cheat sheet that summarizes key concepts, functions, and syntax.
Show steps
-
Gather relevant DAX information
-
Organize the information into logical sections
-
Create a visually appealing and easy-to-use cheat sheet
Read 'DAX Patterns' by Alberto Ferrari and Marco Russo
Show steps
Expand your DAX knowledge by reading a book that provides practical patterns and techniques for building efficient and maintainable DAX solutions.
View
DAX Patterns: Second Edition
on Amazon
Show steps
-
Purchase or borrow the book
-
Read the book thoroughly
-
Apply the patterns and techniques in your own DAX projects
Build a DAX dashboard for a real-world dataset
Show steps
Apply your DAX skills to a practical project by building a dashboard that analyzes and visualizes data from a real-world dataset.
Show steps
-
Find a suitable dataset
-
Create a data model and import the data
-
Develop DAX measures and calculated columns
-
Design and build the dashboard
Participate in a DAX challenge or hackathon
Show steps
Challenge yourself and showcase your DAX skills by participating in a competition where you can solve real-world data analysis problems.
Show steps
-
Find a suitable DAX challenge or hackathon
-
Form a team or participate individually
-
Analyze the problem statement and develop a solution
Volunteer as a DAX mentor or tutor
Show steps
Share your DAX knowledge and gain valuable experience by helping others learn and apply DAX.
Show steps
-
Find opportunities to volunteer as a DAX mentor or tutor
-
Prepare your materials and resources
-
Provide guidance and support to learners
Review concepts of Power BI and Excel DAX basics
Show steps
Refresh your understanding of the basic concepts of DAX, including measures, calculated columns, and context manipulation, to prepare for this course's more advanced topics.
Show steps
- Review online tutorials on DAX basics
- Create a simple DAX measure in Power BI or Excel
Complete the Microsoft DAX tutorial
Show steps
Follow Microsoft's structured tutorial to gain a solid understanding of DAX syntax, functions, and best practices.
Show steps
- Set up your environment for the tutorial
- Go through the guided exercises in the tutorial
- Complete the tutorial's assessment
Solve DAX practice problems
Show steps
Test your understanding of DAX by solving practice problems that cover various concepts and functions.
Show steps
- Find online DAX practice problems
- Attempt to solve the problems on your own
- Review solutions and learn from your mistakes
Create a DAX cheat sheet
Show steps
Consolidate your DAX knowledge by creating a cheat sheet that summarizes key concepts, functions, and syntax.
Show steps
- Gather relevant DAX information
- Organize the information into logical sections
- Create a visually appealing and easy-to-use cheat sheet
Read 'DAX Patterns' by Alberto Ferrari and Marco Russo
Show steps
Expand your DAX knowledge by reading a book that provides practical patterns and techniques for building efficient and maintainable DAX solutions.
View
DAX Patterns: Second Edition
on Amazon
Show steps
- Purchase or borrow the book
- Read the book thoroughly
- Apply the patterns and techniques in your own DAX projects
Build a DAX dashboard for a real-world dataset
Show steps
Apply your DAX skills to a practical project by building a dashboard that analyzes and visualizes data from a real-world dataset.
Show steps
- Find a suitable dataset
- Create a data model and import the data
- Develop DAX measures and calculated columns
- Design and build the dashboard
Participate in a DAX challenge or hackathon
Show steps
Challenge yourself and showcase your DAX skills by participating in a competition where you can solve real-world data analysis problems.
Show steps
- Find a suitable DAX challenge or hackathon
- Form a team or participate individually
- Analyze the problem statement and develop a solution
Volunteer as a DAX mentor or tutor
Show steps
Share your DAX knowledge and gain valuable experience by helping others learn and apply DAX.
Show steps
- Find opportunities to volunteer as a DAX mentor or tutor
- Prepare your materials and resources
- Provide guidance and support to learners
Career center
Reading list
Share
Similar courses
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.
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.
