|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-power-query-power-pivot-dax/
课程评论：没有评论
课程名称：微软Excel：商业智能与Power Query及DAX 课程概述：本课程介绍了微软Excel强大的数据准备、建模、分析和商业智能工具：Power Query、Power Pivot和数据分析表达式（DAX）。如果您希望成为Excel的高级用户，并彻底提升您的Excel分析能力，那么这将是您所需要的完整指南。我将介绍“强大Excel”的工具生态，并探讨这些Excel工具的功能以及它们如何改变自助分析和商业智能的世界。我们将一起走过Excel BI工作流程，从零开始构建整个Excel数据模型。 首先，我们将动手使用Power Query，这是一种从平面文件、文件夹、数据库、API服务等提取、转换和加载数据到Excel的工具。我们将练习在Excel的查询编辑器中对项目文件进行整形、合并、清理和探索，并创建仅需几次点击即可完成的完全自动化加载过程。 接下来，我们将深入学习数据建模基础，涵盖数据库设计和规范化的基本知识（包括表之间的关系、基数、层次结构等）。我们将浏览Excel数据模型界面，介绍一些最佳实践和专业技巧，并创建自己的关系型数据库进行课程中的分析。 最后，我们将使用Power Pivot和DAX来探索和分析我们的Excel数据模型。与传统的Excel数据透视表不同，Power Pivot允许您在多个数据表中分析数亿行数据，并使用一种叫做数据分析表达式（DAX）的公式语言创建强大的计算字段。我们将涵盖基本的DAX语法，并介绍一些最常用和强大的函数 - 如CALCULATE、FILTER、SUMX等。 如果您准备好将您的MS Excel技能提升到新的高度，并加入分析和商业智能的前沿，那么这个课程适合您。是时候停止与繁琐的手动任务斗争，告别“老派”Excel，加入我，一起成为认证的Excel分析高手。 注意：Power Query和Power Pivot当前在Mac版Excel中不可用，您需要与Power Pivot兼容的PC版Excel（Excel 2010附插件、Excel 2013、Excel 2016或Excel 2019独立版、Office 365 Pro Plus、企业E3/E5、Office专业版2016等）。 如果您在寻找我们的完整课程库，可以搜索“Maven Analytics”以浏览我们的Excel、Power BI、SQL、Tableau、Python、Alteryx和机器学习课程的完整集合！ 许多学员反馈本课程是顶级的Excel课程之一，“我是一名自学的Excel Power Query用户，花了很长时间才能理解每个工具的作用及其相互作用。谢谢你的介绍，我终于清晰明确地掌握了这些工具。你帮助我建立了一种我可以自信地应用于Excel中的数据的方法。” 该课程包括Excel项目文件、测验和作业练习、一对一讲师支持、终身访问权限以及100%退款保证！
This course introduces Microsoft Excel's powerful data prep, modeling, analytics and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX).If you're looking to become a power Excel user and absolutely supercharge your Excel analytics game, this course is the A-Z guide that you're looking for. I'll introduce the "Power Excel" landscape, and explore what these Excel tools are all about and why they are changing the world of self-service analytics and business intelligence. Together, we'll walk through the Excel BI workflow, and build an entire Excel data model from scratch:First we'll get hands-on with Power Query; a tool to extract, transform, and load data into Excel from flat files, folders, databases, API services and more. We'll practice shaping, blending, cleaning and exploring our project files in Excel's query editor, and create completely automated loading procedures inside of Excel with only a few clicks.From there we'll dive into Data Modeling 101, and cover the fundamentals of database design and normalization (including table relationships, cardinality, hierarchies and more). We'll take a tour through the Excel data model interface, introduce some best practices and pro tips, and then create our own relational database to analyze throughout the course.Finally, we'll use Power Pivot and DAX to explore and analyze our Excel data model. Unlike traditional Excel Pivot Tables, Power Pivot allows you to analyze hundreds of millions of rows across multiple data tables (inside of Excel!), and create supercharged calculated fields using a formula language called Data Analysis Expressions (or "DAX" for short). We'll cover basic DAX syntax, then introduce some of the most powerful and commonly-used functions - CALCULATE, FILTER, SUMX and more.If you're ready to take your MS Excel game to new heights and join the leading edge of analytics & business intelligence, this course is for you. It's time to stop fighting with tedious, manual tasks and struggling with "old-school" Excel; join me on this journey and emerge a certified excel analytics NINJA.See you in there!-Chris (Founder, Maven Analytics)IMPORTANT: Power Query and Power Pivot are currently NOT available in Excel for Mac. You'll need a PC version of Excel that is compatible with Power Pivot (Excel 2010 with plug-in, Excel 2013, Excel 2016, or Excel 2019 Standalone, Office 365 Pro Plus, Enterprise E3/E5, Office Professional 2016, etc.)__________Looking for our full course library? Search "Maven Analytics" to browse our full collection of Excel, Power BI, SQL, Tableau, Python, Alteryx & Machine Learning courses!Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Power Query + Excel Power Pivot course:"I am a self-taught Excel Power Query user and it took me a while to understand what each tool does and how it interacts with others. Thanks to your introduction I finally nailed it in a very clear, unambiguous way. You helped me build a method that I can confidently apply to my data in Excel. Thank you so much!"-Francesca C."I'm less of an expert at breathing than Chris is at Excel. This course is thorough and well-planned, and he presents in a manner that simplifies the complicated. Well worth your time if you want to master Excel power query and power pivot!"-Tim B."I'm geeking out, this is so cool. Where has this been all my life???"-Karen P.*This course includes Excel project files, quizzes & homework exercises, 1-on-1 instructor support, LIFETIME access and a 100% money-back guarantee!
