第1題通過數(shù)據(jù)分析不可能為企業(yè)降低風(fēng)險(xiǎn)。Enterprisescannotreducerisksthroughdataanalysis.()第2題既不能增加收入也不能直接節(jié)省成本的數(shù)據(jù)分析一定是沒有價(jià)值的。Dataanalysisneithercanincreasesrevenuenordirectlysavescostssoitmustbeworthless.()第3題從收入角度看,數(shù)據(jù)分析的價(jià)值在于帶來了額外的收入。Fromtheperspectiveofrevenue,dataanalysisisvaluablebecauseitbringsinadditionalrevenue.()第4題以下哪些是常見的分析方法?Whichofthefollowingarecommonanalysismethods?()A對比分析法ComparativeanalysismethodB分組分析法GroupanalysismethodC結(jié)構(gòu)分析法StructuralanalysismethodD因素分析法Factoranalysismethod正確答案：ABCD第5題下列哪些是商務(wù)數(shù)據(jù)分析中可能用到的工具?Whichofthefollowingarethetoolsthatmaybeusedinbusinessdataanalysis?()AEXCELBAccessCSPSSDSAS正確答案：ABCD第6題數(shù)據(jù)分析師不僅要具備洞察數(shù)據(jù)的能力,還要對相關(guān)業(yè)務(wù)的背景有深入的了解。Dataanalystsshouldnotonlybeabletogaininsightintodatabutalsohaveanin-depthunderstandingoftherelevantbusinessbackground.()第7題通過商務(wù)數(shù)據(jù)分析可能為企業(yè)節(jié)省成本。Enterprisescansavecostsviabusinessdataanalysis.()第8題數(shù)據(jù)分析只能用在科學(xué)領(lǐng)域。Dataanalysisonlycanbeusedinthescientificfield.()第9題數(shù)據(jù)分析在日常生活中無處不在。Dataanalysisisubiquitousindailylife.()第10題商務(wù)數(shù)據(jù)分析師除了要懂分析之外,還要懂什么?Whatelsedobusinessdataanalystsknowapartfromtheanalysis?()A懂業(yè)務(wù)businessB懂管理managementC懂工具toolsD懂設(shè)計(jì)design正確答案：ABCD第1題DATEDIF函數(shù)的Unit中的“YD”為start_date與end_date日期中天數(shù)的差,忽略日期中的年。"YD"intheUnitoftheDATEDIFfunctionisthedifferencebetweenthenumberofdaysinthestart_dateandend_datedates,neglectingtheyearinthedate.()第2題使用數(shù)據(jù)透視表創(chuàng)建分組,選擇“創(chuàng)建組”,與選擇“值匯總依據(jù)”是兩個(gè)關(guān)鍵的步驟,不可忽略。Whileusingthepivottabletocreateagroup,selecting"CreateGroup"andselecting"ValueSummarizationBasis"aretwokeystepsthatcannotbeignored.()第3題“&”(邏輯與)運(yùn)算符可將文字或數(shù)字合并成一個(gè)單元格"&"(logicalAND)operatorcancombinetextornumbersintoonecell()第4題完全隨機(jī)缺失數(shù)據(jù)的缺失與不完全變量以及完全變量無關(guān)。Theabsenceofcompletelyrandommissingdatahasnothingtodowithincompletevariablesandcompletevariables.()第5題刪除空行可以借助定位條件。Youcanusepositioningconditionstodeleteblankrows.()第6題排序與篩選刪除法都可直接刪除重復(fù)項(xiàng)。Bothsortingandfilteringdeletemethodscandeleteduplicatesdirectly.()第7題排序刪除法需要借助COUNTIF函數(shù)計(jì)算出第幾次重復(fù)值,然后再做排序處理。Whileusingthedeletingbysortingmethod,itisnecessarytocalculatethenumberofrepetitions??withthehelpoftheCOUNTIFfunctionfirst,andthendothesortprocessing.()第8題COUNTIF(A:A,A2)與COUNTIF(A功能相同。2:A2,A2)功能相同。COUNTIF(A:A,A2)hasthesamefunctionasCOUNTIF(A2:A2,A2).()第9題數(shù)據(jù)透視表用來統(tǒng)計(jì)各數(shù)據(jù)出現(xiàn)的頻次,出現(xiàn)2次及以上就說明該數(shù)據(jù)屬于重復(fù)項(xiàng);如果統(tǒng)計(jì)結(jié)果為1,則說明該數(shù)據(jù)沒有重復(fù)出現(xiàn)。Thepivottableisusedtocountthefrequencyofoccurrenceofeachdata.Ifthedataappears2ormoretimes,itisaduplicate.Ifthestatisticalresultis1,itmeansthatthedatadoesnotappearrepeatedly.()第10題非結(jié)構(gòu)化數(shù)據(jù)沒可以用數(shù)據(jù)庫二維邏輯表來表示和存儲(chǔ)。Unstructureddatacannotberepresentedorstored,usingarationaldatabaseintwodimensions.()第11題substitute函數(shù)可替代LEFT、RIGHT函數(shù)。ThesubstitutefunctioncanreplacetheLEFTandRIGHTfunctions.()第12題Len函數(shù)與lenb函數(shù)功能相同。TheLenfunctionhasthesamefunctionasthelenbfunction.()第13題函數(shù)RIGHT(text,[_chars])可得到字符串右部指定個(gè)數(shù)的字符。ThefunctionRIGHT(text,[_chars])cangetthespecifiednumberofcharactersstartingfromtheright-mostcharacterofthetextstring.()第14題Or函數(shù)要所有參數(shù)為真,才返回TRUE。TheOrfunctionrequiresallparameterstobetruebeforereturningTRUE.()第15題AND函數(shù)最多可包含255個(gè)條件。TheconditionsthatANDfunctioncancontainisupto255.()第16題if函數(shù)可進(jìn)行嵌套,且沒有嵌套層數(shù)限制。TheIfFunctioncanbenested,andthereisnolimitonthenumberofnestinglevels.()第17題刪除重復(fù)項(xiàng)不會(huì)提示有多少重復(fù)值被刪除,有多少唯一值被保留。Afterdeletingduplicates,itwillnotpromptthenumberofduplicatevaluesdeletedandthenumberofuniquevalues?retained.()第18題篩選刪除法無需借助COUNTIF函數(shù)計(jì)算出第幾次重復(fù)值。Whileusingthefilteringanddeletingmethod,itisunnecessarytousetheCOUNTIFfunctiontocalculatethenumberofrepetitions.()第19題用高級篩選法可以去除重復(fù)。Useadvancedscreeningmethodstoremoveduplicates.()第20題函數(shù)式"=COUNTIF(數(shù)據(jù)類,某一單元格)",代表計(jì)數(shù)或判定重復(fù)功能的使用。Thefunctionalformula"=COUNTIF(datatype,acertaincell)"representsusingthefunctionofcountingorjudgingduplicates.()ExercisesinCharpterofBusiness第1題RFM模型中,M值越大購買力越低,M值越小購買力越高。IntheRFMmodel,thegreaterMvalueis,thelowerthepurchasingpowerwillbe,andviceversa.()第2題企業(yè)應(yīng)對所有客戶一視同仁,堅(jiān)決抵制根據(jù)客戶的不同特點(diǎn)進(jìn)行有針對性的營銷行為。Companiesshouldtreatallcustomersequallyandfirmlyresistanytargetedmarketingactivitiesbasedonthedifferentcharacteristicsofcustomers.()第3題收藏即送優(yōu)惠券的活動(dòng),對于賣家來說是虧本生意。Forsellers,givingawaycouponsisaloss-makingbusiness.()第4題自主訪問這種流量來源,主要包括買家從購物車、收藏夾、我的淘寶等方式主動(dòng)進(jìn)入店鋪。Thetrafficsource,independentvisitsmainlyincludebuyers’activevisitsviatheirShoppingcarts,Favorites,MyTaobao,etc.()第5題在“人群篩選器”中只能設(shè)置部分參數(shù)。In"GroupFilter",onlysomeparameterscanbeset.()第6題所謂的專業(yè)優(yōu)勢,體現(xiàn)在產(chǎn)品介紹時(shí)關(guān)鍵詞當(dāng)中不同于其他普通產(chǎn)品而言。Theso-calledprofessionaladvantageisembodiedintheintroductionoftheproduct.Thekeywordsoftheseproductsdifferfromotherordinaryones.()第7題新客戶銷售額下的三個(gè)指標(biāo)包括Thethreeindicatorsundernewcustomersalesinclude()A新客戶數(shù)NumberofnewcustomersB客單價(jià)PercustomertransactionC成交量TurnoverD購買頻次Purchasefrequency正確答案：ABD第8題從買家角度來說,產(chǎn)品屬性對其幫助很大,當(dāng)買家在搜索框里多選擇一個(gè)產(chǎn)品屬性,搜索結(jié)果就越接近自己所期望。Fromthebuyers’perspective,productattributesareofgreathelp.Onemoreproductattributeinthesearchboxenablesbuyerstogetclosertotheproducttheydesire.()第9題以下哪個(gè)不屬于產(chǎn)品的屬性。Whichofthefollowingattributedoesnotbelongtoproductattributes.()A產(chǎn)品款式ProductstyleB產(chǎn)品人群定位ProductpeopleorientationC產(chǎn)品價(jià)格ProductpriceD店鋪收藏?cái)?shù)Numberofstoresavers第10題可以根據(jù)頭一年的市場容量來預(yù)測下一年的某行業(yè)的市場容量。Themarketcapacityofacertainindustrynextyearcanbepredictedbasedonthatofthepreviousyear.()第11題市場容量為某類產(chǎn)品在行業(yè)中所占的成交額比重,也就是某一類產(chǎn)品占整個(gè)行業(yè)成交量比重越大,代表著這類產(chǎn)品市場容量就越大。Marketcapacityistheproportionofacertaintypeofproductintheindustry'sturnover.Itmeansthatthelargerproportionacertaintypeofproductaccountsforinthetotalindustrialturnover,thebiggermarketcapacitythistypeofproductwillhave.()第12題在正式做會(huì)員數(shù)據(jù)分析之前,必須對那些異常會(huì)員數(shù)據(jù)進(jìn)行清洗,保證數(shù)據(jù)質(zhì)量。Beforegettingintothememberdataanalysis,theabnormalmemberdatamustbecleanedtoensurethequalityofdata.()第13題會(huì)員生命周期主要經(jīng)歷七個(gè)階段:消費(fèi)者——顧客——新會(huì)員——活躍會(huì)員——()——睡眠會(huì)員——流失會(huì)員Thelifecycleofmembershiphassevenstages:aconsumer-acustomer-anewmember-anactivemember-()-asleepingmember-alostmember.()A沉睡會(huì)員asleepingmemberB回購會(huì)員arepurchasememberC沉默會(huì)員asilentmemberD激活會(huì)員anactivemember第14題相對于女性來說,男性購買商品的目的極為明確,過程也較為簡單、迅速,而且不會(huì)浪費(fèi)過多的精力在購物活動(dòng)上。Comparedwithwomen,menhaveclearshoppingtargetsandtheirshoppingprocessisrelativelysimpleandfast.Theyarenotwillingtowastetoomuchenergyonshopping.()第15題客戶活躍度較高,購買能力較強(qiáng),但是購買頻次較低,這類客戶是指Customeractivityishighandpurchasingpowerisstrong,butpurchasefrequencyislow.Thistypeofcustomerrefersto()A重要保持客戶ImportantcustomerstomaintainB重要發(fā)展客戶ImportantcustomerstodevelopC重要挽留客戶ImportantcustomerstoretainD無價(jià)值客戶Valuelesscustomers第16題RFM模型中,F代表什么意思?IntheRFMmodel,whatdoesFstandfor?()A最近一次消費(fèi)時(shí)間ThetimeoflatestconsumptionB消費(fèi)時(shí)間分布DistributionofconsumptiontimeC消費(fèi)頻率FrequencyofconsumptionD消費(fèi)金額Consumptionamount第17題客戶行為是指人們?yōu)闈M足需要和欲望而尋找、選擇、購買、使用、評價(jià)及處置產(chǎn)品、服務(wù)時(shí)介入的過程活動(dòng)。Customerbehaviorreferstoaseriesofactivitiesintheprocessofsatisfyingtheirneedsanddesires,suchasseeking,selecting,andpurchasingusing,evaluating,anddisposingofproductsorservices.()第18題客戶畫像的作用包括Whatrolesdocustomerportraitsplay?()A精準(zhǔn)營銷ProvidingaprecisionmarketingB助力產(chǎn)品ImprovingproductsC用于行業(yè)報(bào)告和用戶研究BeingusedinindustryreportsanduserresearchD研究行業(yè)狀況Researchingontheindustrystatus正確答案：ABC第19題店鋪流量問題總的分析思路包括4個(gè)步驟,分別是發(fā)現(xiàn)流量問題、分析流量數(shù)據(jù)、找到問題關(guān)鍵、對癥下藥。Theoverallanalysisofstoretrafficproblemsincludes4steps,namely,discoveringtrafficproblems,analyzingtrafficdata,findingthekeytotheproblem,andprescribingtherightmedicine.()第20題賣家發(fā)現(xiàn)流量問題的方式是通過流量趨勢圖。Thewayforsellerstofindtrafficproblemsisthroughtraffictrendgraphs.()ExercisesinCharpterofPresentation第1題趨勢分析是預(yù)測未來,所以不需要考慮過去。Atrendanalysisistoforecast,sothereisnoneedtoconsiderthepast.()第2題數(shù)據(jù)分析最基礎(chǔ)的方法就是對比。Themostbasicmethodofdataanalysisismakingcomparisons.()第3題散點(diǎn)圖不僅可以做分布分析,也可以通過趨勢線做趨勢分析。Thescatterchartcanbeusedfordistributionanalysisbutalsotrendanalysisviatrendlines.()第4題直方圖就是按照范圍值分組后繪制的柱形圖。Thehistogramisacolumnchartdrawnaftergroupingbytherangevalue.()第5題為了讓數(shù)據(jù)更加突出顯示,我們可以給特定的數(shù)據(jù)形狀加上顏色。Tohighlightdata,wecanaddcolorstodatawithspecificshapes.()第6題對比分析法是將兩個(gè)或兩個(gè)以上的數(shù)據(jù)進(jìn)行比較,從而找到差異的方法。Thecomparativeanalysismethodistocomparetwoormoredatatofindthedifference.()第7題柱狀圖是最常見的圖,所以可以“一圖走天下”。Thebarchartisthemostcommongraph,soitcanbeonceforall.()第8題做PPT展示時(shí),文不如表,表不如圖。WhendoingaPPTpresentation,textsareinferiortotables,andtablesaresupersededbycharts,intermsoftheeffect.()第9題所謂高大上的圖表,就是特別美觀炫酷的圖表。Theso-calledadvancedchartsarethosechartsthatareparticularlybeautifulandcool.()第10題做數(shù)據(jù)圖的目的在于讓觀眾更加清楚地觀察數(shù)據(jù)。Thepurposeofmakingdatagraphsistoallowviewerstoobservethedatamoreclearly.()第11題拿到數(shù)據(jù)第一步是上傳到平臺(tái)進(jìn)行分析。Thefirststepafterobtainingthedataistouploadittotheplatformforanalysis.()第12題報(bào)告的撰寫是一成不變的,不需要進(jìn)行調(diào)整。Reportwritingisunifiedanddoesnotneedtobeadjusted.()第13題趨勢預(yù)測法是一種定性分析方法。Thetrendforecastingmethodisaqualitativeanalysism