AdvancedTimeIntelligenceWithDAX.pdf

(1217 KB) Pobierz
Media Partners
Advanced Time Intelligence in DAX
Alberto Ferrari
SQLBI
www.sqlbi.com
Alberto Ferrari
•
BI Expert and Consultant
•
Founder of
www.sqlbi.com
–
–
–
–
Problem Solving
Complex Project Assistance
Data Warehouse Assessments and Development
Courses, Trainings and Workshops
•
Book Writer
•
Microsoft Gold Business Intelligence Partner
•
SSAS Maestro – MVP – MCP
SQLDay 2015
What is Time Intelligence?
•
Many different topics in one name
–
–
–
–
–
–
Year To Date
Quarter To Date
Running Total
Same period previous year
Working days computation
Fiscal Year
•
In short: anything related with time
–
Handled in an intelligent way
SQLDay 2015
Date Table
•
Time intelligence needs a date table
–
Built in DAX
–
Or in a SQL Table
•
Date table properties
–
–
–
–
All dates should be present
From 1° of January, to 31° of December
No holes
Otherwise time intelligence will not work
SQLDay 2015

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin