You are reading a single comment by @hugo7 and its replies.
Click here to read the full conversation.
-
I’ve just built power query spreadsheets with an api call that then populate charts in the agreed format.
I thought I was great. Then I got told I had to build a template for when the data comes down in each of the three different combinations and one to check which way the data comes down.Mainly because we have to build ability to produce output while we step off as a team into coding output in R.
It’s only taken nearly 3 years to get to this point.
Edit it took a month to do the work I’ve just described. It took nearly 3 years to get to this point though, because of taking data from loads of places in the wrong formats and the output “having” to be powerBI.
Chalfie
@hugo7
Not remember to build a spreadsheet so the data can extracted easily at a later date.
(or other ppl for the matter given that I was starting from a template)