This Power BI dashboard provides an interactive and insightful analysis of top U.S. eCommerce companies in 2023. It’s a great example of how to visualize and analyze business performance across geography, industry, and company metrics using Power BI.
📊 Dashboard Components Breakdown
🔹 KPI Cards (Top Center)
- Average Number of Employees:
168.06K - Average Revenue (USD millions):
117.57K - Average Revenue Growth:
19.58%
These KPIs give users a quick overview of the general scale and performance of the companies analyzed.
Dataset : Download Here
🌍 Map Visualization: Revenue by State
- “Sum of Revenue (USD millions) by State”
- Uses a filled map to show which U.S. states contribute most to eCommerce revenue.
- Darker shades represent higher revenue.
🛠 Power BI Tip: This can be created using the Filled Map visual and a data column for state and revenue.
🏭 Donut Chart: Revenue by Industry
- Highlights the percentage revenue distribution across industries like:
- Retail
- Petroleum
- Healthcare
- Technology, etc.
🛠 Power BI Tip: Use Donut Chart and assign Industry as Legend and Revenue as Values.
🏙️ Top Cities by Avg Revenue Growth
- A vertical bar chart ranks the top 10 cities based on average revenue growth (e.g., Clearwater and Miami top the chart with over 90%).
🛠 Power BI Tip: Use a Bar Chart with City on the axis and Average Revenue Growth as value.
📈 Combo Chart: Revenue and Growth by Company Name
- Combines bar chart (sum of revenue) and line chart (average revenue growth).
- Visualizes individual company performance — e.g., Walmart, Amazon, Apple.
🛠 Power BI Tip: Use a Combo Chart (Line and Clustered Column Chart). Assign:
- Column: Revenue
- Line: Growth
🌆 Horizontal Bar Chart: Revenue by City
- Shows cities like New York, Bentonville, and Seattle in terms of revenue contribution.
🛠 Power BI Tip: Use Stacked Bar Chart with City on Y-axis and Revenue on X-axis.
🔍 Slicers (Right Sidebar)
- Filter visuals dynamically using:
- State
- City
- Company Name
- Rank (possibly a numeric rank filter)
🛠 Power BI Tip: Add Slicer visuals from the Visualization pane and bind them to respective fields.
💡 Learning Objectives
This Power BI dashboard teaches you to:
- Use multiple chart types for comparative analytics.
- Add interactivity with slicers.
- Combine KPIs and charts for storytelling.
- Apply maps and donut charts for categorical and geographical data analysis.
- Create a layout that’s both informative and visually appealing.