Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
The Architecture of Data & Excel Preparation
Topic 1: The Principles of Captivating Visualization
- The Data-Ink Ratio: Optimizing the data-to-ink ratio to minimize visual clutter and enhance clarity.
- The Communication Loop: Aligning information needs with available data resources.
- The Audience Analysis Matrix: Customizing visuals for executive summaries versus operational teams, ensuring appropriate levels of detail.
- Workshop: Analyzing a "Bad vs. Good" report to identify the elements that make the latter more effective and relevant for government use.
Preparing Datasets for Visualization
- Data Hygiene: Ensuring data is clean, well-formatted, and structured for optimal visualization in tools designed for government applications.
- Identifying Value: Filtering out noise to isolate key performance indicators (KPIs) that are essential for informed decision-making.
- Excel Prep: Utilizing Power Query (Get & Transform) to clean and prepare raw data for visualization, a critical step for government analysts.
- Lab 1: Participants will take a raw, messy CSV dataset and prepare it for visualization using Excel Power Query, simulating real-world scenarios for government data management.
Excel Visualization: Beyond the Basics
- Conditional Formatting as Data Viz: Leveraging heat maps, icon sets, and data bars to enhance data presentation in government reports.
- Sparklines & Slicers: Embedding mini-charts and interactive filters in Excel to provide dynamic insights for government stakeholders.
- The "Forbidden" Charts: Understanding why pie charts, 3D charts, and double-axis confusion should be avoided in professional government reporting.
- Lab 2: Participants will build a clean, high-impact Excel dashboard using the dataset prepared in Lab 1, emphasizing clarity and impact for government use.
Writing the Report Narrative (Part 1)
- Headline-Driven Reporting: Crafting titles that summarize key insights rather than just presenting data, ensuring relevance for government audiences.
- Annotation Strategy: Using text boxes, arrows, and highlighting to guide readers through complex information in government reports.
- The "So What?" Factor: Ensuring every chart answers a critical business question and provides actionable insights for government decision-makers.
Design Psychology & Advanced Chart Types
Selecting the Best Chart Types
- Comparison Charts: Utilizing diverging bars, dot plots, and bullet graphs to effectively compare data points in government reports.
- Distribution Charts: Employing histograms, box plots, and violin plots to illustrate data distribution for government analysis.
- Relationship Charts: Using scatter plots with bubble sizing and regression lines to explore relationships between variables in government datasets.
- Part-to-Whole: Replacing pie charts with treemaps and Marimekko charts to provide a clearer view of part-to-whole relationships in government data.
Layouts for Specific Data Types
- Time Series: Implementing line charts, area charts, and handling multiple series without clutter to effectively represent temporal data in government reports.
- Geographic Patterns: Creating choropleth maps, heatmaps, and ensuring accurate geocoding of data to support geographic analysis for government use.
- Nested Data: Using waffle charts, pyramid charts, and hierarchical lists to present nested data structures in a clear and organized manner for government audiences.
- Lab 3: Participants will create three distinct visuals (Time series, Map, and Part-to-Whole) using Excel and/or a containerized R tool, focusing on practical applications for government reporting.
Design Psychology & Color Coding
- Color Theory: Applying color for categorization, magnitude, and highlighting to enhance data visualization in government reports.
- Accessibility: Designing visuals that are accessible to individuals with color blindness and ensuring readability in grayscale, a critical consideration for government communications.
- Text-Based Visualization: Using typography and iconography to visualize sentiment analysis, timelines, and calendars, providing additional depth to government data presentations.
- GIFs & Infographics: Best practices for converting static data into animated or static infographics, enhancing the impact of government reports.
Interactive Tools & Assembling the Final Report
Intro to Interactive Visualization (Containerized Tools)
- Tableau vs. R (Shiny/RMarkdown): Evaluating when to use each tool for static versus interactive reports in government settings.
- Connecting to Data: Linking visualization tools to prepared datasets, a crucial step for effective data presentation in government applications.
- Basic Interactivity: Creating filters, dropdowns, and dynamic tooltips to enhance user engagement with government data.
- Lab 4: Participants will replicate the Excel dashboard from Day 1 in Tableau or R (simplified), understanding the workflow differences and their implications for government reporting.
Assembling the Report (Part 2)
- The Grid System: Applying alignment, white space, and hierarchy principles to create well-organized dashboards for government use.
- File Formats: Exporting reports as high-resolution PNGs, PDFs for print, or interactive HTML/Excel files, ensuring compatibility with various government systems.
- Reference Management: Properly citing sources within the visual (footnotes, legends, tooltips) to maintain transparency and accountability in government reporting.
- Case Study Analysis: Reviewing real-world examples of "Captivating Reports" in Finance, Marketing, and Healthcare, providing insights applicable to government operations.
Final Capstone Project & Review
- The Project: Participants will be given a new dataset and an audience persona. They must prepare the data, design the layout, and assemble a 1-page "Captivating Report" suitable for government use.
- Peer Review: Conducting group critiques to focus on clarity, design, and insight, ensuring that reports meet the high standards required for government communication.
- Closing Remarks: Providing resources for ongoing learning and a checklist for future reporting workflows, supporting continuous improvement in government data visualization practices.
Requirements
- Familiarity with Excel, including Pivot Tables and basic VLOOKUP/XLOOKUP functions, is beneficial.
- No previous coding or advanced design experience is required.
Audience:
- Data Analysts, Business Managers, Strategic Planners for government.
21 Hours
Testimonials (1)
workshops, practical examples
