itsmecevi/bi-visual-analytics

BI-Visual-Analytics

🤟 Cevi Herdian -> itsmecevi.github.io

📊 About Tableau Software -> Click Here

📉 Technical Spesifications-> Click Here

1-Business Intelligence 101

• Click Here: Hands-On Tableau BI
• Click Here: 2019 Business Intelligence Trends

2-The Power of Data Visualization

• Hans Rosling

• Gapminder

• Goals :

  • Data Exploration — find the unknown (trends, outliers, patterns)
  • Data Analysis — check hypotheses
  • Presentation — communicate and disseminate (share function->infographic)

• The Five-Step Model :

Picture link: https://bit.ly/3byKYeD

• Visual References
• Rules of Thumb : Edward Tufte Rules

3-Decision Support System (DSS)

• Click Here: DSS
• Demo : World_Bank_CO2-> CO2 Data Cleaned Sheet
  • Excel vs Tableau
  • Machine Learning Clustering in Tableau

4-Tableau Desktop 101

• Click Here: SWOT Analysis
• Tableau GUI Demo
• Tableau + SQL (Google BigQUery)

5-Connecting to data

• Live connection :

  • When you have a fast database
  • When you need up-to-the minute data (real-time)

• Extract connection (in memory) :

  • When your database is too slow for interactive analytics
  • When you need to take load off a transactional database (size of the data)
  • When you need to be offline (without internet connections)

---

• Excel : World_Bank_CO2.xlsx
• CSV : FL_insurance_sample.csv
• PDF : amazn_stock.pdf

6-Data Preparation

• Data connections :

  • Union (vertical connection) : amazn_stock.pdf
  • Joins / Blend / Inner Join (horizontal connection) :
  • Left Join, Right Join, Full Outer Join

• Data Interpreter & Data Pivoting : CO2 API

• Splitting : CO2 API Version-Indicator Name

• Manage data properties :

  • Rename a data field:
  • Assign an alias to a data value
  • Assign a geographic role to a data field
  • Change data type for a data field (number, date, string, boolean, etc.)

7-Understanding Tableau Concepts

Data: Sample-Superstore

• Show Me Tool Bar

• Dimensions and measures

• Column & Rows Shelf

• Marks Cards

• Discrete and Continuous Fields :

  • Blue color: discret, qualitative data (string, geographics, date, date & time, boolean). If added qualitative data, then they are separate the graphs.
  • Green color: continuous, quantitative data, number, aggregation (sum, avg, etc).-> If added quantitative data, then they aren’t separate the graphs.

• “Aggregation / Calculation”

• Sheet

• Dashboard (Filter, Actions Highlight, & Formatting)

• Story

Hands-On Sample-Superstore

8-Tableau Use Case

Hands-On Sample-Superstore: Sample-Superstore

• By Industry
• By Department
• By Business Goal
• By Role Specific