雨课堂学堂在线学堂云《Business Data Analytics（广西机电职业技术学院）》单元测试考核答案

BusinessDataAnalytics第1题Datawithfixedformatandclearorganizationalstructuresuchasenterpriseemployeeinformationtablebelongsto()AStructureddataBUnstructureddataCSemi‑structureddataDUnordereddata第2题Inthebusinessdataanalysisprocess,thekeystepstoprovideahigh-qualitydatafoundationforsubsequentanalysisare()ADatacollectionBDatacleansingCDataanalysisDDatainterpretation第3题Thesalesvolumeofanenterpriselastquarterwere8millionyuan,andthatofthisquarterwere10millionyuan.Thesalesgrowthrateofthisenterprisethisquarteris()A20%B25%C120%D125%第4题Theindexusedtomeasuretheefficiencyofenterpriseinventorymanagementandreflecttheinventoryturnovertimesis()AInventoryturnoverrateBOn-timedeliveryrateCDebt-to-assetratioDGrossprofitmargin第5题Whichofthefollowingdatacollectionmethodsissuitableforobtainingfirst-handinformationoncustomerneeds?()ADatabasesearchingBWebcrawlersCQuestionnaireDIndustryreportsanalysis第6题Thevisualchartthatcanvisuallypresentthecomparisonofdifferentcategoriesofdatasizeis()ALinechartBPiechartCBarchartDScatterplot第7题Sourcesofbusinessdatainclude()AInternalsalessystemoftheenterpriseBReportsreleasedbyexternalmarketresearchinstitutionsCUserreviewsonsocialmediaDDatafromtheenterprisefinancialsystem第8题Thecommontypesofbusinessdataanalysismethodsinclude()ADescriptiveanalysisBDiagnosticanalysisCPredictiveanalysisDPrescriptiveanalysis第9题Whichofthefollowingsbelongtocustomerindicators?()ACustomersatisfactionBCustomers’loyaltyCRepurchaserateDUnitpricepercustomer第10题Intheoperationofe-commerceplatform,whichofthefollowingarekeyoperatingindicators?()AOrderprocessingtimeBLogisticsdeliverytimeCPageviews(PV)DUniquevisitor(UV)第11题Thefunctionsofdatavisualizationinclude()AMakedataresultseasiertounderstandBHelpsspotanomaliesindataCMoreintuitivesupportfordecision-makingDCompletelyreplacethedataanalysisprocess第12题Unstructureddatahasnovalueforbusinessanalysisbecauseithasnofixedformat.()第13题Thegoalofdataanalysisisonlytodiscovertherulesinthedata,andthereisnoneedtoprovidesupportforenterprisedecision-making.()第14题Thehighertheasset-liabilityratio,thestrongerthesolvencyoftheenterprise.()第15题Theconversionrateofe-commerceplatformonlyincludesthepurchaseconversionrate,notthebrowsingconversionrate.()第16题Datainterpretationonlyneedstopresentthedataresults,anddoesnotneedtobeinterpretedincombinationwiththebusinessbackground.()第1题Whenconductingcompetitoranalysis,itisonlynecessarytofocusondirectcompetitors.()第2题Whendevelopingadataacquisitionplan,thereisnoneedtoconsidertheprivacyandsecurityofdata.()第3题Theaccuracyofdatacollectionisanimportantindextomeasuredataquality.()第4题AItechnologycanonlybeusedfordatacollection,notdataanalysis.()第5题Theformulationofthedataacquisitionplandoesnotneedtoconsiderthewaythedataisstored.()第6题Thedatatoolsprovidedbytheplatformcanonlycollectdatafromtheplatform.()第7题Thechoiceofdataacquisitionchanneldoesnotaffectthequalityandavailabilityofdata.()第8题Theformulationofbusinessdataanalysisgoalsneedstobeconsistentwiththebusinessstrategicgoalsofenterprises.()第9题Whichofthefollowingsbelongtothird-partydatacollectiontools?()AChanmamaBDuoduoInformationCZhulutoolboxDOfficesoftware第10题Whataspectsshouldbeconsideredintheevaluationofbusinessdataanalyticssolutions?()AAccuracyofanalyticalresultsBImplementationcostoftheplanCPracticalityofanalyticalresultsDDatasources第11题Whenperformingdatacollection,whichofthefollowingsareexternaldatasources?()AGovernmentstatisticsBIndustryassociationreportCSocialmediaplatformDInternalenterprisedatabase第12题Whichofthefollowingsaredatavisualizationtools?()AExcelBTableauCPowerBIDThematplotliblibraryinPython第13题Whichofthefollowingarecommonbusinessdatacollectionchannels?()ACRMSysteminEnterpriseBTransactionrecordsone-commerceplatformCUserbehaviordataonsocialmediaplatformsDIndustrystatisticspublishedbythegovernment第14题Whichofthefollowingareprinciplesofdatacollection?()ATimelinessBAccuracyCCompletenessDLegality第15题Thegoalsofbusinessdataanalysisusuallyinclude()AIncreasecustomersatisfactionBIncreasecorporateprofitsCIncreasemarketshareDImproveoperationalefficiency第16题Whatfactorsshouldbeconsideredintheselectionofdataacquisitiontools?()ATypeofdatasourceBEfficiencyandaccuracyofacquisitionCCostandeaseofuseoftoolsDAestheticdegreeofthetool第17题Amongthefollowingbehaviors,whichisinlinewithdataethicsis()AGetindustryreportsusingpublicAPIsBPurchaseunmaskedusermobilephonenumbersCCrawldatafrombannedclausewebsitesDUnauthorizedsharingofpartnerdata第18题Indatacollectioncompliance,thelawsandregulationsthatmustbefollowedare()AAnti-UnfairCompetitionLawBPersonalInformationProtectionActCTrademarkLawDAdvertisingAct第19题Amongthefollowingtools,whichisnotthenativedataanalysistoolofe-commerceplatformis()ABusinessAdvisorBJDBusinessIntelligenceCDouyinE-commerceCompassDGoogleAnalytics第20题Thecoreobjectiveofbusinessdatacollectionplanis()AOnlyfordatavisualizationBOnlyforincreasingdatastoragecapacityCSupportbusinessdecision-makingandresourceoptimizationDMeettechnicalcompliancerequirementsonly第21题Whichofthefollowingsarethemaincollectionchannelsofindustrydata:()AGovernmentstatisticalyearbook,industryassociationreportBUserbehaviorlog,CRMsystemCReviewsonsocialmedia,pricesone-commerceplatformDInventoryturnoverrate,conversionrateModule3Text第1题UseExcel'sColumnfeaturetoconvertdatesintextformattostandarddateformat.()第2题Outliersmustbeerroneousdataandmustbedeletedtoensureanalysisaccuracy.()第3题Fieldmatchingmustrelyonuniqueassociatedfields,suchasordernumbers,inordertoachievedatamerging.()第4题Dataconversioncanleadtothelossofdatainformation,soitshouldbeavoidedasmuchaspossible.()第5题Datacleaningonlyrequiresremovingduplicatedataandeliminatingtheneedtohandlemissingvaluesandoutliers.()第6题Thecoreobjectivesofbusinessdataprocessinginclude()AImprovedataquality(completeness,consistency,accuracy)BProvidereliablebasisfordataanalysisanddecision-makingCEliminatealloutliersinthedataDIntegratemulti-sourceheterogeneousdata第7题InExcel,themethodsofdatamerginginclude()AMergefieldsusingthe'&'operatorBMergemultipleworksheetswithPowerQueryCBatchmergeworkbookswithVBAcodeDCopyandpastedatamanually第8题Commonmethodsofdealingwithoutliersinclude()ARemoveoutliersBTreatasmissingvaluesCReduceoutliersweightsDDirectretentionandnoprocessing第9题Whichofthefollowingsarebusinessdataconversionoperations?()ADatarowandcolumntranspositionBDatatypeconversionCDatacalculation(e.g.formulacalculation)DFieldmatching(e.g.VLOOKUP)第10题Themainoperationsofbusinessdatacleaninginclude()ARemoveduplicatedataBSupplementmissingdataCCorrectlogicerrordataDConvertdataformat第11题Inbusinessdatamerging,theoperationofintegratingmultipleworksheetdataintothesameworkbookis()AFieldmergingBWorkbookmergingCWorksheetmergingDDatatypemerging第12题Whichofthefollowingmethodscanbeusedtodealwithdatamissingvalues?()AMeanimputationBPivottablemethodCAdvancedfiltermethodDConditionalformattingmethod第13题Thecorepurposeofbusinessdatatransformationis()AIncreasetheamountofdataBTransformdataintocanonical,easy-to-analyzestructuresCDeleteinvaliddataDMergemultipleworksheets第14题Whichofthefollowingisnottheobjectofbusinessdatacleaning?()ADuplicatedataBMissingdataCOutliersDCategorizeddata第15题IfthestringincellA1is"Huawei"andthestringincellA2is"Mate60",andifyouwanttodisplay"HuaweiMate60pro5GPhone"incellA3,youshouldentertheformulaincellA3as()A=A1&A2&+"pro5GPhone"B=A1&A2&"pro5GPhone"C=A1+A2+"pro5GPhone"D=Al-A2-"pro5GPhone"第16题Thedatain()inFigure3-49isofthetexttype.ACellB1BCellB2CCellB3DCellB4Module4Text第1题TheAIrecommendationsystemonlyreliesonhistoricalpurchasedataanddoesnotanalyzereal-timebehavior.()第2题Intheproductlifecycle,thecorestrategyduringtherecessionperiodistoincreaseproductioninvestment.()第3题Customerrepurchaserate=(numberofrepeatedpurchasecustomers÷totalnumberofcustomers)×100%.()第4题Supplierdeliverypunctualityrate=(numberofdelayeddeliveryorders÷totalnumberoforders)×100%.()第5题Inthecharttrendpredictionmethod,theclosertheR-squarevalueisto0,themorereliablethepredictionis.()第6题AIsentimentanalysistechnologycanbeusedtoanalyzesatisfactionincustomerreviews.()第7题Thehighertheinventoryturnoverrate,thelowertheefficiencyofinventorymanagement.()第8题IntheRFMmodel,theMvaluerepresentstheconsumptionfrequency.()第9题ThesmallerthevalueofHerfindahlIndex(),thestrongerthemonopolyoftheindustry.()第10题Thepurposeofdatacleaningistoeliminatetheinfluenceofdirtydataonanalysisresults.()第11题Strategiestopromotecustomerloyaltyinclude:()AOptimizetheshoppingexperienceBEstablishamembershipsystemCIncreaseadvertisingdeliveryDConductcustomercareactivities第12题Themaindimensionsofcompetitiveproductanalysisinclude:()APriceandsalesdataBCustomerevaluationcontentCLogisticsdeliverytimeDPromotionstrategy第13题Incompetitiveproductanalysis,thedimensionsthatneedattentioninclude:()APricestrategyBProductfeaturesCUserreviewsDBrandhistory第14题Commonmethodsofdatapredictioninclude:()AMovingaveragemethodBExponentialsmoothingmethodCCharttrendforecastingmethodDDatacleansingmethod第15题ApplicationscenariosofAIine-commerceinclude:()ACustomersegmentationandrecommendationsBLogisticspathoptimizationCSupplierriskassessmentDMaintenanceofproductionequipment第16题Keyindicatorsforsupplychaindataanalysisinclude:()APurchasecostsBSupplierdeliverypunctualityCInventoryturnoverrateDCustomersatisfaction第17题Factorsaffectingcustomerloyaltyinclude:()AProductqualityBAfter-salesserviceCLogisticscostsDBrandimage第18题Dimensionsofcustomerclassificationinclude()AValueattributeBBehavioralattributeCSocialattributeDGeographicalattribute第19题ThethreecoremetricsoftheRFMmodelare:()ARecencyoflastpurchase(Recency)BFrequencyofconsumption(Frequency)CMonetaryamountspent(Monetary)DCustomerage(Age)第20题Thecorecontentsofmarketdataanalysisinclude()AIndustrydevelopmentanalysisBCustomerdemandanalysisCCompetitiveproductanalysisDAnalysisofsupplychainefficiency第21题Whatisincludedinmarketdemanddataanalysis?()APricepreferenceanalysisBBrandpreferenceanalysisCIndustryconcentrationanalysisDAttributepreferenceanalysis第22题Indataforecasting,theweightdistributionofexponentialsmoothingmethodtorecentdatais:()ASameasforwarddataBHigherthanforwarddataCLowerthanforwarddataDRandomassignment第23题WhenAIevaluatessupplierperformanceinsupplychainmanagement,themainanalysisis:()ACustomerevaluationsentimentanalysisBOn-timedeliveryrateandqualitydataCSocialmediadiscussionheatDProductclick-throughrate第24题IfanenterprisefindsthattheinventoryturnoverrateofacertainSKUislow,themostlikelymeasurestotakeare:()AIncreaseadvertisinginvestmentBReducepurchasesorpromotionalclearanceCRaiseproductpricesDOptimizelogisticsroutes第25题Thebasisofcustomerportraitconstructionis:()ADatacleansingBDatacollectionandcollationCDatavisualizationDDataencryption第26题Thecoreobjectivesofmarkettrendanalysisare:()ACalculateindustryconcentrationBForecastfuturechangesinmarketdemandCStatisticsoncustomeragedistributionDOptimizelogisticscosts第27题Theformulaforcalculatingproductclick-throughrate()is:()A(Numberofclicks÷Numberofimpressions)×100%B(Conversionvolume÷Numberofclicks)×100%C(Sales÷Numberofdisplays)×100%D(Orderquantity÷Numberofclicks)×100%第28题Insupplychainmanagement,AIoptimizesbyanalyzingtrafficdata:()AProductionplanningBLogisticsdistributionrouteCSupplierselectionDCustomerportrait第29题Whenusingthemovingaveragemethodtoforecastsales,ifthethree-periodmovingaverageisselected,theforecastvalueisbasedon:()AAverageoflast3monthsBAveragevalueofallhistoricaldataCAverageofprevious3yearsD3randomlyselecteddatapoints第30题Measuresofcustomerloyaltydonotinclude:()ARepeatpurchaserateBCustomerlifecyclevalue(CLV)COrderprocessingtimeDRecommendationrate第31题Whichofthefollowingisthekeycontentofcompetitiveproductanalysis?()ALogisticsdeliverytimeBProductpriceandcollectionvolumeCSupplierdeliverycycleDStoragespaceutilization第32题Intheproductlifecycle,thecorestrategiesinthematurityperiodare:()AQuicklyseizethemarketBOptimizecostsandincreaseaddedvalueCExitfromthemarketDIncreaseinvestmentinadvertising第33题AIismainlyusedincustomerdataanalysisforthefollowingpurposes:()AEquipmentfailurepredictionBCustomersegmentationandaccuraterecommendationCLogisticspathoptimizationDSupplierriskassessment第34题Inthecharttrendpredictionmethod,theclosertheR-squarevalueisto1,itmeans:()ALowreliabilityofpredictionresultsBHighreliabilityofpredictionresultsCDatafluctuatesgreatlyDNotrendindata第35题Insupplychaindataanalysis,thecalculationmethodofsupplierdeliveryon-timerateis:()A(Quantityofon-timedeliveryorders÷totalnumberoforders)×100%B(Totalnumberoforders÷numberofdelayedorders)×100%C(Purchaseamount÷inventorycost)×100%D(Stockquantity÷Salesquantity)×100%第36题Thecalculationformulaofinventoryturnoverrateis:()ACostofsales÷averageinventorybalanceBTotalsalesvolume÷inventoryquantityCPurchaseamount÷inventorycostDQuantityofgoods÷totalnumberoforders第37题Ane-commerceplatformfoundbyanalyzingcustomers'browsingpathsthatusersoftenbrowsethemobilephoneaccessoriespageafterthemobilephonepage.Itbelongsto:()AAnalysisofpagebrowsingbehaviorBSearchbehavioranalysisCAnalysisofpurchasingbehaviorpatternsDCustomers’loyaltyanalysis第38题IntheRFMmodel,"R"standsfor:()AAmountofconsumptionBFrequencyofconsumptionCLatestconsumptionintervalDCustomersatisfaction第39题Whichofthefollowingisthecontentofmarketdemanddataanalysis?()AIndustrylifecycleanalysisBCustomerpricepreferenceanalysisCSupplierdeliverypunctualityDLogisticscostanalysis第40题TheHerfindahlIndex()isusedtomeasure:()AMarketsizeBIndustryconcentrationCCustomersatisfactionDSupplychainefficiency第41题Themainvalueofdatacleaningliesin:()AEnhancedatavisualizationeffectBEliminatetheimpactofdirtydataonanalysisresultsCIncreasedatastoragecapacityDSpeedupdatacollectionModule5Text第1题Whenreviewingthereport,youonlyneedtopayattentiontotheaccuracyofdata,notthestandardizationoflanguageexpression.()第2题Predictiveanalyticsreportscanhelpbusinessesplanandlayoutahead.()第3题Thewordsofbusinessdataanalysisreportshouldusetechnicaltermsasmuchaspossibletoreflectprofessionalism.()第4题AIcanonlyhandlemissingvaluesindatacleaning,butcannothandleduplicatevaluesandoutliers.()第5题Thetitlepageisjustanoptionalpartofthebusinessdataanalysisreport.()第6题Datavisualizationisjusttomakethereportlookmoreaestheticallypleasing,andhasnopracticaleffectondataanalysis.()第7题Whenperformingdataanalysis,onlyoneanalysismethodcanbeselected.()第8题Thecauseanalysisreportpaysmoreattentiontodepthandlogicthanthecurrentsituationanalysisreport.()第9题Thecurrentsituationanalysisreportismainlyusedtopredictthefuturebusinessdevelopmenttrendofenterprises.()第10题Businessdataanalysisreportsonlyneedtopayattentiontotheinternaldataoftheenterprise,andexternaldataisnotimportant.()第11题Whene-commercecompaniesuseAItoconductsalesdataanalysisreports,AIcanachieve()AForecastproductsalesBTapthepotentialneedsofusersCAutomaticallywritecompleteandreview-freereportsDSmartrecommendationvisualchart第12题TheAIoptimizationdataanalysisprocessisreflectedin()AIntelligentalgorithmselectionBDeepdataanalysisCDatavisualizationeffecthasbeenenhancedDAutomaticdatacollection第13题AIapplicationsindatacollectionandcollationinclude()AAutomateddatacollectionBIntelligentdatacleansingCDatavisualizationdesignDAutomaticallygeneratereportcontent第14题Theimportanceofdatavisualizationisreflectedin()AHelpreadersquicklyunderstanddataimplicationsandtrendsBHighlightdatafocusesanddifferencesCEnhancedatapersuasivenessDMakethereportformatmorestandardized第15题Thebodyofabusinessdataanalysisreportusuallyincludes()ADatacollectionandcollationBDataanalysisprocessandresultsCInterpretationofresultsDCatalogue第16题Commonlyuseddataanalysismethodsare()ADescriptivestatisticalanalysisBRelevanceanalysisCRegressionanalysisDClusteranalysis第17题Thedataproblemsthatneedtobedealtwithindatacleaningare()AMissingvalueBDuplicatevalueCOutliersDAveragevalue第18题Sourcesfordatacollectioninclude()AInternalenterprisesalesdataBSocialmediadataCThird-partydataplatformdataDGovernmentStatistics第19题Whenenterprisemanagementreadsbusinessdataanalysisreports,thecontentstheypayattentiontoare()AEnterprisemarketpositionBProfitabilityCGrowthtrendDSpecificbusinessoperatio