Click Here For More Information
Description: This intensive 3-day boot camp is designed to turbocharge your Tableau skills and take your analytical ability and the insights you provide to the next level. This assumes you’re already very familiar with the Tableau interface and want to go beyond bar charts and learn a variety of advanced charts, when to use them and how they help you be a better data analyst. This course will also teach you how to turn your formatting into magazine-quality infographics, as well as quantify impacts.
Duration: 3 days
Objectives
• How to ask the right questions
• Learn the Ninja Analyst Framework
• Investigate relationships in data through correlation and outlier analysis
• Learn advanced charts and techniques
• Quantify Insights and Impacts of Recommendations
Course Outline
Calculations and Interactivity (Day 1)
What keeps the CEO up at night?
How to ask the right questions
Where to find answers to these questions
What makes a visualization effective?
The Ninja Analyst Framework
Advanced Time Series Analytics
- Line Chart with Avg. Lines
- Cycle Plots
- Line Chart with Year over Year Growth
- Line Chart with Percent Change and Difference
- Line Chart with Trend Line
- Running Total Charts
- Line Chart with Future Projection via Regression
- Forecasting
- How to use them and when
- How to interpret them
- How to adjust them
- Regression forecasting
- Moving Average forecasting
- Seasonal forecasting
Advanced Calculations
- Logic & Date calculations
Level of Detail calculations
Correlation Analytics and Relationships (Day 2)
Distributions
- Percent of Total and Double Labels
- Bar Chart with Max Color Calc
- Seeing What’s Changed Beyond the Top 10
- Adding Ranks as a Dimension
- Highlight Tables
- Histograms
- Pareto Charts
Correlation Analytics and Relationships Between Data
- Scatter Plots
- Jitter Plots
- Quadrant Charts
- Actual vs. Budget or Actual vs. Target Bullet graphics
- Ratios
- “Relative To” Charts
- Linear Regression
How to create them
How to interpret them
When to use them
- Simple Multiple Linear Regression
- Understanding and testing for Statistical Significance with the Student’s T-test or Chi Square
Outlier Analysis
- Averages
- What’s changed and by how much and how big is the impact
- Standard Deviations
- Control Charts
- 95th Percentile
- Box Plots
- Sets
- Clustering
- When to use
- How to interpret
- How to adjust
Advanced Charts and Techniques (Day 3)
KPIs and BANS
- Reference Line Comparisons
- KPI Indicators with YTD vs. Prev YTD (or similar types of time periods)
Advanced Geographic Analysis
- Filled Map
- Symbol Map
- Dual Axis Map
- Custom maps
- Custom territories or regions
- Mapbox
- Background maps
Other Advanced Charts
- Barbell Charts
- Funnel Charts
- Marginal Histograms
- Small Multiples
Advanced Dashboards
- Layouts
- Formatting
- Fonts
- Colors
- Key Insights
- Providing Recommendations
- Storypoints
Using these skills to advance your career and get promoted
Materials
All students will receive slides with lecture material and data and labs.
Software Needed on Each Student PC
• Microsoft Excel 2010 or later (2013 or later recommended)
• Internet access
Related data and lab files will be provided