Visualize data instantly with machine learning in Google Sheets

Re:Visualize data instantly with machine learning in Google ... by tryitnow on Friday June 02, 2017 @12:15PM (#14471015)

I'm currently evaluating BI vendors for my company and just about every major contender has this functionality or is developing it. Read the Gartner report from 2017 and they basically just come out and say that this will be the new standard in BI.

The much harder problem is data management and preparation. Anyone with half a brain and a decent visualization tool can create basic graphs - but that doesn't mean they should, especially if the organization doesn't have good data management processes in place.

Issues like data governance, data prep, and data modelling are the major pain points for me. And honestly, developing a useful BI solution is more about culture change than it is technology. If a company has poor data governance, it doesn't matter how whiz-bang their technology is, they're still not going to get useful insight from their numbers.

[ Parent | on HN ]

Re:Visualize data instantly with machine learning in Google ... by ozataman on Friday June 02, 2017 @01:45PM (#14471905)

And data management / preparation is where major mistakes are made - get a join wrong and you may easily be missing data or double counting something just obscure enough to go unnoticed like "ancillary sales".

There is something potentially harmful, or perhaps that needs addressing, about end-user tools growing in expressive power. A good friend who does statistical genetics work once told me "but I don't want every user running their own regressions and drawing nonsensical conclusions from badly prepared data!"

[ Parent | on HN ]

Re:Visualize data instantly with machine learning in Google ... by shostack on Friday June 02, 2017 @07:53PM (#14474080)

Yep. Wake me when an AI can tell me "hey, that monthly trending conversion report you asked me to pull...yeah, you're missing two days worth of data when tracking broke, so it will just make your numbers look lower when rolled-up monthly and be hard to notice."

BTW, that is also the reason I not only set alerts, but review data at a daily level when pulling any rolled-up reports of significance.

[ Parent | on HN ]

Re:Visualize data instantly with machine learning in Google ... by kyleschiller on Friday June 02, 2017 @11:21PM (#14474840)

Why can't AI tell you you're missing data?

[ Parent | on HN ]

Re:Visualize data instantly with machine learning in Google ... by massaman_yams on Tuesday June 06, 2017 @02:53AM (#14495290)

For most use cases, you don't even need AI. Once you reach a certain scale, there are certainly ML-based solutions available: https://medium.com/netflix-techblog/rad-outlier-detection-on...

[ Parent | on HN ]

Re:Visualize data instantly with machine learning in Google ... by gefh on Friday June 02, 2017 @07:25PM (#14473962)

That ship sailed somewhere around Excel 95...

[ Parent | on HN ]

Re:Visualize data instantly with machine learning in Google ... by temp246810 on Friday June 02, 2017 @05:57PM (#14473613)

Just out of curiousity, which one did you go with?

We're in the middle of doing this ourselves and would like to hear a random HNers thoughts on the subject.

[ Parent | on HN ]

Re:Visualize data instantly with machine learning in Google ... by paulrosenzweig on Friday June 02, 2017 @07:52PM (#14474072)

I'm at a ~100 person company. We've been using Mode for about six months and like it.

[ Parent | on HN ]

Re:Visualize data instantly with machine learning in Google ... by primeblue on Friday June 02, 2017 @08:57PM (#14474327)

Microsoft PowerBI

[ Parent | on HN ]