seektable

8 ms·

31.
Ask HN: How do you choose a solution for embedded analytics?
2 points by seektable 5y ago|4 comments
32.
by seektable 5y ago
Snowflake is a DW solution - in most cases it is populated from other OLTP DBs and uses as a data source for BI tools. What is the purpose of editing data directly in Snowflake?..
33.
by seektable 6y ago
I see BI tools here (like Superset, Metabase etc) -- for use-cases when updates are not needed, read-only access to DB may be organized with https://www.seektable.com (not open source, but has 'personal usage' free tie
34.
by seektable 6y ago
Shameless plug: for adhoc reporting by non-technical users our https://www.seektable.com also can be considered (esp. if your users heavily use pivot tables), it is closed-source but has a fully functional free accounts & se
35.
by seektable 6y ago
well, try https://www.seektable.com -- with this tool you can make a pivot table just in a few clicks and you may found it much more useful for ad-hoc reporting than Excel/Sheets. For sensitive data self-hosted version can
36.
by seektable 6y ago
> The painful process of data discovery using Excel and Snowflake Why don't use other BI tools that could do pivot tables from Snowflake without pain? For example, our SeekTable can be used for this purpose.
37.
by seektable 6y ago
For CSV/TSV files SeekTable can do various reporting (including pivots) really quickly, naturally just in a few clicks.
38.
by seektable 6y ago
Take a look to https://www.seektable.com , it has native connector for MongoDB. Both cloud & self-hosted versions are available; paid subscriptions are not needed for personal/individual usage.
39.
by seektable 6y ago
For Excel-like analysis with pivot tables take a look to our https://www.seektable.com; it can connect to various DW that are suitable for near real-time big-data analytics (like Redshift, BigQuery, Snowflake, Clickhouse). SeekT
40.
by seektable 6y ago
JFYI SeekTable already has a connector for ClickHouse :) it works over native binary protocol (with connection-level compression). Since you have control over SQL query and SQL expressions used for dimensions/measures ClickHouse SQL-di
41.
by seektable 6y ago
Hi Vlad, what BI tools currently can connect to QuestDB for ad-hoc reporting (without need to write SQL queries by hands)? I guess popular solutions like Tableau/PowerBI doesn't support QuestDB. Is there a demand for BI tools that
42.
by seektable 6y ago
SYMBOL concept sounds like ClickHouse LowCardinality (or maybe implicit 'dictionary').
43.
NReco.PivotData library goes open source [C#/.NET](github.com)
2 points by seektable 6y ago|0 comments
44.
by seektable 6y ago
+1 we use SQLite in our BI tool to keep information about user accounts, data sources (cubes) / reports configs, access control rules etc. SQLite works like a charm even in cloud version where we have > 6,000 registered user account
45.
by seektable 6y ago
You mentioned pivot tables, so reporting tools may be more appropriate in your case. Say, you can keep using Google Sheets, and sync the worksheet with BI tool that for various reports. A lot of totally free options here (including SeekTabl
46.
by seektable 6y ago
What you describe sounds like a mix of personal knowledge base that seats on the top of existing search engines, public and maybe even private databases. Major difference is here: * when you make a query to this knowledge base, it has a his
47.
by seektable 6y ago
SeekTable also can use BigQuery as a data source, however it is more about reports sharing and quick ad-hoc queries - to make this possible data source should be configured first.
48.
by seektable 6y ago
> The reality check is that none of those tools stands on its own. so true! Only exception is maybe CSV data. Re SeekTable: it also supports usage scenario when data sources ('cubes') are configured by power user (with some IT
49.
by seektable 7y ago
Yandex ClickHouse one more free/open source solution that can be considered for this purpose. Setup/maintenance may be a bit tricky - but you'll be surprised how fast CH executes your ad-hoc queries (SQL!) over billions of ro
50.
by seektable 7y ago
New cases may be calculated as a difference between cummulative prev and next day. This is how daily cases are shown here by JHU dataset: http://covid-19.seektable.com/report/fe66549d73c64773bd6712e...
51.
by seektable 7y ago
Also you can choose concrete country in "Params" tab (this is row-level filter). One more useful parameter is "Case Type" which allows you to switch "Cases" measure between Confirmed/Deaths/Active&#x2
52.
by seektable 7y ago
http://covid-19.seektable.com/ - it lacks the rate per 100k, but data source is trusted (JHU) and refreshed daily.
53.
Explore Covid-19 data by John Hopkins University (auto updated daily)(covid-19.seektable.com)
1 points by seektable 7y ago|0 comments
54.
by seektable 7y ago
Metabase is primarily self-hosted Redash can be self-hosted (and our SeekTable also has on-premise version)
55.
Self-service analytics with SeekTable [web BI tool review](itnext.io)
1 points by seektable 7y ago|0 comments
56.
Price comparison of low-cost web BI tools in 2020(web-reporting-tools.info)
2 points by seektable 7y ago|0 comments
57.
Embedded Analytics: An Alternative to PowerBI Premium(embedded-analytics.info)
2 points by seektable 7y ago|0 comments
58.
by seektable 7y ago
> Do you want latency to be larger?? Instant results are good for sure, however very often few more seconds - in addition to instant results! - is not a problem if late , more carefully processed results can save minutes of my time -
59.
by seektable 7y ago
We don't need more search engines like google, we need a new kind of engines that will supersede google/bing/etc and break the following axioms: * search engine is a cloud service, which is not controlled by user of that en
60.
by seektable 7y ago
For his purpose you can check 'Team Sharing' feature of our BI tool (SeekTable): https://www.seektable.com/help/share-report-to-team

More ›