Design Star Schema? One fact table ? Min 100,000 rows ?, SQLSERVER Database. Three or four
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →• Design
• Star Schema
• One fact table – Min 100,000 rows , SQLSERVER Database.
• 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.
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds