What is Business Intelligence ?
A Brief history of Business Intelligence
What is Business Intelligence ?
Where have we been ?
What is Business Intelligence ?
Where are we now ?
What is Business Intelligence ?
Where are we going ?
What is Business Intelligence ?
Why Should we care ?
According to Wikipedia
What is Business Intelligence ?
Business intelligence (BI) mainly refers to computerbased techniques used in identifying, extracting,and analyzing business data, such as sales revenue by products and/or departments, or by associated costs and incomes. BI technologies provide historical, current and predictive views of business operations.
What is Business Intelligence ?
But that BI is still hard to understand ? Is what that what it took to make business intelligent ?
What is Business Intelligence ?
What is Intelligence ?
What is Business Intelligence ?
Knowledge and Understanding
What is Business Intelligence ?
Meaning and Context
What is Business Intelligence ?
Foresight
What is Business Intelligence ?
Solve complex problems
What is Business Intelligence ?
To make decisions.
What is Business Intelligence ?
We make decision every time ?
What is Business Intelligence ?
Sometime good.
What is Business Intelligence ?
Sometimes bad
What is Business Intelligence ?
Intelligence = Decision
What is Business Intelligence ?
Decision = People
Because people make decisions
What is Business Intelligence ?
What make good decision ? Valuable information.
What is Business Intelligence ?
Intelligence + Information = Good Decision
What is Business Intelligence ?
Information provide answers
What is Business Intelligence ?
Information is distributed in various places.
What is Business Intelligence ?
You need to aggregate Information from various sources.
What is Business Intelligence ?
Solution is Informatica.
What is Business Intelligence ?
Decisions are made by Information Analysis.
What is Business Intelligence ?
But BI is about usability as business people don't have time and they need time line based analysisss
What is Business Intelligence ?
To turn data
What is Business Intelligence ?
Into right format
What is Business Intelligence ?
What you need is Business Objects.
ShopAll Case Study ( Return Module )
What is BI
1. Shyam owns a shop. 2. His shop has 3 floors. 3. Jam and bread are on same floor adjacent to each other. 4. Butter is on different floor.
What is BI
5. He gives all his sales data to the abc organization. Sales Data Raw Information
What is BI
6. abc organization observed that 25% of the people who bought bread also bought jam. 7. But 50% of the people who bought bread also bought butter.
What is BI
8. Prediction can be made that bread and butter combination is more likely purchased compared to the bread and jam combination. He then exchanged the butter with the jam location.
What is BI
9. This is called Business Intelligence. 10. And the outcome is Happy Customers and Better revenues.
What is BI
1. BI technologies provide historical, current and predictive views of business operations. 2. Common functions of BI technologies are reporting, online analytical processing, analytics, data mining, process mining, complex event processing, business performance management, benchmarking, text mining and predictive analytics .
What is BI
3. BI help in the following processes : 3.1. Decision support system 3.2. Future trends analysis 3.3. Bussiness patterns Etc. s
ETL Process
1. ETL stands for Extraction Transformation Loading.
ETL
1. Data is taken from different sources, lets say US and UK. 2. In US database the shoe size is in mm size, In UK database it is in cm size. 3. We need both of them in common format, so that we can use it for future preditions.
Extraction
UK(mm) ----> US(cm) ---->
Source ---> Intermediate State
Transformation
Source UK(mm) ----> ----> Common format(mm) Source US(cm) ---->
Loading
Common format(mm)
Data Warehouse (OLAP)
ShopAll Scenario
Populating Data Warehouse
ShopAll Example
Tools for ETL
Informatica
Preserving history for trends analysis
1. Methods : 1.1. 1.2. 1.3. 1.3. Slowly Changing Dimensions 0 Slowly Changing Dimensions 1 Slowly Changing Dimensions 2 Slowly Changing Dimensions 3
Slowly Changing Dimensions 0
The Type 0 method is a passive approach to managing dimension value changes, in which no action is taken. Values remain as they were at the time of the dimension record was first entered.
Slowly Changing Dimensions 0
Slowly Changing Dimensions 1
The Type 1 methodology overwrites old data with new data, and therefore does not track historical data at all. This is most appropriate when correcting certain types of data errors, such as the spelling of a name.
Slowly Changing Dimensions 1
Slowly Changing Dimensions 2
The Type 2 method tracks historical data by creating multiple records for a given natural key in the dimensional tables with separate surrogate key and/or different version numbers. With Type 2, we have unlimited history preservation as a new record is inserted each time a change is made.
Slowly Changing Dimensions 2
Slowly Changing Dimensions 3
The Type 3 method tracks changes using separate columns. Whereas Type 2 had unlimited history preservation, Type 3 has limited history preservation, as it's limited to the number of columns designated for storing historical data.
Slowly Changing Dimensions 3
Benefits of Informatica
Data Migration Legacy Retirement Data Synchronization Data Replication Data Consolidation Test Data Management Data Archiving Complex Event Processing B2B Data Exchange Master Data Management Identity Resolution Cloud Data Integration Data Warehousing Data Quality
ShopAll Scenario
1. ETL process for populating following tables : 1.1. Loading product table using lookup. 1.2. Loading product table using joins. 1.3. Return fact table loading using one to one mapping. 1.4. Return fact table loading using heterogeneous source.
Loading product table using lookups
Loading product table using joins
1.
Loading using one to one mapping
Loading using heterogeneous source
Test Cases
Example :
Bug Solved
Example :
Reports Generation
Analyzing
Business Objects
Analyzing
Reports Generation
Analyzing
Reports Analyzed
Deductions
Test Cases
Solutions
Problem Faced
Solutions
Problem Faced
Deductions
Problem Faced
Deductions
Lesson Learnt
Deductions
Misc
Deductions
Suggestions and Questions
1.
Thank You
1.
