Apply to multidimensional analysis

Assignment Help Basic Computer Science
Reference no: EM13854294

  1. Which of the following statements does not apply to multidimensional analysis:
  2. Provides the most flexible type of reporting.
  3. Allows for drill up, drill down, and iterative data analysis.
  4. Divides analysis into dimensions, by which users may view data.
  5. Allows data to be aggregated by different aggregation functions by dimensions.
  6. None of the above.
  1. Online transaction processing and online analytical processing have which of the following in common:
  2. Orientation or alignment of data
  3. Data access and manipulation
  4. Design and functionality
  5. Usage patterns
  6. None of the above.
  1. Which of the following statements about multidimensional models is not true:
  2. Organize and present the data by primary lines of the users.
  3. Allow the user to select the qualification of the return data set
  4. Filter one dimension independent of other dimensions
  5. Allow the user to perform current transactions.
  1. Which of the following statements is true:
  2. Multidimensional analysis consists of defining the aggregation level and qualifying the return set depending on all dimensions.
  3. Multidimensional analysis consists of defining the aggregation level and qualifying the return set independent of all other dimensions.
  1. Which of the following statements about dimensional attributes is not true:
  2. Allow the users to define the level of aggregation at an attribute level.
  3. Would likely be entities in an entity-relationship diagram.
  4. Would be related to attributes in other dimensions.
  5. Allow users to present data grouped by one or more dimension.
  6. None of the above.
  1. Which of the following considerations does not need to be balanced (or traded off) when developing a data warehouse:
  2. Data warehouse maintenance
  3. Source data
  4. Query performance
  5. User requirements
  6. None of the above
  1. Which of the following statements is true:
  2. Source systems can possess overlapping data
  3. Data must always be calculated using a consistent algorithm across operational source systems
  4. Users of the warehouse will primarily be the same as users of source systems
  5. Data warehouses cannot reside in one or more databases operating on one or more servers
  6. All of the above.
  1. Which of the following statements about aggregation is true:
  2. Aggregate calculations involve sorts that are costly
  3. Aggregation increases the number of physical disk reads.
  4. The amount of data that is aggregated and must be stored is reduced, reducing swap requirements.
  5. Data is summarized with more granularity.
  6. All of the above.

 

9.  Which of the following is an advantage of a denormalized schema? 
a. Fewer indexes. 
b. Ease of restructuring the database. 
c. Simpler access method. 
d. All of the above. 

10. Which are the best attributes of a dimension: 
a. Additive attributes. 
b. Numeric attributes. 
c. Continuously valued attributes. 
d. Textual attributes. 
e. All of the above.

Company ABC wants to analyze his margins and how they vary over time, by region, by industry, by product, and by customer.  Margins are revenue minus production, development, distribution, office, and sales costs. Company ABC also wants to know market, industry, and customer trends.  Company ABC also wants to know which sales reps are high achievers.  Develop the multidimensional model for a data warehouse to satisfy Company ABC's analysis requirements.

 

The following are the sources of the data:

Sales Tracking System:  An Oracle database that helps the marketing group track their orders, costs, and expenses.  Orders are tracked for each customer, and customers are categorized by industry and country.  The system also tracks the contacts made by the sales force in terms of customer visits and customer contacts.  Sales orders are recorded for each customer with references to the product information that was sold.  Information about the sales reps is tracked to record their expenses, commissions, and salaries.  Because sales reps are assigned to sales regions, office costs for each region are also tracked.

It contains the following tables and attributes:

 

PRODUCT_PRICE TABLE

Start_date

End_date

Price

 

SALES_ORDER_DETAIL TABLE

Item_number

Quantity

Discount_rate

Quanitity_backorder

Description

 

PRODUCT TABLE

Product_number

Product_name

Model

Size

Description

 

PRODUCT_TYPE TABLE

Product_type

Description

 

SALES_ORDER TABLE

Order_id

Order_date

Delivery_date

Description

 

CUSTOMER_CONTACT TABLE

Contact_id

Last_name

First_name

Phone_number

 

CUSTOMER_VISIT TABLE

Date_of_visit

Hours_spent

 

CUSTOMER TABLE

Customer_id

Customer_name

Address

City

State

Zip_code

 

INDUSTRY TABLE

Industry_code

Description

 

COUNTRY TABLE

Country_id

 

CUSTOMER_SALES_REP TABLE

Start_date

End_date

 

COMMISSION_RATE TABLE

Start_date

End_date

Commission_rate

 

SALARY TABLE

Start_date

End_date

Amount

 

EXPENSE TABLE

Expense_id

Period_start_date

Period_end_date

Effective_date

Amount

Description

 

EXPENSE_CODE TABLE

Expense_code

Description

 

SALES_REP TABLE

Rep_number

Last_name

First_name

Hire_date

Termination_date

Title

 

SALES_REGION TABLE

Region_name

Description

 

OFFICE_COST TABLE

Effective month

Amount

Description

 

OFFICE_CODE TABLE

Office_cost_code

Description

 

SALES_AREA TABLE

Area

Description

 

General Ledger Cost System:  Cost reports are run against records from the General Ledger application, which consists of flat file records.  Information is extracted based on cost codes (production, distribution, etc.) and product codes.  From this information, it is possible to determine the total cost to develop, produce, and distribute each product.  Information about sales and marketing costs are captured in the Sales Tracking System

 

The General Ledger System contains the following:

GENERAL_LEDGER TABLE

General_ledger_transaction_id

Cost_code

Effective_date

Product_code

Facility_type

Facility_name

Location

Customer_name

Quantity

Amount

Market Estimate:  Information about market estimates come from an external source, Market Estimating Company, in a flat file format.  The information is broken down by industry group.  Spending estimates are provided for each industry and region.  The regions are the same regions as in the Sales Tracking System.

The Market Estimate data is:

MARKET_FORECAST_DATA TABLE

Start_period_date

End_period_date

Industry

Region

Product_type

Spending_estimate

Quantity_purchase_estimate

Explain the following data warehousing terms.

    1. Data warehouse
    2. Data mart
    3. Granularity
    4. Roll up
    5. Star schema
    6. Drill down
    7. Aggregation
    8. Snowflake schema
    9. Dimension
    10. Fact

Reference no: EM13854294

Questions Cloud

Which type of research design is appropriate : Which type of research design is appropriate
Compose a clear thesis statement containing the information : Compose a clear thesis statement containing the following information: the films's title that you are analyzing, the director, the three main criteria, and your overall assessment. Note that thesis statements can be more than one sentence
Whos responsibility for what is being taught in our colleges : Who has the greater responsibility for what is being taught in our colleges--students, parents, primary and secondary schools, or the colleges themselves
Explain the meaning of variety management : Explain the meaning of variety management as used in operational management
Apply to multidimensional analysis : Which of the following statements does not apply to multidimensional analysis:Provides the most flexible type of reporting.Allows for drill up, drill down, and iterative data analysis.
Matrices-set of problems : Use the matrices defined below for the following set of problems.
The modifications are the assignment : The modifications are the assignment!This assignment will require you to think, research and explore, it is not a step-by-step!Work on this assignment on your own!
What is your financial analysis that supports your decision : How would you approach this opportunity? How would you determine customer interest, what would be your key assumptions, and what are the cheapest ways you can determine to test those assumptions?
What are precise effects of the engagement of an escort team : What are the precise effects of the engagement of an escort team representing the final end users during the execution of the project from the initial phase till the end?

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Standardize programming between many processor platforms

Do you think the java virtual machine is a good way to standardize programming between many processor platforms? Explain your view with details.

  Describes the benefits of getting a college education

Change the Font style and Font size of the numbers in the Worksheet and change the Row and Column headins to Bold Font.

  Discrete math problem

Discrete Math problem.What is the number of subsets of {a,b,c,d,e,f,g,h} containing exactly 3 elements?

  Which design strategy would you recommend

Assume that you are developing a new system for a local real estate agency. The agency wants to keep a database of its own property listing and also wants to have access to the citywide multiple listing service used by all real estate agents Which de..

  Print a header line with appropriate labels for each column

Print a header line with appropriate labels for each column. Format each data line to vertically align each column right-justified.

  Write the code segment needed to set the data variable

Write the code segment needed to set the data variable to 25, and the tag string to "Hello World".

  Fi and rri notation illustrate

Using the Fi and RRi notation illustrate the transfer of 15 data packets with a window size of 5.

  Saas and cloud computing

SaaS and Cloud Computing

  Charts and conditional formatting

Explain what you believe to be the main business purpose of charts in Excel. Next, discuss whether or not you believe Excel would still be a useful tool if the charting features were removed from the application. Justify your response.

  Current standards sufficient to protect privacy

What is the right of privacy, and what is the basis for protecting personal privacy under the law and are current standards sufficient to protect privacy?

  The prime address id being foreign

First last name using Zip code 56716 as the select statement.

  How many frames are destroyed

In a Standard Ethernet LAN, the average size of a frame is 1000 bytes. If a noise of 2 ms occurs on the LAN, how many frames are destroyed? Also repeat this problem with Gigabit Ethernet LAN.

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!

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