Sheets as a Business Intelligence platform

Data Visualization in Google Sheets

Raina Hawley

Owner/Instructor of OzGrid Business Applications

Why use Google Sheets?

 

Data Visualization in Google Sheets

How does Business Intelligence help us?

Business Intelligence

  • Decision-making
  • Measuring goals
  • Operational efficiency
  • Optimizing processes
  • Pinpointing opportunities

What data?

  • Sales
  • Profits
  • Target Customers
  • Market opportunities
  • Competitors
  • Costs
  • More
Data Visualization in Google Sheets

What message are you trying to convey?

  • What information?
  • Who is your audience?
  • How are they viewing it?

Data Visualization in Google Sheets

What else matters?

  • Logos
  • Scenarios
  • Colors
  • Do you want to use 3D objects?
  • How much detail is too much?
  • What charts do you want?

Data Visualization in Google Sheets

What functions does a dashboard use?

Data Visualization in Google Sheets

Different types of charts

Data Visualization in Google Sheets

Let's practice!

Data Visualization in Google Sheets

Preparing Video For Download...