Objective: Develop an executive dashboard to monitor and analyze sales performance of Munchy’s Pet Supply.
Goal: Provide key insights on revenue, product performance, customer segments, and regional sales to support data-driven decisions.
Dataset: Sales transaction data including product categories, customer types, payment methods, regions, and sales metrics.
Objective: Create a supply chain dashboard to analyze operational efficiency and logistics performance for JustinTime Supply Chain.
Goal: Provide actionable insights on inventory management, supplier performance, delivery efficiency, and order fulfillment to optimize supply chain operations.
Dataset: Supply chain data including order details, product categories, supplier performance, shipping status, delivery times, and fulfillment rates.
Objective: Develop a shipment dashboard to track delivery performance and shipping efficiency for JustinTime.
Goal: Provide insights into shipment status, delivery timelines, shipping delays, and carrier performance to optimize logistics operations.
Dataset: Shipment data including order IDs, shipping dates, delivery dates, shipment status, carrier details, and delivery performance metrics.
Objective: Create an inventory dashboard to monitor stock levels, product movement, and warehouse efficiency for JustinTime.
Goal: Provide insights into inventory management, stock availability, turnover rates, and restocking needs to optimize supply chain operations.
Dataset: Inventory data including product IDs, categories, stock levels, warehouse locations, reorder points, and stock movement history.
Objective: Develop an HR dashboard to monitor workforce metrics and analyze employee-related data for Atlas Labs.
Goal: Provide insights into employee demographics, turnover, hiring trends, and workforce distribution to support HR decision-making.
Dataset: HR data including employee IDs, demographics, departments, job roles, tenure, hiring status, and attrition records.
Objective: Build a customer churn analysis dashboard to monitor customer retention and churn patterns for Databel.
Goal: Provide insights into churn rates, customer behavior, and key factors influencing churn to support retention strategies.
Dataset: Customer data including demographics, tenure, contract types, payment methods, service usage, and churn status.
Objective: Build an inventory analysis dashboard to track stock levels, product movement, and inventory performance.
Goal: Provide insights into inventory health, stock availability, turnover rates, and replenishment needs to improve operational efficiency.
Dataset: Inventory data including product IDs, categories, stock levels, sales data, reorder points, and warehouse locations.
Objective: Develop a trip analysis dashboard to understand rider behavior and usage patterns for Divvy Bike Sharing.
Goal: Provide insights into rider demographics, trip patterns, and differences between casual and member riders to support business strategies.
Dataset: Divvy historical trip data including rider types, trip durations, start/end stations, rideable types, and trip dates.
Objective: Create a Length of Stay (LOS) dashboard to analyze patient stay duration and hospital performance.
Goal: Provide insights into average LOS, patient flow, and departmental efficiency to support healthcare management and operational improvements.
Dataset: Hospital data including patient IDs, admission/discharge dates, departments, diagnoses, and length of stay records.
manufacturing_parts
table, containing item_no
, length
, width
, height
, and operator
data.sales
table, including order_number
, date
, warehouse
, client_type
, product_line
, quantity
, unit_price
, total
, payment
, and payment_fee
, covering June-August 2021 orders.Assignments
, Donations
, and Donors
tables (2010-2023).student_performance
.charging_sessions
table.charging_sessions
dataset and performing queries for analysis).product_emissions
table.product_emissions
dataset to calculate and compare carbon footprints).