Sikkim manipal Solved MBA Assignments, SMU MBA, Solved assignments, 1st sem, 2nd sem, 3rd sem, 4th sem, SMU MBA PROJECTS

Email Us

MI0036 —Business Intelligence Tools

MI0036 —Business Intelligence Tools

Summer 2013

Master of Business Administration- MBA Semester 3

MI0036 —Business Intelligence Tools -4 Credits

(Book ID: B1219)

Assignment (60 marks)

Note: Answer all questions. Kindly note that answers for 10 marks questions should not exceed 400 words. Each question is followed by evaluation scheme.


Q1. a. Emergency Medical Association (EMA) is a group of 250 board- certified emergency physicians. They are responsible for effectively managing the emergency departments. List out what BI values and applications they should be implementing.

Answer :BI values and applications :

In today’s healthcare environment, organizations are swimming in an ever-deeper pool of data yet many lack the technology to use this data as valuable information. As regulations change and the amount of data increases, organizations are turning to business intelligence (BI) solutions to harness data for precise decision-making to help improve patient outcomes, reduce costs, and ensure their organization’s future.

Below are numerous ways healthcare providers can




b. Most of the credit card companies permit a consumer to get approval for specified amounts via mobile to ensure that the purchase is covered. This type of consumer support which retains a customer to the bank for a longer time is real time business intelligence. Define real time Business intelligence and the various steps involved in the process.

Answer : Real time business intelligence :

Real-time business intelligence (RTBI) is the process of delivering information about business operations as they occur. The speed of today’s processing systems has moved classical data warehousing into the realm of real-time. The result is real-time business intelligence. Business transactions as they occur are fed to a real-time business intelligence system that maintains the current state of the enterprise. The RTBI system not only supports the classic strategic functions of data warehousing for deriving information and knowledge from past enterprise activity, but it also provides real-time tactical




Q2. Today businesses largely rely on the information available and can be communicated through various sources, both internally and externally with the help of internet. Explain the role of Business Intelligence in modern business. What are the three different types of decision that most business organisations take?

Answer : Role of business intelligence in modern business :

For many companies, new technologies are causing information overload, leaving decision makers overwhelmed with inadequate, incorrect, inconsistent and misleading information. Indeed, the various acts of retrieving and processing this often useless information can tie up numerous resources. Yet there are companies that manage to provide their decision makers with processed and automatically consolidated raw data, presented in an understandable, easy-to-grasp format. These




Q3. a. Granularity of data is an important factor to be considered in the business which involves data warehousing. How the characteristics of data granularity does varies from application to application? List the different tools in data granularity.

Answer : Granularity refers to the level of detail of the data stored fact tables in a data warehouse. High granularity refers to data that is at or near the transaction level. Data that is at the transaction level is usually referred to as atomic level data. Low granularity refers to data that is summarized or aggregated, usually from the atomic level data. Summarized data can be lightly summarized as in daily or weekly summaries or highly summarized data such as yearly averages and totals. Granularity is the most important to the data warehouse architect because it affects all the environments that depend in the data warehouse for data. The main issue of granularity is that of getting it at the right level.




b. Consider a data warehousing enterprise where a Total data quality management (TDQM) cycle has to be implemented. Find the members involved in TDQM team of that organisation.

Answer : Members involved in TDQM team :

Form a data quality improvement team, with: · A team leader, who is responsible (process owner) of the product attributes and has the power to implement solutions · A team engineer who can facilitate the team meetings · A data manufacturer who has extensive knowledge about the database system · A financial team member, who understands financial consequences of proposed solutions · Product attribute data suppliers, selected on the chosen product attribute to handle · Product





Q4. a. You are given the responsibility to organize a tour for your batch to an organisation. Find out the parameters used by your team for data mining.

Answer : Parameters for data mining :

Data mining is sorting through data to identify patterns and establish relationships. Data mining parameters include:

Association – looking for patterns where one event is connected to another event

Sequence or path analysis – looking for patterns where one event leads to another later event

Classification – looking for new patterns (May result in a change



Q5. According to a recent IDC report, knowledge management is in a state of high growth, especially among the business and legal services industries. As the performance metrics of early adopters are documenting the substantial benefits of knowledge management, more organizations are recognizing the value of leveraging organizational knowledge. Define Knowledge Management. Explain the various characteristics of Knowledge management. What are knowledge assets?

Answer : Knowledge Management :

Knowledge management (KM) comprises a range of strategies and practices used in an organisation to identify, create, represent, distribute, and enable adoption of insights and experiences.  Such insights and experiences comprise knowledge, either embodied in individuals or embedded in organisations as processes or practices. More recently, other fields have started contributing to KM research; these include information and media, computer science, public health, and public policy.



Q6. How to make the best use of Business intelligence? What are the advantages of BI with sales?

Answer :Use of Business intelligence :

Business intelligence (BI) is a set of theories, methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information for business purposes. BI can handle large amounts of information to help identify and develop new opportunities. Making use of new opportunities and implementing an effective strategy can provide a competitive market advantage and long-term stability.

BI can be used in following ways wisely


Leave a Reply

You must be logged in to post a comment.