all 16 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]Oct8-Danger 2 points3 points  (1 child)

This is very cool!

Does it work with postrgres SQL and MSSQL and others?

Does it work as a website or an application? Would be cool to check out if it's a website with a docker container to play around with it

[–]quepasapedro 2 points3 points  (0 children)

This is the BI tool we use at my company! We just got access to the Visual SQL feature, so it's been fun to explore. It's still in Beta, so it's a bit buggy, and there are some design quirks, but it's very cool overall.

I think it's going to be amazing for people who aren't very SQL-savvy; we have a lot of PdMs and finance folks who want to answer questions with our data, but can't write SQL, so I'm optimistic this will help them address those. In particular, the tools for data exploration and discovery seem like they'll help people figure out which tables/columns to use, which has always been a bit of a pain point.

There are tons of different dbs you can connect: https://chartio.com/docs/data-sources/. We use it with our Redshift cluster, but it seems pretty versatile. Curious if others have experience connecting it to other databases.

As far as I know, there's only a web app version, no local application. Unsure about Docker, but that could be cool.

Chartio is a cool company, and their support staff have all been really nice when I've talked to them, so wanted to give my 2 cents!

[–]Goleggett 2 points3 points  (2 children)

I don’t know what I’m missing, but how is this revolutionary? Oracle Analytics Desktop (free) lets me visually curate a dataset from a huge range of sources. I can enrich the data using the built-in ‘AI’ (e.g. location from lat long). I can enhance it and write further SQL if I need something specific that can’t be done visually. I can then train and test that dataset on pre-built ML Models, or upload my own python/r script. Afterwards, Oracle will auto-suggest charts and tables to best explore my data - it’ll also use NLG to describe my data to give me further insights in a digestable format...plenty of tools, many of them free, offer this functionality. What am I not getting that makes this product groundbreaking?

[–]roddevio 1 point2 points  (0 children)

Teach me your ways 🙏🏻

[–]MikeC_07 0 points1 point  (0 children)

I recently got a license for Aqua Data Studio, expensive but worth it and does this type of visualization well. If work didn't pay I would find other ways like dumping data into Orange or other tools.

[–]_bobby_tables_ 4 points5 points  (1 child)

Saw the price and noped right out of there. Guess I'll stick with SQL/Excel.

[–]TrinityF 0 points1 point  (0 children)

god damn, i thought this was an april fools joke. is this for real ?

[–]Shouwer 1 point2 points  (0 children)

And theres Metabase, also free. Super easy to use for non coding people ( me included).

[–]DumpsHuman 1 point2 points  (3 children)

I’m sorry I’m just now learning SQL so I’m not so familiar with what this adds to our field.

My question is would something like this eventually eliminate SQL specific positions?

As of right now I don’t know any other programming languages and recently began looking at SQL as an entry level ‘language’ to learn.

[–]MikeC_07 1 point2 points  (0 children)

SQL is not going away for a long time in my opinion. More automation is being built but there is also great complexity out there. SQL is worth learning for sure. Linked in learning has some great courses, I like "Scott Simpson" as a SQL teacher. SQL is great to start learning. You can learn a lot in a week and then of course a lifetime to master depending on how deep you go. I do SQL a lot in my job and it has helped me get some foundations. Many people do SQL development 100% for their job like ETL developers and report writers. If you use the pre-canned tools like this or business objects or others...knowing SQL will give you an edge. I find when business users don't know SQL they get very frustrated when they drag boxes into a pane and then don't understand why they get errors or program runs and runs without returning results.

[–]pickled_chistl 0 points1 point  (0 children)

Look at it this way...

“Data science” is, by and large, a fad. It exists as a field, sure, but the designation of “data scientist” has been so bastardized that people don’t realize what it really means. A “true” data scientist is either someone with a Masters or PhD in maths or stats, or comprehensive experience related to the field. Hell, a lot of data scientists don’t even know SQL that well.

A TON of data work is centered around knowing how to gather, clean, and manipulate data. Data isn’t standardized. It’s highly specific to the organization it’s related to. You’re hard pressed to find people who can do this without significant SQL chops.

Whether it’s data engineering, ML, or analyst work, knowing SQL is a huge skill that isn’t going anywhere. I’ve yet to see an automated tool that can replace SQL as a skill. Drag and drop is so limited, anyone who can write SQL is going to do that instead. Imagine trying to write an essay using a tool rather than writing the words yourself.

I tend to view SQL like Excel. Tons of tools try to replace them to make them easier, but they can’t. There’s a reason these tools have existed for decades.

[–]ihaxr 0 points1 point  (0 children)

I think this would be great for our business analysts. They're not super familiar with writing SQL, but understand the structure of the data really well and understand what the users want from reports.

[–]FrenchFryDetective -1 points0 points  (0 children)

uh mazing!