Visualisations

1. Power BI - Sales Analysis

Overview

Key Features

• Dashboard Preview: A visual summary of sales trends, customer behavior, and order breakdowns.
• Semantic Model: data relationships. Click Here to view
• DAX Calculations: Includes formulas for Average Order Value (AOV), Online vs. Offline Sales, Year-over-Year (YoY) Growth, etc.
• BigQuery SQL Queries: Used for extracting regional sales, employee performance, and sales reasons from the dataset.

How to Access

1. Download the Power BI file
2. Open in Power BI Desktop to explore visuals and insights.

• B2B FY2004.pdf report focuses on B2B sales for 2004 fiscal year Click Here to view
• Sales Dashboard Report.pdf overall report for sales Click Here to view
• Sales Dashboard Report.pbix overall report for sales Click Here to view

Overall sales trend, KPI's:

• Performance overview.pdf Click Here to view
• Performance overview.pbix Click Here to view

---

2. Looker - Google Merch Shop Web Analytics

Overview

A web analytics report using Looker, BigQuery to evaluate customer behavior, conversion funnels, and marketing effectiveness.

Key Features

• Customer Behavior Trends: Purchase decisions, engagement levels, and drop-off rates.
• Conversion Funnel Analysis: Identifying bottlenecks in the customer journey.
• Marketing Effectiveness

How to Access

1. View the Looker Dashboard online: Click Here
2. See exported report: Click Here

Contact

Feel free to reach out via LinkedIn.