Microsoft-Power-BI-Report-and-Dashboard

Customer Analytics Report

https://app.powerbi.com/view?r=eyJrIjoiNDkxM2UxYjEtMTczZi00NDg2LTlkYWEtMmE3ZDVkMjJmM2JhIiwidCI6IjFhNDc1OGYwLTk2ZTctNDdjOC1iZThlLWY1YjA2YmRiOGU0NSJ9&pageName=ReportSection9e18d82523911fba6e35

• Analyzing New Customers Vs Old Customers Vs Lost customers (based on time period selected)
• Monthly Sales by all customers vs New Customers
• Top 10 Products Purchased by First Time Visited Customers

• Cohort Analysis
• Customer Segmentation by Total Revenue
• Customer Segmentation by Customer Count
• Top 10 Customers by Sale
• Top 15 Products by Sale

Sales Analysis

https://app.powerbi.com/view?r=eyJrIjoiOGUzYmJhM2QtYjhjYi00MGExLWEyMWMtODRmNjcwMGZmMzU2IiwidCI6IjFhNDc1OGYwLTk2ZTctNDdjOC1iZThlLWY1YjA2YmRiOGU0NSJ9&pageName=ReportSection

Sales Segmentation as per Margin

Product Segmentaion as Per Sales Ranking

Commulative Sales(Yearly) / Commulative Sales(from beginning) / Average Moving Sales/ Previous Month Sales / Sales Same Period Last Year

Top 50 Customers and Orders by Top 50 Customers

Product/Customer Overall Ranking /Sales Ranking/ Profit Ranking /Profit Margin Ranking (Sorted by Overall Ranking)

https://app.powerbi.com/view?r=eyJrIjoiZTZiNTFiM2EtYmZmYi00N2I0LWIyNzktNjI3NGZjZWFjMGY3IiwidCI6IjFhNDc1OGYwLTk2ZTctNDdjOC1iZThlLWY1YjA2YmRiOGU0NSJ9