|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-power-bi-the-complete-guide/
课程评论：没有评论
课程名称：Microsoft Power BI：完整指南 课程概述：本课程旨在学习当前最受欢迎的商业智能工具之一—Power BI。通过实践操作，您将掌握Power BI生态系统中的重要概念。课程项目将使用一级方程式（Formula One）数据集，创建一个互动报告，并包含令人惊叹的可视化效果。您将学习如何连接多种数据源（如CSV、Excel、JSON等），进行数据转换，使数据准备好进行报告。利用关系和数据建模方法，创建有效的数据模型，并探索各种可视化形式，如柱形图、散点图、地图、工具提示等。 课程内容还将涵盖如何使用视觉元素（例如行动图标和按钮）在报告页面之间导航，Power BI Pro的能力以及如何在组织内进行协作。此外，您将学习数据分析表达式（DAX），为Power BI报告增加洞察与分析。完成一级方程式分析项目后，您将获得丰富的技能，并体验从头到尾开发商业智能解决方案的过程，有足够的经验为您的实际项目增值。 课程大纲： 1. 数据加载与转换 - 连接数据源、理解数据类型、转换列、排序与过滤等。 2. 数据建模 - 表关系、一对多、一对一和多对多基数、自动检测、星型与雪花模型等。 3. 可视化和图表 - 可视化基础、各种图表类型、工具提示和交互等。 4. 报告设计最佳实践 - 为您的报告添加互动性，设计优良的报告界面。 5. Power BI 服务 - Power BI Pro与Premium概述、报告发布、个人工作区及协作工作区等。 本课程包含丰富的讲座、代码跟随视频、作业问题和详细的实操演练，足以让您保持参与感并不断学习。作为额外福利，您还将获得所有讲座的终身访问权限。
Learn one of the most in demand business intelligence tools around and master the most important concepts in the Power BI Ecosystem.This course is hands-on and you will LEARN BY DOING!COURSE PROJECTWe will be using a Formula One Dataset to create an interactive report with some amazing visualizations.Connect to various data sources including csv, excel, JSON and more.Perform extensive data transformations to make our data ready for reporting.Use relationships and data modelling methodologies to create an effective data model.Explore all kinds of visualisations from Column Charts, Scatter Charts, Maps, Tooltips and more.Use visual elements like action icons and buttons to navigate between pages in your report.Explore the capabilities of Power BI Pro and how it can enable you to collaborate within your OrganizationLeverage Data Analysis Expressions to add insight and analysis to our Power BI ReportBy the end of the Formula One Analysis Project you will gain extensive skills and have experience of developing a business intelligence solution end to end.You should gain more than enough experience to add value to your real world projects!CURRICULUMThis course can be split into 5 key areas:Loading and Transforming DataConnecting to data sources in Power BIUnderstanding Data TypesTransforming Columns in your QueryAdding Columns to your QuerySorting and FilteringDuplicating vs Referencing your QueryTransposing your dataGrouping and summarising your dataPivoting and Unpivoting your dataData ModellingTable RelationshipsOne to Many, One to One and Many to Many CardinalityAutodetect"Active" vs "Inactive" RelationshipsSTAR and SNOWFLAKE Modelling ApproachesDimensions and Fact TablesJoining Tables with the Merge OperationVisualizations and ChartsVisualization and Report BasicsTables and Pivot TablesMatrix VisualsBar and Column ChartsLine and Area ChartsCombo ChartsScatter ChartsTreemap ChartsCardsData Categories and Geographical ChartsTooltipsInteractions between VisualsFilters and SlicersAdding small multiplesVisual ElementsReport Design Best PracticeAdding Interactivity to your ReportPower BI ServicePower BI Pro vs Premium OverviewPower BI Pro Interface TourPublishing Reports to Power BI ProPersonal WorkspacesDashboardsAppsCollabortation WorkspacesData Analysis Expressions (DAX)Overview of the Langauges used in Power BI (M and DAX)DAX Syntax BasicsAggregation FunctionsFilter FunctionsOther FunctionsDAX DocumentationThe course is packed with lectures, code-along videos, assignment questions and detailed walkthroughs.There should be more than enough to keep you engaged and learning! As an added plus you will also have lifetime access to all the lectures.
