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	SPRING 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 be approximately of 400 words. Each question is followed by evaluation scheme.

Q.1. Similarity measures determine the similarity between the two objects. The similarity between the two objects ti and tj, sim(ti, tj) in the database D is a mapping from D*D to the range [0, 1].

a. List the characteristics of a good similarity measure.

b. what are the four methods to determine the similarity characteristic between the two objects?

Ans : Similarity Measures

Similarity measures determine the similarity between the two objects. Similarity measure is an important tool of business intelligence system which is useful in determining the similarities between the two factors in abusiness application.

a. List the characteristics of a good similarity measure:

b. what are the four methods to determine the similarity characteristic between the two objects?

Ans :

1. Stimulus Generalization  :

A few years ago a chapter on similarity in a book about animal behavior would have been titled  “Stimulus Generalization,” and similarity would be defined by relative responding across stimuli in generalization and discrimination tasks. 

Q.2. Transactions refers to business or commercial transactions. Online transaction processing refers to the categories of systems that assists and manage transaction- oriented applications, typically for data entry and retrieval transaction processing. List the differences between OLAP and OLTP.

Ans : Difference between OLAP and OLTP:

1. Definition:

OLTP (On-line Transaction Processing) is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second.

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

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) BI Strategy and its main aspects :

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-organizational business analysis capabilities to all business users in the organization. Demand for information

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 project, specifying the insightful questions that business executives need answers to, requires a structured and collaborative approach to elicit, including use of stakeholder workshops to storyboard key metrics and use of customisable project templates by business function and process.

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) 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. These procedures can be manual steps or an automated

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

• OLAP

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 positive side, many more product-to-product matchups are possible in data warehousing environments, enabling tools to be provided both by RDBMS vendors and other third-party vendors.

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

Q.6. RSG is a footwear company which has its chain all over the world. This company has to keep track of all the products sold in the company and huge data is involved in it.

a. How should it plan to implement the Business intelligence solutions?

b. How to make the best use of BI?

Ans : a)  Planning to Implement a Business Intelligence Solution:

Implementing a business intelligence system requires careful planning to assure that it meets expectations. These are the basic steps:

1. Identify End-User Requirements

It is important to anticipate how end users will

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 )