|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-power-bi-desktop-for-business-intelligence-pl300/
课程评论：没有评论
课程名称：Microsoft POWER BI Desktop for Business Intelligence & PL300 课程概述：如果您是数据专业人士或有志于成为分析师，想学习市场上顶尖的商业智能平台，那么您来对地方了。本课程专为希望分析来自多个来源的数据、创建个人数据集并将结果转换为美观且易于制作的可视化效果的学员而设。您还希望与同事分享结果或合作项目，并能够从多个设备访问数据吗？那么Power BI工具就是您的最佳选择！ 随着全球企业实施Power BI解决方案，市场对熟练专业人才的需求也急剧增加。现在学习Power BI的人，将在未来获得最佳的就业机会。立即获取我们畅销的Power BI课程，成为备受追捧的Power BI专业人士。 在本课程中，您将学习Power BI为何为您的数据分析目标提供全面的商业智能工具，以及如何使用这些工具完成上述所有任务和更多。想象一下，您可以快速整理数据，轻松添加计算公式，并在几分钟内创建和发布精美的图表。 您将学习到的内容包括： - 了解Power BI宇宙中的不同工具及其使用 - 理解Power BI Desktop及其组件 - 学会使用查询编辑器将Power BI连接到各种数据源，工作于数据模型，并理解这两个步骤之间的区别 - 学会过滤和格式化数据，掌握数据透视和反透视的工作原理 - 理解数据模型的不同视图 - 创建计算列和度量值 - 建立不同表之间的关系 - 使用不同的交互式可视化类型创建报告 - 使用Power BI Pro创建仪表板、分享和发布结果 - 使用Power BI Mobile从多个设备访问结果 - 以及更多！ 课程还提供20个精彩的Power BI模板！此外，将深入讨论Power Query这一微软创建的ETL工具，它用于数据的提取、加载和转换，帮助您从各种来源检索数据，进行处理并加载到一个或多个目标系统中。 本课程将帮助您掌握Power BI的核心功能，并为您的数据分析和商业智能需求提供坚实的基础。
If you're a data professional or aspiring analyst looking to learn the top business intelligence platform on the market, you've come to the right place.You want to analyze data from single or multiple sources? You want to create your individual datasets based on these sources and transform your results into beautiful and easy-to-make visualizations? You also want to share your results with colleagues or collaborate on your projects? Finally, you want to be able to access your data from multiple devices?Then the Power BI tools are the tools to choose for you!POWER BI SKILLS ARE IN HIGH DEMANDAs companies worldwide implement Power BI solutions, there's a big gap in the job market for skilled professionals. People who learn Power BI today, will be first in line for the best jobs tomorrow. Get access to our best-selling Power BI course now and become a highly sought-after Power BI professional.In this course you will learn why Power BI offers you a comprehensive set of Business Intelligence tools for your data analysis goals and how to use these tools to fulfill all of the above tasks - and more. Imagine to quickly structure your data, to easily add calculations to it and to create and publish nice-looking charts in just a few minutes.This is what you will learn:Get to know the different tools of the Power BI universe and learn how to use themUnderstand Power BI Desktop and its componentsLearn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model and understand the difference between those two stepsLearn how to filter and format data, how pivoting and unpivoting worksHow to work in the different views of the Data ModelHow to create calculated columns and measuresHow to build relationships between different tablesHow to create a report with different interactive visualization typesLearn how to use Power BI Pro to create dashboards and to share and publish your resultsHow to access your results from multiple devices using Power BI MobileAnd more!20 Awesome POWER BI Templates included!Power Query is an ETL tool created by Microsoft for data extraction, loading and transformation, and is used to retrieve data from sources, process it, and load them into one or more target systems.PQ 1 - What is Power QueryPQ 2 - Data TypesPQ 3 - Fixing Dates & Date Locale SettingPQ 4 - For Columns - MOVE, REMOVE, RENAME, DUPLICATESPQ 5 - Split ColumnsPQ 6 - MergePQ 7 - Filtering RowsPQ 8 - Removing Duplicates and ErrorsPQ 9 - SortingPQ 10 - Appending Data from Multiple Excel WorksheetsPQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names)PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet NamesPQ 13 - Replace and FillPQ 14 - Formatting Numbers and DatesPQ 15 - Adding Custom Calculated ColumnsPQ 16 - GroupByPQ 17 - UnpivotPQ 18 - 6 Types of JoinsPQ 19 - Create Calendar in PQ vs. DAX
