|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/dax-power-pivot-10-easy-steps-for-intermediates/
课程评论：没有评论
课程名称：DAX Power Pivot - 中级的10个简单步骤 课程概述：本课程基于先前的初学者课程《DAX Power Pivot - 10 Easy Steps for Beginners》，旨在帮助学员更深入地掌握Power Pivot的技能。在前面的课程中，您已经体验到了Power Pivot的强大功能，现在准备通过学习如何使用“断开连接”表或“参数”表来深入了解数据模型，从而提升您的技能。 课程的第一部分将讨论Microsoft对DAX引擎的变更，这使得编辑查询变得复杂，因此，您将学习使用数据获取与转换功能（Get & Transform）来导入数据，从而显著减小数据模型文件的大小。您将通过初级的DAX技能进一步探讨“初始过滤上下文”、“过滤上下文”和“上下文转换”的真正含义，并通过解释、示例和练习巩固您的理解。 课程中还将介绍阈值、截止值和分段的概念，以便利用“断开连接”表的能力。学习这些内容将为您带来丰富的可能性，并获得一些强有力的新见解。您将在每个步骤（1-10）中持续建立技能和理解，课程中还会有一些惊喜设计，帮助您在工作中突出表现，并安心管理数据模型。 此外，课程还包括一个额外的奖金部分，提供7个Power Query练习，旨在帮助您处理常见的混乱数据表布局。课程反馈积极，学员们对课程的教学方式和内容深感满意。 课程学习内容包括：数据建模的获取与转换（Get & Transform）、DAX迭代器与聚合函数、初始过滤上下文、过滤上下文、上下文转换、VALUES()、ALL()、ALLSELECTED()和ALLEXCEPT()、IF()和HASONEVALUE()、断开连接表的创建与添加、"收获者"度量、转换度量、阈值/截止值、分段及关键绩效指标（KPI）。 无论您是在金融、统计、项目、商业和市场分析或任何数据报告角色中，Power Pivot都是一个理想的工具，可以帮助您创建商业智能风格的仪表板和洞察报告。 如果您对课程有任何问题，请随时联系我，或查看免费预览讲座以了解更多信息。感谢您花时间查看我的课程，我期待着帮助您在DAX技能方面迈出下一步！
This course builds upon the skills learned in the first course in this series DAX Power Pivot - 10 Easy Steps for Beginners. You have already gotten your hands dirty with Power Pivot and seen how awesome it is. Now you are ready to take your skills to the next level by delving deeper and acquiring a more thorough understanding of how "Disconnected" or "Parameter" tables can be utilised to gain additional insights in your data models. The first part of the course addresses Microsoft's change to the DAX engine that now makes editing queries a challenge if you aren't an expert in SQL. Therefore, you learn to use Get & Transform to import data and in doing so, reduce the size of your data model file size considerably. You will draw upon your beginner DAX skills to delve deeper into the real meaning behind "Initial Filter Context", "Filter Context" and "Context Transition" with explanations, diagrams, examples and practice exercises. To leverage the capabilities of "Disconnected" tables, I introduce you to the concept of thresholds, cut-offs and banding. This really does open the door to a wealth of possibilities and you'll learn some useful techniques to gain some powerful new insights along the way. Throughout the course, you are building your skills and understanding - taking you to the next level at each Step - 1-10. I'll have a couple of surprises for you along the way - not only to boost your brownie-points at work but for your own piece of mind around administration of your data models!I've included a BONUS section featuring 7 Power Query exercises that tackle what to do with typical messy data table layouts that require manipulation even before you start! A GREAT start to getting to grips with the magic that is Power Query!Here's what others said about the course: "Gilly. Did it again with the Addition of Dax PowerPivot-10 easy steps for intermediate course. This intermediate Course adds more formulas and Dax functions and even disconnected slicers and cube formulas to add your learning base and continues to build off the previous two courses. Gilly is a brilliant teacher who clearly has an in-depth understanding of how power pivot works. She can break it down and simplify Dax so you know how functions works and understand how to use it in your day-to-day excel work. If you follow along and do the exercises when you're done with a lesson you fully understand how to complete and use the Dax formulas in your data work. If you want to understand and learn Dax, Gilly courses are what you want to start with. I recommend Gilly courses, you will be pleased with your results afterwards. Well done Gilly. Thanks" - SD"OUTSTANDING COURSE Love the exercises, really enforces the instruction Learning so much, will go over the course again reinforce learning Everything is explained in easy to understand terms" - JM"A lovely paced course with the different elements nicely segmented and of a good length. Certainly liked the extra surprise of Cubes. Will aid in displaying data that does not fit well with the confines of a pivot table. Cheers Gilly!" - GB "Do Love the way you teach. Hope to learn more from you for advanced DAX course with real world case studies. Bravo!" - HA "Trainer explains concepts really well without using too much tech talk. The many examples support the good understanding of the subjects. The speed is ok for advanced users but too fast if you did not follow the basic course. Course is complete and every important subject is explained." - R "Gilly does a great job of explaining complex concepts and makes her points using thought-provoking analogies. Excellent instructor!" - SA "The course continued to build on the 10 Easy steps for Beginners. Detailed Instructions and real-world examples. Deep dive into advanced Power Pivot Formulas." - CJWhat you will learn in this course: Get & Transform - building the Data ModelDAX Iterators & Aggregator FunctionsInitial Filter ContextFilter ContextContext TransitionVALUES()ALL(), ALLSELECTED() & ALLEXCEPT()IF() & HASONEVALUE() Disconnected/Parameter TablesCreating/Adding Disconnected tables"Harvester" MeasuresConversion MeasuresThresholds/Cut-offsBandingKPI's I provide examples that we work through together. Then it's over to you with practice exercises for you to help embed and consolidate your skills. I always provide video solutions - so, you're never on your own.Power Pivot is the perfect tool for those working in finance, statistics, project, business and market analysis or any data reporting role who have a need to create and produce Business Intelligence style dashboard and Insight reports.I have used Excel 2016 to demonstrate this fantastic tool but you can follow along in Excel 2010 & 2013 - I'll do my best to point out the differences. If you have any questions about the course, feel free to message me here or check out the FREE preview lectures to learn more.Thanks for taking the time to check out my course. I can't wait to help you take the next step in developing your DAX skills. Take the first steps to a new and rewarding future by clicking on the TAKE THIS COURSE button, located on the top right corner of the page.
