|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-power-query-and-m-language-the-easy-way/
课程评论：没有评论
课程名称：Power Query 和 M 语言轻松掌握 课程概述：随着公司每天收集越来越多的数据，数据分析、商业智能和商业分析的技能在当今的就业市场中变得尤为重要。Microsoft Power BI 是一款先进且易于使用的自助式商业智能与商业分析工具，广泛应用于专业分析师和数据科学家。因此，依赖数据来做出的决策成为了未来商业成功的关键。本课程将帮助你掌握如何清洗大数据，利用 Microsoft Power Query 和 M 语言，这些工具能够帮助你从不同源提取、清理和重塑数据，合并和生成新数据。 本课程涵盖了 Power Query 的多个功能与数据转换，适合任何水平的学习者，无需任何基础知识。我们将从基础入手，逐步提升你的技能，课程包括大量的动手实践。完成课程后，你将能够像数据库管理员和 ETL 开发人员一样处理数据，而无需学习复杂的 R 或 Python 编程语言。 课程内容包括： - 理解 Power Query 及其组成部分 - 使用 Power Query 连接和探索数据 - 数据重塑和富化 - 创建计算列以及合并多个数据源 - 表格过滤、排序、分组及聚合 - 自定义列的插入和复杂数据转换 - 编写 M 代码实现自定义数据操作 此外，本课程还提供： - 终身访问和未来更新 - 快速友好的支持 - 课程笔记、作业练习和测验 - 完成证书可供下载 - 30 天内无条件退款保证 通过本课程，学习者将获取实际技能，并能够提高工作效率，推动职业发展。
Companies are gathering more and more data everyday. Skills in data analysis, business intelligence / business analytics are highly in demand in today's job market. Microsoft Power BI is an advanced yet easy to use self service Business Intelligence / business analytics tool for that. It is same business intelligence. tools used by professional analysts and data scientists. Therefore they rely heavily on data. Data driven decision making is the key to success for any business in the world of tomorrow.Imagine how much power you when you know how to clean big data. Microsoft included power query and M language Engine virtually in every data product. You will be very surprised that you did not learn this earlier.One of the advantages of technology and having the skill is the opportunity it offers to scale your business and career. To be more productive, you need to work smarter. With low-code/no-code tools Microsoft Power Query and M Language, you can extract data from different sources, clean, reshape, remove, prepare, generate new data mashup, append and merge data.This is the most comprehensive and complete course in power query. We are going to cover over hundreds of data transformations in this course. We are covering Power Query in depth in this course does. Absolutely no experience required in Power Query or M Language. We will start from the basics and gradually build up your knowledge. I will introduce you to some great features of Power query and M Language with hands on demos. after completing this course you be able to transform you data like DBAs and ETL Developers.You do not have to learn R or python anymore. I am going to teach you to become data scientist just learn power query and M because you already know how to clean data. You can follow along with the provided learning material on your own computer at your own pace. I will basically hold your hand and teach you everything step-by-step.Understand Power Query and its componentsUnderstand power query to connect and explore your dataHow to explore, reshape and enrich your dataHow to create calculated columnsHow to shape or transform data to match your data analysis requirements.How to refresh a query to import the latest data into a tableHow to combine data from multiple data sourcesHow to filter a table based on size, value, or condition.How to sort a table ranked by a criteria, such as the alphabetical or numerical value of one or multiple columns, and by ascending or descending order.How to group rows in a tableHow to expand/extend a columnHow to aggregate data from a column by group operation, including sum, count, average, min, and max.How to Insert a custom column into a table - Insert an Index or custom columnHow to Combine multiple queries by merging or appending them.There is no coding required! Power Query allows you to do that but it's not necessary.Build complex and custom transformationWrite M code to add/delete/transform custom columnsImplement best practice in Power Query and M languageThis Course Also Comes With:Lifetime access to all future updatesFast & friendly support in the Q & A sectionCustom notes, homework exercises, checklists, templates, course quizzes to help get results fasterUdemy certificate of completion ready for downloadA 30 days "no questions asked" money back guarantee!Here is list of lectures:What are you going to learn in this courseThank you and how to get supportWhat is Power QueryWhy Microsoft created Power Query and why use itPower Query Interface ComponentsFirst things firstM Language Type Structures ValuesM Language Type Primitive ValuesM Language OperatorsWhat are Lists and how to create them using M LanguageWhat are Tables and RecordsCreate initial pbix fileData Source and Privacy SettingsUsing Parameters in Report-0Using Parameters in Report-1Using Parameters as File Path or Data SourceQuery OptionsManage Column using M LanguageReduce Rows using Power QueryReduce Rows using M LanguageSort Order for Data and Filters using Power QuerySort Order for Data using M LanguageSplit Column using Power QuerySplit Column using M LanguageGroup by or Grouping Data using Power Query-0Group by or Grouping Data using Power Query-1Group by using M LanguageData Type using Power Query and MHeaders as first row and First row as Headers using Power Query and MReplace Values using Power Query and MMerge Tables using Power Query-0Merge Tables using Power Query-1Append Tables using Power Query-0Append Tables using Power Query-1Group by or Grouping Data using Power Query-0Group by or Grouping Data using Power Query-1Headers as first row and First row as Headers using Power Query and MTranspose-Reverse-Count Rows using Power Query and MData Type and Rename using Power Query and MReplace - Fill using Power Query and MPivot - Unpivoting using Power QueryMove - Convert to List using Power QuerySplit Column using Power Query 0Split Column using Power Query 1Split Column using M LanguageFormat - Trim - clean -Lower - Upper Case using Power QueryFormat - Trim - clean -Lower - Upper Case using M LanguageMerge Columns using Power Query and M LanguageExtract using Power Query and M LanguageParse XML Data using Power Query and M LanguageParse JSON Data using Power Query and M LanguageStatistics using Power Query and M LanguageStandard and Scientific using Power Query and M LanguageTrigonometry - Rounding - Information using Power Query and M Language-0Trigonometry - Rounding - Information using Power Query and M Language-1Date Transformation using Power Query and M Language-0Date Transformation using Power Query and M Language-1Time-Duration Transformation using Power Query and M LanguageColumn From Example using Power Query and M LanguageCustom Column using Power Query and M Language-0Custom Column using Power Query and M Language-1Invoke Custom Column using Power Query and M Language-0Invoke Custom Column using Power Query and M Language-1Conditional Column using Power Query and M LanguageIndex Column using Power Query and M Language-0Index Column using Power Query and M Language-1Duplicate and Merge Column using Power Query and M LanguageFormat - Trim - clean -Lower - Upper Case using Power QueryFormat - Trim - clean -Lower - Upper Case using M LanguageExtract using Power Query and M LanguageParse XML Data using Power Query and M LanguageParse JSON Data using Power Query and M LanguageStatistics using Power Query and M LanguageStandard and Scientific using Power Query and M LanguageTrigonometry - Rounding - Information using Power Query and M LanguageDate Transformation using Power Query and M Language-0Date Transformation using Power Query and M Language-1Time- Duration Transformation using Power Query and M LanguageQuery Setting in View Tab-0Query Setting in View Tab-1Data Preview 1 in View TabData Preview 2 in View TabCreate Calendar using M Language and DAXPower Query Best Practices-0Power Query Best Practices-1Power Query Best Practices-2Mega searchable tutorials o Power BI, DAX, SQL and Power QueryBest Practices Power BI-0Best Practices Power BI-1Best Practices Power BI-2Best Practices Power BI-3Best Practices Power BI-4Best Practices Power BI-5DIAD - IntroductionDIAD - Accessing DataDIAD - Data Prepration-0DIAD - Data Prepration-1DIAD -Data Modeling and Exploration-0DIAD -Data Modeling and Exploration-1DIAD -Data Modeling and Exploration-2DIAD -Data Modeling and Exploration-3DIAD -Data Modeling and Exploration-4DIAD - Data Visualization-0DIAD - Data Visualization-1DIAD - Publishing ReportDIAD - Creating DashboardsDIAD - Creating Dashboards-0DIAD - Creating Dashboards-1
