📈

Apache Superset

Kusanthula

Kufufuza deta kwamakono ndi nsanja yowonetsera zowunikira mabizinesi

Kukhazikitsa

Kutumizidwa kwa anthu: 2-5 min
gulu: Kusanthula
Min RAM: 2048MB
Thandizo: Tikiti ndi imelo

Share this guide

Kufotokozera

Apache Superset ndi nsanja yamakono yamakampani ya business intelligence ndi kufufuza kwa data, yomwe imathandiza ogwiritsa ntchito a mibadwo yonse ya luso kufufuza ndi kuwonetsa data yawo mosavuta. Poyamba inapangidwa ku Airbnb, ndipo tsopano ndi projekiti yapamwamba ya Apache Software Foundation. Superset imapereka mawonekedwe olemera komanso osavuta pomanga ma dashboard, ma chart, ndi mapulogalamu a data analytics popanda kufunika kwa SQL yambiri kapena luso lopanga mapulogalamu.

Pakati pake, Superset imamangidwa pa semantic layer yamphamvu yolumikizana ndi database kapena data warehouse iliyonse yomwe imamvetsa SQL. Imathandizira PostgreSQL, MySQL, SQLite, Oracle, Microsoft SQL Server, Amazon Redshift, Google BigQuery, Snowflake, Apache Drill, Apache Druid, Apache Hive, Presto, ClickHouse, ndi zina zambiri kudzera mu ma connector a SQLAlchemy. Kulumikizana kumeneku kumalola mabungwe kuphatikiza analytics m'magwero osiyanasiyana a data kudzera pa mawonekedwe amodzi.

Nsanjayi ili ndi laibulale yayikulu ya zowonetsera yokhala ndi mitundu yopitirira 40 ya ma chart okonzedweratu, kuphatikizapo time-series chart, bar chart, pie chart, mapu a geography, heatmap, pivot table, ndi zowonetsera zapamwamba monga Sankey diagram ndi sunburst chart. Mtundu uliwonse wa zowonetsera ukhoza kusinthidwa kwambiri kudzera pa UI yosavuta, kotero kuti akatswiri a analytics amatha kusintha zowonetsera zikhale zogwirizana ndi zosowa za bizinesi popanda kulemba code.

SQL Lab ya Superset ndi IDE yamphamvu yofufuzira data, yokhala ndi mbiri ya ma query, ma query osungidwa, kukonza nthawi ya ma query, ma tab ambiri, ndi ma preview a data ophatikizidwa. Thandizo la Jinja templating mu ma query limalola kupanga SQL mwamphamvu kutengera ma filter a dashboard, kupanga zochitika zolumikizana za analytics. Zotsatira za ma query zitha kutumizidwa ku CSV kuti zifufuzidwenso kapena kugawidwa.

Pa malo a VPS hosting, Superset imagwira ntchito ngati njira yodziyendetsera yokha m'malo mwa nsanja za BI zamalonda monga Tableau, Looker, kapena Power BI, ndipo imapereka ntchito zofanana popanda ndalama za layisensi pa wogwiritsa aliyense kapena kudalira wopereka. Kapangidwe kake kamathandiza kukula mopingasa kudzera pa load balancing, ndipo kamatha kugwira ntchito za mlingo wamakampani ndi ogwiritsa ntchito zikwi zingapo nthawi imodzi komanso mizere ya data mamiliyoni.

Zinthu za chitetezo ndi ulamuliro zikuphatikizapo role-based access control (RBAC), chitetezo cha dataset ndi mzere (row-level security), kuphatikizana ndi ma OAuth provider (Google, GitHub, Okta), authentication ya LDAP, ndi audit logging yokwanira. Thandizo la multi-tenancy limalola malo ogwirira ntchito odzipatula a madipatimenti kapena makasitomala osiyanasiyana mkati mwa kukhazikitsa kumodzi kwa Superset.

Kuthekera kwa nsanjayi kukulitsidwa kudzera mu kapangidwe ka plugin kolimba kumalola opanga kupanga zowonetsera zawo, ma database connector, ndi zigawo za dashboard. Gulu lomwe likukula limathandiza ndi ma plugin ndi zowonjezera, ndipo likukulitsa mosalekeza luso la Superset ndi ma integration ake.

Zithunzi zazikulu

Kulumikizana Kwa Database Kulikonse

Thandizo lachibadwa la ma database opitirira 40 kudzera mu SQLAlchemy, kuphatikizapo PostgreSQL, MySQL, BigQuery, Snowflake, Redshift, Druid, ClickHouse, ndi Presto, kuti pakhale analytics yogwirizana.

Laibulale Yolemera Ya Zowonetsera

Ma chart okonzedweratu opitirira 40, kuphatikizapo time-series, mapu a geospatial, ma pivot table, ma Sankey diagram, ndi zowonetsera zapamwamba zokhala ndi makonzedwe ambiri.

IDE ya SQL Lab

Mkonzi wamphamvu wa SQL wokhala ndi mbiri ya ma query, ma query osungidwa, mawonekedwe a ma tab ambiri, Jinja templating, kukonza nthawi ya ma query, ndi ma preview a data ophatikizidwa pa kufufuza.

Chitetezo Chamakampani Ndi Ulamuliro

Role-based access control, row-level security, zilolezo za dataset, kuphatikizana kwa OAuth/LDAP, audit log yokwanira, ndi thandizo la multi-tenancy.

Ma Dashboard Olumikizana

Chomanga cha dashboard cha drag-and-drop chokhala ndi cross-filtering, drill-down, makonzedwe osinthika pa zida zosiyanasiyana, ndi kutsitsimutsa data nthawi yeniyeni pa analytics yamphamvu.

Kapangidwe Kokulirakulira

Kapangidwe kokulirakulira mopingasa kothandiza load balancing, zigawo za caching (Redis), kuchita ma query mosalunjika (Celery), ndi ogwiritsa ntchito ambiri nthawi imodzi pa mlingo wamakampani.

Kugwiritsa ntchito Cases

- Ma Dashboard a Business Intelligence: Pangani ma dashboard a akuluakulu, kuyang'anira ma KPI, kusanthula kwa malonda, ndi malipoti a ntchito zogwiritsa ntchito data popanga zisankho
- Kufufuza ndi Kusanthula Data: Lolani akatswiri a analytics kufufuza ma dataset, kupanga ma query a nthawi yomweyo, ndi kupanga zowonetsera popanda thandizo la engineering
- Mapotolo a Customer Analytics: Pangani analytics yolowedwa mu mapulogalamu a SaaS yopereka kwa makasitomala chidziwitso cha kagwiritsidwe ntchito kawo, magwiridwe antchito, ndi zochitika
- Kuwunika Nthawi Yeniyeni: Yang'anirani ma metric a mapulogalamu, magwiridwe a dongosolo, deta ya masensa a IoT, ndi zochitika za bizinesi ndi ma dashboard omwe amadzisintha okha
- Nsanja ya Self-Service BI: Lolani ogwiritsa ntchito a bizinesi m'madipatimenti onse kupanga malipoti awo ndi zowonetsera zawo kuchokera ku ma dataset oyendetsedwa
- Multi-Tenant Analytics: Perekani malo a analytics odzipatula a makasitomala, madipatimenti, kapena magawo a bizinesi osiyanasiyana, ndi row-level security

Kukhazikitsa Guide

Ikani Apache Superset pa Ubuntu VPS pogwiritsa ntchito pip mu Python virtual environment. Pangani database yodzipereka (PostgreSQL ndiyo yovomerezeka) yosunga metadata ya Superset. Ikani Redis ya caching ndi thandizo la async query.

Pangani virtual environment ndi python3 -m venv venv, ilowetseni, ndipo ikani phukusi la superset ndi pip install apache-superset. Yambitsani database ndi superset db upgrade, ndipo pangani wogwiritsa ntchito wa admin ndi superset fab create-admin.

Lowetsani data yachitsanzo ndipo yambitsani Superset ndi lamulo la superset init. Konzani superset_config.py ndi SECRET_KEY, ma connection string a database, ndi makonzedwe a cache a Redis. Khazikitsani ma Celery worker kuti azichita ma query mosalunjika pa ma dataset akuluakulu.

Konzani web server (Gunicorn) ndi reverse proxy (Nginx) pa deployment yopanga. Yatsani HTTPS ndi ziphaso za Let's Encrypt. Khazikitsani ma systemd service a Superset web server ndi Celery worker kuti ziyambe zokha ndikuyang'aniridwa.

Pa ma deployment a high availability, yendetsani ma Superset web server angapo kumbuyo kwa load balancer, konzani database yogawana ya metadata ndi cache ya Redis, ndipo ikani pool yosiyana ya Celery worker yochitira ma query. Yang'anirani magwiridwe antchito ndipo kulitsani ma worker malinga ndi katundu wa ma query.

Kusintha kwa Malamulo

Makonzedwe a Superset amayendetsedwa kudzera mu fayilo ya superset_config.py mu PYTHONPATH. Konzani SECRET_KEY yobisa ma session (ipangidwe ndi openssl rand -base64 42), SQLALCHEMY_DATABASE_URI yosungira metadata, ndi CACHE_CONFIG ya caching ya Redis.

Khazikitsani ma connection a database kudzera mu UI kapena lamulo la superset set_database_uri. Konzani row-level security (RLS) popanga ma SQL filter omwe amagwiritsidwa ntchito pa ma dataset kutengera maudindo a ogwiritsa ntchito. Yatsani ma dashboard a anthu onse ndi PUBLIC_ROLE_LIKE = "Gamma" kuti mugawane kunja.

Sinthani authentication poyika AUTH_TYPE (DATABASE, OAUTH, LDAP, kapena REMOTE_USER) ndi makonzedwe ofanana a AUTH_CONFIG. Phatikizani ndi ma OAuth provider (Google, GitHub, Okta) kapena LDAP/Active Directory ya kampani kuti mupeze SSO.

Njira zabwino zimaphatikizapo kuyatsa chitetezo cha CSRF, kukonza CORS pa ma dashboard olowedwa, kukhazikitsa malire a nthawi pa ma query kuti asatenge nthawi yaitali, kuyatsa kuyerekezera mtengo wa query pa kasamalidwe ka zida, kukonza ma email alert a malipoti okonzedwa, ndi kukhazikitsa njira yosungira kopi ya metadata database. Gwiritsani ntchito ma environment variable pa zidziwitso zachinsinsi m'malo molemba mwachindunji mu config file.

Zofunikira zaukadaulo

Zofunikira pa dongosolo

  • Kukumbukira: 2048MB RAM

Voterani Nkhaniyi

★★★★★
-
Kutsitsa...

Kodi Mwakonzeka Kutumiza Fomu Yanu Yofunsira? Apache Superset?

Kuyambiranso m'maola angapo ndi njira yathu yokhayo ya VPS

Kugwiritsa ntchito mu • pafupifupi 2 mphindi Full root kulowa • Support ndi tikiti ndi email