MI0036- BUSINESS INTELLIGENCE & TOOLS

Dear students get fully solved  assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601

(Prefer mailing. Call in emergency )

ASSIGNMENT

DRIVE	FALL 2014
PROGRAM	MBADS – (SEM 3/SEM 5) / MBAN2 / MBAFLEX – (SEM 3) / PGDISMN – (SEM 1)
SUBJECT CODE & NAME	MI0036- BUSINESS INTELLIGENCE & TOOLS
SEMESTER	3
BK ID	B1219
CREDITS	4
MARKS	60

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: Business intelligence (BI) is the transformation of raw data into meaningful and useful information for business analysis purposes. BI can handle enormous amounts of unstructured data to help identify, develop and otherwise create new strategic business opportunities. BI allows for the easy interpretation of volumes of data. Identifying new opportunities and implementing an effective strategy can provide a competitive market advantage and long-term stability.

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

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 support to drive enterprise actions that react immediately to events as they occur. As such,

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 : Business intelligence needs suitable analytical tools to assist in gathering information. The business intelligence solutions should be contemplated carefully, and the system opted for should prove to be consistent. Even if you add new data or new systems, or bring about major changes, business intelligence systems have to steer the company to success. Steering to accomplishment is done by integrating the new data with the existing business intelligence systems is one of the significant elements of this intelligence solution. Creating or developing data warehouses consume time, money and energy, whereas creating the data

Q.3. Data extraction is the act or the process of extracting data out of data sources for added data processing or data storage or data migration. This data can be extracted from the web. Explain the different techniques for data extraction. (Listing the various techniques, Explaining the four methods) 2,8

Ans: Listing the various techniques:

•         The Logical Extraction Methods

•         Physical Extraction Methods

•         Change Data Capture

•         Extracting data from the operational systems

Explaining the four methods :

1. Logical Extraction Methods

Q.4. Business Intelligence strategy summarizes the finest combination of procedures and technologies to meet the business intelligence strategies of an organization.

a. List the main aspects of BI strategy.

b. What are the steps to be followed to implement BI framework?

Ans : a) Business intelligence (BI) continues to be the top investment priority for CIOs. An effective BI approach can benefit your IT and line of business (LOB) teams alike.

Four aspects of BI framework:-

1. Determine information needs by business user, business analyst, and BI analyst / designer. The purpose of BI is to provide cross-

b. What are the steps to be followed to implement BI framework?

BI Methodology

Project Initiation:  Agrees and documents the scope, application and data landscape, executive sponsorship, project team roles & responsibilities, high-level project timeline in a project initiation document (PID).

Analysis: The most challenging part of any BI

Q.5. Write short note on:

a. Content Management System

b. End User Segmentation

c. Basic Reporting and querying

d. OLAP

Ans: a) Content Management System (CMS):- A content management system (CMS)[1][2][3] is a computer program that allows publishing, editing and modifying content as well as maintenance from a central interface. Such systems of content management provide procedures to manage workflow in a collaborative environment

A content

b. End User Segmentation :

There are user types delineated by application requirements and by

skill. If we look at the users in light of their application requirements, we normally see

three distinct types:

• Traditional query and reporting

c. Basic Reporting and querying:

A querying and reporting tool helps to run regular reports, create organized listings, and perform cross-tabular reporting and querying.

The use of SQL as the basis for most querying and reporting tools was both good and bad for data warehousing. On the

d. OLAP:

OLAP (On-line Analytical Processing) is characterized by relatively low volume of transactions. Queries are often very complex and involve aggregations. For OLAP systems a response time is an effectiveness measure. OLAP applications are widely used by Data Mining techniques. In OLAP database there is aggregated, historical data, stored in multi-dimensional schemas (usually star schema). OLAP can be used for data mining or the discovery of previously undiscerned relationships between data items. An OLAP database does not need to be as large as a data warehouse, since not all transactional data is needed for trend analysis. Using Open Database Connectivity (ODBC), data can be imported from existing relational databases to create a multidimensional database for OLAP.

Q6 . 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) is the process of capturing, developing, sharing, and effectively using organisational knowledge. It refers to a multi-disciplined approach to achieving organisational objectives by making the best use of knowledge.

An established discipline since 1991 KM includes courses taught in the fields of business administration, information systems, management, and library and information sciences .More recently, other fields have started contributing to KM research; these include information and media, computer science, public health, and public policy. Columbia University and Kent State University offer dedicated Master of Science degrees in Knowledge Management

Knowledge management (KM) comprises a range of strategies and practices used in an organisation to identify, create, represent, distribute, and

Dear students get fully solved  assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601

(Prefer mailing. Call in emergency )