Description

This course builds upon the skills learned in the firstcourse 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 acquiringa more thorough understanding of how Disconnectedor Parameter tables can be utilisedto gain additional insights in your data models. The first part of the course addresses Microsofts change tothe DAX engine that now makesediting queries a challenge if youarent an expert in SQL. Therefore, you learn to use Get & Transform to import data and in doing so, reduce the sizeof 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 youll learnsome 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.Ill have a couple of surprisesfor you along the way not only to boost your brownie-points at work but foryour own piece of mind around administration of your data models!Here’s what others said about the course: Gilly. Did it again with the Addition ofDax PowerPivot-10 easy steps for intermediate course. This intermediate Courseadds more formulas and Dax functions and even disconnected slicers and cubeformulas to add your learning base and continues to build off the previous twocourses. Gilly is a brilliant teacher who clearly has an in-depth understandingof how power pivot works. She can break it down and simplify Dax so you knowhow functions works and understand how to use it in your day-to-day excel work.If you follow along and do the exercises when youre done with a lesson youfully understand how to complete and use the Dax formulas in your data work. Ifyou want to understand and learn Dax, Gilly courses are what you want to startwith. I recommend Gilly courses, you will be pleased with your resultsafterwards. 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” – JMA lovely paced course with the differentelements nicely segmented and of a good length. Certainly liked the extrasurprise of Cubes. Will aid in displaying data that does not fit well with theconfines of a pivot table. Cheers Gilly! – GB Do Love the way you teach. Hope to learnmore from you for advanced DAX course with real world case studies. Bravo!- HATrainer explains concepts really wellwithout using too much tech talk. The many examples support the goodunderstanding of the subjects. The speed is ok for advanced users but too fastif you did not follow the basic course. Course is complete and every importantsubject is explained. – RGilly does a great job of explainingcomplex concepts and makes her points using thought-provoking analogies.Excellent instructor! – SAThe course continued to build on the 10Easy steps for Beginners. Detailed Instructions and real-world examples. Deepdive into advanced Power Pivot Formulas. – CJWhat you will learnin 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 tablesHarvester MeasuresConversion MeasuresThresholds/Cut-offsBandingKPIsI provide examplesthat we workthrough together. Then its over to you with practice exercises for youto help embed and consolidate your skills. I always provide videosolutions so,youre 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 rolewho have a need to create and produce Business Intelligence style dashboard and Insightreports.I have used Excel2016 to demonstrate this fantastic tool but you can follow along inExcel 2010 & 2013 – I’ll do my best to point out the differences. If youhave any questions about the course, feel free to message me here or check outthe 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 yourDAXskills.Take the first steps to a new and rewarding future by clicking on the TAKETHIS COURSE button, located on the top right corner of the page.