91 Dashboard (Internal Software)
I played a pivotal role in designing an internal dashboard tailored for the company's founder and investors. The dashboard was created to streamline the tracking and analysis of business metrics, with a focus on media sales and inventory management. My responsibilities encompassed the complete UI/UX design
Problem Statement
As the organization experienced rapid growth, managing and analyzing critical business metrics related to media sales and inventory using Google Sheets or MS Excel became increasingly problematic. The primary challenges included, Scalability Issues, Complex Analysis, Data Fragmentation, Investor Reporting.
Overview
Website Traffic Analysis: Provides insights into user engagement and traffic patterns on the company’s website, helping identify trends and areas for improvement.
Media Sales Reports: Displays detailed reports on media sales performance, including revenue, sales volume, and trends over time. This section allows for in-depth analysis of sales data to inform strategic decisions.
Marketing Spend Overview: Tracks and analyzes marketing expenditures, enabling the assessment of return on investment (ROI) and the effectiveness of various marketing campaigns.
91Trucks Store Inventory Report: Offers a comprehensive view of inventory management, including vehicle purchases and sales. This section helps monitor stock levels, track sales performance, and manage inventory efficiently.
Proposed Solution
To address the challenges of managing and analyzing business metrics through spreadsheets, we developed a comprehensive internal dashboard designed to centralize and enhance data visibility. The solution includes the following key components.
This dashboard represents a significant advancement over conventional data management practices, offering a more robust and user-friendly solution for tracking and analyzing business metrics.