1. Dashboard Layout Design
- How to organize multiple charts in a visually coherent layout.
- Use of consistent color themes (e.g., brown/orange) for branding and readability.
- Placement of slicers (filters) on the right for intuitive interactivity.
Dataset Link : https://www.kaggle.com/datasets/ricardobj/electric-vehicle-population
Note: We don’t own the link, it belongs the user who has uploaded it on Kaggle, dataset may be delete by the original user.
2. Visualizations Used
Learn how to create and customize the following Power BI visuals:
| Visual Type | Tutorial Topics |
|---|---|
| Line Chart | Visualize vehicle growth trend by model year. |
| Map (Filled Map) | Show vehicle distribution across states using geo-mapping. |
| Bar Charts | Compare counts by city, electric utility, and model. |
| Pie Charts | Display proportion-based data (e.g., Make, Vehicle Type, CAFV eligibility). |
| Stacked Column Chart | Display distribution of electric range bins. |
3. Data Slicing and Filtering
- Use Slicers for user-controlled filters (City, State, County, Make, Model Year).
- Learn how to apply slicers to all visuals or specific charts only.
- Enable multi-select and search functionality in slicers.
4. Calculated Measures & DAX
- Calculate vehicle counts by eligibility, type, make, etc.
- Use DAX to group data into bins (e.g., electric range categories).
- Build calculated columns for custom labels or eligibility segments.
5. Interactivity and Drill-Downs
- Set up visuals to be cross-filtered based on user selection.
- Use tooltips to provide detailed info on hover.
- Add drill-down capabilities to explore data at deeper levels (e.g., by year, make, or model).
6. Cards and KPIs
- Display key metrics like total number of EVs in a big number card.
- Customize KPI visuals to draw attention to main figures.
7. Power BI Best Practices
- Use consistent colors for clarity and accessibility.
- Optimize visual hierarchy and spacing.
- Use titles, legends, and data labels appropriately.
- Publish and share dashboards with end users.
8. Branding and UX
- Add icons and titles (e.g., electric car icon, “Learn Power BI @Slidescope”).
- Apply consistent fonts and padding for professional appearance.
Ideal For:
- Power BI beginners who want a hands-on example of building a multi-page dashboard.
- Intermediate users looking to apply interactivity, DAX measures, and custom visuals.
- Analysts working on transportation, automotive, or clean energy data.