Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Vice President of Sales for AdventureWorks Inc. has hired you as a consultant to build an analysis tool for her to monitor Internet sales.
The Vice President of Sales for AdventureWorks Inc. has hired you as a consultant to build an analysis tool for her to monitor Internet sales. She has provided you with data to use in developing this tool.
- Using the InternetSales Excel file, include the following tables as described: (10 points)
- FactInternetSales
- Rename to Sales
- Import all available columns
- DimSalesTerritory
- Rename to Territory
- Import all available columns
- DimCustomer
- Rename to Customer
- Import all available columns
- DimDate
- Rename to Date
- Import all available columns
- DimProduct
- Rename to Product
- Import all available columns
- FactInternetSales
Step by Step Solution
There are 3 Steps involved in it
Step: 1
To build the analysis tool for monitoring Internet sales several steps to import and rename tables f...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started