Time Intelligence in Power BI by Marco Russo
Time Intelligence is probably the most interesting feature of any analytical solution. Computing
Year-To-Date, Month-To-Date, Same-Period-Last-Year, is quite easy in DAX but, as soon as the
customer requests for time intelligence comparing data from different tables, or to manage
non-standard calendars, the DAX formulas start to be harder to write.
In this session, we are going to show how to compute classical time intelligence with the built-in
Power BI tools and DAX functions. Then, we will show some more complex time intelligence
formulas, which require thinking out of the box, using advanced data modeling and querying
techniques to produce interesting and useful formulas.
About Marco Russo
His main activities are related to data warehouse relational and multidimensional design, but
he is also involved in the complete development lifecycle of a BI solution. He has particular
competence and experience in sectors like financial services (including complex OLAP
designs in the banking area), manufacturing, gambling, and commercial distribution.
Marco is also an author and, in addition to his BI-related publications, he has authored
books about .NET programming. He is also a speaker at international conferences such as
TechEd, PASS Summit, SQLRally, and SQLBits.
SUBSCRIBE!
https://www.youtube.com/channel/UCBcNUiP2wqZNHUwXB79mC8A
LET'S CONNECT!
-- http://community.powerbi.com/t5/Global-Virtual-Power-BI-User/gp-p/GPBUG
-- http://twitter.com/GlobePUG
-- http://www.facebook.com/groups/powerbi
-- https://www.linkedin.com/groups/6631454
Видео Time Intelligence in Power BI by Marco Russo канала Global Power BI User Group
Year-To-Date, Month-To-Date, Same-Period-Last-Year, is quite easy in DAX but, as soon as the
customer requests for time intelligence comparing data from different tables, or to manage
non-standard calendars, the DAX formulas start to be harder to write.
In this session, we are going to show how to compute classical time intelligence with the built-in
Power BI tools and DAX functions. Then, we will show some more complex time intelligence
formulas, which require thinking out of the box, using advanced data modeling and querying
techniques to produce interesting and useful formulas.
About Marco Russo
His main activities are related to data warehouse relational and multidimensional design, but
he is also involved in the complete development lifecycle of a BI solution. He has particular
competence and experience in sectors like financial services (including complex OLAP
designs in the banking area), manufacturing, gambling, and commercial distribution.
Marco is also an author and, in addition to his BI-related publications, he has authored
books about .NET programming. He is also a speaker at international conferences such as
TechEd, PASS Summit, SQLRally, and SQLBits.
SUBSCRIBE!
https://www.youtube.com/channel/UCBcNUiP2wqZNHUwXB79mC8A
LET'S CONNECT!
-- http://community.powerbi.com/t5/Global-Virtual-Power-BI-User/gp-p/GPBUG
-- http://twitter.com/GlobePUG
-- http://www.facebook.com/groups/powerbi
-- https://www.linkedin.com/groups/6631454
Видео Time Intelligence in Power BI by Marco Russo канала Global Power BI User Group
Показать
Комментарии отсутствуют
Информация о видео
31 декабря 2017 г. 21:25:14
01:02:42
Другие видео канала
Power BI Full Course - Learn Power BI in 4 Hours | Power BI Tutorial for Beginners | EdurekaMicrosoft Power BI: Deep dive into DAX evaluation context - BRK3060Do you need a date table for time intelligence in Power BI? Nope! (Quick Measures)Compute a ranking based on multiple columnsTypes Of Time Intelligence Functions - (1.15) Ultimate Beginners Guide to DAX 2019Power BI visualization best practices by Marco Russo.MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX FunctionsPowerBI.Tips - Tutorial - Model Performance Tuning in DAX Studio - By Marco RussoUse Microsoft Flow, and other options, to refresh your Power BI datasetMeasures vs Calculated Columns - (1.4) Ultimate Beginners Guide to DAX 2019Advanced Power BI Takeover!Power BI Data Modelling - Marco RussoAdvanced DAX [Heavy Webinar]Time Intelligence calculations with Power BI | Community WebinarsPower BI Drill Through - Easy And Fast! || Zebra BI Knowledge BaseMany-to-Many Relationships in DAX - Alberto FerrariA quick look at Power BI dataflows👉Beginning Power BI DAX Functions Tutorial [Full Course]Power BI time intelligence for retail and wholesale industries with Matt AllingtonAppend vs Merge in Power BI and Power Query