Help with Visualization

[Anonymous]

Have a full excel sheet with data that shows projections of hiring needs over time, but am having difficulty seeing how to visualize it. Sample data is below - thoughts/help?

Division	Project	State	Recruiter	Admin	10/3	10/10	10/17	10/24	10/31
Wind	1	MN	A	S	6	6	6	6	6
Wind	2	ND	A	S	177	141	63	50	30
Wind	3	OK	A	R	130	125	125	126	126
Wind	4	TX	A	J	126	125	125	90	83
Wind	5	NM	M	K	233	231	230	217	188
Wind	6	MN	A	B	120	116	120	196	193

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

You can download a PBIX file with the following data and visual.

Once the dates are unpivoted to give this

You can then produce visuals like this

With regards to relationships in your data, well I guess that is down to what is recorded and what you want to report.  The visual above shows Values by Project each week.  You could also look at things like Value per state, Value per Recruiter or Admin, Recruiter by State etc.  Presumably you have other divisions so you could look at Value per Division?  What data insights are important to you?

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[PhilipTreacy]

Hi @Anonymous 

I'd start by unpivoting the date columns into a single date column, with the values for those dates in another column.  That will get the data into the correct tabular format to allow you to create a line or column chart showing the hiring needs values over time.

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Anonymous]

If I pulled those out and did what you're suggesting, how would I keep the rest of the data relevant and usable? I'm not seeing a relationship I could use to keep everything connected. Thanks!