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.
What you will learn in Business Intelligence?
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 in Business Intelligence
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 Intelligence
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
Upcoming Batches Schedule
14th Dec 2020 | Regular | 7.30 am To 9.30 am |
19th Dec 2020 | Weekend | 10.30 am To 02.30 pm |
21st Dec 2020 | Regular | 7.30 am To 9.30 am |
26th Dec 2020 | Weekend | 10.30 am To 02.30pm |
Contact – Call us at 9372005897/ 8956930899 or fill out this form, and we will be happy to contact you back.
Will See you soon in center, Happy Learning!!!
Mr. Gaurav Pagar – i joined Oracle Data Warehousing Development training at sadashiv peth, wanted to mentioned here that our faculty is very good,providing good support.having a wonderful experience, having a wonderful lab set up feeling happy.