What is a Date Table and how to create one in Excel - The Date Table (Calendar) Series - Part 1

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: https://bit.ly/2TTuABk Part 2: Create a Date Table in Power Pivot or Power BI: https://bit.ly/3ioXpPB Part 3: Create a Date Table with Power Query in Excel or Power BI:https://bit.ly/3xuxDh8 Part 4: Extending the Date Table - Why you NEED to do it: https://bit.ly/2WRy20p Part 5: Extending the Date Table with DAX in Power Pivot or Power BI: https://bit.ly/3CsQm0q Part 6: Extending the Date Table with Power Query in Excel or Power BI: https://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 - https://amzn.to/3e9zxML Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK Lights: Elgato Key Light - https://amzn.to/3rurte7 EU Links Camera: Canon EOS R6 - https://amzn.to/3tubwGy Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0 Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP Laptop: Dell XPS 15 - https://amzn.to/3effMmT Lights: Elgato Key Light - https://amzn.to/3vcs6v9 Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y Recorded With: Camtasia - https://www.techsmith.com/video-edito... Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub Subscribe for the Excel Olympics Newsletter: https://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