[SOLVED] 代写 Design

Design
•Start schema-must have a really good reason for snowflake
•One fact table – Min 100,000 rows
•Three or four (preferably dimensions)
1.One time dimension
2.One dimension with hierarchies
3.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.

Word document
•Assumptions
•Design process
•ETL process and why that process was chosen
•Professional document, with references as needed

PowerPoint-5-10 minute presentation

Zip all files and submit to the blackboard