Sem: NOV-2024 Maximum Marks: 50 Examination: End Exam Date: Duration: 2.5hrs
Programme code: Programme: MBA for working executive (program code-18)	Class: FY	Semester: III Batch-1
College: K. J. Somaiya Institute of Management	Name of the department/Section/Center: Data Science and Technology
Course Code: 117P18C310	Name of the Course: Business Intelligence
Instructions: Solve any 5

Question No.	Max. Marks
1	What are the advantages of making decisions using business intelligence over making decisions without business intelligence Software?	10
2	Explain Star Vs. Snowflake Schema with example.	10
3	A data warehouse is subject-oriented. What would be the major critical business subjects (Areas) for the following companies? an international manufacturing company a local community bank a domestic hotel chain	10
4	You are on the Datawarehouse project of AuctionsPlus.com, an Internet auction company selling upscale works of art. Your responsibility is to gather requirements for sales analysis. Find out the key metrics, business dimensions, hierarchies, and categories. Draw the information package diagram.	10
5	In a STAR schema to track the shipments for a distribution company, the following dimension tables are found: (1) time, (2) customer ship-to, (3) ship-from, (4) product, (5) type of deal, and (6) mode of shipment. Review these dimensions and list the possible attributes for each of the dimension tables. Also, designate a primary key for each table.	10
6	BigBook, Inc. is a large book distributor with domestic and international distribution channels. The company orders from publishers and distributes publications to all the leading booksellers. Initially, you want to build a data warehouse to analyze shipments that are made from the company’s many warehouses. Determine the metrics or facts and the business dimensions. Prepare an information package diagram.	10