How to create a Time Table to analyze your Power BI or Excel data
35.1 هزار بار بازدید -
3 سال پیش
-
If you want to know
If you want to know how to analyze your data by hour, minute, half hour etc in Power BI or Excel Power Pivot then I will show you how to build your own Time Table and how to round your data to the nearest minute 🔽 More Info below 🔽
00:00 Intro
00:29 Explaining the data and goal
01:35 Splitting Date Time
02:10 Round to nearest minute using Modulo
04:08 Round to nearest minute using Column From Examples
05:48 Create a Time Table
10:48 Connect Fact table to Time Table and produce charts
Find a copy of the Time Table on our website
https://accessanalytic.com.au/free-ex...
Video on Calendar Table
What is a Date Table / Calendar table...
Follow me on LinkedIn
LinkedIn: wynhopkins
Twitter
Twitter: wynhopkins
Access Analytic Training
https://accessanalytic.com.au/training
00:00 Intro
00:29 Explaining the data and goal
01:35 Splitting Date Time
02:10 Round to nearest minute using Modulo
04:08 Round to nearest minute using Column From Examples
05:48 Create a Time Table
10:48 Connect Fact table to Time Table and produce charts
Find a copy of the Time Table on our website
https://accessanalytic.com.au/free-ex...
Video on Calendar Table
What is a Date Table / Calendar table...
Follow me on LinkedIn
LinkedIn: wynhopkins
Twitter: wynhopkins
Access Analytic Training
https://accessanalytic.com.au/training
3 سال پیش
در تاریخ 1400/07/25 منتشر شده
است.
35,198
بـار بازدید شده