A Date Table (or a Calendar Table) is, without doubt, the most often used dimension table in Data Models. And that makes total sense as most reports will slice and dice the data by months, years, quarters, weeks... So it becomes a necessary tool of the trade to be able to create a calendar table. In this video, you will learn what a calendar table is and how you can make one in Excel. In the future videos of the Date Table Series, I will show you how to create one using DAX in Power Pivot and Power BI and create one using M language in Power Query. The last three parts of the series will be all about defining the "Extended Calendar Table" by adding extra columns to make your reports better and, specifically in Power BI, more user-friendly.
This tutorial was made using Excel 365, but all methods work with Excel 2010 and above. Keep in mind that for Excel 2010 Power Pivot is a separate AddInn you have to install.
Links to other parts of the Date Table Series:
Part 1: What is a Date (Calendar) Table and how to create one in Excel: bit.ly/2TTuABk
Part 2: Create a Date Table in Power Pivot or Power BI: bit.ly/3ioXpPB
Part 3: Create a Date Table with Power Query in Excel or Power BI:bit.ly/3xuxDh8
Part 4: Extending the Date Table - Why you NEED to do it: bit.ly/2WRy20p
Part 5: Extending the Date Table with DAX in Power Pivot or Power BI: bit.ly/3CsQm0q
Part 6: Extending the Date Table with Power Query in Excel or Power BI: bit.ly/3hGQKj3
Chapters:
0:00 Excel Olympics Animation
0:08 Introduction to the Date Table Series
1:00 Table introduction
1:46 Calendar Table definition
4:23 Date Table Creation
7:03 Adding Extra Columns
10:10 Spoilers for next videos
10:56 Outro
Gear Used:
US Links
Camera: Canon EOS R6 - amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - amzn.to/3dgM8wS
Laptop: Dell XPS 15 - amzn.to/3w8CyoK
Lights: Elgato Key Light - amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - amzn.to/3amDRXP
Laptop: Dell XPS 15 - amzn.to/3effMmT
Lights: Elgato Key Light - amzn.to/3vcs6v9
Green Screen (visible in bloopers): amzn.to/3ajUm6Y
Recorded With: Camtasia - www.techsmith.com/video-edito...
Subscribe for more Excel tutorials on the Excel Olympics RU-vid Channel: bit.ly/EOYTsub
Subscribe for the Excel Olympics Newsletter: bit.ly/3w3rkjK
Disclaimer: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support!
#Excel #ExcelOlympics #gasperkamensek #DataModeling #Calendar #DateTable #TimeIntelligence #PowerBI
14 июл 2024
