Intro In this end to end Excel data project, we gather data, transform it then use pivot tables and pivot charts to build a dynamic interactive coffee sales dashboard. Problem Statement Our stakeholders have requested a dashboard that analyzes the following:1. Total coffee sales over time by coffee type.2. Coffee sales by country3. Top customers […]
This HR Analytics dashboard enables stakeholders to monitor, measure, and understand: HeadcountEmployee retentionRemote employee %Avg employee ageEmployee tenure by positionAvg employee age by position Tools used: Power BI Key Business Insights:1. The company currently has 5,501 active employees.2. The average employee tenure is 2 years.3. 25% of employees currently work remotely.4. The average age of […]
This Sales Analytics dashboard enables stakeholders to monitor, measure, and understand: Monthly sales order volumesSegment & product category compositionMonthly sales trendsTop customersMost profitable products. Tools used: Power BI 2012 Key Business Insights:1. The Corporate segment has the highest sales with the Technology category being the largest.2. John Lucas is the top customer but not among […]
This Customer Analytics dashboard enables stakeholders to monitor, measure, and understand: Number of customers by segmentOrdering trends by segmentSales volumes by segment & product subcategories. Tools used: Power BI Key Business Insights:1. Corporate segment is the largest in terms of the number of customers.2. The Corporate segment also produces the most revenue.3. The Corporate Office […]
Introduction This data science project analyzes Super Bowl TV ratings data. The purpose is to gain insight into the following questions: 1. What are the most extreme game outcomes?2. How does the game affect television viewership?3. How have viewership, TV ratings, and ad cost evolved over time? We will briefly discuss the data, tools & […]
This Tableau dashboard utilizes Superstore data to illustrate various business KPIs related to Sales, Profit, Order Quantities, Customer Segments, Regional, and Product Categories. The dashboard utilizes a variety of chart types including Area, Bar, Stacked Bar, Donut, and Scatter Plot to convey the business insights. Some of the Tableau elements used were Filters, BANS, and […]