|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/apis-with-power-bi-and-other-advanced-techniques/
课程评论：没有评论
**课程名称：** 使用 Power BI 及其他高级技术进行 API 操作 **课程概述：** 本课程将带您使用免费的 OpenWeather API 免费创建一个炫酷的天气仪表板。您将学习如何连接到 API、对 API 进行参数化设置、解析 JSON 数据、处理 Unix Epoch时间、在 Power BI 中使用表情符号、动态链接到互联网图片等一系列高级技巧。 **课程级别：** 中级。要求学员具备 Power BI 的基础知识。课程节奏较快，但所有必要内容都会在视频中详细讲解。 **课程内容：** 1. **连接与探索 OpenWeather API：** 学习如何连接到免费的 OpenWeather API 并探索其数据内容。 2. **将 API 数据导入 Power BI Desktop：** 掌握将 API 获取的原始数据导入 Power BI 的方法。 3. **API 参数化：** 将 API 调用转换为参数化形式，以便轻松调整查询，例如切换公制与英制单位。 4. **JSON 数据解析：** 学习如何将 API 返回的 JSON 数据解析成 Power BI 可用的格式。 5. **数据格式化与优化：** * 将 Unix Epoch 时间转换为标准日期时间格式。 * 清晰展示数据刷新时间，避免查看过时信息。 * 在 Power BI 报表中嵌入表情符号，无需插件即可添加图形元素。 6. **报表可视化与美化：** * 创建包含多个图表和视觉对象的天气预报报表。 * 深入讲解如何格式化图表，使其既美观又信息丰富。 * 学习如何链接到互联网上的图片，增强报表的视觉吸引力。 **课程亮点：** * 全程使用 Power BI Desktop 的内置功能，无需额外插件。 * 学习完整的 API 数据接入和 Power BI 报表制作流程。 * 掌握链接外部资源、处理日期时间、使用表情符号等实用技巧。 **目标学员：** 希望学习如何从 API 获取数据并利用 Power BI 制作功能强大、视觉吸引人的仪表板的 Power BI 用户。
This course will show you how to use the free OpenWeather API to create an awesome Weather Dashboard. You will learn about connecting to APIs, parameterizing APIs, parsing JSON, dealing with Unix Epoch Time, incorporating emoji into Power BI, dynamically linking to images on the internet, and much more.This class is an intermediate level class. You should have basic familiarity with Power BI already. We will move quickly, but everything necessary will be covered in the videos.We will begin by connecting to the (free) OpenWeather API and exploring its contents. Then we will move on to importing this data into Power BI Desktop. We will quickly change this into a parameterized call so that adjustments can be made to it very easily, such as requesting metric units instead of imperial units. Initially we will have JSON data from the API in Power BI. We will go over how to parse this information into a format Power BI can use.We will then begin formatting our data so that it looks nicer. We will also be covering how to convert from Unix Epoch Time into our more standard datetime format. We'll make sure to prominently display the last time the data was refreshed so we can make sure we aren't looking at stale weather data.We'll even be incorporating emoji into our report as a quick and easy way to add graphics to Power BI without any plugins or add-ons. Everything in this class is just using out-of-the-box Power BI Desktop.The report will have multiple charts and other visuals to display a nice, easy to read weather forecast. We'll go in-depth on how to format these so that they look clean while still displaying important information. And also cover how to link to images hosted on the internet to make the report really pop.Take this class to learn how to do the complete start-to-finish process of bringing in API data and creating a great looking Power BI report.
