Analysis-Tool-SQL-Excel-PowerQuery-PowerPivot

The tool was developed to do extensive analysis on trailer dormancy and counts. This tool was used in a production environment

Step 1

Use Power Query to import data form SQL Database and remove/add features.

Step 2

Add other tables outside of the Database

Step 3

Use Power Pivot to join tables and create relationships

Step 4

Optional - Add custom functions/measures/columns in Power Pivot

Step 5

Create pivots and slicers

Step 6

Conduct analysis