📈

KCharselect unicode block name

Nazarin Nazari

Tsarin bincike da hangen nesa na zamani don nazarin kamfanoni

Bayanin KCharselect unicode block name

Tura-ture: min
rukuni: Nazarin Nazari
RAM: 2048MB
Tallafi: Tickets and email

Share wannan shawarwari

QPrintPreviewDialog

Apache Superset dandamali ne na zamani mai shirye don kamfani na leken asirin kasuwanci da binciken bayanai, wanda ke sauƙaƙa wa masu amfani na kowane matakin ƙwarewa bincike da gani bayanansu. Airbnb ne ya fara haɓaka shi, yanzu kuma aikin Apache Software Foundation ne na matakin farko. Superset yana ba da mu'amala mai ƙarfi kuma mai sauƙin amfani don gina dashboards, ginshiƙai da aikace-aikacen nazarin bayanai ba tare da buƙatar ilimin SQL mai zurfi ko ƙwarewar shirye-shirye ba.

A tsakiyarsa, Superset an gina shi ne a kan semantic layer mai ƙarfi wanda ke haɗi da kusan kowane database ko data warehouse da ke fahimtar SQL. Goyon baya ya haɗa da PostgreSQL, MySQL, SQLite, Oracle, Microsoft SQL Server, Amazon Redshift, Google BigQuery, Snowflake, Apache Drill, Apache Druid, Apache Hive, Presto, ClickHouse da wasu dubbai ta masu haɗa SQLAlchemy. Wannan haɗin duniya yana ba ƙungiyoyi damar haɗa nazari a faɗin tushen bayanai daban-daban ta hanyar mu'amala guda ɗaya.

Dandamalin yana da ɗakin gani mai faɗi tare da sama da nau'ikan ginshiƙai 40 da aka riga aka gina, ciki har da ginshiƙan lokaci-lokaci, ginshiƙan mashaya, ginshiƙan pie, taswirorin yanki, heatmaps, pivot tables, da gani na ci gaba kamar sankey diagrams da sunburst charts. Kowane nau'in gani za a iya keɓance shi sosai ta UI mai sauƙin amfani, wanda ke ba masu nazari damar daidaita gabatarwa da buƙatun kasuwanci ba tare da rubuta lamba ba.

SQL Lab na Superset yana ba da IDE mai ƙarfi don binciken bayanai, tare da fasali kamar tarihin tambaya, tambayoyin da aka adana, tsara tambayoyi, tabs da yawa, da samfoti na bayanai da aka haɗa. Goyon bayan Jinja templating a cikin tambayoyi yana ba da damar samar da SQL mai canzawa bisa tacewar dashboard, yana ƙirƙirar gogewar nazari mai mu'amala. Ana iya fitar da sakamakon tambaya zuwa CSV don ƙarin nazari ko rabawa.

Ga muhallin masaukin VPS, Superset yana aiki a matsayin madadin da kake sarrafawa da kanka ga dandamalan BI na kasuwanci kamar Tableau, Looker ko Power BI, yana ba da aiki iri ɗaya ba tare da kuɗin lasisin kowane mai amfani ko dogaro da mai sayarwa ɗaya ba. Tsarin gine-ginen dandamalin yana goyon bayan girma a kwance ta hanyar load balancing kuma yana iya ɗaukar ayyuka masu girman kamfani tare da dubban masu amfani a lokaci guda da miliyoyin layuka na bayanai.

Fasalolin tsaro da mulki sun haɗa da sarrafa samun dama bisa rawa (RBAC), tsaro a matakin dataset da layi, haɗin kai da masu samar da OAuth (Google, GitHub, Okta), tabbatar da shaida ta LDAP, da cikakken rajistar bincike. Goyon bayan multi-tenancy yana ba da damar wuraren aiki masu keɓe ga sassa ko abokan ciniki daban-daban a cikin shigar Superset guda ɗaya.

Ƙarfin faɗaɗa dandamalin ta tsarin plugin mai ƙarfi yana ba masu haɓakawa damar ƙirƙirar gani na musamman, masu haɗa database da abubuwan dashboard. Masu ba da gudummawa a cikin al'umma suna ƙara plugins da extensions, suna faɗaɗa iyawar Superset da yanayin haɗin kai a kai a kai.

QPrintPreviewDialog

Haɗin Database Na Duniya

Goyon baya na asali ga sama da database 40 ta SQLAlchemy, ciki har da PostgreSQL, MySQL, BigQuery, Snowflake, Redshift, Druid, ClickHouse da Presto, domin nazari guda ɗaya.

Ɗakin Gani Mai Faɗi

Sama da nau'ikan ginshiƙai 40 da aka riga aka gina, ciki har da lokaci-lokaci, taswirorin yanki, pivot tables, sankey diagrams da gani na ci gaba tare da zaɓuɓɓukan keɓancewa masu yawa.

IDE na SQL Lab

Editan SQL mai ƙarfi tare da tarihin tambaya, tambayoyin da aka adana, mu'amalar tabs da yawa, Jinja templating, tsara tambayoyi, da samfoti na bayanai da aka haɗa don bincike.

Tsaro Da Mulki Na Kamfani

Samun dama bisa rawa, tsaro a matakin layi, izinin dataset, haɗin OAuth/LDAP, cikakkun rajistar bincike, da goyon bayan multi-tenancy.

Dashboards Masu Mu'amala

Mai gina dashboard ta ja-da-sauke tare da tacewa tsakanin ginshiƙai, zurfafawa, tsarin da ke dacewa da allo, da sabunta bayanai a ainihin lokaci don nazari mai rai.

Gine-gine Mai Iya Girma

Tsarin da za a iya girma a kwance wanda ke goyon bayan load balancing, layukan caching (Redis), aiwatar da tambayoyi marasa aiki tare (Celery) da masu amfani na lokaci guda a matakin kamfani.

QShortcut

- Dashboards Na Leken Asirin Kasuwanci: Ƙirƙiri dashboards na manyan jami'ai, sa ido kan KPI, nazarin tallace-tallace da rahotannin aiki don yanke shawara bisa bayanai
- Binciken Bayanai & Nazari: Ba masu nazari damar bincika saitin bayanai, gina tambayoyi na lokaci-lokaci da ƙirƙirar gani ba tare da taimakon injiniyoyi ba
- Portal ɗin Nazarin Abokan Ciniki: Gina nazari da aka saka cikin aikace-aikacen SaaS don bai wa abokan ciniki fahimta game da amfani, aiki da yanayinsu
- Sa Ido Na Lokaci-Lokaci: Sa ido kan ma'aunin aikace-aikace, aikin tsarin, bayanan na'urorin IoT da abubuwan kasuwanci tare da dashboards masu sabuntawa ta atomatik
- Dandamalin Leken Asirin Kai-Da-Kai: Ba masu amfani da kasuwanci a sassa daban-daban damar ƙirƙirar rahotanni da gani nasu daga saitin bayanai da aka tsara
- Nazari Mai Yawan Masu Amfani: Samar da muhallin nazari keɓaɓɓu ga abokan ciniki, sassa ko rukunonin kasuwanci daban-daban tare da tsaron matakin layi

@ action

Shigar da Apache Superset a kan Ubuntu VPS ta amfani da pip a cikin muhallin Python mai kama-da-wane. Ƙirƙiri database mai keɓe (PostgreSQL ana ba da shawara) don ajiyar metadata na Superset. Shigar da Redis don caching da goyon bayan tambayoyi marasa aiki tare.

Ƙirƙiri muhallin kama-da-wane da python3 -m venv venv, kunna shi, sannan shigar da kunshin superset ta pip install apache-superset. Fara database da superset db upgrade, kuma ƙirƙiri mai amfani na admin da superset fab create-admin.

Loda bayanan misali kuma fara Superset da umarnin superset init. Saita superset_config.py tare da SECRET_KEY, hanyoyin haɗin database da saitunan cache na Redis. Saita ma'aikatan Celery don aiwatar da tambayoyi marasa aiki tare kan manyan bayanai.

Saita web server (Gunicorn) da reverse proxy (Nginx) don turawar samarwa. Kunna HTTPS da takaddun Let's Encrypt. Saita sabis na systemd don web server na Superset da ma'aikatan Celery domin farawa ta atomatik da sa ido.

Don turawar samuwa mai girma, gudanar da abubuwan web server na Superset da yawa a bayan load balancer, saita database na metadata da aka raba da cache na Redis, kuma tura tafkin ma'aikatan Celery daban don aiwatar da tambayoyi. Sa ido kan aiki kuma daidaita ma'aikata bisa nauyin tambayoyi.

@ action

Ana sarrafa saitin Superset ta fayil ɗin superset_config.py a cikin PYTHONPATH. Saita SECRET_KEY don ɓoye zama (ƙirƙira ta openssl rand -base64 42), SQLALCHEMY_DATABASE_URI don ajiyar metadata, da CACHE_CONFIG don caching na Redis.

Saita haɗin database ta UI ko umarnin superset set_database_uri. Saita tsaro a matakin layi (RLS) ta hanyar ayyana matatun SQL da ake amfani da su ga datasets bisa rawar mai amfani. Kunna dashboards na jama'a tare da PUBLIC_ROLE_LIKE = "Gamma" don rabawa a waje.

Keɓance tabbatar da shaida ta hanyar saita AUTH_TYPE (DATABASE, OAUTH, LDAP ko REMOTE_USER) da saitunan AUTH_CONFIG masu dacewa. Haɗa da masu samar da OAuth (Google, GitHub, Okta) ko LDAP/Active Directory na kamfani don SSO.

Mafi kyawun ayyuka sun haɗa da kunna kariyar CSRF, saita CORS don dashboards da aka saka, saita lokutan jira na tambaya don hana dogayen tambayoyi, kunna kimanta kuɗin tambaya don sarrafa albarkatu, saita faɗakarwar imel don rahotanni da aka tsara, da aiwatar da tsarin ajiyar bayanai na database na metadata. Yi amfani da masu canjin muhalli don sirrin shiga maimakon rubuta su a cikin fayil ɗin saiti.

Ka'idojin Kwarewa

Bukatun tsarin aiki

  • Ƙwaƙwalwa: 2048MB RAM

Yi Ƙimanta Wannan Labarin

★★★★★
-
@ action

Shin Ka Shirya Don Tura Aikace-aikacenka? KCharselect unicode block name?

Yi farawa cikin mintina tare da tsarin shigar da VPS na sauƙi

Deploy a kan 2 minti • Full root damar • Taimako ta tikiti da imel