版權(quán)說(shuō)明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)
文檔簡(jiǎn)介
Visualization:UsingVisualizationsandSummariestoShareResultswithStakeholdersChapter4Wherewearenow1.DataAnalytics2.DataPreparationandCleaning3.ModelingandEvaluation4.Visualization5.TheModernAudit6.AuditAnalytics7.KeyPerformanceIndicators8.FinancialStatementAnalyticsObjectivesLO4-1DeterminethepurposeofyourdatavisualizationLO4-2ChoosethebestchartforyourdatasetLO4-3RefineyourcharttocommunicateefficientlyandeffectivelyLO4-4CommunicateyourresultsinawrittenreportIntheIMPACTcycle,we’renowgoingtolookatCommunicatingInsightsandTrackingOutcomes.IdentifythequestionsMasterthedataPerformtestplanAddressandrefineresultsCommunicateinsightsTrackoutcomesExhibit1-1TheIMPACTCycleDataAnalyticsareeffective,buttheyareonlyasimportantandeffectiveaswecancommunicateandmakethedataunderstandable.Whatisthepurposeofyourdatavisualization?LO4-1Whattypeofdataisbeingvisualized?
Areyouexplainingresultsorexploringthedata?Exhibit4-2ThefourcharttypesAreyouusingqualitativeandquantitativedata?Qualitativedataarecategoricaldata
(e.g.count,group,rank)Nominaldataissimple.
(e.g.haircolor)Ordinaldatacanberanked.
(e.g.gold,silver,bronze)Proportionshowsthemakeupofeachcategory.
(e.g.55%cats,45%dogs)Quantitativedataarenumerical
(e.g.age,height,dollaramount)Ratiodatadefines0as“absenceof”something.(e.g.cash)Intervaldatawhere0isjustanothernumber.(e.g.temperature)Discretedatashowonlywholenumbers.(e.g.pointsinabasketballgame)Continuousdatashownumberswithdecimals.(e.g.height)Distributions
describethemean,median,andstandarddeviationofthedata.Isyourvisualizationdeclarativeorexploratory?Declarativevisualizationsareusedtopresentfindings.
(e.g.financialresults)
Exploratoryvisualizationsareusedtogaininsightswhileyouareinteractingwithdata.
(e.g.identifyinggoodcustomers)Onceyouhavedefinedyourdataandthepurpose,youcanfindanappropriatechartorgraph.Exhibit4-3ThefourcharttypeswithdetailsQ.Whichtypeofdatascaleshouldthefollowingvariablesbemeasuredon?Instructorevaluations(excellent,good,average,poor)WeeklyclosingpriceofgoldNamesofcompanieslistedontheDowJonesIndustrialAverageFahrenheitscaleformeasuringtemperatureHowdoyouchoosetherightchart?LO4-2Whichchartsareappropriateforqualitativedata?Whenyouwanttoshowproportion:BarchartsPiechartsStackedbarchartTreemapsHeatmapsSymbolmapsWordcloudsWhichchartsareappropriateforquantitativedata?Whenyouwanttoshowcomplexdata:LinechartsBoxandwhiskerplotsScatterplotsFilledgeographicmapsHereisasummaryguideofwhentousedifferentvisualizations.
AlsocheckoutConceptual(Qualitative)Comparison:BarchartPiechartStackedbarchartTreemapHeatmapGeographicdata:SymbolmapTextdata:WordcloudData-Driven(Quantitative)Outlierdetection:BoxandwhiskerplotRelationshipbetweentwovariables:ScatterplotTrendovertime:
LinechartGeographicdata:
FilledmapExhibit4-8TypesofchartsWhichtoolsarehelpfulforcreatingvisualizations?TableauandMicrosoftBIaregreatforexploratorydataanalysis.TableauandMicrosoftBItopthelistofvisionaryleadersforvisualizationtools.MicrosoftExcelisgoodforbasicdeclarativecharts.Exhibit4-9GartnerMagicQuadrantforBusinessIntelligenceandAnalyticsPlatformsBadexample:Howdoesthischartillustratebias?Howbigofachangedoesthisrepresent?Whymightthecreatormakethischart?Exhibit4-12Amoreappropriatescaleisagoodstart.Exhibit4-12Exhibit4-13Stackingcanrevealtherealincrease.Exhibit4-12Exhibit4-14Badexample:Whatisthischarttryingtotellthereaderaboutwhosecomputerisattackedmore?IsFinnaScientist?IsMarkusanAdministrator?Dowecaremoreaboutthepeopleorroles?Howdotheusersevencompare?Exhibit4-15Ifwecareaboutindividuals,anorderedbarchartisalittlemoreclear.Exhibit4-15Exhibit4-16Ifwecareaboutfunction,anbarchartcanshowtheproportionmoreclearly.Exhibit4-15Exhibit4-17Andastackedbarchartisalmostalwayseasiertointerpret(inlessspace)thanapie.Exhibit4-15Exhibit4-18Q.Whichcharttypeisbetterforworkingwithdatesovertime,abarchartorlinegraph?Why?Howcanyourefineyourcharts?LO4-3Improvingyourchartscomesdowntochoosinganappropriatescaleandusingcolorseffectively.Considerscaleandincrements:Howmuchdatadoyouneedtoshow?Whatdoyoudowithoutliers?Whatisthebaseline?0?Somethingelse?Wouldcontextorreferencelinesmakethescalemoremeaningful?Thinkaboutyouruseofcolor:Whatdothecolorsmean?Shouldredbeusedforpositiveoutcomes?Whatcolorschemewouldhelpyourcolor-blindparticipants?Q.Howmighttheuseofcompanycolorsorlogosdistractfromavisualization?Howcantheuseofwordsprovideinsight?LO4-4Gettothepoint.Beclear,unambiguous,correct,interesting,anddirect.RemembertouseplainlanguagethroughouttheIMPACTmodelI:Explainwhatwasbeingresearchedandthepurposeoftheproject.M:Ifappropriate,describeissuesyouencounteredintheETLprocess.PandA:Giveanoverviewofyourmodelandlimitationsyoufaced.C:Provideanexplanationofthevisualyouchose.Describeanyitemsthatstandoutorthatareinteresting.T:Discusswhat’snextinyouranalysis.Howfrequentlywillitbeupdated?Aretheretrendsoroutliersthatshouldbepaidattention?ConsideryouraudienceandtonePlacethefocusonyouraudience.Craftdifferentversionsfordifferentaudiences.Useanappropriate
tone.Providetherightcontent.Avoidtoomuchdetail.Don’tforgettoreviseasneeded.Askotherpeopletoreadthoughyourwritingtomakesureyouareclear.
Q:IfyouwerepresentingdataonsalesforacompanylikeSláinte,howwouldyoudescribetheETLprocesstotheCEO?Totheprogrammerscreatingthereport?SummaryThischapterfocusedonthefifthstepoftheIMPACTmodel,orthe“C,”todiscusshowtocommunicatetheresultsofyourdataanalysisprojects.Communicationcanbedonethroughavarietyofdatavisualizationsandwrittenreports,dependingonyouraudienceandthedatayouareexhibiting.nordertoselecttherightchart,youmustfirstdeterminethepurposeofyourdatavisualization.Thiscanbedonebyansweringtwokeyquestions:Areyouexplainingtheresultsofapreviouslydoneanalysis,orareyouexploringthedatathroughthevisualization?(Isyourpurposedeclarativeorexploratory?)Whattypeofdataisbeingvisualized(conceptualqualitativedataordata-drivenquantitativedata)?Thedifferencesbetweeneachtypeofdata(declarativeandexploratory,qualitativeandquantitative)areexplained,aswellashoweachdatatypeimpactsboththetoolyou’relikelytouse(generallyeitherExcelorTableau)andthechartyoushouldcreate.Afterselectingtherightchartbasedonyourpurposeanddatatype,yourchartwillneedtobefurtherrefined.Selectingtheappropriatedatascale,scal
溫馨提示
- 1. 本站所有資源如無(wú)特殊說(shuō)明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
- 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
- 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁(yè)內(nèi)容里面會(huì)有圖紙預(yù)覽,若沒(méi)有圖紙預(yù)覽就沒(méi)有圖紙。
- 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
- 5. 人人文庫(kù)網(wǎng)僅提供信息存儲(chǔ)空間,僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
- 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請(qǐng)與我們聯(lián)系,我們立即糾正。
- 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。
最新文檔
- 《學(xué)前兒童衛(wèi)生保健》 教案 17 托幼園所的生活制度
- 高中英語(yǔ)語(yǔ)法典型性習(xí)題測(cè)試
- 學(xué)校體育產(chǎn)品線介紹課件
- 2024 大中華區(qū) ETF投資者調(diào)查
- 2024屆山西省運(yùn)城市臨猗中學(xué)高三下學(xué)期期中模擬統(tǒng)練(七)數(shù)學(xué)試題
- 小學(xué)語(yǔ)文說(shuō)課課件
- 5年中考3年模擬試卷初中生物八年級(jí)下冊(cè)第三節(jié)生物進(jìn)化的原因
- 高中語(yǔ)文《過(guò)秦論》隨堂練習(xí)(含答案)
- 地產(chǎn)排號(hào)協(xié)議書(shū)
- 蘇少版小學(xué)音樂(lè)三年級(jí)上冊(cè)全冊(cè)教案
- 新蘇教版小學(xué)科學(xué)四年級(jí)上冊(cè)12點(diǎn)亮小燈泡-教學(xué)課件
- 愛(ài)祖國(guó)愛(ài)家鄉(xiāng)課件
- 再生水清水池施工技術(shù)措施
- 人教版四年級(jí)語(yǔ)文上冊(cè)精美課件第一單元習(xí)作推薦一個(gè)好地方
- 深基坑專項(xiàng)施工方案(專家論證)
- 運(yùn)營(yíng)管理精細(xì)化 助推醫(yī)院高質(zhì)量發(fā)展
- 高中英語(yǔ)選擇性必修一 5.4 Reading for writingUsing language 2 課件(共21張)
- 裁剪作業(yè)指導(dǎo)書(shū)
- 微震應(yīng)用前景及預(yù)期效益論證
- 大學(xué)生職業(yè)生涯規(guī)劃全套教學(xué)課件
- 供應(yīng)鏈ppt課件匯總(完整版)
評(píng)論
0/150
提交評(píng)論