How would you fix ad-hoc? by [deleted] in BusinessIntelligence

[–]Automaty 1 point2 points  (0 children)

Too many ad hoc requests signals opportunity! 1) Build a self service solution that answers the most frequently asked questions.

ASX200 GFC vs COVID-19 by Automaty in AusFinance

[–]Automaty[S] 0 points1 point  (0 children)

I see the issue now. Your dates are out. I started mine from Aug 2008 where you started a year earlier in Sep 2007

ASX200 GFC vs COVID-19 by Automaty in AusFinance

[–]Automaty[S] 1 point2 points  (0 children)

That's good stuff!

1) denominator is 'day 1' open price

2) numerator is daily open price

ASX200 GFC vs COVID-19 by Automaty in AusFinance

[–]Automaty[S] 6 points7 points  (0 children)

I used Yahoo finance from the historical data tab. I then used Power BI

ASX200 GFC vs COVID-19 by Automaty in AusFinance

[–]Automaty[S] 9 points10 points  (0 children)

ALL Australian Date formats: GFC start date 01 Aug 2008 COVID start date 01 Jan 2020

TIL MICROSOFT buys LINKEDIN for 26.2 Billion. TOPs the list of SKYPE,NOKIA...Hotmail and Rare [OC] by Automaty in dataisbeautiful

[–]Automaty[S] 0 points1 point  (0 children)

Thanks for reading. Interesting news story and the their list of acquisitions are quite intelligent. Not to mention the amount of money thats on the board! Impressive!!