Sales Dash Board using Microsoft Excel

This is one of the first projects I did while I was learning data analytics using MS Excel, Following a tutorial from Online Training Hub, I was able to clean, analyze and design a dashboard using MS Excel.

Real Estate Analysis

I worked on a realtor dataset to derive insights such as total assets owned, number of houses sold and unsold, total revenue, assets by location, location with most houses, most expensive house, etc all these were achieved using MS Powerbi and going the the data analysis life cycle.

Financial Analysis

The dashboard is a financial Analysis, It visualizes the revenue generated by the organization, the most Product sold, country with the highest profit, a time series showing the revenue generated per month and many more.

Sprocket Central Sales Analysis

Sprocket central dataset was analyzed to bring out insights of the the sales trend and the customer analysis. The dashboard displays insights such as Total sales, most product sold, sales trend by year, total number of orders, total customers, customers by segment,customer by gender, and many more.