Page 88 - DCAP606_BUSINESS_INTELLIGENCE

Deepak Mehta,Lovely Professional University Unit 6: Business Intelligence Project

Unit 6: Business Intelligence Project Notes

CONTENTS
Objectives
Introduction
6.1 Creating Data Source
6.2 Creating a Data Source View

6.3 Modifying the Data View
6.4 Creating Dimensions, Time and Modifying Dimensions
6.4.1 Creating Dimensions
6.4.2 Time Dimension
6.4.3 Modifying the Date Dimension
6.5 Parent-Child Dimensions
6.6 Summary

6.7 Keywords
6.8 Review Questions
6.9 Further Readings

Objectives

After studying this unit, you will be able to:
Discuss Creating Data Source
Explain Creating the Data Source View

State the Modifying of the Data View
Summarize Creating Dimensions, Time and Modifying Dimensions
Define the Parent-child Dimension

Introduction

Too many times, Business Intelligence (BI) and Data Warehousing project managers are not
equipped well to handle their role in guiding a project to success. Often, the person allotted to
lead a project is either: (1) a technician who doesn’t know the first thing about managing a
project, or (2) a project manager who doesn’t know the first thing about Business Intelligence.
Purpose of BI is making the most of an organization’s data assets. By making better data-driven
decisions through BI, companies can gain advantages like increasing revenue, reducing costs, or
reducing risks. This Unit focus on discussion of data source and data source view. Also, working
with dimension is explained in the unit. Finally, you will learn about parent-child dimension.

6.1 Creating Data Source

In an Analysis Services multidimensional model, a data source object represents a connection to
the data source from which you are importing data. A multidimensional model must contain at
least one data source object, but you can add more to combine data from several data warehouses.

LOVELY PROFESSIONAL UNIVERSITY 83