Omnichannel Retail Dashboards: Online + In-Store in One View

Understanding Omnichannel Retail Dashboards

Retail has fundamentally shifted. Your customers don't think in silos—they browse online, buy in-store, return items across channels, and expect seamless experiences regardless of where they engage with your brand. Yet most retailers still operate with fragmented data systems: separate dashboards for e-commerce, point-of-sale (POS) systems, inventory management, and customer service. This fragmentation creates blind spots, delays decision-making, and leaves money on the table.

An omnichannel retail dashboard consolidates data from online and physical channels into a single, unified view. It's not just a dashboard that displays data side-by-side; it's an integrated analytics layer that treats your business as one cohesive operation, regardless of where the transaction occurs. This means real-time visibility into inventory across all channels, customer behavior patterns that span online browsing and in-store purchases, and the ability to optimize pricing, promotions, and staffing based on holistic performance metrics.

The business case is compelling. According to McKinsey's research on omnichannel strategy, retailers who excel at omnichannel integration see higher customer lifetime value, improved inventory turnover, and better margins. But building this capability requires more than just connecting databases—it demands a thoughtful architecture, clean data pipelines, and analytics infrastructure that can handle the complexity of multi-channel operations at scale.

This guide walks you through the strategic and technical foundations of building omnichannel retail dashboards. We'll cover what data you need to capture, how to structure it, the key metrics that matter, and how to implement this using modern open-source analytics platforms like Apache Superset.

The Core Challenge: Data Fragmentation in Retail

Most retailers operate across multiple systems that were never designed to talk to each other. Your e-commerce platform (Shopify, WooCommerce, or a custom build) generates one stream of transaction and behavior data. Your POS system (Square, Toast, or an enterprise ERP) tracks in-store sales, inventory, and customer interactions. Your inventory management system maintains stock levels. Your customer relationship management (CRM) system holds customer profiles and communication history. Your payment processor records transactions. Your customer service platform logs returns and complaints.

Each system is optimized for its specific function, but they're isolated. When a customer buys online and returns in-store, that return data might not flow back to your e-commerce system. When inventory sells out online, your POS system doesn't automatically know to adjust pricing or promotion strategy. When a customer has a service issue, the support team can't see their full purchase history across channels.

This fragmentation creates operational friction and analytical blindness. You can't answer basic questions like: "What's our total revenue yesterday across all channels?" or "Which products are performing well online but struggling in-store?" or "How many customers are using multiple channels in their journey?" You're forced to manually stitch together reports from different systems, introduce delays, and risk errors.

Building an omnichannel dashboard solves this by creating a unified data layer. As Harvard Business Review discusses in their analysis of omnichannel retail tools, retailers that consolidate data see faster decision cycles and better alignment across merchandising, operations, and customer service teams.

Key Data Sources for Omnichannel Visibility

To build an effective omnichannel dashboard, you need to ingest data from multiple sources and normalize it into a common structure. Here's what you need:

E-Commerce Platform Data

Your online store generates rich behavioral and transactional data: product views, cart abandons, purchases, returns, customer demographics, traffic sources, and conversion funnels. This data typically includes timestamps, product IDs, customer IDs, order values, and device information. Modern e-commerce platforms expose this via APIs (REST or GraphQL) or provide data export capabilities. You'll want to capture:

• Transaction-level data: order ID, customer ID, product ID, quantity, price, discount, payment method, timestamp
• Customer behavior: sessions, page views, time on site, cart interactions, device type, traffic source
• Product catalog: SKU, category, price, inventory levels, images, descriptions
• Returns and refunds: return reason, refund amount, restocking status, timestamp

Point-of-Sale (POS) System Data

Your in-store operations generate transaction data through the POS system, but this data often includes richer context than e-commerce—employee ID, store location, payment method, tender type (cash, card, mobile), and sometimes customer loyalty program interactions. Critical fields include:

• Transaction details: transaction ID, store location, timestamp, items purchased, total amount, discounts applied
• Store context: store ID, region, employee ID (for staffing analysis), register ID
• Customer data: loyalty program ID (if available), customer phone or email
• Inventory impact: units sold by SKU, inventory adjustments, stockouts

Inventory Management System

Real-time inventory visibility is crucial for omnichannel optimization. Your inventory system should feed current stock levels for each SKU at each location, along with historical movement data. This enables you to identify:

• Stock-outs: which products are unavailable where, and when
• Slow-moving inventory: SKUs that aren't selling in certain channels or locations
• Overstock situations: where excess inventory needs clearance
• Allocation opportunities: where to move stock to maximize sales

Customer Data Platform (CDP) or CRM

Unifying customer identity across channels is essential. Your CRM or CDP should provide a single customer view with:

• Customer ID (unique identifier)
• Demographic data: age, location, preferred channel
• Purchase history: all transactions across channels, total spend, frequency
• Engagement data: email opens, website visits, in-store visits
• Loyalty program status: tier, points balance, redemptions

Customer Service and Returns Data

Support tickets, returns, and complaints reveal friction points and opportunities. Track:

• Return reason: defect, wrong size, changed mind, etc.
• Resolution: refund, exchange, store credit
• Channel: which channel the return originated from
• Resolution time: how quickly the issue was resolved
• Customer satisfaction: NPS, CSAT scores

Microsoft's Omnichannel for Customer Service documentation provides detailed guidance on structuring these insights dashboards for operational KPIs.

Designing the Data Architecture

Once you've identified your data sources, you need a cohesive architecture to ingest, transform, and serve this data to your analytics platform. Here's a proven pattern:

Extract, Transform, Load (ETL) Pipeline

Build a data pipeline that:

1. Extracts data from each source system (APIs, database replication, CSV exports)
2. Transforms it into a common schema (normalizing date formats, mapping customer IDs, calculating derived metrics)
3. Loads it into a centralized data warehouse (Snowflake, BigQuery, PostgreSQL, or similar)

This pipeline should run on a schedule (hourly, daily, or real-time depending on your needs). Tools like Fivetran, Stitch, or custom Python/SQL scripts can orchestrate this. The key is establishing a single source of truth for each data type.

Data Warehouse Schema

Organize your data warehouse using a dimensional model (star schema or snowflake schema) that separates facts (transactions) from dimensions (products, stores, customers, dates). A simplified structure might look like:

Fact Tables:

• transactions: one row per transaction (online or in-store) with order ID, customer ID, product ID, store ID, channel, amount, timestamp
• inventory_movements: one row per inventory change with store ID, product ID, quantity change, reason (sale, return, adjustment), timestamp
• customer_interactions: one row per customer engagement (website visit, support ticket, loyalty redemption) with customer ID, channel, interaction type, timestamp

Dimension Tables:

• customers: unique customer records with ID, email, phone, location, loyalty status, signup date
• products: unique SKUs with ID, name, category, price, supplier
• stores: physical locations with ID, name, address, region, store manager
• dates: calendar table with date, day of week, week number, month, quarter, year, is_holiday
• channels: online, in-store, mobile app, marketplace, etc.

This structure makes it easy to join data across sources and build consistent metrics.

Real-Time vs. Batch Considerations

Decide how fresh your data needs to be. E-commerce dashboards often require hourly or real-time updates to catch trends quickly. In-store data might be acceptable on a daily refresh if you're analyzing trends, but real-time inventory visibility might be critical. Design your pipeline accordingly—real-time data streams (using Kafka, Kinesis, or similar) are more complex but valuable for operational dashboards.

Building the Unified Dashboard in Apache Superset

Once your data is in a centralized warehouse, you can build your omnichannel dashboard using D23's managed Apache Superset platform, which simplifies the deployment and operation of a production-grade analytics layer.

Apache Superset is an open-source business intelligence platform that excels at building interactive, multi-layered dashboards without requiring extensive custom development. Here's how to structure your omnichannel dashboard:

Dashboard Architecture

Organize your dashboard into logical sections:

1. Executive Summary (Top of Dashboard)

• Total revenue (online + in-store) for today, week, month, and year-to-date
• Key metrics: transaction count, average order value, customer count
• Sparklines showing trends
• Alerts for anomalies (revenue down 10% vs. last week, etc.)

2. Channel Comparison

• Revenue by channel (online vs. in-store) with trend lines
• Transaction count by channel
• Average order value comparison
• Customer acquisition cost by channel
• Return rate by channel

3. Geographic and Store Performance

• Map visualization showing revenue by store location
• Table of top/bottom performing stores
• Store-level inventory health (stockout rate, turnover)
• Regional performance trends

4. Product Performance

• Top products by revenue across channels
• Products performing well online but struggling in-store (and vice versa)
• Inventory levels and movement velocity by product
• Return rate by product (quality issues?)

5. Customer Insights

• Breakdown of single-channel vs. multi-channel customers
• Customer lifetime value by acquisition channel
• Repeat purchase rate by channel
• Cohort analysis: how do customers acquired online differ from in-store?

6. Operational Metrics

• Inventory turnover by store and product
• Stockout incidents and impact on lost sales
• Return processing time by channel
• Customer service resolution time and satisfaction

Implementing Filters and Interactivity

Superset makes it easy to add filters that let users drill into the data:

• Date range selector: compare any two periods
• Channel filter: toggle between online, in-store, or both
• Store/region filter: focus on specific locations
• Product category filter: analyze specific product lines
• Customer segment filter: segment by loyalty tier, acquisition source, etc.

These filters should be connected so that selecting a store automatically updates all visualizations to show that store's data.

Critical Metrics for Omnichannel Retail

Define these metrics in your Superset dashboard using SQL calculations:

Revenue Metrics:

• Total revenue by channel and date
• Revenue per transaction
• Revenue per square foot (in-store locations)
• Revenue by product category

Customer Metrics:

• Unique customers by channel
• Multi-channel customers (customers who shop both online and in-store)
• Customer lifetime value by acquisition channel
• Repeat purchase rate
• Net Promoter Score (NPS) by channel

Operational Metrics:

• Inventory turnover ratio (cost of goods sold / average inventory value)
• Days inventory outstanding (DIO)
• Stockout rate and lost sales due to stockouts
• Return rate by channel and product
• Order fulfillment time (online to delivery, in-store to pickup)

Efficiency Metrics:

• Labor productivity (revenue per employee hour)
• Conversion rate by channel
• Customer acquisition cost by channel
• Marketing ROI by channel and campaign

Advanced Capabilities: AI and Text-to-SQL

Modern analytics platforms like D23 extend Superset with AI capabilities that make omnichannel dashboards even more powerful. Two key features are particularly valuable for retail:

Text-to-SQL for Ad-Hoc Analysis

Retail leaders often have specific questions that don't fit standard dashboard views. "Which products have the highest return rate in the Northeast region, and how does that correlate with online reviews?" or "Show me customers who bought online in the last 30 days but haven't visited a store—what's their average order value?"

With text-to-SQL capabilities (powered by LLMs), users can ask questions in natural language, and the system automatically generates SQL queries. This dramatically speeds up analysis and reduces dependency on data engineers. D23's integration with AI models means your team can explore data without writing SQL.

Anomaly Detection

AI-powered anomaly detection automatically flags unusual patterns in your omnichannel data. For example:

• A sudden drop in online conversion rates
• Unusually high return rates for a specific product in a specific store
• Inventory imbalances (a store with far higher stockout rates than peers)
• Customer churn acceleration in a specific region

These alerts help your team catch problems early and investigate root causes.

Predictive Analytics

Beyond historical analysis, AI can forecast:

• Demand by product and location (enabling better inventory allocation)
• Customer churn risk (so you can intervene with retention campaigns)
• Optimal pricing and promotion timing
• Inventory needs for seasonal peaks

Implementation Strategy and Best Practices

Building an omnichannel dashboard is a journey, not a one-time project. Here's how to approach it:

Phase 1: Foundation (Weeks 1-4)

Start with your two largest data sources (e-commerce and POS). Build a basic ETL pipeline that syncs transaction data daily into a warehouse. Create a simple dashboard showing revenue by channel and date. Get stakeholder feedback.

Deliverables:

• Data warehouse with 6 months of historical data from both channels
• Basic dashboard with channel comparison and trend analysis
• Documentation of data definitions and refresh schedule

Phase 2: Enrichment (Weeks 5-12)

Add customer and inventory data. Implement customer ID matching across channels. Build out the geographic and product analysis sections of the dashboard.

Deliverables:

• Customer dimension table with unified IDs across channels
• Inventory fact table with real-time updates
• Enhanced dashboard with store-level and product-level analysis
• Automated alerts for key anomalies

Phase 3: Optimization (Weeks 13+)

Add operational and customer service data. Implement AI-powered features like text-to-SQL and anomaly detection. Build role-specific views (operations team sees inventory and fulfillment; merchandising team sees product performance; finance sees margin analysis).

Deliverables:

• Integrated returns and customer service data
• AI-powered query capabilities
• Role-based dashboard views
• Predictive analytics for demand and churn

Data Quality and Governance

As your dashboard grows in importance, invest in data quality:

• Define data ownership: who is responsible for each data source?
• Implement validation rules: catch missing or invalid data before it reaches the dashboard
• Document data lineage: track where each metric comes from
• Regular audits: compare dashboard numbers to source system reports to catch discrepancies
• Access controls: ensure sensitive data (customer PII) is properly protected

D23's privacy policy outlines how data is handled in managed environments, which is important when consolidating sensitive retail data.

Comparing Omnichannel Dashboards to Alternatives

Retailers often evaluate different approaches to omnichannel analytics:

Spreadsheet-Based Reporting

Many retailers start with manual reports—exporting data from each system and combining in Excel. This is time-consuming, error-prone, and doesn't scale. You can't drill into data or ask ad-hoc questions. Not recommended for anything beyond a small pilot.

Point Solutions

Some vendors offer omnichannel-specific tools (like NewStore's Omnichannel Manager, which provides visibility into returns insights across channels). These are valuable for specific functions but typically don't provide the flexibility or breadth of a general analytics platform.

Enterprise BI Platforms (Looker, Tableau, Power BI)

These are powerful and feature-rich, but they're expensive (often $5,000-$20,000+ per month for mid-market retailers), require significant implementation effort, and lock you into proprietary platforms. If you need omnichannel analytics, you're paying for many capabilities you don't need.

Open-Source with Managed Hosting (D23)

Apache Superset on a managed platform like D23 gives you the flexibility of open-source (no vendor lock-in, full customization) with the operational simplicity of managed hosting (no infrastructure to maintain, expert support). For omnichannel retail dashboards, this is often the sweet spot—you get powerful analytics without enterprise software costs.

Real-World Example: A Mid-Market Retailer's Journey

Consider a mid-market fashion retailer with 15 stores and a growing e-commerce business. Before implementing an omnichannel dashboard:

• The merchandising team couldn't see which products were selling in-store vs. online, so they ordered inventory based on incomplete data
• The finance team spent 2 days each month manually combining reports from three systems
• Store managers had no visibility into online inventory or demand, leading to missed cross-selling opportunities
• The company couldn't identify multi-channel customers or understand their behavior

After implementing an omnichannel dashboard on Apache Superset:

• Inventory optimization: By seeing online and in-store demand patterns, they reduced excess inventory by 12% while improving in-stock rates
• Faster reporting: Monthly reporting dropped from 2 days to 2 hours, freeing up the finance team for analysis
• Store performance visibility: Store managers could see online demand trends and adjust in-store promotions accordingly, increasing store traffic
• Customer insights: They identified that 23% of customers shop both channels, and these multi-channel customers have 3x higher lifetime value, informing acquisition strategy
• Pricing optimization: They discovered that certain products had 15-20% price differences between channels, which they standardized

According to Gartner's research on omnichannel retail platforms, this type of impact is typical—retailers see 10-15% improvement in inventory efficiency and 5-10% improvement in revenue when they gain unified visibility.

Handling Common Challenges

Building omnichannel dashboards isn't without challenges. Here's how to address them:

Challenge 1: Customer ID Matching

Problem: Online customers might use email, in-store customers might use phone, and not all customers are in your loyalty program. How do you match the same person across channels?

Solution: Use a hierarchical matching approach:

1. Start with exact matches on loyalty program ID (most reliable)
2. Match on email + phone (if both are available)
3. Use probabilistic matching on name + address + purchase history for remaining customers
4. Accept that some customers will appear as separate records and note this in your analysis

Invest in a customer data platform that specializes in identity resolution.

Challenge 2: Data Latency

Problem: E-commerce data might update in real-time, but POS data might take 24 hours to sync. Your dashboard shows inconsistent pictures.

Solution: Be explicit about data freshness. Clearly label each metric with its last update time. For operational dashboards, implement real-time data streaming for critical systems (inventory, sales). For analytical dashboards, batch updates are fine as long as they're consistent.

Challenge 3: Metric Definitions

Problem: "Revenue" might be calculated differently in your e-commerce platform (excluding tax and shipping) vs. your POS system (including everything). Your dashboard will be confusing.

Solution: Create a data dictionary that defines every metric. Document whether revenue includes tax, shipping, returns, discounts, etc. Standardize calculations across all data sources.

Challenge 4: Scaling to Complexity

Problem: As your dashboard grows, query performance degrades. Your dashboard becomes slow and unusable.

Solution: Use data aggregation and materialized views. Pre-calculate common metrics (daily revenue by store by product) and serve those instead of raw transactions. Superset handles this well with its caching layer.

Measuring Success

How do you know if your omnichannel dashboard is working? Track these metrics:

• Adoption: How many users access the dashboard weekly? Are they using it for decisions?
• Query speed: Are dashboards loading in under 3 seconds? Are ad-hoc queries returning results quickly?
• Data accuracy: Do dashboard numbers match source system reports? Are there discrepancies?
• Business impact: Are decisions being made faster? Have you identified any revenue or efficiency improvements?
• Cost: What's your total cost of ownership (platform, infrastructure, data engineering time)? Is it lower than alternatives?

A successful omnichannel dashboard should be used daily by multiple teams (operations, merchandising, finance) and drive at least one major business decision per month.

Next Steps: Building Your Omnichannel Dashboard

If you're ready to build unified omnichannel visibility, here's your path forward:

1. Audit your data sources: List every system that holds customer, product, or transaction data. Understand what data each contains and how frequently it updates.

2. Define your metrics: What decisions do you need to make? What data do you need to support those decisions?

3. Design your data architecture: Sketch out your ETL pipeline and data warehouse schema. Identify where customer ID matching will be needed.

4. Choose your platform: Evaluate whether a managed open-source solution like D23 fits your needs better than enterprise platforms. Consider total cost of ownership, implementation time, and flexibility.

5. Start small: Build a pilot dashboard with your two largest data sources. Get feedback before scaling.

6. Iterate: Add data sources, metrics, and AI capabilities based on user feedback and business priorities.

Omnichannel retail dashboards aren't a nice-to-have anymore—they're essential for competing in modern retail. As Forbes discusses in their analysis of omnichannel retail's future, retailers who unify their data and operations gain significant advantages in customer experience, operational efficiency, and profitability.

The technology to build these dashboards is mature and accessible. The question isn't whether you can build an omnichannel dashboard—it's how quickly you can implement one and start making better decisions.

Conclusion

Omnichannel retail is no longer a differentiator—it's table stakes. Customers expect seamless experiences across online and physical channels, and your operations need to match that reality. A unified omnichannel dashboard is the foundation for making that happen.

By consolidating data from e-commerce, POS, inventory, and customer systems into a single analytical layer, you gain visibility into your business as a cohesive whole. You can optimize inventory across channels, understand multi-channel customer behavior, identify operational inefficiencies, and make faster, better-informed decisions.

The implementation requires thoughtful architecture, clean data pipelines, and the right analytics platform. Open-source solutions like Apache Superset, especially when managed by platforms like D23, provide the flexibility and power you need without the cost and complexity of enterprise BI platforms.

Start with a clear understanding of your data sources and the decisions you need to make. Build incrementally, validate with stakeholders, and scale based on what you learn. Within a few months, you'll have a dashboard that's essential to how your business operates.

Your competitors are already moving toward omnichannel integration. The time to build your unified dashboard is now.