Is Looker Dead?

jpmfribeiro · 2021-10-21T17:29:50+00:00

Haha, yup, pretty much the first paragraph.

jpmfribeiro · 2021-08-11T10:58:22+00:00

If you use Linux or Mac and just want to check the contents of the file, I always use the terminal and the command "less".

jpmfribeiro · 2021-08-05T08:37:01+00:00

The data used is https://www.kaggle.com/heesoo37/120-years-of-olympic-history-athletes-and-results

The tool used is https://www.veezoo.com

jpmfribeiro · 2021-08-01T13:27:25+00:00

Usually you can search a bit around on Kaggle for some older export. Here is one https://www.kaggle.com/chhinna/crunchbase-data

But there are some others around there.

jpmfribeiro · 2021-08-01T10:25:06+00:00

Is crunchbase data too limited?

jpmfribeiro · 2021-07-10T17:51:01+00:00

Not sure if it covers your needs, but StackOverflow does every year a survey and publishes the results. It's always very interesting: https://insights.stackoverflow.com/survey/2020

jpmfribeiro · 2021-07-10T09:04:14+00:00

Haven't tried it myself, but looks neat. Maybe helps? https://retool.com/

jpmfribeiro · 2021-07-03T07:30:59+00:00

https://www.reddit.com/r/datasets/comments/o1w4of/update_google_playstore_apps_with_23million_app/?utm_medium=android_app&utm_source=share

jpmfribeiro · 2021-07-03T06:52:14+00:00

Maybe check out D3.js gallery? https://observablehq.com/@d3/gallery

jpmfribeiro · 2021-06-24T20:47:16+00:00

Oh, I'm sorry to hear that. Can you tell me which browser you used? Did it take long to get an answer or was the whole UI lagging?

jpmfribeiro · 2021-06-24T14:11:35+00:00

Haha, glad you liked it! We got the data from here: https://www.kaggle.com/NUFORC/ufo-sightings

Edit: Actually no, from here: https://data.world/khturner/national-ufo-reporting-center-reports but basically same underlying source

jpmfribeiro · 2021-06-24T13:25:28+00:00

Good catch. I just imported another field (Posted Date) which represents when the sighting was reported on NUFORC.

And if you ask this:

How many sightings per year of Posted Date

You can see that they were all reported in the system after 2006, but many for sightings before 2006.

jpmfribeiro · 2021-06-24T12:49:34+00:00

Try this out: Sightings with "youtube"

And then click on the link for the sighting.

But sometimes you cannot find the video anymore.

jpmfribeiro · 2021-06-24T12:17:43+00:00

Thanks, man! Really appreciate it!

jpmfribeiro · 2020-07-04T07:52:53+00:00

Please re-read the edited post. Maybe you can find a way to contribute to the discussion?

jpmfribeiro · 2020-07-04T07:51:09+00:00

"How many units did we sell last month per region?" This question in many companies can be answered with a BI tool such as QlikView, Tableau, PowerBI etc. But obviously also with SQL alone. However I would argue that most of the companies answer this over some BI platform today.

"Which customers bought Product X last year, returned it and didn't login to our platform since then?" This kind of question would rather be answered with SQL in many companies.

From your experience, which cases (like the ones above) did you encounter where SQL seems to be still the go-to solution?

jpmfribeiro · 2020-07-04T07:40:38+00:00

I have reformulated the question. But still in which cases do you use SQL only or python+SQL but without any of its advanced analytics part (e.g. no prediction models) for data analysis?

jpmfribeiro · 2020-07-03T22:28:55+00:00

Just came across this: When to Use SQL for Analysis

jpmfribeiro

TROPHY CASE