superset
nba-sql
Our great sponsors
superset | nba-sql | |
---|---|---|
137 | 14 | |
57,792 | 160 | |
2.4% | - | |
9.9 | 5.3 | |
5 days ago | 5 months ago | |
TypeScript | Python | |
Apache License 2.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
superset
-
Apache Superset
Had a very good experience with Superset.
Superset allowed us to replace Tableau and not looking back
Took me a while figure out how to embed it into my app using Superset Embedded SDK.
Superset Embedded SDK - "Embedded SDK allows you to embed dashboards from Superset into your own app, using your app's authentication. Embedding is done by inserting an iframe, containing a Superset page, into the host application."
https://github.com/apache/superset/tree/master/superset-embe...
Superset is based on very high quality and well maintained chart library eChart
https://echarts.apache.org/examples/en/#chart-type-linesG
Community Roadmap
https://github.com/apache/superset/projects?query=is%3Aopen
Huge respect to Preset.io and its team for contributing to the project and keep it in a great shape
Superset source code is very easy to read and understand, and as a result it's possible to implement some advanced caching techniques reduce the load on charts.
No BI is perfect.
Watching Superset for years gives me confidence the project will work as supposed down the road, and eventually some of its packages can be reusable for all kind of visualizations and data hacking.
Superset is absolutely phenomenal. I really hope Microsoft eventually releases all of their customizations they made to it internally to the OS community someday.
-
A modern data stack for startups
Do you have any thoughts on Superset? Did you consider it as a candidate?
For anyone who doesn't know: https://superset.apache.org/
(There's at least one service that offers managed Superset hosting if that's what you're looking for; it's easy to find so I won't link it here.)
I recently ran a little shootout between Superset, Metabase, and Lightdash. All have nontrivial weaknesses but I ended up picking Lightdash.
Superset the best of them at _data visualization_ but I honestly found it almost useless for self-serve _BI_ by business users. This issue on how to do joins in Superset (with stalebot making a mess XD) is everything difficult about Superset for BI in a nutshell. https://github.com/apache/superset/issues/8645
Metabase is pretty great and it's definitely the right choice for a startup looking to get low cost BI set up. It still has a very table centric view, but feels built for _BI_ rather than visualization alone.
Lightdash has significant warts (YAML, pivoting being done in the frontend, no symmetric aggregates) but the Looker inspiration is obvious and it makes it easy to present _groups of tables_ to business users ready to rock. I liked Looker before Google acquired it. My business users are comfortable with star and snowflake schemas (not that they know those words) and it was easy to drop Lightdash on top of our existing data warehouse.
- FLaNK Stack Weekly for 20 Nov 2023
-
Yandex open sourced it's BI tool DataLens
Or like not being able to delete a user without running some SQL:
https://github.com/apache/superset/issues/13345
Almostl instantly run into this issue setting up a test instance of Superset. And the issue has been around for years.
-
Apache Superset: Installing locally is easy using the makefile
Are you interested in trying out Superset, but you're intimidated by the local setup process? Worry not! Superset needs some initial setup to install locally, but I've got a streamlined way to get started - using the makefile! This file contains a set of scripts to simplify the setup process.
-
More public SQL-queryable databases?
Recently I discovered BigQuery public datasets - just over 200 datasets available for directly querying via SQL. I think this is a great thing! I can connect these direct to an analytics platform (we use Apache Superset which uses Python SQLAlchemy under the hood) for example and just start dashboarding.
-
Real-time data analytics with Apache Superset, Redpanda, and RisingWave
In today's fast-paced data-driven world, organizations must analyze data in real-time to make timely and informed decisions. Real-time data analytics enables businesses to gain valuable insights, respond to real-time events, and stay ahead of the competition. Also, the analytics engine must be capable of running analytical queries and returning results in real-time. In this article, we will explore how you can build a real-time data analytics solution using the open-source tools Redpanda a distributed streaming platform, Apache Superset, a data visualization, and a business intelligence platform, combined with RisingWave a streaming database.
nba-sql
-
Jalen Green Shot Attempts 2021-2022 Season [OC]
Repost but I tried to make it look nicer. Data Source: https://github.com/mpope9/nba-sql
-
How often has a playoff team done what Dallas did yesterday?
This is what I've found - https://github.com/mpope9/nba-sql
-
nba-sql: v0.0.4 - Alpha Windows Client Release!
Thanks! I used Postgres and Apache Superset. I wrote a small wiki on how to use it https://github.com/mpope9/nba-sql/wiki/Data-Visualization-with-Superset. Superset doesn't work with SQLite sadly.
To start, the alpha version of the Windows client can be found here. Basically, if you click the Start button you'll have your very own SQLite database generated in the same directory as the .exe file. It can take some time, but there is an option to skip some tables which will greatly increase the speed (namely shot_chart_detail if you don't need every shot in the latest season, and play_by_play if you don't need every play). To connect and query this database, I use DBeaver, a great free tool. Set your connection to SQLite, allow it to install the required driver, and point it to the new DB that was generated. Here is an example query to find Russell Westbrook's total triple doubles in the 2020-21 season:
-
nba-sql: v0.0.2 Release
The latest Postgres dump can be found here: https://github.com/mpope9/nba-sql/releases/tag/v0.0.2. It is a compressed file, using xz. After decompressing it, you can run it using psql -U -P nba < nba.sql.
-
nba-sql: A Relational NBA Database
There is also a schema diagram here that explains everything: https://github.com/mpope9/nba-sql/blob/master/image/NBA-ER.jpg
There is an image of the ER Diagram here. The arrows show foreign key constraints. The model definitions can be found in stats/models.
What are some alternatives?
streamlit - Streamlit — A faster way to build and share data apps.
jupyter-dash - OBSOLETE - Dash v2.11+ has Jupyter support built in!
Apache Hive - Apache Hive
lightdash - Open source BI for teams that move fast ⚡️
Metabase - The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:
django-project-template - The Django project template I use, for installation with django-admin.
react-admin - A frontend Framework for building data-driven applications running on top of REST/GraphQL APIs, using TypeScript, React and Material Design
nifi - Apache NiFi
Baserow - Open source no-code database and Airtable alternative. Create your own online database without technical experience. Performant with high volumes of data, can be self hosted and supports plugins
Airflow - Apache Airflow - A platform to programmatically author, schedule, and monitor workflows
appsmith - Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.
dagster - An orchestration platform for the development, production, and observation of data assets.