Eric Rajoriya
Data Analyst | SQL, Excel, Power Bi & Tableau
New to Contra
Eric is ready for their next project!
Cleaned and analyzed a retail sales dataset using Microsoft Excel to transform raw transaction data into structured, analysis-ready information.
The dataset includes Order Date, Customer, Product, Category, City, State, Region, Quantity, Price, Discount, Gross Sales, Net Sales,...
Analyzing Sales Data using SQL!
Converting raw data into meaningful business insights is a key part of Data Analytics. Today, I wrote a SQL query to calculate key sales and profitability metrics.
Key Metrics Covered:
Gross Sales: Quantity * Price
Discount Amount: (Quantity *...
📊 Interactive Sales Analytics Dashboard in Excel
I created an interactive Excel dashboard to analyze sales performance across different business dimensions.
Key Insights & Features:
• Total Orders, Sales & Profit KPIs
• Sales & Profit by Region
• Sales by City
• Category-wise...
Built an interactive Sales Insights & Trends dashboard in Power BI to analyze revenue performance across regions, states, and cities.
The dashboard helps identify top-performing locations, compare revenue trends, and track key sales metrics through interactive visuals and...
I created an interactive Tableau dashboard to analyze sales revenue across different cities, products, and months.
The dashboard allows users to filter data by City, Product, and Month and quickly compare revenue performance across different locations and products.
Key...
