|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-power-bi-essential-for-beginners/
课程评论：没有评论
课程名称：微软 Power BI 初学者与 Excel 用户课程 课程概述：本课程最初为现场录制，旨在提供互动和参与感，让你仿佛置身于与企业界参与者一起学习解决实际问题的环境中。以下是各单元所学内容： 1. 商业智能概述 - 理解商业智能的定义和重要性 - 从数据到智慧的转变 2. Power BI 的商业智能流程 - 探索数据周期及其在 Power BI 中的应用 - 传统工具（如 Excel）的局限性 - Power BI 的不同许可选项 3. 数据转换技巧 - 引入 Power BI 查询编辑器 - 识别常见数据问题 - 高效数据清洗步骤： - 删除列和行 - 设置第一行为表头 - 更改数据类型、替换值和删除空格 - 处理错误、重命名和优化步骤 - 填充缺失值、拆分列和去重 - 自动化数据清理的技巧和窍门 4. 数据建模与数据丰富 - 数据建模基础及构建关系 - 理解过滤传播和基数 - 数据模型构建的最佳实践 - 数据丰富简介：创建计算列和度量值 5. 数据可视化基础 - 熟悉 Power BI 的原生和自定义可视化 - 实操创建各种图表（饼图、折线图、柱状图）、表格和卡片 - 掌握层次下钻和视觉交互设置 - 格式化可视化和报告，包括标题、图例和坐标轴 - 使用切片器及不同级别的筛选 - 应用条件格式，嵌入图片到报告中 6. 发布与共享洞察 - 报告发布步骤及设定默认用户体验 - 创建及管理协作工作区 - 有效共享报告的策略 - 为移动布局设计报告 本课程强调实践和互动，帮助学员熟练掌握 Power BI，解决实际工作中的数据分析挑战。
Dive into a course initially recorded live, making it engaging and interactive. You won't just be passively learning; you'll feel like you're right there in the room with participants from the corporate world and learning solutions to REAL problems.Here's what you'll learn in each unit:Introduction to Business IntelligenceOverview of Business IntelligenceThe journey from data to wisdomUnderstanding the Business Intelligence process with Power BIUnderstanding the Data CycleExploring the limitations of traditional tools like ExcelReviewing different licensing options in Power BIData Transformation Techniques in Power BIIntroduction to Power BI Query EditorCommon issues with data and how to identify themSteps for effective data cleaning:Removing columns and rowsSetting the first row as headerChanging data types, replacing values, and removing spacesHandling errors, renaming and optimizing stepsFilling down missing values, splitting columns, and removing duplicatesTips and tricks to automate data cleaningData Modeling and EnrichmentBasics of data modelling and building relationshipsUnderstanding filter propagation and cardinalityBest practices in data model constructionIntroduction to data enrichment: Creating calculated columns and measuresBasics of Data VisualizationFamiliarization with native and custom visuals in Power BIHands-on creation of various charts (pie, line, bar), tables, and cardsTechniques for drilling down hierarchies and setting visual interactionsFormatting visuals and reports, including titles, legends, and axesUtilizing slicers and different levels of filteringApplying conditional formattingEmbedding images into reportsPublishing and Sharing InsightsSteps to publish reports and set default user experiencesCreating and managing workspaces for collaborationStrategies for sharing reports effectivelyDesigning reports for mobile layouts
