Data visualization and dashboarding (Looker, Tableau, Metabase)
The systematic practice of transforming raw data into interactive, actionable visual narratives using specialized software to inform business decisions.
This skill bridges the gap between technical data teams and business stakeholders, enabling faster, evidence-based decision-making. It directly impacts business outcomes by surfacing operational efficiencies, customer trends, and financial performance in an immediately understandable format.
1Careers
1Categories
8.5 Avg Demand
20%
Avg AI Risk
How to Learn Data visualization and dashboarding (Looker, Tableau, Metabase)
Focus on foundational data literacy: understanding data types, basic chart selection logic (when to use a bar chart vs. a line chart), and the core interface of one platform (start with Tableau Public or Metabase's open-source edition). Learn the principles of effective dashboard design: clarity, context, and reducing cognitive load.
Move to practical application by connecting live data sources (SQL databases, Google Sheets, APIs) and building multi-chart dashboards that answer specific business questions. Master intermediate functions like calculated fields, parameters, level-of-detail expressions (in Tableau), and LookML dimensions/measures (in Looker). Common mistake: prioritizing flashy visuals over actionable insight.
Mastery involves architecting scalable analytics ecosystems. This includes designing governed data models (e.g., Looker's LookML projects), implementing performance optimization for large datasets, establishing dashboard governance and access controls, and mentoring teams on data storytelling. Strategic alignment means ensuring every dashboard ties directly to a key business process or KPI.
Practice Projects
Beginner
Project
Build a Sales Performance Dashboard
Scenario
You are a junior analyst tasked with creating a weekly report for the sales manager showing revenue, units sold, and top-performing products.
How to Execute
1. Source a clean dataset (e.g., Kaggle's Sample Superstore data). 2. In Tableau or Metabase, connect to the data and define three key metrics. 3. Design a single-page dashboard with a revenue trend line, a bar chart for sales by product category, and a geographical map. 4. Add basic filters for time period and region.
Intermediate
Project
Develop a Customer Cohort Analysis Dashboard
Scenario
The product team needs to understand user retention and lifetime value (LTV) for different user sign-up cohorts.
How to Execute
1. Write SQL to join user activity and transaction tables, creating a cohort by sign-up month. 2. In Looker or Tableau, create calculated fields for retention rate (e.g., % of cohort active in month N) and cumulative LTV. 3. Build a dashboard with a cohort heatmap showing retention decay over time and a line chart tracking LTV growth per cohort. 4. Implement parameters to allow dynamic cohort comparison.
Advanced
Project
Architect a Real-Time Executive KPI Platform
Scenario
The C-suite requires a single, authoritative source for enterprise-level metrics (ARR, Burn Rate, Customer Health Score) updated in near real-time, with strict governance and role-based access.
How to Execute
1. Design a semantic layer in LookML (Looker) that defines all core KPIs, ensuring a single source of truth and complex business logic. 2. Implement a streaming data pipeline (e.g., using Kafka or Pub/Sub) into your data warehouse. 3. Build the dashboard in Looker, incorporating performance best practices like aggregate awareness and persistent derived tables. 4. Establish a governance model: document data definitions, set up user access controls via SAML/SSO, and create a formal change management process for dashboard updates.
Tableau excels in ad-hoc, visual exploration. Looker, with its modeling layer (LookML), is superior for governed, scalable analytics embedded in workflows. Metabase is ideal for fast, lightweight, self-service analytics for technical teams, especially in startups.
Design & Communication Frameworks
The 'Five-Second Test' (dashboard readability)Stephen Few's Data Visualization PrinciplesThe 'What? So What? Now What?' Storytelling Framework
The Five-Second Test ensures a dashboard communicates its core message instantly. Few's principles prevent chart junk and misleading representations. The storytelling framework structures how you present insights to drive action.
Interview Questions
Answer Strategy
The interviewer is testing your process orientation and business acumen. Use the 'Design Thinking' framework: 1) Empathize & Define: Start by asking clarifying questions about the user's goals, key decisions, and current pain points. 2) Ideate: Propose 3-5 core metrics (e.g., Cost per Acquisition, Channel ROAS, Funnel Conversion Rates). 3) Prototype: Describe your layout-top-level KPIs, trend lines, channel breakdown table, and a filter for campaign/date. 4) Test: Mention you'd validate with the stakeholder before building final data pipelines.
Answer Strategy
This behavioral question tests your influence and storytelling. Structure your answer using STAR: Situation (A debate about expanding into a new market), Task (Create a dashboard to provide objective data), Action (Built a geospatial dashboard showing customer density vs. proposed market saturation, overlaid with logistics cost contours), Result (The visual proof led to a revised, phased expansion plan, saving $2M in potential sunk costs).
Careers That Require Data visualization and dashboarding (Looker, Tableau, Metabase)