Data analytics
Business Analytics
ERP and BI
BI Applications in CRM
BI Applications in Marketing
BI Applications in Logistics and production
Role of BI in Finance
BI Applications in Banking
BI Applications in Telecommunications
BI Applications in Fraud Detection
BI Applications in Retail Industry
• Analytics is discovering the useful patterns from data.
• Types of Analytics :
• Descriptive (What has happened?)
• Diagnostic (Why did it happen?)
• Predictive (What could happen?)
• Prescriptive (What should happen?)
• Business Intelligence Vs. Business Analytics
BI BA
The questions asked : The questions asked :
What Why did it happen?
When Will it happen again?
Who What if we change the
How many parameter X?
What it does it tell us?
Activities : Activities :
Reporting Data Mining
Automated Monitoring and Statistics
alerting Optimizations
Scorecards Text Mining
Dashboards Predictive analysis
Ad hoc reporting Forecasting
OLAP Qualitative Analysis
• Data analytics is an emerging technique that
dives into a data set without prior set of
hypotheses
• The data derive meaningful trends or
intriguing findings that were not previously
seen or empirically validated (Leventhal, 2010).
• Data analytics enables quick decisions or help
change policies due to trends observed
Contd..
• Accumulation of raw data captured from
various sources (i.e. discussion boards, emails,
exam logs, chat logs in e-learning systems) can
be used to identify fruitful patterns and
relationships (Bose, 2009)
– Exploratory visualization – uses exploratory data
analytics by capturing relationships that are
perhaps unknown or at least less formally
formulated
– Confirmatory visualization - theory-driven
Data Analytics Statistical Analysis
Utilizes data mining Utilizes statistical and/or
techniques mathematical techniques
Identifies inexplicable or Used based on theoretical
novel relationships/trends foundation
Seeks to visualize the data Seeks to identify a
to allow the observation significant level to address
of relationships/trends hypotheses or RQs
This PPT is prepared by
Yair Levy, Ph.D.
Graduate School of Computer
and Information Sciences
• KNIME (Konstanz Information Miner)
• Data Applied
• R - Programming
The use of analytical methods, either manually
or automatically, to derive relationships from
data
• Remember that we defined business analytics
(BA) to include the access, reporting, and
analysis of data supported by software to
drive business performance and decision
making
Prepared By
Matthew J.
Liberatore
Thomas Coghlan
• Boost Profitability
• Decrease warranty and service conduct contract
expenses
• Get new customers
• Maintain Existing Customers
• Up-Sell or Cross Sell of the Products
• Supervise the Supply Chain
• Progress in Operational Activities
• Decrease the response time to customer
complaints
• Boost Profitability
• Decrease warranty and service conduct contract
expenses
• Get new customers
• Maintain Existing Customers
• Up-Sell or Cross Sell of the Products
• Supervise the Supply Chain
• Progress in Operational Activities
• Decrease the response time to customer
complaints
•Data Preparation
•Data Visualization
•Data Discovery
•Action
• Mobile commerce & other IT makes ERP extensions
possible, attractive
– Broader use of web-enabled systems
– Greater AI-driven applications
– Greater use of ERP in mid-sized manufacturing
– Flexible modular systems
– More bolt-ons (3rd party applications)
• Creates security issue
• ERP interfaces to external applications difficult to program
• Middleware is an enabling engine to allow such external
applications eto ERP
– Data oriented products - shared data sources
– Messaging-oriented - direct data sharing
• CRM : Customer Relationship Management
• Customer Relationship Management very promising
– Has not reached all expectations as ERP add-on
• Quite expensive to get needed data storage capability
• Still an opportunity to use all the data generated by an
ERP
• Determine value of customer
• Identify what they want
– Package products (services) to keep them
• Maximize expected net present value of customer
• Categorize and focus on customers with High
Profitability
• Increase the Accuracy of Sales Forecast
• Measure the Effects of Marketing Programs
• Service Improvement
• Improve organizational support functions
• Provide IT based Services
• Predict changes in bond and stock prices
• Access the effect of events on market
movements
• Identify and prevent fraudulent activities in
trading
• Bankruptcy Prediction
• Automate the loan application process
• Detect the fraudulent transactions
• Maximize customer value (Cross Selling, Up
Selling)
• Optimize cash reserves with forecasting
• Historical Analysis can be done easily
• Churn Management
• Marketing and Product Creation
• Network Failure Management
• Fraud Management (Prediction of Cellular
Fraud)
• Optimize inventory levels at different locations
• Improve store layout and sales promotions
• Optimize logistics for seasonal effects
• Minimize losses due to limited shelf life