|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/powerbi-hero/
课程评论:没有评论
课程名称:PowerBI 从零到英雄 概述:欢迎参加这门 Microsoft Power BI 课程。如果您想迅速掌握连接、转换、可视化和分析数据的最佳工具,您来对地方了。我们将通过实践学习方法,从零开始将您培养成 Power BI 专家,帮助您快速构建分析解决方案。我的名字是 Abdelkarim M. MAHMOUD,我是一名获得 Power BI 认证的顾问。在过去的几年里,我帮助不同类型的组织通过数据提升绩效与竞争力。我有幸培训了从普通 Power BI 用户到首席数据官的多个团队,现在我将以简单实用的方式分享我的专业知识。 该课程结合了理论与实践,涵盖了多个 Power BI 的使用案例,以帮助您充分利用数据。以下是课程的主要内容: 1. **介绍** - 什么是 Power BI?使用 Power BI 的更多理由,尤其是如果您使用 Excel。 2. **课程结构和资源** - 简要介绍与界面概览。 3. **第1章 - 在 Power Query 中提取、加载和转换数据**:连接数据库、数据类型、过滤、列的处理、数据源的连接等。 4. **第2章 - 数据建模**:表和关系,维度建模的最佳实践,优化开发时间的模型。 5. **第3章 - 用于数据分析的 DAX 表达式**:使用度量创建计算和 KPI,年度对比,DAX 的使用等。 6. **第4章 - 数据可视化**:数据可视化的重要性,饼图与树形图,层级,过滤,复合图表,人工智能元素等。 7. **第5章 - Power BI 服务**:在 Power BI 中的共享与协作,如何将报告发布到 Power BI 服务中,以及深入了解 Power BI 服务。 课程旨在帮助您快速掌握 Power BI 的使用,让您在数据分析领域脱颖而出。
Hello & Welcome to this Microsoft Power BI course. If you're trying to quickly master the most suitable tool for connecting, transforming, visualising, and analysing your Data, you are in the right place. We will take you from zero to hero, through our practical learning approach, and will quickly get you up running & building analytical solutions for your organisation.My name is Abdelkarim M. MAHMOUD, and I am a Power BI certified Consultant. I have spent the last years empowering different type of organizations by helping them gain performance and competitivity through their Data. I had the chance and the pleasure to train dozens of teams from simple Power BI users to Chief Data Officers. I am here today to put all my expertise at your disposal in a simple and practical way.This in-depth training strikes the perfect balance between theory and practice, several PowerBI use cases are covered to allow you to get the most value from your data. Here's what we're gonna dive into:Introduction - What is Power BI ?More reasons to use Power BI ESPECIALLY if you use excelResources & Course StructureQuick tour & Interface overviewChapter 1 - Extract, Load, and Transform Data in Power QueryPower Query, Connecting to a Database and Data TypesFilteringRemoving & Ordering ColumnsConditional ColumnsConnecting to a folder as a Data SourceCombining DataDealing with less structured dataFixing ErrorsChapter 2 - Data Modeling ?Tables and RelationshipsBEST PRACTICE: Dimensional Modeling & Star SchemasBEST PRACTICE: Optimising The model for Development TimeChapter 3 - DAX for Data Analysis ExpressionsDAX, the "POWER" in POWER BIUsing Measures to create Calculations and KPIsComparing this year's Value to last year's valueYear over Year Varience, and Waterfall ChartsYear to Date with DAXChapter 4 - Data VizualisationWhy Data Visualisation Really MattersPie Chart and TreemapHierarchiesFiltering and TopNDual-Axis (Combo) ChartAdvances Visual Analytics Pane - Trends, Targets, Forecasts and moreArtificial Intelligence: Decomposition Tree, Q & A and Key InfluencersSlicersMAPS and Dynamic Coloring!Fancy TablesChapter 5 - Power BI ServiceSharing and Collaboration in Power BIHow to Publish a report to the Power BI serviceDeep Dive into the Power BI service