In this video, we will build our data model and create a date table in Power BI Desktop.
Download the exact files used by me in this video series here - https://www.computergaga.com/_excel/f...
After importing the data from different files in the previous video, we now need to relate them ready for our analysis. We can do this in our model view.
We then need to create a date table. It is important to have a date, or calendar table, in your model to efficiently perform date and time calculations. This date table must include every day, of every year for the dates in your data set.
In this video, we will create a simple date table in Power BI Desktop that suits our analytical purposes.
You can find more information on Power BI Desktop here - https://powerbi.microsoft.com/en-us/d...
Check out the previous video where we imported our data from multiple sources into Power BI Desktop? - • Power BI Desktop Introduction #2 - Im...
Find more great free tutorials at;
https://www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1