Retail Analytics · Looker Studio Project

Retail Sales Performance Dashboard

A Looker Studio analytics solution giving sales, customer and profitability visibility across a multi-store furniture retail business.

Built with Looker Studio, data blending and calculated fields to demonstrate executive reporting, retail analytics and dashboard design.

Looker Studio Data Blending Executive Reporting Sales Analytics Customer Analytics Dashboard Design

Executive dashboards

Retail stores

20+

Calculated fields

Unified data model

Project Overview

One reporting layer for sales, customers and profitability.

Multi-store retail businesses generate sales, customer and financial data across stores, channels and salespeople, which makes consolidated reporting slow and inconsistent.

This Looker Studio project brings those views together into a single analytics framework, so leadership can track performance, spot trends and act faster — from one source of truth.

Dashboard Showcase

Four connected views, one reporting model.

Click any dashboard to view it full size.

CLICK TO ENLARGE Executive Overview dashboard — revenue, profit and growth

screenshots/executive-overview.png

Executive Overview

Headline revenue, profit, growth and category mix across stores.

CLICK TO ENLARGE Sales Team Performance dashboard

screenshots/sales-performance.png

Sales Team Performance

Rep-level revenue, discounting, conversion and repeat-customer behaviour.

CLICK TO ENLARGE Customer Intelligence and Store Analytics dashboard

screenshots/customer-analytics.png

Customer Intelligence & Store Analytics

Customer segments, retention and store-by-store performance.

CLICK TO ENLARGE Financial and Profitability Analytics dashboard

screenshots/profitability-dashboard.png

Financial & Profitability Analytics

Margins, costs, discount impact and product profitability.

Dashboard Capabilities

What the reporting framework delivers.

Sales Performance Monitoring

Track revenue, units sold, conversion and order value across the team.

Store & Channel Analysis

Compare performance across stores and sales channels.

Customer Intelligence

Segment customers into VIP, repeat and new, and track retention.

Profitability Analysis

Review margins, costs and discount impact by product and store.

Salesperson Performance

Rank representatives by revenue, discounting and repeat rate.

Executive KPI Reporting

Centralized KPI monitoring through executive dashboards.

My Contribution

What I built, end to end.

01Designed the reporting framework

02Built the Looker Studio data model

03Built data blends and calculated fields

04Created the KPI architecture

05Designed the dashboard UX

06Developed salesperson & store analytics

07Created customer intelligence views

08Delivered the executive reporting solution