Looker is a business intelligence platform with an analytics-oriented application server that sits on top of relational data stores. The Looker platform includes an end-user interface for exploring data, a reusable development paradigm for creating data discovery experiences, and an extensible API set so the data can exist in other systems. Looker enables anyone to search and explore data, build dashboards and reports, and share everything easily and quickly.
Looker might be a bit more popular than DSQ. We know about 14 links to it since March 2021 and only 11 links to DSQ. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.
You might want to look at tsv-utils, or a similar project: https://github.com/eBay/tsv-utils (No longer maintained, but has links to lots of other projects). - Source: Hacker News / 8 months ago
SPyQL is really cool and its design is very smart, with it being able to leverage normal Python functions! As far as similar tools go, I recommend taking a look at DataFusion[0], dsq[1], and OctoSQL[2]. DataFusion is a very (very very) fast command-line SQL engine but with limited support for data formats. Dsq is based on SQLite which means it has to load data into SQLite first, but then gives you the whole breath... - Source: Hacker News / over 1 year ago
> dsq registers go-sqlite3-stdlib so you get access to numerous statistics, url, math, string, and regexp functions that aren't part of the SQLite base. (https://github.com/multiprocessio/dsq#standard-library) Ah, I wondered if they rolled their own SQL parser, but no, I now see the sqlite.go in the repo and all is made clear. - Source: Hacker News / over 1 year ago
I am currently evaluating dsq and its partner desktop app DataStation. AIUI, the developer of DataStation realised that it would be useful to extract the underlying pieces into a standalone CLI, so they both support the same range of sources. Dsq CLI - https://github.com/multiprocessio/dsq. - Source: Hacker News / almost 2 years ago
This is a cool project! But if you query Excel and ODS files with dsq you get the same thing plus a growing standard library of functions that don't come built into SQLite such as best-effort date parsing, URL parsing/extraction, statistical aggregation functions, math functions, string and regex helpers, hashing functions and so on [1]. [0] https://github.com/multiprocessio/dsq [1]... - Source: Hacker News / about 2 years ago
Then in the "foldername" you can have 5 folders, each one for each of the groups. This means that when group1 enters looker.com, his default page will be the "foldername", which contains group1folder (he cannot see the rest of the folders if you have set the permissions correctly for each folder). Source: over 1 year ago
Even if you want to make Wide Tables, combining fact and dimensions is often the easiest way to create them, so why not make them available? Looker, for example, is well suited to dimensional models because it takes care of the joins that can make Kimball warehouses hard to navigate for business users. - Source: dev.to / over 1 year ago
We take daily snapshots of test results, aggregate them, and send Looker dashboards to the appropriate teams. - Source: dev.to / over 2 years ago
Dashboard: I like to use Datastudio because it's easy (just like using google sheets), but you can also try out Looker. Source: over 2 years ago
For Growth and larger, I would recommend Looker. The only reason I wouldn't recommend it for the smaller company stages is that the cost is much higher than alternatives such as Metabase. With Looker, you define your data model in LookML, which Looker then uses to provide a drag-and-drop interface for end-users that enables them to build their own visualizations without needing to write SQL. This lets your... - Source: dev.to / over 2 years ago
Superintendent.app - Superintendent.app is a Desktop app that enables you to write SQL on CSV files.
Tableau - Tableau can help anyone see and understand their data. Connect to almost any database, drag and drop to create visualizations, and share with a click.
fx - Command-line JSON processing tool
Microsoft Power BI - BI visualization and reporting for desktop, web or mobile
AWS Config - Cloud Monitoring
Sisense - The BI & Dashboard Software to handle multiple, large data sets.