|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/dax-power-pivot-time-intelligence-10-easy-steps/
课程评论：没有评论
Coursera 上的 "DAX Power Pivot 时间智能 - 10 个简单步骤" 课程总结： 本课程是 "DAX Power Pivot - 10 个简单步骤入门" 的进阶篇，旨在帮助您深入了解 Power Pivot 如何处理时间数据，并掌握 DAX 中的时间智能函数。通过本课程，您将能够： **第一部分：标准日历的时间智能** * **日期计算：** 使用 DAX 对标准日历进行日期计算。 * **日历表构建：** 创建标准的日历表。 * **累积计算：** 计算月度累计 (MTD)、季度累计 (QTD) 和年度累计 (YTD)。 * **年度移动总计：** 计算财年末的年度移动总计。 * **增长百分比：** 聚合和比较不同时间段的增长百分比。 * **CALCULATE() 的运用：** 使用 CALCULATE() 函数实现时间智能。 * **同比比较：** 计算与上一年同期相比的指标。 * **期末、期初、月末、年初计算：** 计算期末余额、首个日期、最后一个日期、月末日期和年初日期。 * **日期段计算：** 计算两个日期之间的值。 **第二部分：自定义日历（如 4-4-5 日历）的时间智能** * **自定义日历表：** 构建适用于特定行业（如零售业）的 4-4-5 自定义日历表。 * **多日历表处理：** 学习如何处理多个日历表。 * **DAX 模式应用：** 操纵 DAX 模式以创建自定义函数。 * **自定义时间智能：** 使用 FILTER() 和 ALL() 等函数进一步增强自定义时间智能功能。 * **增长百分比的聚合与比较：** 扩展到自定义日历下的增长百分比分析。 **课程亮点：** * **循序渐进：** 课程内容从易到难，既有直观的标准日历函数，也有更具挑战性的自定义日历函数。 * **实践性强：** 讲师强调案例分析和练习，每个函数都配有示例和练习。 * **讲师专业与热情：** 讲师 Gilly Dow 在 Excel 和 Power Pivot 方面知识渊博，教学风格充满热情和鼓励，并能及时回应学生的问题。 * **实用性高：** 学习到的技能可以直接应用于日常的商业智能分析，提升工作效率和分析能力。 * **学习体验佳：** 课程设计清晰，解释易懂，即使是新手也能快速上手。 本课程适合已经掌握基础 DAX 和 Power Pivot 技能，并希望进一步提升时间智能分析能力的用户。通过本课程的学习，您将显著提升 DAX 的运用能力和数据分析的信心。课程使用 Excel 2016 进行演示，但同样适用于 Excel 2010 和 2013。
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 DAX & 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 Power Pivot handles Time data. Data Analysis Expressions (DAX) includes Time Intelligence functions to support the needs of Business Intelligence analysis by enabling you to manipulate data using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods. Here's what others had to say about the course: "So far it's been easy to follow. The instructor is doing a great job of explaining what she is doing. Looking forward to more advanced topics. UPDATE: I've completed the course. It's a great course and I'm glad I took this one, as well as DAX Power Pivot 10 Easy Steps for Beginners. I'll be referencing the material often, there's a lot on information that's new to me. I really want to dive more into custom calendars and DAX patterns. I've already been showing my managers at work how powerful DAX functions can be. Gilly Dow did a fantastic job with both of her courses I took on Udemy. She's very knowledgeable on Excel and Power Pivot topics and her enthusiasm and encouragement always shows in her lectures. She is very responsive to queries from her students; my questions were answered very quickly. I've taken other online courses where you never heard back if you were having problems; that's definitely not an issue here." - John Pertell "Outstanding. It's explained clear concise wonderful examples that are broken down and clearly explained fantastic course great teacher and teaching style. Highly recommend" - Stephen Davanzo "Highly recommended course! For every single function mentioned in the course there are an example and practice exercise. Great!" - Elbina Rizakhanova What You'll Learn: The first part of the course concentrates on DAX time-ready functions ideal for a standard calendar - the kind you hang on your wall. So, if that's how you roll at work - this is perfect for you. The second half raises the stakes and you will learn how to manipulate DAX to generate your own custom functions to work with 4-4-5 calendars used in many different industries including retail. In order to do this, I'll introduce you to some new DAX functions that will elevate your skills enabling you to build custom functions for those pesky non-standard calendars. Even if this doesn't fit your remit - DO IT ANYWAY! Your level of understanding will increase leaps and bounds and your confidence will soarrrrr!!! Plus, it's GREAT fun and you'll learn heaps along the way! What you will learn in this course: Performing Date Calculations in DAX with a Standard Calendar Building a standard Calendar tableRunning Totals with: Month-to-Date (MTD), Quarter-to-Date (QTD) and Year-to-Date (YTD)Computing the moving annual total for Fiscal Year EndsAggregating and Comparing Growth %'s over timeTime intelligence with CALCULATE()Computing periods from the Prior YearClosing Balance, First Date, Last Date, End of Month and Start of YearComputing values Between Dates Performing Date Calculations in DAX with a 4-4-5 Calendar Building a custom Calendar tableWorking with multiple Calendar tablesManipulating DAX PatternsCustom Time intelligence with CALCULATE()Custom Time intelligence with CALCULATE(), FILTER() and ALL()Aggregating and Comparing Growth %'s over time Will it be easy? Yes and no - the first half of the course - the DAX "time-ready" functions are intuitive and straightforward. The custom Time Intelligence functions you create can be challenging but with my guidance and your growing understanding it will be really, really satisfying - trust me! 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 & Power Pivot skills. 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. 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. I look forward to seeing you on the inside!
