|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/analyzing-covid-19-data-with-power-bi/
课程评论:没有评论
课程名称:2021年使用Power BI分析Covid-19数据 课程概述:新冠疫情对我们每个人的生活产生了深远的影响,造成了商业停摆、经济波动和健康问题,也让我们失去了许多亲人。为了分析Covid-19的影响,我们采用了微软的Power BI这一数据可视化工具。Power BI提供免费桌面版本,但专业使用需要购买许可证,分为专业版和高级版。该工具可以从多种数据源获取数据,包括数据库、平面文件、Excel文件、SharePoint和网页等,并使用基本的ETL工具——Power Query进行数据处理。 本课程基于Covid-19的开源数据集,这些数据集来自“我们的世界数据”(Our World in Data)网站和爱尔兰政府的官方网站。我们在课程中使用了以下工具和技术:SQL Server(用于提取数据集)、Power BI桌面(用于创建可视化)、Power Query(进行数据转换)、Power BI服务(发布报告)以及Python(用于在Power BI中进行Python可视化)。希望我们的努力和贡献能为您带来价值。
Covid-19 has hit all of us badly. Its impressions will last forever. It has shutdown businesses, affected economies and without a question, health. We have lost a lot of near and dear ones. To analyze the effects of Covid-19, we have used Power BI. Power BI is a data visualization tool by Microsoft and it has free desktop version. However, to use it professionally, we need to purchase the license. There are two types of license available - pro and premium. Power BI can get data from assorted data sources like databases, flat files, excel files, sharepoint, web etc. It used a basic ETL tool - Power query.This course is based on the open source datasets of covid-19. The datasets referred here are taken from the 'Our world in data' website and the official website of Irish Government. We have used following tools and technologies in this course - SQL server, Power BI desktop, Power query, Power BI service, Python. We have used SQL server to fetch one of the data-set, Power BI desktop for creation of visualizations, Power query for transformations, Power BI service for publishing the report and Python for Python visuals in Power BI. I hope you will like our efforts and contributions in this field.