Chapter 1: Business Need On Bi
Chapter 1: Business Need On Bi
Chapter 1: Business Need On Bi
✓ Behaviour Analytics
✓ Marketing Analytics
Sales
Finance Inventory
Retail
Store
Supply
People
Chain
Industries
SALES
MARKE
BI is required
AGRICULTURE OIL AND GAS
• Earlier, only Sales & Purchases data was available and analysed / reported.
• Raw data needs integration, design, modeling, architecting, and other work before it can be
transformed into consumable information.
• Enterprises still need leaders and decision-makers with intuition, they depend on data to
validate their intuitions.
• Organizations want to do all sorts of analytics -> advanced, predictive, diagnostics etc
• Handling, processing this data needs new generation tools and technologies.
www.CartoonStock.com.
Definition
Processing
Data
Data
• Architecting a BI portfolio
Data:
Not u
into in
Inform
decisi
What is a database?
Database
Data Collection
Store
Store Stor
Store
• ERP
• CRM
Oracle
• Exce
• Inho
SQL Server
Data Sources
INTERNAL
Within organizations, managed by the organization. Outside o
Faceboo
Primavera, Excel, SAP, HR systems, IoT system
Data Sources Storage
ON PREMISE
Within organizational Premise. Managed by On
Organization
Data Sources Category
INTERNAL
On Premise Cloud On
What is the Cloud?
Raw Data.
Can you dir
What is data preparation?
Once th
fast, eas
deliciou
multiple
Don’t fee
Data Preparation is the key step
• Raw data has all forms of issues – errors, missing values, inconsistencies, not in
• Convert raw data into useable format using tools and software
Month Budget
2
Table 1
2
Month Budget Cost
Join 1
Month Cost
Table 2
Preparing Data: Data in Two Databases
2
Month Budget Cost
Join 1
2
Table 1
Excel Month Budget Cost 2
Month Cost
Table 2
Microsoft SQL Server
Preparing Data: Data in Two Tables
Inconsistency
Jan-20 M1 10 12 2 Ja
Jan-20 M2 20 15 -5 Ja
January 20 M3 30 14 -16 Ja
Feb-20 M2 12 15 3 F
Feb-20 M4 14 20 6 F
Feb-20 M1 15 22 7 F
Cost 18 6 6 5
When Data is Ready (Prepared)
• All modern analytics tools and software have inbuilt data preparation
• Example:
Download Link:
https://www.microsoft.com/en-
us/download/details.aspx?id=54920
• Access Database Engine set up file downloaded –> 2016 & 2010