Answered step by step
Verified Expert Solution
Link Copied!

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.

  1. Using the InternetSales Excel file, include the following tables as described: (10 points)
    1. FactInternetSales
      1. Rename to Sales
      2. Import all available columns
    2. DimSalesTerritory
      1. Rename to Territory
      2. Import all available columns
    3. DimCustomer
      1. Rename to Customer
      2. Import all available columns
    4. DimDate
      1. Rename to Date
      2. Import all available columns
    5. DimProduct
      1. Rename to Product
      2. Import all available columns

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project Management in Practice

Authors: Samuel J. Mantel Jr., Jack R. Meredith, Sco

4th edition

470533013, 978-0470533017

More Books

Students also viewed these General Management questions