Diploma in Business Intelligence

Diploma in Business Intelligence

This is a Job Oriented Training Program. Candidates who join this program will undergo a training on SQL,Business Intelligence tool(QlikView). Data Warehouse Design and concepts, ETL (Extract, Transform & Load) and creation of Dash board and Report through QlikView. Training will be provided as part of a hands-on industry strength ETL project. This project will walk you through the process of designing and building a real-life data mart for a Retail Sales Corporation and Reports depending on that.

Diploma in Business Intelligence Training Course in Pune

Diploma in Business Intelligence Training Course in Pune

What you will learn?
In this course, students study the issues involved in planning, designing, building, populating, and maintaining a successful data warehouse. Students learn the reasons why data warehousing is a compelling decision-support solution in today’s business climate and why do we connect Reporting tool to a Data warehouse and generate reports . Participants also examine what Oracle has to offer to a successful data warehouse implementation by identifying the proven Data Warehouse and Business Intelligence (DW and BI) technologies and tools provided by Oracle and QlikView.

Course Syllabus:

Unit 1 – Oracle SQL

  • Basic SQL Statement
  • Restricting and Sorting Data
  • Single Row Functions
  • Displaying Data from Multiple Tables
  • Aggregating Data by Using Group Functions
  • Writing Sub queries
  • Sqlplus
  • Manipulating Data
  • Managing Tables, Constraints
  • Views
  • Other Database Objects
  • Controlling User Access
  • Using Set Operators
  • Hierarchical Retrieval
  • Oracle Extensions to DML and DDL Statements/li>

Unit 2 – Business Intelligent

Introduction

  • What is QlikView?
  • How does QlikView differ from traditional BI?
  • Architecture

Desktop Installation

  • Installation
  • Navigation

Data Loading

  • Excel file
  • Delimited file
  • Web file
  • XML file
  • Database

Data Transformation

  • Transformation Wizard
  • Fill Function
  • Column Manipulation
  • Rotating Tables

Data Model

  • Dimensions and measures(OLAP Operations)
  • Start Schema
  • Synthetic Key
  • Generating Data

Sheet and Objects

  • Documents
  • List Box
  • Multi box
  • Text object
  • Current selection box
  • Adding a Bookmark
  • Search
  • Slider Object

Data Analysis

  • Cross tables
  • Straight tables
  • Pivot table

Charts

  • Bar Chart
  • Pie chart
  • Line Chart
  • Combo chart
  • Radar chart
  • Mekko chart
  • Block Chart
  • Grid chart
  • Funnel chart
  • Container
  • Buttonc

Scripting

  • The Script Editor
  • Menu toolbar
  • Script Pane
  • Tool pane
  • Script statement
  • Manipulating Tables
  • Join
  • Keep
  • Concatenate
  • Mapping
  • Master Calender
  • Circular Reference
  • Loading
  • Inline Data
  • Resident load
  • Preceding Load
  • Partial Load
  • Incremental Load
  • QVD
  • Script Debugger
  • Comments

Functions

  • Interval Match
  • Aggregate
  • Match
  • Rank
  • Peek
  • RangeSum

QV Objects in MS Powerpoint and Excel
QVS files (include external scripts)
Creating static reports
Triggers

  • Document Level
  • Sheet Level

Dashboard
Advance Topics

Unit 3 – Data Warehousing Project

  • Dealing with large amount of data (millions of rows)
  • Database performance tuning
  • Monitoring of daily & nightly jobs
  • Data warehousing concepts
  • Dimensional data modeling/li>
  • ETL – Extract Transform & Load
  • Management

Unit 4 – Business Intelligent Project

  • Creation Of Dash Board
  • Creation Of Reports
  • Designing Dash Board on ETL Project

Unit 5 – International Certification Exams

  • Introduction to Oracle SQL (Exam code- IZ0-007)
  • Oracle SQL Fundamental (Exam code- IZ0-051)

Unit 6 -Placement Assistance

  • Preparation of the best resume
  • Prepare for an Interview
  • Most likely questions in interviews
  • How to find a right job to match your skills
  • How to get your resume short listed by HR
  • Powerful resume searching techniques

Hiring Companies

  • Persistent
  • Amdocs
  • IBM
  • Data Vision
  • Vodafone
  • Cognizant
  • TCS