基于PowerBIDesktop的豆瓣电影TOP250评分数据采集与可视化展示

打开文本图片集

中图分类号：TP311 文献标志码：A 文章编号：2095-2945（2025）29-0032-04

Abstract：Thecompletedatavisualizationprocessencompassesfourstages：datacollectiondataprocessing，dataanalysis， anddata visualization.ThisatcledemonstratesanaplicationcaseusingPowerBIDesktop toperformmulti-page webscraping， processing，andvisualizationofDouban Movie'sTOP25Oratingdata.First，aqueryfunctioncallisexecutdusingPowerBI Desktop'sMlanguage.Byaddingadatacolumnwiththecustomfunction，connectionstoandretrievalfrommulti-pagewebdata sourcesareachieved.Next，fieldextractionanddatatypeconversionareperformedusingdatatransformationcapabilities， ultimatelyyieldingadatatablecontainingkeyfieldssuchasmovieranking，title，rating，andreleaseyear.Finaly，data visualizationsarecreatedbasedontheratingdataforthe25Ofilms，includingbarcharts，amoviescoreslicer，andafilm informationmatrixtable.Tebarchartfeaturesacolorgradientefectbasedonmovieratings，whiletheslicerandmatrixtable incorporate interactive linking effects，delivering an engaging visual experience.

Keywords： Douban Movie;Web Data Acquisition; Data Processing;Data Visualization; Power BI Desktop

数据的价值在于蕴含的信息。（剩余3710字）