Skip to content

Fiscal Calendar

About

Fiscal calendar data is present in fiscalcalendar container inside dwh-repo cosmosdb at cosmos-dwh-account in Azure. The table contains the following columns: - Quarter - Quarter Start Date - Quarter End Date - Quarter Month - Calendar Month Number - Fiscal Calendar Month Number - Fiscal Week Number - Fiscal Week Start Date - Day/Date

Currently the fiscal calendar data is from FY2021 to FY2029.

Note that the structure of data present in the container is tailored for use in PowerBI and may differ for other data visualization applications.

Usage

Power BI

Due to the way data is represented once imported into PowerBI, additional steps are required to transform the imported table before using it for visualization purposes.

Importing Data

  • To import data from Azure data source:
    • Get Data > Azure > Azure Cosmos DB v1 import image
    • Click Connect
  • Enter the all the requried values in the dialogue box
    • URL: https://cosmos-dwh-account.documents.azure.com:443/
    • Database: dwh-repo
    • Collection: fiscalcalendar import data
    • Click OK
  • Click Transform Data

PowerBI may require you to enter the key value for the cosmos database. Kindly contact Energizers Team for this

Transforming Data

  • Click the Expand Icon next to the table header and select only the following fields for expansion:
    • id
    • Qtr_info Expansion Data
  • After clicking OK the table should look like : initial expansion
  • Expand the Qtr_Info column again by clicking the expand icon and selecting Expand to New Rows Further_expansion
  • Now we split the expanded Qtr_Info column:
    • Select the entire column by clicking the column header
    • Home > Split Column > By Delimiter split_column
      • Select --Custom-- from dropdown
      • Enter the pipe, | , symbol
      • Select Each occurance of the delimiter and press OK split_options
    • Rename the columns, respectively, as stated at the beginning
  • Now the data can be used for visualization

For any queries on fiscal calendar data please raise a support request to Energizers Team