科技创新与应用2025，Vol.15Issue(29)：32-35,4.DOI:10.19981/j.CN23-1581/G3.2025.29.008
基于Power BI Desktop的豆瓣电影TOP250评分数据采集与可视化展示
摘要
Abstract
The complete data visualization process encompasses four stages:data collection,data processing,data analysis,and data visualization.This article demonstrates an application case using Power BI Desktop to perform multi-page web scraping,processing,and visualization of Douban Movie's TOP250 rating data.First,a query function call is executd using Power BI Desktop's M language.By adding a data column with the custom function,connections to and retrieval from multi-page web data sources are achieved.Next,field extraction and data type conversion are performed using data transformation capabilities,ultimately yielding a data table containing key fields such as movie ranking,title,rating,and release year.Finally,data visualizations are created based on the rating data for the 250 films,including bar charts,a movie score slicer,and a film information matrix table.The bar chart features a color gradient effect based on movie ratings,while the slicer and matrix table incorporate interactive linking effects,delivering an engaging visual experience.关键词
豆瓣电影/Web 数据获取/数据处理/数据可视化/Power BI DesktopKey words
Douban Movie/Web Data Acquisition/Data Processing/Data Visualization/Power BI Desktop分类
信息技术与安全科学引用本文复制引用
王敏玲..基于Power BI Desktop的豆瓣电影TOP250评分数据采集与可视化展示[J].科技创新与应用,2025,15(29):32-35,4.基金项目
2023年度校级本科高质量课程建设与创新创业教育建设改革项目(KC2023047) （KC2023047）
