Therefore, management has limited confidence in the data warehouse reports. Because this business logic is generated separately for each report, summary information sometimes is different between reports. Complex calculation logic is buried in report definitions and is difficult to share between reports.However, while these aggregate tables greatly improve query performance, the infrastructure that they built to maintain the tables over time is fragile and prone to errors. For example, they built a table that summarizes sales by month. In an attempt to improve query response times, the data warehouse team at Adventure Works built several aggregate tables in the AdventureWorksDW2012 database. Aggregate tables are difficult to manage.For example, some queries return results very quickly, in only a few seconds, while other queries take several minutes to return.
#DOWNLOAD ADVENTUREWORKS2012 MULTIDIMENSIONAL HOW TO#
However, because of the complexity of the AdventureWorksDW2012 database, too much time is needed for such users to master how to create effective queries. Although the existing set of predefined reports is sufficient for many users, more advanced users need direct query access to the database for interactive queries and specialized reports. Users have no way to interactively explore the data in the reports to obtain more detailed information, such as they could do with a Microsoft Office Excel pivot table. However, the relational data warehouse presents the following challenges: To support the data analysis needs of the sales and marketing teams and of senior management, the company currently takes transactional data from the AdventureWorks2012 database, and non-transactional information such as sales quotas from spreadsheets, and consolidates this information into the AdventureWorksDW2012 relational data warehouse. In 2005, Importadores Neptuno became the sole manufacturer and distributor of the touring bicycle product group.įollowing a successful fiscal year, Adventure Works Cycles now wants to broaden its market share by targeting advertising to its best customers, extending product availability through an external Web site, and reducing the cost of sales by reducing production costs. These subcomponents are shipped to the Bothell location for final product assembly. Importadores Neptuno manufactures several critical subcomponents for the Adventure Works Cycles product line. In recent years, Adventure Works Cycles bought a small manufacturing plant, Importadores Neptuno, which is located in Mexico. Additionally, Adventure Works Cycles employs several regional sales teams throughout its market base. The headquarters for Adventure Works Cycles is Bothell, Washington, where the company employs 500 workers. Adventure Works Cycles is a large, multinational manufacturing company that produces and distributes metal and composite bicycles to commercial markets in North America, Europe, and Asia. This tutorial is based on Adventure Works Cycles, a fictitious company.
0 kommentar(er)
