User Account

All Pages

Explore the database to understand what it is about

Assignment Help Database Management System
Reference no: EM13889457

Project

In this project you will create an OLAP cube of the Northwind sales database provided by Microsoft Access. You are required to generate

1. Two cuboids from the different tables (dimensions) of the database.

2. Two reports from each cuboid along with their charts that would support the top management decisions.
Installing the Database

To install the database, you need to open Microsoft Access. In the ‘Search for online templates' field , type ‘Northwind'. It will be automatically located and you can download it.

Once downloaded, explore the database to understand what it is about then close your Microsoft Access.

Creating the Cube

To create the cube, you need a data warehouse tool, i.e. an analysis services software that usually require a license. To ease the process, you can use cube creator tool, called Cube-it Zero. This is not data warehouse tool, it is only an OLAP cube builder based on creating an access query from an external DMBS like MS Access or SQL Server. To download Cube-it Zero, access the following link:

https://www.bi-lite.com/product/CUBEITZEROEnquiry.aspx

Download the 30 day evaluation version.

Visualizing the Cube

To visualize the cube, you need an OLAP tool. A popular OLAP tool that is already available on your PC is Excel. You need to use the Pivot tables and Pivot charts feature. Cube-it -Zero is already linked with Excel.

Reference no: EM13889457

Questions Cloud

Define an input format for your program to provide it input : Define an input format for your program to provide it input data.
Why do not we track costs of the orders separately : Since Melton occasionally prepares snack foods for special orders in the Snack Foods Division, why don't we track costs of the orders separately?
Write a value to memory in terms of what is put into the mar : Write a value from memory and to write a value to memory in terms of what is put into the MAR, MBR, address bus, data bus, and control bus.
What is the final velocity : The Question is how do you find the time when given distance and acceleration.(A car starts from rest accelerates uniformly at a rate 5.78m/s^2 for a distance of 115m.what is the final velocity?) so from that question how do you start and end the..
Explore the database to understand what it is about : explore the database to understand what it is about then close your Microsoft Access
Describe the primary steps used to manufacture paintballs : Describe in sequence the primary steps used to manufacture paintballs. Discuss whether a paintball manufacturer would use job order costing or process costing.
Writing a business law issue paper : The problem related to Law and it describes about reading the above mentioned articles and writing a business law issue paper.
Rocking horse winner : The Rocking Horse Winner;  Analysis of D.H. Biography; depictions of childhood What connection do Paul and the author have?  What in the story can be used to answer the above question?
What was per unit conversion cost of the sofas transferred : If 3,000 sofas were started into production on May 1 and 2,500 sofas were transferred to Upholstering. Using the data in (a) above, what was the per unit conversion cost of the sofas transferred to Upholstering?

Reviews

Write a Review

Database Management System Questions & Answers

  How to use traditional database design method

Explain how you would follow three phases of traditional database design method (Hierarchical, Network, and Relational), considering the following scenario.

  Prepare an entity relationship diagram

Prepare an entity relationship diagram which models your proposed design. Write the SQL statements to create the database tables, relationships and populate each table with at least 10 records per table, where applicable

  In online marketing a shopping cart is a piece of

in online marketing a shopping cart is a piece of e-commerce software on a web server that allows visitors to an

  Develop the erd for given problem

An art museum owns a large volume of works of art. Each work of art is described by an item code (identifier), title, type, and size; size is further composed of height, width, and weight.

  Create a report that dumps the contents of a table

A screen shot of the first page of the contents of each table. Alternatively, you may create a report that dumps the contents of a table and submit a single page of that report.

  Describe a polynomial-time algorithm to test dependency

Describe a polynomial-time algorithm to test dependency-preservation.

  Oracle having multiple group functions in same select list

Can Oracle have multiple group functions in the same SELECT list of query (i.e can we do a COUNT and AVG)? Let us assume we wanted to find lowest, highest, average.

  Write an sql query

Write an SQL query to get the author of the book "The Alchemist"

  Determine columns that make up the primary key

Carry out the following tasks below by using the correct SQL statements. Create the statements in Oracle by using the following steps (SQL > SQL commands > Enter Command). Determine the columns that make up the primary key of the l_lunch_items tabl..

  Develop a context diagram and system level data flow diagram

Develop a Context Diagram and a System Level Data Flow Diagram , make sure you properly identify all the components. Develop an ERD as well making sure you properly label the Entity name.

  Design database in microsoft access

Access will draw a line, called_______a, between matching fields in two tables, indicating that the tables are related. You can then select fields from either table. Access joins the tables automatically.

  Differentiate between the interaction types and styles

Explain the conceptual model employed in the design of these types. Describe the analogies and concepts these monitors expose to users, including the task-domain objects users manipulate on the screen.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd