Create Time Dimension

Create Time Dimension

Create Time Dimension
Preview image
Preview image
FREE
This app requires the new Office. Get it today.
By clicking Add you agree to the terms and conditions and privacy statement and acknowledge this app’s requirements.

VERSION1.0
RELEASED1/9/2013
PRODUCTExcel 2013
SUPPORTED LANGUAGESEnglish
PROVIDER DESCRIPTION
Create Time Dimension creates a table with the required information for a time dimension. The time dimension table can be used for analysis of information in one or more data tables so that the plain date information from the source data can be broken down by year, month, quarter etc.
Once the table is inserted into the spreadsheet it can be expanded with any custom columns directly in the spreadsheet using Excel 2013 formulas or added to a data model in PowerPivot and extended using DAX.
This app solves the problem of manually creating or linking Time Dimension information every time a Time based table is needed. By choosing the needed start and end date the number of day rows can be customized for individual analysis needs
The table is day based and includes columns for:
Year
Month
Day
id
Quarter
Day Names
Month Names
Day of Year
Day of Week