Reference no: EM131277783
OLAP cubes are very similar to Microsoft Excel pivot tables. For this exercise, assume that your organization's purchasing agents rate vendors similar to the situation described in Application Exercise.
a. Open the Excel file Ch1lEx01. The spreadsheet has the following column names: VendorName, EmployeeName, Date, Year, and Rating.
b. Under the Insert ribbon in Excel, click Pivot Table.
c. When asked to provide a data range, drag your mouse over the data you imported so as to select all of the data. Be sure to include the column headings. Excel will fill in the range values in the open dialog box. Place your pivot table in a separate spreadsheet.
d. Excel will create a field list on the right-hand side of your spreadsheet. Drag and drop the field named VendorName under the word "Rows" at the bottom of the field list. Drag and drop EmployeeName under the word "Columns:' Now drag and drop the field named Rating under the word "Values?' Voila! You have a pivot table.
e. To see how the table works, drag and drop more fields onto the various sections of your pivot table. For example, drop Year on top of Employee. Then move Year below Employee. Now move Year below Vendor. All of this action is just like an OLAP cube, and, in fact, OLAP cubes are readily displayed in Excel pivot tables. The major difference is that OLAP cubes are usually based on thousands or more rows of data.
Attachment:- ch11ex01.xlsx
|
Who are the major trading partners of the united states
: Who are the major trading partners of the United States?- Which countries are the top five exporters to the United States?
|
|
Write abel test vectors or a vhdl or ve1ilog test bench
: The machne should go to state SD whenever RESET is asserted. When RESET is negated, it should move to next-numbered state only if ENABLE is asserted. However, once it reaches state S7, it should stay there unless RESET is again asserted. The DONE ..
|
|
To help readers quickly asses the relative contributions
: To help readers quickly asses the relative contributions of Warby Parkers various products lines to the company's overall revenues, year by year over a 10-year period, which type of visual would be more effective? and why. you chose this statement.
|
|
Draw a circuit diagram using ssi and msi components
: Write a transition list, a transition equation for each state variable as a sum of p-terms, and simplified transition/excitation equations for a realization using D flip-flops. Draw a circuit diagram using SSI and MSI components.
|
|
Create a field list on right-hand side of your spreadsheet
: Excel will create a field list on the right-hand side of your spreadsheet. Drag and drop the field named VendorName under the word "Rows" at the bottom of the field list.
|
|
Fully explain why economists see quotas
: Briefly(in1-2 paragraphs) and in your own words, fully explain why economists see quotas as far more disruptive methods of protectionism than tariffs.
|
|
Discuss about the group project peer response
: Evaluate how clearly the PowerPoint presentation accomplished the objectives, providing examples and references.Provide a recommendation to enhance the presentation, including a rationale for your recommendation.
|
|
The cost of performing inspection sampling moves inversely
: The cost of performing inspection sampling moves inversely to the cost of quality failures. We can reduce the cost of quality failures by increased levels of inspection, but that of course increases the cost of inspection. Can you think of any method..
|
|
Focusing on process rather than output
: Monczka states, "TQM puts the focus on those value-adding processes that generate an output rather than on the output itself." Perhaps the most dramatic difference between traditional quality control methods and total quality management thinking invo..
|