Overview
Intermediate DAX & Time Intelligence Overview
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.
Intermediate DAX & Time Intelligence Learning Objectives
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
Who Should Take This Course?
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.
Intermediate DAX & Time Intelligence
Get Started
Level 4
Approx 6h to complete
100% online and self-paced
Get Recognized With CFI
See All Certification ProgramsWhat you'll learn
This Course is Part of the Following Programs
Why stop here? Expand your skills and show your expertise with the professional certifications, specializations, and CPE credits you’re already on your way to earning.
- Skills Learned Data visualization, data warehousing and transformation, data modeling and analysis
- Career Prep Business intelligence analyst, data scientist, data visualization specialist
- Skills learned Data Transformation & Automation, Data Visualization, Coding, Data Modeling
- Career prep Data Analyst, Business Intelligence Specialist, Finance Analyst, Data Scientist
Learner Reviews
Detailed explanation about basic concepts of DAX along with hands on tutorials on how to use DAX in MS Excel (using Power Pivot) and Power BI.
Farooq Anwer
CFI's BIDA program and Data Science specialization has helped me learn new things while reinforcing previous knowledge. The curriculum is well curated with business & finance focus case studies followed by alot of hands on practice. These skills I hope to bring into my everyday work experience, while continuing my CPD with CFI.
MOHAMED ALIE KAMARA
The contents good and are well organized.
Stélio Menete
DAX language is broad and deep, also very flexible. You just have to use your imagination
