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.
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/8zjbcy/getting
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
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
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
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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.
Review Relational Databases
Show steps
Review basic relational database concepts to ensure a solid foundation for learning DAX.
Browse courses on
Relational Databases
Show steps
Show steps
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
Show steps
Reinforce your understanding of DAX syntax through repetitive exercises.
Browse courses on
DAX Language
Show steps
Show steps
Show steps
- Complete online DAX syntax quizzes.
- Practice writing DAX expressions to solve simple data analysis problems.
Guided Tutorials on Power BI and DAX
Show steps
Enhance your DAX skills by following structured tutorials.
Browse courses on
Power BI
Show steps
Show steps
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
Show steps
Apply your DAX knowledge to create and improve data models.
Browse courses on
Data Modeling
Show steps
Show steps
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 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
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 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 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
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 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 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 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 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 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 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 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 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 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 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.
For more career information including salaries, visit:
OpenCourser.com/course/8zjbcy/getting
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.
Save
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.
Save
A collection of recipes that demonstrate how to apply DAX patterns to solve real-world business problems.
A comprehensive guide to using DAX with Power BI.
Save
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.
Save
A gentle introduction to DAX. It covers basic DAX syntax and functions but does not venture too deeply into more complex DAX topics.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/8zjbcy/getting
Share
Similar courses
Here are nine courses similar to
Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS.
Create Measures by Using DAX with Power BI
OpenCourser.com/course/qkgzbm/create
Create Measures by Using DAX with Power BI
Most relevant
Data Modeling in Power BI
OpenCourser.com/course/cw7018/data
Data Modeling in Power BI
Most relevant
Common DAX Expressions and Scenarios Power BI Playbook
OpenCourser.com/course/64r5in/common
Common DAX Expressions and Scenarios Power BI Playbook
Most relevant
Modeling Data in Power BI
OpenCourser.com/course/dtehdb/modeling
Modeling Data in Power BI
Most relevant
Excel Power Tools for Data Analysis
OpenCourser.com/course/v9j1qq/excel
Excel Power Tools for Data Analysis
Most relevant
Power Pivot Fundamentals
OpenCourser.com/course/tg3p92/power
Power Pivot Fundamentals
Most relevant
Advanced DAX for Power BI
OpenCourser.com/course/kecbln/advanced
Advanced DAX for Power BI
Most relevant
Create Model Calculations by Using DAX
OpenCourser.com/course/obj45j/create
Create Model Calculations by Using DAX
Most relevant
Financial Statements in Power BI
OpenCourser.com/course/kum66r/financial
Financial Statements in Power BI
Most relevant
Time
178 hours
Level
Introductory
Via
Pluralsight
Instructor
Eugene Meidinger
Language
English
This course belongs to a
collection
called
Microsoft Power BI for Analysts. It's comprised of 13 courses:
- Building Your First Power BI Report
- Power BI Data Import Playbook
- Power BI Data Preparation Playbook
- Modeling Data in Power BI
- Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS (viewing)
- Effective Reporting with Power BI
- Creating Dashboards with Power BI
- Deploying and Publishing Power BI Reports
- Effective Quick Insights and Q&A in Power BI
- Querying and Shaping Data in Power BI Using M
- Leveraging Timely On-premises Data with Power BI
- Power BI Playbook: Securing Shared Data with Power BI
- Common DAX Expressions and Scenarios Power BI Playbook
Good to know
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
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