Task 1: Load AW Data (SSIS) – this should have been completed already – Load company data to SQL…
Do you need academic writing help with your homework? Let us write your papers.
Order a Similar Paper
Order a Different Paper
Task 1: Load AW Data (SSIS) – this should have been completed already
? Load company data to SQL
? Data files have been posted to Blackboard
Task 2: Select Analysis
? From the Table 1, identify ONE business process for analysis (like sales)
? Review and identify the data (in SQL) that you would require to provide the
corresponding business intelligence
o Identify measure or facts (sales dollar)
o Identify dimensions for facts (product dimension, location dimension, etc)
o List the columns that describe each dimension (region name, branch dimension,
etc)
o Determine the lowest level of summary in a fact table (sales dollar)
o Based on the analysis selected, list at least 5 questions the you intend to provide
intelligence for
Attachments:
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper Now