Excel pivot table interactive dashboard
Budget: $250 – $750 USD
I have some simple Excel reports running. I pull the data monthly from our TMS (Transportation Management Software) and paste it into my sheet. I pull simple data from the TMS like Monthly and quarterly Gross, Net, Total Margins, Margin percentages, number of loads and Growth month over month %..
Id like an interactive dashboard that runs continuously as i add monthly data.
Using graphs and Slicers for Months quarters and years for Gross, Net and Margin totals
Id also like to add a Dealer graph and Slicer that shows each dealer margin totals made from their deliveries. Id also like to get a dealer total miles and rate per mile chart as well.
We are only looking a max of 3000 loads per year so not a tremendous amount of data.. But all the data pulled from our TMS has the info in it. This side of the business entity only started in March of 2021 so not much data in the past..
Ive uploaded a screen shot of what ive built and some of what ive messed around with on the pivot table.
Id like an interactive dashboard that runs continuously as i add monthly data.
Using graphs and Slicers for Months quarters and years for Gross, Net and Margin totals
Id also like to add a Dealer graph and Slicer that shows each dealer margin totals made from their deliveries. Id also like to get a dealer total miles and rate per mile chart as well.
We are only looking a max of 3000 loads per year so not a tremendous amount of data.. But all the data pulled from our TMS has the info in it. This side of the business entity only started in March of 2021 so not much data in the past..
Ive uploaded a screen shot of what ive built and some of what ive messed around with on the pivot table.