Excel Projects

This repository contains my work in Microsoft Excel.

  1. Dynamic heat map using excel to analyze accidents
  2. Sales dashboard built using excel

Below are the instructions for using dynamic heat map in excel.

1.Dynamic Heat Map

Analyzed accident frequency for the city of Cambridge by building a dynamic heat map of accidents. Generated heat map allows to quickly visualize when certain types of accidents are most likely to occur. The data visualization displays the safest and dangerous time to travel around the city.

Prerequisites

Basic Knowledge of Pivot Tables, custom and conditional formatting in Excel

Instructions

  1. Go to the heat map sheet.
  2. click on drop down list beside the blue boxes on top.

Output

  1. You will see the heat map changing for different combination of accident type and season type
  2. You will also see the Geo heat map (Power Map) at the bottom also changing accordingly.
  3. On top left corner total number of accidents are displayed. .
  4. Notice the values on X and Y axis, they're dynamic and will be changing dynamically based on the time the worksheet is opened. X-axis displays the day of the week and number of accidents hour wise subsequently. Similarly, Y-axis displays the number of accidents for following day of the week.

Built With

Power Map - 3D visualization tool to plot geographic data

2.Sales Dashboard

I have utilized following items in building sales dashboard which analyzes products by category and region.

  1. Pivot Tables
  2. Pivot Chart
  3. Data Refresh
  4. Data Table
  5. Dynamic Name Tagging
  6. Slicers
  7. Map Pivot
  8. Sparklines