📈

Apache Superset

Kuongorora

Kutsvaga data remazuva ano uye chikuva chekuona nezvekuongorora mabhizinesi

Kugoverwa kweInfo

Kutumirwa kwemauto: 2-5 min
chikamu: Kuongorora
Min RAM: 2048MB
Tsigiro: Tickets uye email

Shandisa iyi bhuku

_Zvinyorwa

Apache Superset ibasa re business intelligence uye data exploration rinonzi yakagadzirira masangano, rinoita kuti vashandisi vemanyorerwo ese vakwanise kuongorora nekuona data yavo nyore. Yakatanga kugadzirwa paAirbnb uye ikozvino iprojekti yepamusoro yeApache Software Foundation, Superset inopa interface yakapfuma, iri nyore kushandisa yekuvaka madhashibhodhi, machati, uye application dzekuongorora data pasina SQL yakawanda kana chirongwa chakasimba.

Pakati pazvo, Superset yakavakwa pane semantic layer yakasimba inobatanidza kune database ipi zvayo ine SQL kana data warehouse. Kutsigira kunosanganisira PostgreSQL, MySQL, SQLite, Oracle, Microsoft SQL Server, Amazon Redshift, Google BigQuery, Snowflake, Apache Drill, Apache Druid, Apache Hive, Presto, ClickHouse, nezvimwe zvakawanda kuburikidza nema connector eSQLAlchemy. Kubatanidzwa kwakafara uku kunobvumira masangano kubatanidza analytics pamasosi akasiyana edata kuburikidza ne interface imwe chete.

Pulatifomu ine raibhurari yakakura yekuona data ine machati anopfuura 40 akagadzirwa kare anosanganisira machati enguva, machati emabhari, machati epayi, mamepu ekunzvimbo, heatmaps, pivot tables, uye kuona kwakaoma senge Sankey diagrams nesunburst charts. Mhando yega yekuona data inogona kugadziridzwa zvakanyanya kuburikidza ne UI nyore, zvichibvumira vaongorori kugadzirisa zvinoratidzwa kuti zvienderane nezvinodiwa nebhizinesi pasina kunyora kodhi.

SQL Lab yeSuperset inopa IDE yakasimba yekuongorora data ine zvinhu zvinosanganisira nhoroondo yemaqueries, maqueries akachengetwa, kuronga maqueries, ma tabs akawanda, uye preview dzedata dzakabatanidzwa. Kutsigira kweJinja templating mumaqueries kunobvumira kugadzira SQL yakasiyana zvichienderana nemafiritari edhashibhodhi, zvichigadzira maitiro ekuongorora anoita kuti vashandisi vabatanidzwe. Mhedzisiro yemaqueries inogona kutumirwa muCSV kuti iongororwe zvimwe kana kugoverwa.

Kune VPS hosting environments, Superset inoshanda sealternative yekuzvivhurira yemapuratifomu eBI akaita seTableau, Looker, kana Power BI, ichipa mabasa akafanana pasina mutengo we license pamushandisi wega wega kana kuvharirwa nemuvaki. Architecture yepurogiramu inotsigira kukura kwakatwasuka kuburikidza nekugovera mutoro uye inogona kubata mabasa emasangano akakura ane vashandisi zviuru zvakawanda vari vachishandisa panguva imwe chete uye data remamiriyoni emitsara.

Zvinhu zvekuchengetedza nekutonga zvinosanganisira role-based access control (RBAC), kuchengetedzwa kwedataset nemitsara, kubatanidzwa neOAuth providers (Google, GitHub, Okta), LDAP authentication, uye audit logging yakazara. Kutsigira kwemultitenancy kunobvumira mashandiro akaparadzaniswa emadhipatimendi kana vatengi vakawanda mukati meSuperset imwe chete.

Kukwanisa kwepurogiramu kuwedzerwa kuburikidza nearchitecture yeplugin yakasimba kunobvumira vagadziri kugadzira zvinoonekwa zvavo, zvinobatanidza data, nezvikamu zvedhashibhodhi. Vashandi vakawanda vanogovera mapurogiramu ekuwedzera uye zvinowedzera, zvichiwedzera zvigona nenzira dzekubatanidza zvakare.

Zvinhu zviviri zvakakosha

Kubatanidzwa Kwakapararira Kwedatabase

Kutsigira kwakavakwa mukati kwe 40+ databases kuburikidza neSQLAlchemy kunosanganisira PostgreSQL, MySQL, BigQuery, Snowflake, Redshift, Druid, ClickHouse, nePresto kune analytics yakabatanidzwa.

Raibhurari Yakapfuma Yekuona Data

Machati anopfuura 40 akagadzirwa kare anosanganisira enguva, mamepu ekunzvimbo, pivot tables, Sankey diagrams, uye kuona kwakaoma nezvisarudzo zvakawanda zvekugadzirisa.

SQL Lab IDE

Mhariri we SQL ane simba ane nhoroondo yemaqueries, maqueries akachengetwa, interface yema tabs akawanda, Jinja templating, kuronga maqueries, uye preview dzedata dzakabatanidzwa kuongorora.

Kuchengetedza Kwakasimba Nekutonga Masangano

Role-based access control, row-level security, kubvumidzwa kwe dataset, kubatanidzwa kweOAuth/LDAP, audit logs yakazara, uye kutsigira multi-tenancy.

Madhashibhodhi Anoita Zvinhu

Muvaki wedhashibhodhi wekudonha-uye-kubata ane cross-filtering, drill-down, mapeji anoshanduka, uye kugadziridzwa kwedata renguva chaiyo kune analytics inoshanduka.

Architecture Inokura

Dhizaini inokura yakakwana inotsigira load balancing, mativi ekucheneka (Redis), kuita maqueries asingadzokororwi (Celery), uye vashandisi vakawanda munzvimbo dzakakura.

Kushandisa Zvikonzero

- Madhashibhodhi eBusiness Intelligence: Gadzira madhashibhodhi ezvatungamiriri, kutarisa KPI, kuongorora kutengesa, uye kushuma kwekushanda kuti vagadzire zvisarudzo zvinotsanangurwa nedata
- Kuongorora uye Kutsvagisisa Data: Batsira vaongorori kuongorora madataset, kuita maqueries ekuda kwavo, uye kugadzira zvinoonekwa vasina rutsigiro rekuvaka
- Mapoto Ekuongorora Vatengi: Vaka analytics yakaiswa mumapurogiramu eSaaS vachipa vatengi ruzivo rwekushandisa kwavo, kushanda, uye mabhenji
- Kutarisa Munenguva Chaiyo: Tarisa metrics dzeapplication, kushanda kwesisitimu, data yemasensor eIoT, uye zviitiko zvebhizinesi nemadhashibhodhi anozvigadzirisa
- Pulatifomu Yekuzvishandira BI: Batsira vashandisi vebhizinesi mumadhipatimendi akasiyana kugadzira mishumo yavo nezvinoonekwa kubva kune ma dataset akatongwa
- Multi-Tenant Analytics: Ipa nzvimbo dzeanalytics dzakaparadzaniswa kune vatengi, madhipatimendi, kana mayuniti ebhizinesi akasiyana ine kuchengetedzwa kwemitsara yedata

Kuiswa kweGuide

Isa Apache Superset pa Ubuntu VPS uchishandisa pip mu Python virtual environment. Gadzira database yakazvimiririra (PostgreSQL inokurudzirwa) yekuchengeta metadata yeSuperset. Isa Redis yekucheneka uye kutsigira async query.

Gadzira virtual environment nemurairo python3 -m venv venv, mutange, uye uise package yesuperset nepip install apache-superset. Gadzira database nesuperset db upgrade uye gadzira mushandisi weadmin nesuperset fab create-admin.

Isa data rekuedza uye gadzira Superset nemurairo superset init. Gadzirisa superset_config.py neSECRET_KEY, mitsara yekubatanidza database, uye zvirongwa zvecache yeRedis. Gadzira Celery workers kuti maqueries asingadzokororwi amhanyisa pamadataset makuru.

Gadzirisa web server (Gunicorn) uye reverse proxy (Nginx) kune kuisa kwepurodhakishoni. Gonesa HTTPS neLet's Encrypt certificates. Gadzira systemd services yeweb server yeSuperset neCelery workers kuti zvitange zvega uye zvitarisirwe.

Kune high-availability deployments, mhanyisa mienzaniso yeweb server yeSuperset yakawanda kuseri kwe load balancer, gadzirisa metadata database yakagovaniswa neCache yeRedis, uye isa Celery worker pool yakasiyana kuti imhanyise maqueries. Tarisa kushanda uye kukura kwebasa rewaka zvichienderana nemutoro wemaqueries.

Kugadzirisa Zvinhu

Superset config inotonhorwa kuburikidza nefaera superset_config.py mu PYTHONPATH. Gadzirisa SECRET_KEY yekuvanza sessions (gadzira nemurairo openssl rand -base64 42), SQLALCHEMY_DATABASE_URI yekuchengeta metadata, uye CACHE_CONFIG yekucheneka kwe Redis.

Gadzirisa mitsara yedatabase kuburikidza ne UI kana murairo superset set_database_uri. Gadzira row-level security (RLS) uchitsanangura SQL filters dzinoshandiswa kumadataset zvichienderana nemabasa evashandisi. Gonesa madhashibhodhi everuzhinji nePUBLIC_ROLE_LIKE = "Gamma" kuti vagovane nevanhu vekunze.

Gadzirisa authentication nekugadzirisa AUTH_TYPE (DATABASE, OAUTH, LDAP, kana REMOTE_USER) uye AUTH_CONFIG yakaenderana. Batanidza neOAuth providers (Google, GitHub, Okta) kana LDAP/Active Directory yemasangano kune SSO.

Mazano akanaka anosanganisira kugonesa kudzivirirwa kweCSRF, kugadzirisa CORS kune madhashibhodhi akaiswa, kuisa nguva dzekupera kwemaqueries kudzivirira maqueries anotora nguva yakareba, kugonesa kufungidzira mutengo wemaqueries kuti kushandiswa kwezvishandiso kugadzirwe, kugadzirisa email alerts kune mishumo yakarongwa, uye kuisa strategy yekubhadhara ne backup yemetadata database. Shandisa zvinhu zvenharaunda pane zvakavanzika kwete kuzviisa mufaera rekugadzirisa.

Zvinodiwa zvetekinoroji

System Requirements

  • Ndangariro: 2048MB RAM

Ongorora Chinyorwa Ichi

★★★★★
-
Kuisa...

Wagadzirira Kutumira Chikumbiro Chako Here? Apache Superset?

Kutanga mumasekondi nedu nyore VPS kugovera maitiro

Kuisa mu • pamusoro 2 maminitsi Full root kukwanisa • Support nechitima uye email