|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-essentials-from-basic-to-intermediate-training/
课程评论：没有评论
课程名称：Power BI 基础与中级培训 课程概述： 通过我们的综合性 Power BI 基础培训项目，解锁数据可视化与分析的强大力量。无论您是完全没有经验的初学者，还是希望扩展技能的中级用户，本课程都旨在为您提供坚实的基础和实用知识。在这段实践培训中，您将体验从掌握基础知识到熟练运用中级 Power BI 技巧的全过程。此外，培训结束时您将获得一份优秀的技巧与窍门指南，确保您能够随时查找和利用工具的核心概念与功能。 完成此 Power BI 基础培训后，您将拥有自信与能力，能够创建深入的报告和仪表盘，从而推动明智的决策。无论您是商业专业人士、分析师，还是渴望成为数据爱好者，此课程将助您充分发挥 Power BI 的潜能。立即加入我们，踏上从基础到中级的数据分析技能提升之旅。 课程大纲： 1. Power BI 介绍： - 商业分析 - 课程介绍 - 商业智能与 Power BI 的区别 - 理解数据可视化在决策中的重要性 - 熟悉 Power BI 的界面与组成部分 2. 数据源连接： - 如何获取数据 - 连接 CSV 文件 - 连接文本文件 - 网页数据导入 - 连接文件夹（多个文件） - JSON 数据导入 - 连接 Excel 文件 3. 数据准备与清洗： - Power Query 转换 - 新查询 - 列操作 - 分组 - 切割列 - 合并/附加查询 - 列数据类型 - 日期与时间列 - 透视与反透视列 - 自定义列 - 条件列 4. 数据建模与关系： - 商业智能概念 - 维度与事实表 - 创建数据模型 - 创建关系 - 创建日历维度 - 在 KPI 表创建度量 5. 探索对象： - 表格与矩阵的使用 - 卡片的使用 - 饼图与树图的使用 - 条形图与折线图的使用 6. 过滤与交互： - 对象之间的过滤与交互 7. 创建可视化： - 布局创建 - 主题与布局创建：使用主题 通过本课程，您将步入 Power BI 的世界，提升您的数据分析能力。现在就报名参加吧！
Unlock the power of data visualization and analysis with our comprehensive Power BI Essentials training program. Whether you're a beginner with no prior experience or an intermediate user looking to expand your skills, this course is designed to provide you with a solid foundation and practical knowledge of Power BI.In this hands-on training, you'll embark on a journey from mastering the basics to becoming proficient in intermediate-level Power BI techniques. As an additional, in the end of the training you should have an excellent tips and tricks guide repository, ensuring that you can always find and use the tool's core concepts and features.By the end of this Power BI Essentials training, you'll have the confidence and competence to create insightful reports and dashboards that drive informed decision-making. Whether you're a business professional, analyst, or aspiring data enthusiast, this course will empower you to harness the full potential of Power BI. Join us and take your data analysis skills from basic to intermediate level. Enroll now and embark on your journey to becoming a proficient Power BI user.Course Curriculum:Introduction to Power BI:Business Analysis - Course IntroductionWhat is Business Intelligence vs What is Power BIUnderstand the significance of data visualization in decision-making.Familiarize yourself with Power BI's interface and components.Connecting to Data Sources:How to Get DataConnecting with CSV FilesConnecting with Text FilesWeb Data ImportConnecting with Folders (Multiple files)JSON Data ImportConnecting with Excel FilesData Preparation and Data Cleansing:Power Query TransformationsNew QueryWorking with ColumnsGroup bySplit ColumnsMerge / Append QueriesColumn data typesDate & Time ColumnPivot and Unpivot columnsCustomn columnsConditional columnsData Modeling and Relationships:Business Intelligence ConceptsDimension and Fact TablesCreating a Data ModelCreating RelationshipsCreate calendar dimensionCreating Measures in a KPI TableUsing lookup dataExploring Objects:Working with Tables and MatrixWorking with CardsWorking with Pie Charts and TreeMapWorking with Bar Chart and Line ChartFilters and Interactions:Working with Filter and Interactions between objectsCreating Visualizations:Layout CreationThemes and Layout Creation:Using Themes
