Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Business Analytics at ....

No description
by

on 9 January 2014

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Business Analytics at ....

The Data Warehouse
Functions, Components, Examples
Business Analytics Portal
Functions and Examples
Causes and Effects of Poor Data Quality
Business Analytics at the ....


Intro
ETL
Staging area & Operational data stores
The Data Warehouse
Business Analytics portal
Poor data quality
Tips & Techniques
Summary

Outline
Organization's Dimensions
Metadata Repository
Star Schema
Sales figures,
Revenue figures,
Cost figures
Surrounded by dimensions
The key question for analysts:
What really happened?
Why did things turn out
as they did?
What

happened?
Where?

When?
Who

was involved?
Why a Data Warehouse?
Business Area
Department
Individual Employee
Improve
"slice and dice"
technique
Objective is to give the organization a common information platform, which ensures consistent, integrated, and valid data across source systems and business areas

Essential to obtain the most complete picture possible of its customers

To gather info: join info from more independent systems to generate a 360-degree profile of customer
What is Metadata?
Data about Data
Examples:
Digital Photo
Tsutaya
Apple's iTunes
Date Taken
Resolution
Size
Color Balance
XML Files
Tracks
Albums
Artists
Genres
Date Published
Language
Producer
Data Warehouse
Technical
Datamart
designed to contained much more specific and detailed date to answer business users’ specific questions
Business
OLAB Cube
Online Analytical Processing Cube
ensures that organization’s data is collected from it source system, and stored, combined, structured and cleansed regardless of the source system platform
To arrange data in an area in order to facilate a quick data analysis
ensures that desired key figures and reports can be created
BA tools and portals aim to deliver information to operational decision makers
BA Front-ends and dashboards example

SAS
information
delivery portal
From the portal we can know what action should we do and take in the future.
Provides forecasts of demand for services so that organizations can maximize staff resources
Identify market basket profiles
Classify documents into predefined or data driven categories, find explicit relationships or associations between documents, and incorporate textual data with structured input.
Architecture and Processes
ETL
Tips and Techniques in
Data Warehousing
Master Data Management
Extract
data from a source table

Transform
data for business use
Load to
target table in the data warehouse or different locations outside
Service-Oriented Architecture
Users of Data Warehouse
The complexity of the business increases
The data volumes explode
MDM as an intelligent way of consolidating and managing data
Provides unified view of data when data is integrated from different data sources
Master data as a reference file
Identical definitions will rise across business areas, national borders and/or merging companies
Feed information back to the application with accuracy and consistency
MDM
Example:
explanation
how to use organization's resources based on a service approach
objective
providing a more efficient achievement of overall business targets
A service is a program with which the user can interact through well-defined standards for the exchange of messages
Data quality
result of how complete data is
Correct data (customer contact data for CRM) is essential for positive return on investment


Installation of quality firewall
ensure
quality
when data is loaded from the staging area to the actual data warehouse
ensures external poor data quality doesn’t destroy or reduce internal data quality
keeps poor quality data out of internal processes and applications
There are 2 types direct users of a data warehouse
The business user
The BA analyst
Poor quality
makes analysis for business needs
costly, cause break downs to organization’s value chains ( no items in stock)
Leads to impaired decision making at management and operational levels
Substandard customer service = dissatisfaction and cancellation of business
Lack of trust in reporting which will delay budgeting processes
affects the organization’s competitiveness negatively
end user
Reasons for user approaches BA Analyst
Enrichment and interpretation of an information to do business
Doesn't have access for a data
Looking for more information
Data Improvement
1. Develop tools for data profiling
advanced software
algorithm

2. Data Cleansing
correcting errors
securing accuracy
increase reliability
"Fuzzy"
frequently used technology
removes duplicated rows, rows without customer names
corrects data with incorrect postal codes
adjusts phone numbers to desired format
How you doing?
position
credit
property evaluation
C
Complete profile
level
Data
Warehouse
Thank you for listening !!!
lalallallalalalal
Finance
Sales
HR
Business Activity
SAS (pronounced "sass") once stood for "statistical analysis system"
Full transcript