Power BI Sales Dashboard Development
Budget: $250 – $750 USD
I need a Power BI dashboard focused on sales analysis. The dashboard should effectively present sales data to provide insights and facilitate decision-making.
Key Requirements:
-the main requirement for this dashboard is to be repeatable .
I need to be able to copy data in a specific way from another program and get defined results
The data needed is
- date range graph with count of product by week
- date range with average weekly hours needed
- date range with average personal count by week
- specialized formulas for reporting as I describe (to much for here )
- definable by job title or customizable field column
-definable by location or customizable field column
Thanks for taking a look at this , I have included a spreadsheet here . If you look at Sheet 4 its essentially the hard data im exporting from our scheduling software. I want to be able to paste columns A-I into here natively at the moment . Eventually I would add a column for a formula to do a counting a specific signifier for type of labor or by a WBS code ( if you know what that is )
Essentially i want to be able to copy and paste these in here and get reports much like the graphs i created on Schedule tab. Showing the total number of product on the floor at a time , and be sortable by label type i.e. MER skid vs Elec skid .
This would also directly corelate to a manhour count as the one graph represents , and then eventually to a man power curve ( weekly hours / 5/10) is the standard formula .
I would love to have the dashboard be able to capture the formulas and the information in Column N-P as well as a high level by project glance , this project hasnt started yet so it shows negative. I also dont know how to make Excell auto select from column D and E the earliest and latest dates to calculate N29 , so technically it and the other two yellow boxes are hard codes.
Eventually i could have the cost report pull into a seperate tab and do a labor sum lookup i think ( idk how to do that) to auto populate n45
But getting itso i can inport the 8 columns into a base document and then have it auto populate the reports would be great .
Let me know your thoughts , i would be more than happy to compensate you for either teaching me how to do this or building it for me as this is for my work.
Key Requirements:
-the main requirement for this dashboard is to be repeatable .
I need to be able to copy data in a specific way from another program and get defined results
The data needed is
- date range graph with count of product by week
- date range with average weekly hours needed
- date range with average personal count by week
- specialized formulas for reporting as I describe (to much for here )
- definable by job title or customizable field column
-definable by location or customizable field column
Thanks for taking a look at this , I have included a spreadsheet here . If you look at Sheet 4 its essentially the hard data im exporting from our scheduling software. I want to be able to paste columns A-I into here natively at the moment . Eventually I would add a column for a formula to do a counting a specific signifier for type of labor or by a WBS code ( if you know what that is )
Essentially i want to be able to copy and paste these in here and get reports much like the graphs i created on Schedule tab. Showing the total number of product on the floor at a time , and be sortable by label type i.e. MER skid vs Elec skid .
This would also directly corelate to a manhour count as the one graph represents , and then eventually to a man power curve ( weekly hours / 5/10) is the standard formula .
I would love to have the dashboard be able to capture the formulas and the information in Column N-P as well as a high level by project glance , this project hasnt started yet so it shows negative. I also dont know how to make Excell auto select from column D and E the earliest and latest dates to calculate N29 , so technically it and the other two yellow boxes are hard codes.
Eventually i could have the cost report pull into a seperate tab and do a labor sum lookup i think ( idk how to do that) to auto populate n45
But getting itso i can inport the 8 columns into a base document and then have it auto populate the reports would be great .
Let me know your thoughts , i would be more than happy to compensate you for either teaching me how to do this or building it for me as this is for my work.