Transcript What is Business Intelligence?

Techniques for Decision-Making:
Data Visualization
Sam Affolter
• Introductions
• Class Overview, Structure, and Expectations
• Pre-Test
• What is BI and Data Visualization
• Class Exercise
• Examples of DV
• Discussion of Class Project
Sam Affolter www.linkedin.com/pub/samuel-affolter/a/198/991/
Over 8 years in analytics roles
5 years training, mentoring, and teaching
Built dashboards, created new metrics, and
presented to all levels of business
Retail
Business Analysis (Manager)
Insurance
Marketing Analysis (Manager)
Product Analysis
Risk Analysis
Finance
Project Management
Education
Project Management Program
Masters Degree
Bachelors Degree
Duration
1.5
1.5
5.75
1.75
3
1
1.5
1.5
8
1
2
5
Data visualization is the most interesting of the 3 Business Intelligence topics because of our ability to quickly and
effectively see patterns within data and thereby communicate “Ah ha!” moments to non-analysts.
• Name
• What do you do currently?
• What attracted you to the Techniques for Decision
Making course?
• What was your worst job experience?
BI Overview
Tables
• Business Intelligence
• Data Visualization
• Types of tables.
• When to use tables and best practices.
Diagrams
• Diagrams’ place in Data Visualization (when and why)
• Types of diagrams
Graphing
• Best practices in graph design.
• Types of graphs and their uses.
Tools for
Visualization
• Excel and Tableau
• Power View and discussion of other tools.
• Classes will consist of lecture time, multimedia
exhibits, and class exercises.
• Participation is expected. The more interactive the
lectures time is, the better for everyone.
• Exercises will be discussed in breakout groups with
each group discussing examples with the rest of the
class.
• This is will not affect your grade!
• The test touches many of the topics we will be
covering in this class.
• Two principle reasons for this test:
– To give you an impression of some of the things covered.
– To help me understand where the class is and how to pace
course materials.
• A set of tools that allow individuals to transform raw
data into meaningful and useful information for
business purposes.
• Traditionally focused on the use of a consistent set of
metrics to measure and guide the business.
• Closely aligned with Business Analytics
• 3 main divisions of Business Intelligence and
Business Analytics
– Data Mining (sorting through large amounts of data to
retrieve relevant data)
– Data Analysis (studying data to extract useful information
and develop conclusions)
– Data Visualization (creation and study of visual
representations of data to inform and communicate)
• Analysis
– Using visualizations to gain insight.
• Communication
– Passing a message to others.
• Monitoring
– Tracking information about performance.
• Planning
– Predicting and preparing for the future.
Job Satisfaction By Income, Education, and Age
College Degree
Income
Under 50
No College Degree
50 & Over Under 50
50 & Over
Up to $50,000
643
793
590
724
Over $50,000
735
928
863
662
Employee Job Satisfaction
1000
950
900
Job Satisfaction
850
800
College Degree, Up to $50,000
College Degree, Over $50,000
750
No College Degree, Up to $50,000
700
No College Degree, Over $50,000
650
600
550
500
Under 50
50 & Over
Employee Job Satisfaction
1000
950
900
Job Satisfaction
850
800
College Degree, Up to $50,000
College Degree, Over $50,000
750
No College Degree, Up to $50,000
700
No College Degree, Over $50,000
650
600
550
500
Under 50
50 & Over
Sales in Test Markets Versus Control
$130,000
$125,000
$120,000
$115,000
Revenue
$110,000
Test Group Lift Over Control
$105,000
Control Group
$100,000
 Test markets launched
$95,000
$90,000
$85,000
$80,000
Feb-13
Mar-13
Apr-13
May-13
Jun-13
Jul-13
Aug-13
Sep-13
Oct-13
Projected and Actual Revenues 2013-2014
$130,000
$125,000
$120,000
$115,000
$110,000
$105,000
2013 Actual Revenue
2014 Projected Rev
$100,000
2014 Actual Rev
$95,000
$90,000
Jan-14
Feb-14
Mar-14
2014 Projected Rev
$125,387
$126,811
$130,775
2014 Actual Rev
$112,848
Net to Plan
$(12,539)
2013 Actual Revenue
Jan-13
$95,000
Feb-13
$100,000
Mar-13
$99,000
Apr-13
$99,000
May-13
$106,920
Jun-13
$114,404
Jul-13
$110,972
Aug-13
$119,850
Sep-13
$117,453
Oct-13
$111,580
Nov-13
$120,507
Dec-13
$119,631
Infographics typically fall
into the category of
information design rather
than data visualization.
• Think about two examples of data visualization used
in either your current or past workplace.
• Which of the purposes did it serve?
• Are there things you can think of that would have
made it serve that purpose better?
• Share in groups.