DAX Formulas in Action
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
Explore the power of DAX formulas in action through this 57-minute conference talk from PASS Data Community Summit. Dive into a demo-heavy session led by Alberto Ferrari, where you'll learn to build a working prototype of a Business Intelligence solution using the DAX language in Excel and SQL Server Management Studio. Begin with the Contoso database in Excel, performing basic analysis using DAX to create calculated columns and measures for effective PivotTable analysis. Follow the progression as the prototype is promoted to a SQL Server Analysis Services database, running queries that serve as the source for a Reporting Services report. Gain insights into the analytical capabilities achievable with a fundamental understanding of the DAX language. The talk covers topics such as DAX hierarchy, calculate columns, time intelligence calculations, previous year sales, growth percentages, and pivot tables, while also comparing DAX to Excel and providing valuable resources for further learning.
Syllabus
Introduction
What is DAX
DAX Hierarchy
Calculate Column
Time Intelligence Calculation
Previous Year Sales
Growth
Percentage of Growth
Pivot Table
Personal Preference
Why DAX
DAX vs Excel
Resources
Questions
Taught by
PASS Data Community Summit
Related Courses
Organizational AnalysisStanford University via Coursera Introduction to Business in Asia
Griffith University via Open2Study Introduction to Enterprise Architecture
Enterprise Architects via Open2Study Business Processes: Modeling, Simulation, Execution
openHPI BI 4 Platform Innovation and Implementation
SAP Learning