|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-intermediate-course-beyond-the-basics/
课程评论：没有评论
**课程名称：** Power BI 中级课程：超越基础 **课程概述：** 本课程是微软 Power BI 业务分析服务的进阶培训，旨在帮助学员在掌握基础知识后，进一步提升 Power BI 的使用能力。课程提供可下载的讲师文件，方便学员同步学习。 Power BI 以其交互式可视化和商业智能解决方案，以及直观的界面，使各级别用户都能轻松创建报告和仪表板。本课程是入门课程的延续，**强烈建议已有 Power BI 基础知识的学员学习，否则请先完成入门课程。** 课程内容涵盖： * **数据导入与转换：** * 使用 Power Query 导入和转换数据 * 导入 Excel、文本、CSV 文件并合并 * 启用/禁用加载和报表刷新 * 解决数据导入错误 * **数据建模：** * 数据建模、关系类型和故障排除 * 创建度量值（Measures）与计算列（Calculated Columns） * 使用 DAX 创建计算日期表 * 创建附加列和条件列 * 使用 ROUNDUP 和 SUMX 函数 * 创建快速度量值（Quick Measures）和关键度量值表 * 深入学习 DAX 中的 CALCULATE 函数 * **可视化与仪表板：** * 表格（Tables）与矩阵（Matrix）表格的应用 * 可视化格式设置和条件格式化 * 使用列图、折线图、地图图 * 使用仪表（Gauge）和卡片（Card）可视化 * 使用切片器（Slicers）和筛选器（Filters），并应用设计元素 * **Power BI 服务与仪表板：** * 在 Power BI 服务中创建共享工作区 * 构建报告和仪表板 * 将可视化固定到仪表板 * 设置计划刷新 **课程特色：** * 超过 6 小时的视频教程 * 68 个独立视频讲解 * 提供课程讲师文件，方便学员实践 * 完成课程可获得结业证书 **适用人群：** 已掌握 Power BI 基础知识，希望深入学习数据处理、建模、可视化以及 Power BI 服务相关功能的专业人士。
**This course includes downloadable course instructor files to follow along.**Power BI is a powerful business analytics service from Microsoft. It provides interactive visualizations and business intelligence solutions. Power BI has an intuitive interface, enabling users at all skill levels to create their own reports and dashboards.This intermediate training course is designed to be a continuation of the introductory Power BI course. If you have no experience with the software, we recommend starting with that course, which will familiarize you with the Power BI basics and interface, basic knowledge that is a prerequisite for the intermediate level.We start the intermediate course by discussing the data files to be used and some Power BI desktop settings that will set you up for success. The latter part of the course is an intensive exercise to give you practice creating reports and dashboards.This course includes course files to follow along with your instructor and uses the Power BI Desktop version.This course will cover:Importing and transforming data in Power QueryImporting Excel, text, and CSV files and combining filesEnabling/disabling load and report refreshResolving data import errorsData modeling, relationship types, and troubleshooting relationship issuesMeasures vs. calculated columnsCreating a date table with DAXCreating additional and conditional columnsUsing the ROUNDUP and SUMX functionsCreating quick measures and key measures tablesThe DAX - CALCULATE functionTables vs. matrix tablesFormatting visualizations and applying conditional formattingUsing column, line, and map chartsGauge and card visualizationsUsing slicers and filters and applying design elementsCreating a shared workspace in Power BI serviceBuilding reports and dashboardsPinning visualizations to the dashboardSetting up scheduled refreshesThis course includes:6+ hours of video tutorials68 individual video lecturesCourse instructor files so you can follow alongCertificate of completionHere's what our students are saying.★★★★★ "I like everything! Everything is clear and understandable. Perfect courses!" -Jovita Svilainiena
