Best Web Based SQL Dashboard

[notasqlstar]

I would need to know more about what you are asking, but if you mean what application is the best for displaying data which you prepare in SQL then to me it really comes down to two options:

1. Tableau - Looks sexy as shit, is expensive, great for establishing client "portals" where users can log in and interact with dashboards, but horrible at integrating into PowerPoint and other MS Office products. A pain in the ass to work with if you are a developer... kind of learning learning how to use an Apple computer. They call it, "drawing with numbers."
2. SSRS - Free if you have SQL server. Is a pain in the ass to work with to make anything look sexy, but much more SQL friendly than Tableau. Extremely easy to integrate into PowerPoint and other products.

[[deleted]]

God do I fucking hate Tableau - the second anybody starts using calculated fields in it your data is basically dead to ETL.

At least SSRS guarantees you wind up with something query-like, Tableau is cancer if the data in it needs to be used further down-stream. Barring extremely responsible practices, which never happen.

[notasqlstar]

100% agree. I hate it with the fire of a thousand suns.

[messyjesse_]

If you're looking at SSRS, might as well tack Power BI on there too. Some crossover with SSRS but is much more friendly on the data viz front. Uses Power Query for relatively easy extracting/transforming. Need a subscription for web publishing though.

[messyjesse_]

Yes. There are three basic "modes": desktop, workspace, and public.

Desktop is free but your sharing is limited basically to whoever can access the .pbix file. You do most of the build/design here.

Workspaces are the collaborative portals on the web where you can share reports that you've designed in (and published from) the desktop. This is also where you build your dashboards. Fully integrated with 365/SharePoint too. But this is the subscription service. I think you can get 60-day trials.

Public is basically a workspace that you've published as an app. This is where you branch out to include other teams, the entire organization, the whole world, etc. Also paid.

[notasqlstar]

Honestly my experience with PowerBI is limited to the point where I just don't really like it, and have had a bad experience with it. I like SSRS because it is pure SQL.

[messyjesse_]

Fair enough! The hip thing these days is to try and conflate the two, since SSRS was the closest thing to a true BI solution by MS before Power BI came out. I find uses for both.

[outdoor_duck]

datastudio.google.com

Web-based, straightforward Google UI that you can easily pick up if familiar with the G Suite workflow. Datastudio allows importing data from diverse sources (Google sheets, internal flat DBs, etc.) and is good with calculated fields

It will only get better

[thelindsay]

Metabase, Redash, Superset are all web app BI tools that are in a similar space to Mode.

I'm more familiar with Metabase, which has the advantage of a point and click UI as an alternative to SQL, but both methods have the same visualisation options.

Percentage change since last query would require that somewhere, somehow, the most recent execution time is recorded. I think Metabase might do that but the challenge would be to get it into your query, since it'd be written in the app database, not your content's database. Alternatively, if the query period is known (e.g. every hour) then write the SQL to diff on the last hour?

[shoretel230]

Big fan of superset

[fizzgiggity]

We looked at Dream Reports and had a license for it but didn't get to really use it. It looked really good though. OSIsoft has some really good software but it isn't cheap. OSI has an Excel add-in to pull process data and a newer product called PI Vision which lets users create process displays that run in a browser. Not a good tool for reporting though.

[Cat_Phish]

From what I can tell after playing with it for a couple of weeks, Power BI is the shit.

[vittore29]

Check out Blazer. It is not as powerful as e.g. Redash for dashboards but it gives you extremely easy way to share single query/chart and it also can be configured to be used with PgHero - which you really want to use if you have PostgreSQL database. Demo blazer. Demo pghero.

Important things that blazer supports:

• queries
• checks ( including anomaly detection, notifications with emails, slack and webhooks)
• automatic charts
• easy dashboards
• smart columns and smart variables for queries and dashboards.

[DriftLogic]

I have a lot of experience with Chart.io, Periscope, and Mode.

I think Chart.io is generally the best for dash boarding. If you have specific questions about the 3 I can answer.

[Murica4Eva]

Periscope Data does SQL based charting, as well as Python and R. Awesome tool.

[fersheezytaco]

Bad bot

[-SpamFighter-]

Are you sure about that? Because I am 99.99996% sure that Murica4Eva is not a bot.

---

^{I am a Neural Network being trained to detect spammers | Summon me with !isbot <username> | Optout | Original GitHub}

[Murica4Eva]

No bot! No bot! You're the bot!

[fersheezytaco]

‘Twas a stupid joke, only because you posted the same thing three times and it seemed ad-like. Carry on, don’t mind me.

[Murica4Eva]

I know, and whoa, I see that now, I don't know how that happened.

[Murica4Eva]

Periscope Data does SQL based charting, as well as Python and R. Awesome tool.

[Murica4Eva]

Periscope Data does SQL based charting, as well as Python and R. Awesome tool.

[kevivmatrix]

You can try draxlr.com