Page 5 - DCAP606_BUSINESS_INTELLIGENCE

SYLLABUS
Business Intelligence

Objectives: To impart the skills needed to manage database of large scale organization, techniques for data mining. Student
will learn OLAP and generating quick reports.

S. No. Description
1. Business Intelligence: Introduction, Meaning, Purpose and Structure of Business Intelligence Systems.
Understanding Multidimensional Analysis Concepts: Attributes, Hierarchies and Dimensions in data
Analysis. Understanding Dimensional Data Warehouse: Fact Table, Dimension Tables, Surrogate Keys and
alternative Table Structure. What is multi-dimension OLAP?
2. Understanding OLAP: Fast response, Meta-data based queries, Spread sheet formulas. Understanding
Analysis Services speed and meta-data. Microsoft’s Business intelligence Platform. Analysis Services Tools.
Data Extraction, Transformation and Load. Meaning and Tools for the same.
3. Creating your First Business Intelligence Project: Creating Data source, Creating Data view. Modifying the
Data view. Creating Dimensions, Time, and Modifying dimensions. Parent-Child Dimension.
4. Creating Cube: Wizard to Create Cube. Preview of Cube. Adding measure and measure groups to a cube.
Calculated members. Deploying and Browsing a Cube.
5. Advanced Measures and Calculations: Aggregate Functions. Using MDX to retrieve values from cube.
Calculation Scripting. Creation of KPI’s.
6. Advanced Dimensional Design: Creating reference, fact and many to many dimensions. Using Financial
Analysis Cubes. Interacting with a cube. Creating Standard and Drill Down Actions.
7. Retrieving Data from Analysis Services: Creating Perspectives, MDX Queries, Excel with Analysis Services.
8. Data Mining: Meaning and purpose. Creating data for data mining. Data mining model creation. Selecting
data mining algorithm. Understanding data mining tools. Mapping Mining Structure to Source Data columns.
Using Cube Sources. Configuring Algorithm parameters.
9. Creating Data mining queries and reports: Creation of Prediction queries. Understanding DMX language.
10. Reporting Tools: Using SQL Server Reporting Services to develop reports for analysis services.