Send the link below via email or IMCopy
Present to your audienceStart 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.
Make your likes visible on Facebook?
You can change this under Settings & Account at any time.
Business Analytics at ....
Transcript of Business Analytics at ....
Functions, Components, Examples
Business Analytics Portal
Functions and Examples
Causes and Effects of Poor Data Quality
Business Analytics at the ....
Staging area & Operational data stores
The Data Warehouse
Business Analytics portal
Poor data quality
Tips & Techniques
Surrounded by dimensions
The key question for analysts:
What really happened?
Why did things turn out
as they did?
Why a Data Warehouse?
"slice and dice"
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
designed to contained much more specific and detailed date to answer business users’ specific questions
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
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
Tips and Techniques in
Master Data Management
data from a source table
data for business use
target table in the data warehouse or different locations outside
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
how to use organization's resources based on a service approach
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
result of how complete data is
Correct data (customer contact data for CRM) is essential for positive return on investment
Installation of quality firewall
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
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
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
1. Develop tools for data profiling
2. Data Cleansing
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?
Thank you for listening !!!
SAS (pronounced "sass") once stood for "statistical analysis system"