Dive into a comprehensive conference talk on creating exceptional spreadsheet models in this Business Analytics Marathon session. Learn essential techniques for layout design, development memory, naming conventions, and model organization. Explore strategies to enhance readability, utilize named ranges, and identify spreadsheet errors. Discover the impact of volatile functions and best practices for data visualization, including the effective use of sparklines and dashboards. Gain insights into solving organizational problems with creative solutions and understand the importance of cost-benefit analysis in complex data scenarios. Master the art of crafting outstanding spreadsheet models to elevate your business analytics skills.
Overview
Syllabus
Introduction
Layout Design
Development Memory
Design Layout
Naming Conventions
Naming Convention Example
Model Layout
Why does this matter
Clean and organized layout
Bloat
Technology
Layout
Mechanics
Design for readability
Named ranges
Root out spreadsheet errors
What to do with spreadsheet errors
Volatile functions
Data visualization presentation
Pie charts
Data occlusion
Show relevant data
Sparklines
Dashboard
Data Visualization Principles
Organizational Problem
Canned Solution
Creative Solution
Avoid 3D Pie Charts
I Wish More People Would Say This
Understanding Complex Data
CostBenefit Analysis
Taught by
PASS Data Community Summit
