|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/dax-power-pivot-10-easy-steps-for-advanced-users/
课程评论：没有评论
课程名称：DAX Power Pivot - 高级用户的10个简单步骤 概述：准备好提升您的DAX技能吗？我的新课程“DAX Power Pivot - 高级用户的10个简单步骤”是我之前“10个简单步骤”系列的延续，旨在帮助您增加数据模型的复杂性，进而创建和理解更复杂的计算。该课程专为那些已经参加过初学者和中级课程的学生设计，您将在这些课程中学习到必要的基础知识，以便过渡到更高级的概念，从而构建更大规模的数据模型并创建更复杂的计算。 课程内容包括： - 热身 - 变量 - 行上下文与过滤上下文 - 静态分割 - 多数据表处理 - RANKX()与TOPN()函数 - 不同粒度 - 预算与实际比较 - 单年预算模式 - 多年预算模式 - 月度预算 课程内容采用实例教学方式，学生将与我一起完成练习，帮助巩固技能。您将获得所有小组作业和练习文件，以及一本内容丰富、图文并茂的用户指南PDF。我还提供视频解答，确保您在学习过程中不会感到孤单。 课程评价： 许多学员对我的“10个简单步骤”系列课程称赞有加，认为课程结构清晰，提供了充分的复习和练习，帮助他们能迅速适应自己的项目。 Power Pivot是那些从事财务、统计、项目、商业和市场分析或任何数据报告角色的完美工具，能够有效创建商业智能风格的仪表板和洞察报告。我使用Excel 2016进行演示，但您也可以在Excel 2010和2013中跟随学习，课程中会指出相关差异。如对课程有任何疑问，请随时联系我，或查看免费预览课程以了解更多信息。 感谢您花时间查看我的课程。我期待帮助您迈出提升DAX技能的下一步！如果您准备好迎接新的发展机会，请点击页面右上方的“报名参加此课程”按钮。
Are you ready to take your DAX skills to the next level? My new DAX Power Pivot - 10 Easy Steps for Advanced Users follows on from the my previous "10 Easy Steps" series to enable you to increase the complexity of your data models and progress to creating and understanding more complex calculations.I have created this course specifically for those students who have taken my Beginners and Intermediates courses where you have learned the fundamentals necessary to transition into more advanced concepts enabling you to build bigger data models and create more complex calculations.By helping you to understand evaluation context will help you "think" like DAX. When you have this understanding you'll be in a better position to troubleshoot when things don't go according to plan.Course ContentsWarm UpVariablesRow & Filter ContextStatic SegmentationMultiple Data TablesRANKX() & TOPN()Different GranularitiesBudget vs ActualsBudget Patterns (Single Year)Budget Patterns (Multiple Years)Budgets (Monthly)I provide examples that we work through together. Then it's over to you with practice exercises to help you embed and consolidate your skills. You receive all the group work and exercise files and a fully supporting, diagram rich user guide pdf. I always provide video solutions - so, you're never on your own.Still not sure? Here's what others have had to say about my "10 Easy Steps" series of courses:DAX Power Pivot - 10 Easy Step for Advanced Users"Once again, a masterpiece from Gilly to guide through the journey of advanced DAX. Step by Step diving deeper into DAX logic without loosing the line thanks to the outstanding effort of a well structured course which come along with a clear guideline, recaps and exercises to be able to adapt to own projects soon. Thanks so much Gilly!"Doris.DAX Power Pivot - 10 Easy Step for Advanced Users"Another excellent course by Gilly. Covers a range of topics clearly and thoughtfully with challenging and interesting practice exercises."Gary F.DAX Power Pivot - 10 Easy Steps for Beginners"I thought that I was intermediate on this topic, so didn't bother buying the beginner course. However, getting stuck part way through the intermediate course, I decided to complete the beginner course. Boy am I glad I did - it has really consolidated things for me, and was well worth the money. If you haven't taken any of Gilly's courses before I can highly recommend them - she is super enthusiastic, keen, knowledgeable, and very responsive. If you only take one DAX course as a beginner, make it this one".Ian W.DAX Power Pivot Time Intelligence - 10 Easy Steps"Great Course from Gilly. Her courses are a masterpiece and this subject was a tough one but she does a good job in explaining it Step By Step. Going by her own words you need practice to master it but at least I am happy the foundation is being laid with strong understanding to move forward. Thanks so much Gilly"Guna R.DAX Power Pivot - 10 Easy Steps for Intermediates"It is obvious that Gilly has spent a lot of time with her study guide and organization of this class. This is one of the best illustrated courses I've found on Udemy. Explanations of the DAX formulas are very clear and flow logically throughout the course. The concepts discussed are easily at the Intermediate level as advertised. Truly an exceptional effort by Gilly Dow."Jimmy F.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.
