Posted: April 13th, 2023
Datawarehouse Project.
• Star Schema
• One fact table – Min 100,000 rows
• Three or four (preferably) dimensions
• One time dimension
• One dimension with hierarchies
• One or two slowly changing dimension attributes, at least one of which is implemented with Type 2.
• Submit a Visio or Lucidchart diagram
• ETL
• Can use any combination of methods
• Submit your code and/or package
• Visualization
• Using Tableau or Power BI – at least two visualizations of the data
• One visualization needs to have drill-down/roll-up (i.e. use the hierarchical dimension)
• One visualization needs to demonstrate filtering
• One visualization needs to use one or more calculated fields
• Between all visualizations, all dimensions are used.
• Submit at least four images … one for each of the above criteria. Expectations are that it could require 8 to 10 images to demonstrate everything.
-research paper writing service