|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-and-dashboards-for-the-busy-professional/
课程评论：没有评论
**课程名称：** 使用 Power BI 进行商业智能和自动化报告 **课程概述：** 本课程旨在帮助学员从对 Power BI 的初步了解，成长为能够创建富有洞察力且交互式报告/仪表板的专业人士。通过实践操作，学员将学习如何利用 Power BI 驱动业务流程和实现报告自动化，将数据分析提升到商业智能 (BI) 的新高度。 **课程将涵盖以下核心内容：** * **数据获取：** * Power BI Desktop 数据源连接（Web 数据、Web 应用、Excel 工作簿、企业数据库） * **数据转换与 DAX：** * Power Query 数据转换和组合（Unpivot, Pivot, Split Column, Append Tables, Merge Tables, Remove rows, Use first row as header, Merge Columns, Add Columns, Group By, Extract, Fill, Transpose 等常见操作） * M Code 参考资源 * 数据模型构建（关系创建、基数、方向） * 数据准备（数据类型、数据格式） * DAX 基础（新建列、新建度量值、新建表，常用 DAX 公式，DAX 公式参考指南） * 行级别安全性（通过角色控制报告访问权限） * **报告创建：** * 报告构建器（Power BI Desktop） * 原生和自定义视觉对象的使用 * 菜单工具的应用，打造专业外观的报告 * 交互编辑，控制视觉对象之间的联动 * 从零开始创建报告 * **报告发布、仪表板与 Power BI 服务：** * 工作空间概念理解 * 报告发布（从 Power BI Desktop 到 Power BI 服务） * 通过角色控制报告访问（区域、部门、级别） * 报告导出选项（PowerPoint, PDF） * 报告嵌入（SharePoint, 网站） * 通过 Web 链接分享报告 * 与特定用户分享报告 * 报告编辑（添加新视觉对象，更改现有视觉对象，创建新报告页面） * 在报告中添加评论和标记用户 * 报告定时发送（每日/每周） * 创建仪表板（整合一个或多个报告的分析） * 整合他人分享的数据和视觉对象 * 设置警报（KPI 达成或 SLA 违约时即时通知） * 在仪表板中添加可操作评论 * 仪表板定时发送（每日/每周） * 与最终用户分享仪表板 * **最佳实践与设置：** * 自动/计划刷新设置，实现数据自动摄取 * 数据网关配置（需要数据网关的数据源类型） * AI in Power BI（Q&A 功能，用于自动生成图表和表格） * 组织、账户、工作空间、仪表板、报告、数据集等各项设置 **课程亮点：** * 提供共享 Power BI Pro 账户，供学员练习所有 Power BI 功能。 * 定期举行在线支持会议，提供更丰富的学习体验，并帮助学员将所学知识与职业发展相结合。 * 报名即可终身享受此项权益。 * 本课程强调“动手实操”，确保学员熟练掌握 Power BI。
**We give participants access to a shared Power BI pro account so they can practice all the full aspects of Power BI. We also do regular live support sessions to give a more enriching experience and help you align what you are learning with career growth. Enroll now to get this benefit for life!**This course is a fully hands-on one to take you from just having an idea of what Power BI does to being able to create insights-rich and interactive reports/dashboards in Power BI that can drive business process and report automation and take you from just data analysis level to Business Intelligence (BI). We cover the following aspects:Get Data (bringing in your data for analysis)Data Sources in Power BI DesktopConnect to web data and web appsImport Excel WorkbooksConnect to enterprise DatabaseData Transformation, Power Query and DAXGet Data Model section of the report builder (Power BI Desktop)Creating RelationshipsCardinalityDirectionData section of the report builder (Power BI Desktop)Data TypeData FormatDAXNew ColumnNew MeasureNew TableMust know DAX formulasDAX formula reference guideRow level Security to control report access using roles (dept, function, branch, cost centre etc)Report section of the report builder (Power BI Desktop)Report creationNative VisualsCustom VisualsMenu Tools for professional looking reportsEdit InteractionsReport creation from scratchPower QueryTransforming and Combining Data before loading to ModelCommon Power Query tasksUnpivotPivotSplit ColumnAppend TablesMerge TablesRemove rowsUse first row as headerMerge ColumnsAdd ColumnsGroup ByExtractFillTransposeM Code reference resourceReport Publishing, Dashboards and Power BI ServiceUnderstanding the concept of WorkspacesPublishing report (from Power BI desktop to Power BI service for consumption)Controlling access to aspects of the report by role (region, department or level)Published Report optionsExporting to PowerPoint or PDFEmbedding in SharePointEmbedding in a websiteMaking it available via a web linkSharing with specific usersEditing the report - adding new visuals, changing visuals used and creating new report pagesAdding comments and tagging usersScheduling the report to send our daily or weekly to specific peopleCreating a DashboardCan be created from one or more reports to show management useful analysisCan incorporate data and visuals from other people's dashboards or reports shared with youSet Alerts to be instantly notified when a KPI is reached or an SLA is breachedAdd actionable commentsSchedule the dashboard to be sent out daily or weekly to specific peopleShare the dashboard with final usersBest practicesSetting automatic/scheduled refresh so new data is ingested automaticallyData Gateway configurationThe type of data sources that require data gatewayAI in Power BI and SettingsQ & A for autogenerating charts and tables in answer to questionsOrganization wide settingsAccount wide settingsWorkspace settingsDashboard settingsReport settingsDatasets settingsThis is the course to solidify your Power BI proficiency.
