DAX Power Pivot 10 Easy Steps for Advanced Users

4.8 (108)
Онлайн-курс
DAX Power Pivot 10 Easy Steps for Advanced Users
Payment
Обучение платное
Language
Not set
Duration
9 часов курса
Курс от Udemy
DAX Power Pivot 10 Easy Steps for Advanced Users
Чему вы научились?
Work with Multiple Data Tables
Build complex calculations with Variables
Gain Insights with RANKX() & TOPN()
Work with Differing Granularities
Use Budget Patterns
Budget vs Actuals
О курсе

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 Contents

  • Warm Up
  • Variables
  • Row & Filter Context
  • Static Segmentation
  • Multiple Data Tables
  • RANKX() & TOPN()
  • Different Granularities
  • Budget vs Actuals
  • Budget 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.

Требования
  • Power Pivot must be enabled and visible as a Ribbon Tab
  • You know how to create a Data Model
  • You recognise the term Initial Filter Context
  • You understand CALCULATE()
  • IMPORTANT: You need a version of Excel that is compatible with Power Pivot (Excel 2013/2016/2019 Standalone, Office 365, Enterprise E3/E5, Office Professional 2016, etc.)
  • This course is designed for PC users (Power Pivot is currently unavailable with Excel for Mac)
Лекторы
Gilly Dow
Gilly Dow
IT Training Consultant, founder gdteach.co.uk
Платформа
/storage/img/providers/udemy.svg
Курсы Udemy подойдут для профессионального развития. Платформа устроена таким образом, что эксперты сами запускают курсы. Все материалы передаются в пожизненный доступ. На этой платформе можно найти курс, без преувеличений, на любую тему – начиная от тьюториала по какой-то камере и заканчивая теоретическим курсом по управлению финансовыми рисками. Язык и формат обучения устанавливается преподавателем, поэтому стоит внимательно изучить информацию о курсе перед покупкой.
Рейтинг
4.8
(70)
(29)
(7)
(3)
(1)
Комментарии (108)
Как и любой другой веб-сайт, konevy использует файлы cookie. Эти файлы используются для хранения информации, включая предпочтения посетителей и страницы веб-сайта, которые он/она посещал. Информация используется для того, чтобы подстроить содержимое нашей страницы под тип браузера пользователя и другие параметры и таким образом улучшить его пользовательский опыт. Для получения более подробной информации о файлах cookie, пожалуйста, прочтите статью «Что такое файлы cookie»