Produces online games for mobile devices

Assignment Help Operation Management

Reference no: EM132177561

You are a business intelligence consultant hired by a small start-up company that produces online games for mobile devices. The company is evaluating the construction of a data warehouse. The company’s operational databases contain information on each game, including the game title, the game genre (action, puzzle game, word game, etc.), the game’s rating (Everyone, Teen, Mature, etc.), and the price. They also store information on customers, including customer names, addresses, ages, and genders; on game downloads, including date, time, and amount paid; and on the devices where games are installed, including the device type (phone or tablet), operating system platform (iOS, Android, etc.), manufacturer (Apple, Samsung, etc.), and model (iPhone 5, Galaxy S4, etc.).

(a) A senior executive is questioning the need for a data warehouse, arguing that all the needed data are already in the operational databases. Briefly explain to this executive at least three major differences between an operational database and a data warehouse.

(b) Recommend one fact table and at least three dimension tables for the data warehouse, and list at least three possible attributes for each dimension.

Reference no: EM132177561

Questions Cloud

Does home depot utilize cost leadership strategy : Does Home depot utilize a cost leadership strategy? If so, how do they go about using this strategy? If not what type of strategy do they use?

The first step in developing direct marketing strategy : The first step in developing a direct marketing strategy is ________. The high level of competition in direct marketing is due to ________.

A trade-off to using high degree of graphics : A trade-off to using a high degree of graphics on a Web site is the ________. A major advantage of omnichannel retailing is the ability of consumers to ________

Centralized internet-connected inventory database : Describe one way in which a centralized Internet-connected inventory database could be used by this company.

Produces online games for mobile devices : You are a business intelligence consultant hired by a small start-up company that produces online games for mobile devices.

Relational database management system : Describe a data management technology that preceded today’s relational database management system,

Direct marketing is forecast to grow based : Direct marketing is increasingly used by store-based retailers since it ________. Direct marketing is forecast to grow based on ________.

Direct selling and direct marketing are similar in that : Infomercials are generally broadcast ________. Direct selling and direct marketing are similar in that ________.

The promotional strategy of shopping networks : The promotional strategy of most infomercials ________. The promotional strategy of shopping networks ________.

User Account

All Pages