superset用戶使用流程手冊

1、Superset的功能介紹1、我們可以通過連接數(shù)據(jù)庫，去對數(shù)據(jù)庫中的單個(gè)表進(jìn)行配置，展示出柱狀圖，折線圖，餅圖，氣泡圖，詞匯云，數(shù)字，環(huán)狀層次圖，有向圖，蛇形圖，地圖，平行坐標(biāo)，熱力圖，箱線圖，樹狀圖，熱力圖，水平圖等圖，官網(wǎng)上是不可以操作多個(gè)表的，不過我們可以操作視圖，也就是說在數(shù)據(jù)庫建好視圖，也可以在superset 中給表新增一列進(jìn)行展示。2、配置好了我們想要的圖表之后我們可以把它添加到儀盤表進(jìn)行展示，還可以去配置緩存，來加速儀盤表的查詢，不必要沒次都去查詢數(shù)據(jù)庫。3、我們可以查看進(jìn)行查詢表的 sql,也可以把查詢導(dǎo)出為 json,csv 文件。它有自己的 sql 編輯器，我們可以在里面

2、來編寫 sqL一、系統(tǒng)基本使用在使用本系統(tǒng)前，應(yīng)該先進(jìn)行賬戶的建立操作。登陸輸入開通的賬號、密碼點(diǎn)擊登錄即可。新建賬號在登陸時(shí)可以使用 admin 進(jìn)行用戶的創(chuàng)建。先登陸 admin 用戶，點(diǎn)擊界面欄目安全。用戶列表”一，點(diǎn)擊按鈕 *=*=WlAmiflWlAmifli imrmr：JWmiJWmi”*:*:3 幢lUiiWrJNnlUiiWrJNn幅”在填寫完信息后點(diǎn)擊保存（注：紅色*的選項(xiàng)未必填項(xiàng)）即可使用新建賬號登陸。酉stst用尸省用戶d d畤手口同A A* *。stairs.stairs.ininI IIDIDI I中KIKIa(4q1$a(4q1$人-在創(chuàng)建賬號時(shí)，根據(jù)使用賬號功能

3、需求選擇不同的角色屬性，每個(gè)賬號的用戶名不能相同。WJS*WJS*創(chuàng)建數(shù)據(jù)源superset連接MySQL登錄到部署 superset 主機(jī)1.進(jìn)入 superset 的 Web 界面，點(diǎn)擊 sources 下拉選項(xiàng)的 Databases;,如下圖:國|fu|fuGnTTMi。門與 lri-e_paraiTis()lri-e_paraiTis()3.查看已經(jīng)連接好的數(shù)據(jù)庫添加數(shù)據(jù)表Sources-Tables點(diǎn)擊加號（+）新增數(shù)據(jù)表Database 選擇之前創(chuàng)建文？的數(shù)據(jù)源，TableName 必須是數(shù)據(jù)源中對應(yīng)真實(shí)的表名，表中必須包含一個(gè) Date 或者 Timestamp 類型的字段OOS

4、upersetOOSupersetC用戶權(quán)限 VManagev 琶 Sourcej|LmLmSlices言 Databases 點(diǎn)擊Tables2.進(jìn)入數(shù)據(jù)庫界面，點(diǎn)擊“+”按鈕進(jìn)入數(shù)據(jù)庫連接界面，填寫正確字段后保存，操作如下:DaE-abM3QCDaE-abM3QCtesttestaLAk_liCFTirURIaLAk_liCFTirURIm m芋R RI.CI.CFQOFQOL LTNaxixgiQNJTNaxixgiQNJd dJBmtjdijTul:JBmtjdijTul:Q Q正石iftift白句URUlURUl卑出卜Rfe-rRfe-r1 1 寸 tfrivtfrivaqlaql

5、八 yAmyAm y yG GOCABOCAB/ /Q QLIQTQnTformllonnTformllon wii-Kjwwii-KjwI I。b*riKwb*riKtMiltMil*+*+IhxpoEaaIhxpoEaa：mMQLmMQLAlawCHJEATETABLEASAlawCHJEATETABLEASAllWAllW CJMLCJMLA AI II-I-C C- -RWVRWVielFkiI IThultThult -40-401 1口 HllultLldHNFI1tllil&lWL.d!riC|IMsUhkCIHllultLldHNFI1tllil&lWL.d!r

6、iC|IMsUhkCI0 0 色在 f-1nriif-1nrii 力 lJIlJI；kJIkJI記吊題口 TYLizrijunYLizrijunB B ckck ndndIAllowRunAllowRunAllowRinAllowRinA A號ynyn匕AllowDAllowDMLIMLICreatorICreatorILatChandChandSyncSyncImysqlmysql一八廣raiseraiseraiseraiseadminadmin2Q17-06-1417:04:302Q17-06-1417:04:30mycqlmycqlTrueTrueFalseFalseFalctFalct

7、2017-OM4111:51:512017-OM4111:51:51門1H71rll1H71rllimkiWimkiWIgAlll-OWCJlitAAlll-OWCJlitAI IfczfczI IiA.Hll_k.iA.Hll_k.1 1A AOpTilOtltinOpTilOtltin3 3。1_1_L L hbhbAM-owvufiAM-owvufi r rK KtolullFborBtolullFborB3 3 工 1_41_4 口 10101 1t t1 11 13THlnit3THlnitlUDiOlUDiO 八 I IjUt.l_EjUt.l_EI It,t,口 l4hl4h A

8、IAI 占，JISC3FS1JISC3FS1 修工iitlfJiiitlfJiftft1 11r1r wskwsk 口 runrun 近,口 00riri，(_(_也門，略J J/ /TKCTKC：& &CPCCPC= =rFilssrFilss后EIEIIEIE鹿 yeuyeuIH-CflkJ|lIH-CflkJ|lM M-H-HV/f+VIrtiMM-T4*HHJIIHEJMrfiCh.*-l11V/f+VIrtiMM-T4*HHJIIHEJMrfiCh.*-l11THSLHin5OLILHilaTHSLHin5OLILHilaritotFcritotFc3Qlalc.ti

9、En_i$i.crc-nCe_engIt3Qlalc.tiEn_i$i.crc-nCe_engItoll.wthilcIlieoll.wthilcIlieB B 1 1Iflil_HMFmyIflil_HMFmyMEMEB BUIUIBITHBITHfINfINCnjirnfiifjiCnjirnfiifjiJRJRwlriajriwlriajriM MJ JM ManianiH Hifcifc E Etrai聾SourcesvSourcesv迎SlicesSlicessDatabases& &DruidClustersDruidClusters0DruidDatasource

10、s0RefreshDruidMetadataOFputkputk題ug4dug4d附lymlym轉(zhuǎn)印0 0雪UlUl鐳例IkAFDMIkAFDM審的HMfiMHMfiMIOR18WIVIOR18WIVNMF電M M附ihaiihai如骷n n碗允twtw睡seiBTkiseiBTkiKtflKtflrtflrtfl4 4它airiQrBairiQrTables 可看到所有已連接的數(shù)據(jù)表可對表結(jié)構(gòu)、數(shù)據(jù)類型、是否可進(jìn)行 group、filtercount、summin、max 操作等進(jìn)行編輯數(shù)據(jù)探索分析與可視化展示Table 定義好維度字段和指標(biāo)之后，即可針對該表進(jìn)行數(shù)據(jù)探索分析與可視化展示，在

11、 ListTable 頁面，點(diǎn)擊一個(gè)表名，即可進(jìn)入。T昌血FigFigQ QTUI9TUI91gPQMBygPQMByIhkhk陽叫的回口班hrhr C11C11J4wnMJ4wnM2aMi1*SW2aMi1*SW加血啾 nQai4jmiigoiQai4jmiigoi仃1 1ecoecojajhejajheaiwiniQiaiwiniQi(亙1.ptititeubl_WM11ptititeubl_WM11總由岫JatOnhdJatOnhdAfWtUhAfWtUhQ Q回*rnuutonwrnuutonw： wrieswriesrpttnrpttnaiwnliaiwnli畔&A*tHrf

12、i_nncc_g_ncg6tHrfi_nncc_g_ncg6rwirwianwffihanwffih事產(chǎn)c c年.102102圖manmananwitfi14canwitfi14cQ Q已rarWfTLELMaMKrarWfTLELMaMKHW1HW1moEh19cmoEh19c口*IEMIE*IEMIE*= =nUnnUnA AtuMhtuMh干.wbtwainwbtwain西加MTMTmammamacwrlhacwrlh均c cQarQar E E* *H H4inwrlH4inwrlH在分析頁面中，可以針對某一個(gè)表事先定義的時(shí)間字段、維度及指標(biāo)字段進(jìn)行數(shù)據(jù)探索分析,Q QrKiprKip

13、% %|-AM*k0WHM0U1|-AM*k0WHM0U1T TM MF FZOHCZOHCI*JfcWITHQU-1I*JfcWITHQU-11 1TMtTMtJQ*tJQ*tBCKXBWMJWilAFMWriBCKXBWMJWilAFMWri. .VWKrHWieWiVWKrHWieWiO OWtPiOidhACMTWtPiOidhACMTssakrtecmikrtecmi并可以選擇相應(yīng)的圖表進(jìn)行可視化展示。/iibiib1rH1rHCX3CX3TtWfl-TtWfl-FHCwwFHCww*tient_coLjntySerieslimitSonSerieslimitSonByBy可視化選擇

14、配色圖例是否堆積/分布ChartOptionsColorSchColorSchmqmqQ Q 匚I IRangeFitterRangeFitter LegerxiLegerxi口BarValuesBarValues叵|RihR4ltipCOhlrilHiliOhRi ) ) * ！ * * f f141IF141IFftftaSQLexpresstonaseyntnowngbacxenaEuwxubHn削跑，iPP1*porc33i4neg州iftmeslariph川儂起in6餌/61而/配卻依酬lypTdxaigg皿locael/。下潮比加御之是4船。和，贈白玄:岫typexcf4g比l幅D

15、BAPLThe腫/抬slormu期間班T5名MC電m01小名的*!IJ：H條$.Or口也sitDdAPLftwsrrq酎MUDoe*CYBWCYBWI IQinoIOIOTFTF就鼐rEx:TLMTE1ry.YWT*R 操作數(shù)據(jù)庫經(jīng)過上邊的步驟就連接上了數(shù)據(jù)庫，下邊就可以進(jìn)行數(shù)據(jù)的可視化操作了。首先點(diǎn)擊SQL 測試下拉菜單下的 SQL 編輯器按鈕。如下圖所示:dudentsdudentsNONOSQL 語句的執(zhí)行結(jié)果如下:點(diǎn)擊 Visualize 按鈕進(jìn)入數(shù)據(jù)可視化編輯窗口:*OOOOSupersetH 用戶桎聯(lián)z想印呼QSco匚仃I*SNoesADEshbuEK也&SQLLubUnt

16、itlMQuery*hrrcuweii前比的沖暗軍巨字.,生：1.1凸二!：.百ASQLEditorQQuerysearchatanle168Tw豺據(jù)庫ieUct-froftHrthjia配$寫GQL詩句PS,無分號符fcsHirpcrJfcsHirpcrJ訓(xùn)Fit跟TmHAJKPHAJKP1肘&5觸面月R R片i用 X 裊s甫pYneGRuiid廿1巾/口K KI I血mbmtobeDATETIMEorWiTTiME-bl?egi郎FFgmanKCaKCa福鼻LM10|hBLM10|hB Visuitihie部分圖形使用案例DistributionBarChart(分布-條形圖)案例

17、需求：統(tǒng)計(jì)每個(gè) state 的總?cè)藬?shù)，總女生人數(shù)，總男生人數(shù)。SELECTstateASstate,sum(num)ASsum_num,sum(sum_girls)ASsum_sum_girls,sum(sum_boys)ASsum_sum_boysFROM(select*frombirth_names)ASexpr_qryWHEREds=1917-07-0518:21:31ANDdsceffi1 10 0。-ear5-ear5妁OartOptionsSefics0加 8設(shè)置圖用底部的距離aiifoaiifoYAxi&Label設(shè)首Y Y地的標(biāo)簽fimfim專后修修, ,.OU.OU相

18、當(dāng)于對曲 te 字樓進(jìn)行勿在圖冊的煽顯示10M10MMEtaleEtaleRrfakdowns1Mi-Ini丸上”聚臺不段ili亍時(shí)Khum_nijmihum_nijmiK3UEK3UEUE_WUE_WSUTTliSLimD0V3SUTTliSLimD0V3Rowlimit1 1% %費(fèi)百丫軸數(shù)值的裾式LegendYaxisforrffaT(2YaxisforrffaT(2KAxisLab?lKAxisLab?lReduce-X1txtraContrtxtraContrSnrUnluSnrUnlu彩石 6Sf4ckfidSf4ckfidQHPAn口BottomMarginMargin cont

19、ributioncontribution rISortBarsII段置塔由的標(biāo)筆SQLSQLCustomWHtiRtclaMseCECustomHAVINGclause6CustomHAVINGclause6Filter56海加里刑的過硫泉竹4-4-AddfiH*rAddfiH*r在圖形的右上方有對圖形的保存等一些操作:KavcaaIvisual!zatlcnTypedistbarIDatasourceIDatasourceMyDatfisourceASQLLab設(shè)置圖片大小保存文件到本地sum_numsum_numsum_sum_5oyssum_sum_5oysWsum_sum_girisW

20、sum_sum_giris圖表的保存:查看保存的圖表:slrceslrce3.2TableView一表視圖顯示Json數(shù)據(jù)顯示查詢語句JueryJuery顯示圖形的鏤接、ScWEasScWEasSavealice圖表的名字3urcegChartT 年。iMyDatasoufceGfOAddslicetjexistingdadnboardtuLion-HarcnartOAddrJnewdaEhtJoarddashboardnameerseterset4 4用戶稅限v#M自口明 u*ASOLLabvUstSlize好看圖表劌袤需求 1：根據(jù) name,gender 分組，統(tǒng)計(jì)總?cè)藬?shù)。郭onetad

21、dto日dashboard|b=i(T：口三rtSELECTnameASname,genderASgender,sum(num)ASsum_numFROM$SourcesvJiunices&tDashboards捶祚v v0.21sec0.21sec由喈宿gtndashhoerri(select*frombirth_names)ASexpr_qryWHEREds=1917-07-0518:24:31ANDds=1917-07-0518:25:21ANDds=2017-07-0518:25:21GROUPBYgender,state,nameORDERBYsum_numDESCLIMIT

22、50000iifcail.BlFLiifcail.BlFLELELMlMlhLPVTMlMlhLPVTWlWlMTHntarMTHntarf fa aUhUh單如御T T造MMDMMD用MDHWfl11WMDHWfl11W 刀中J J的口I IE3T3*E3T3*1 11dbftr1dbftr電口妙imao5imao5，01WJ1Q01WJ1Q了件MIQiBfTQV3KI415MIQiBfTQV3KI415工001WWU1flFtW-fl001WWU1flFtW-fllimelime f f4UIS9194474JI44EQTH4UWKlflJ7W03t44UIS9194474JI44EQTH

23、4UWKlflJ7W03t4K4K4 4M4M和”力JbdWxJbdWxam27191311MID130ED24J7O3MZ1Q1W2CIam27191311MID130ED24J7O3MZ1Q1W2CIbt/Tbt/TaJJHU7W.taJJHU7W.t:溶5 5口5651447u|?UI344KD5651447u|?UI344KDg gHDHD 7%1106MJQ7HN1G7%1106MJQ7HN1GTEITEI拿回HGHG/ /nFBinFBi事W WI I。巾M MI IM M1 11MlM1MlM1 1I I171171。修麗9 9曲*融7 7i i財(cái)詢電rmeCobrmeCob 息

24、%:Egfenrfenr，燈H HZWQ0rgmQiUffiSDZWQ0rgmQiUffiSD 4BHIE4BHIE。iQmDiQmD4141 00TJEijW2DCTJEijW2DCShe*She* IJIJH HIIIIAkwbvrAkwbvr/蝴。IN4017MMMSIN4017MMMS打”力X XSIWASIWA1 1匐才?曲包1 1。iDU.D677SHWMbiDU.D677SHWMb利力瑜曲i i刻短曲91&Bd191&8M/晶口UkZJQUkZJQ1212設(shè)電婚77Q77Q融1 1中一回0 0PGDJrt-HJQfEiPGDJrt-HJQfEi- -BOW.BOW

25、.Ml*kMl*k1 1崎2 2。420 05252洋舞中HMD1HMD1 74D74D1 1黜”彳例小行屯1 1如酹巾4AdMfHAdMfH9I1MV9I1MV”曲131311W911W9 niDniD 44lKQ44。事西隱申喟14141414彳4 4M4HM4H心了氤UWUUWU 43H-Li43H-LiBMDBMDf fIHIHN N4EdLMH#3L4EdLMH#3L口M4&DM4&D1 1直弱口強(qiáng)鯉illilli57l4Di57l4D1 121gg21gg口2SM2Q2SM2QitMtJ：3.4 TimeSeries-LineChart一時(shí)序線圖案例需求：查看每個(gè)

26、state 人數(shù)總數(shù)隨時(shí)間的變化。SQL:SELECTstateASstate,dsAS_timestamp,sum(num)ASsum_numFROM(select*frombirth_names)ASexpr_qryINNERJOIN(SELECTstateASstate_,sum(num)ASsum_num(select*frombirth_names)ASexpr_qryWHEREds=1917-07-0518:26:35ANDds=1917-07-0518:26:35ANDds=1917-07-0518:27:06ANDds=1917-07-0518:27:06ANDds=1917-

27、07-0518:29:51ANDds=1917-07-0518:28:57ANDds=1917-07-0518:28:57ANDdsHOWHOWTTZTTZ；I II IS SbliltabliltaS9rwlprrt$S9rwlprrt$LtWlLtWlTw*/Tw*/3.8BubbleChart-氣泡圖SQL 語句：SELECTcountry_nameAScountry_name,regionASregion,SUM(SP_POP_TOTL)ASsum_SP_POP_TOTL,SUM(SP_RUR_TOTL_ZS)ASsum_SP_RUR_TOTL_ZS,SUM(SP_DYN_LE00_I

28、N)ASsum_SP_DYN_LE00_INFROMwb_health_populationWHEREyear=STR_TO_DATE(2011-01-0100:00:00,%Y-%m-%d%H:%i:%s)ANDyear4itl4it30301iIii1iIiiliIliIIIIIliiliiHiiiHiii i i15Q315Q3 Z34Z34irMyDashboardmrkupmrkupThesiHjrMWaTavMiramafromThesiHjrMWaTavMiramafromfhee-fhee-TlrwcolunwiTim#GrairnTim#Grairn yuaryuarFriKFriK：Coki.Coki.SinceUYtMUYtM1a3M1-O11a3M1-O1MockupTjflpejHEHECode dfdf 所IwlotfIwlotf工網(wǎng)