PowerPivot Course
overview
About this course
Data is growing at an alarming rate in many situations excel is becoming less of a viable option to deal with all of this data so what do we do? Does it make sense to immediately move to a database? Well, that comes with a lot of commitment and a lot of cost in terms of implementation and maintenance. However in the last decade a powerful alternative has emerged.
PowerPivot.
So before you move to a database you need to consider power pivot which has been described as Excel on steroids! Picture this-you’re used to dealing with large volumes of data and as it grows and grows and grows excel just slows down and grinds to a halt and it becomes very frustrating to get the outputs that you need well PowerPivot has come along and turned Excel into something like a database so we have a relational model, we have Data Analytics Expressions or DAX expressions to easily and quickly perform analysis on our large volumes of Data.
At Earn And Excel, we’ve created a course that is going to take you from beginner to advanced level with PowerPivot. Working with Ross Hughes who is a highly experienced consultant having worked with data in large companies for over 30 years. Ross distills his 30+ years of data and gives you not just technical advice on how to make the most of PowerPivot but also practical advice on how to work with data. This course has the potential to transform your data analysis game and if you don’t feel it’s the course for you, then you can get a refund no questions asked.
Description
We will cover all you need to know PowerPivot with the following topics (please use the contents to learn further details of lessons that will be covered):
- Introduction to Power Pivot
- Loading Data
- Pivot Tables And Refresh
- What are Measures and why they are so crucial
- Hierarchies And Related Columns
- Working with DAX beyond the basics
Details
Skill level: Intermediate to BeginnerLanguages: English
Lessons: 52Video: 3 hours and 36 minutes
Certificates
Get a certificate of completion that can be displayed on LinkedIn
What You’ll Learn (click for details)
MODULE 1: Getting Started With Power Pivot
1.1 Introduction to Power Pivot1.2 Data Model Familiarisation1.3 Data Modelling Concepts1.4 Introduction to Data Types
MODULE 2: Loading Data
2.1 Loading data with PowerQuery2.2 Loading Data from Excel tables2.3 Introduction to using with Pivot Tables2.4 Other data load options2.5 Loading Data from an external database
MODULE 3: Pivot Tables And Refresh
3.1 More on Pivot Tables3.2 Pivot Tables and Relationships3.3 Introduction to Refreshing Data3.4 Refreshing Data via Connections3.5 Refreshing Data from an external database
MODULE 4: Introduction To Measures
4.1 Calculated Columns4.2 Introduction to measures4.3 Adding explicit measures with Autosum4.4 Adding implicit measures4.5 Adding explicit measures in Power Pivot menu
MODULE 5: Hierarchies And Related Columns
5.1 Introduction5.2 Adding a hierarchy5.3 Using hierarchies in a Pivot Table5.4 Drill paths5.5 Introduction to Related Columns5.6 Related Columns in a hierarchy 5.7 Best practices with hierarchies5.8 Editing hierarchies
MODULE 6: Deeper Into DAX
6.1 DAX Syntax and Operators6.2 Some Useful DAX Functions part 16.3 Some Useful DAX Functions part 26.4 Some Useful DAX Functions part 36.5 Introduction to Iterator Functions6.6 Expressions in Iterator Functions6.7 Table functions in Iterator Functions (RELATEDTABLE)6.8 Table functions in Iterator Functions (TOPN)
6.9 Other Iterator Functions6.10 Introduction to Context6.11 Examples of Context6.12 Filter Context in Pivot Tables6.13 Introduction to Filter Functions6.14 Example of a Filter Function6.15 Using Filters in a Filter Function6.16 Using the ALL Filter Function6.17 Using the ALLSELECTED Filter Function6.18 Introduction to Parent-Child Functions6.19 Using Parent-Child Functions6.20 Using Parent-Child Functions for a Hierarchy6.21 Time Intelligence Functions Part 16.22 Time Intelligence Functions Part 26.23 Time Intelligence Functions Part 36.24 Time Intelligence Functions Part 4
PRICING
Select Currency
1 Year Online Access
£59 GBP
- Access this course online
- Including exercise files & supporting material
- Certificate of completion
- Email Support for 12 months
- Download the course
1 Year Premium Access
£350 GBP
- Access this course AND ALL our online courses
- Including exercise files & supporting material
- Certificate of completion
- Email Support for 12 months
- Download the courses
1 Year Online Access
$69 USD
- Access this course online
- Including exercise files & supporting material
- Certificate of completion
- Email Support for 12 months
- Download the course
1 Year Premium Access
$449 USD
- Access this course online AND ALL our courses
- Including exercise files & supporting material
- Certificate of completion
- Email Support for 12 months
- Download the courses
Student Success!
We have had the pleasure of helping over 2000 professionals to better their skills and become indispensable to their companies. Here are some encouraging words from just a few:
A. Saleem
Investment Banking PMO, London
“This course is excellent. The Skills I have developed have given me the confidence to tackle advanced problems in an Investment Banking environment. Unlike other courses, the tutorials are practical, to the point and are relevant to professionals. I would highly recommend this course.”
James Barton-Ginger
Senior Project Manager, New Zealand
“Sohail’s courses have provided me with the guidance and traction to hugely grow my earnings – in fact trebled my income over the past few weeks upon completion. This was due to the fact there’s a formula that for me clarified core missing pieces. For me this has been a real game changer and a catalyst.”
Kiran Arain
Senior Financial Analyst, Canada
“I applied many of the skills I learnt through your excel course to automate many aspects of my work and it has been a huge help. My next step is to improve my VBA skills!”
Mike Doubek
Project Manager, US
“The VBA course has been a game changer as the ability to automate was something I longed for in order to be more efficient and more effective as a professional. I also really liked the PowerPoint lesson and the Marketing Your Skills lesson. This course is the complete package, I would recommend this course 100%
Some Of The Companies Our Students Work At
Frequently Asked Questions
HOW DO YOU DELIVER YOUR COURSES?
Once you have signed up then we will send you an email with a link to access our training dashboard, you can access all of our courses from this dashboard.All courses consist of video lessons that can be viewed on your device of choice and also to truly enhance your learning you will access lots of exercise files relevant to the lessons.
THERE ARE MANY OPTIONS THESE DAYS TO LEARN, WHY GO WITH YOUR COURSES?
Great question, well frankly we make the best courses because all of our trainers have spent 10+ years using these skills in the real world! True knowledge is passed on from people who have been in the trenches, putting in long hours, solving real problems creatively. Our mission is to empower you with the very best of what works and more importantly, leave out what is unnecessary and thus a waste of your precious time.
HOW LONG WILL IT TAKE TO LEARN THESE SKILLS?
It depends on your level of commitment. Our students have seen incredible results from as little as 3o mins a day. But remember the magic is in applying the skills as much as learning them. Our courses are designed with this in mind. On the very practical end we have students who squeeze in a few mins here and there on their commute and some do dedicated 2-3 hour weekend sessions. One of our most successful students Jayne managed to get up at 4am to do her learning! This paid off massively as it landed her a six figure analyst job in a bank!
CAN MY EMPLOYER PAY FOR MY TRAINING?
Yes, this is quite common since we focus on helping actual corporate employees. Note that for teams we offer bulk discounts. However, this needs to be done with a corporate credit/debit card. We don’t accept transfer/remittances. Get in touch if you have any specific questions.
DO YOU HAVE A REFUND POLICY?
Yes, we do, we will dust it off if you need it because it rarely happens! You have 30 days to let us know that the training isn’t right for you and we will happily refund.
HOW MUCH DOES IT COST TO TAKE YOUR COURSES?
You can either purchase access to one course or all of our courses, which are listed above. What we have done in a post COVID-19 world is to keep our prices low to accommodate as many ambitious people from all over the world who are looking to upskill through our high level courses without the burden of high expense.
WHY DO YOU SELL IN MULTIPLE CURRENCIES?
We recognise that people prefer to pay in their own currencies and especially when our main product is a recurring membership to all our courses, you can rest assured knowing that fluctuations in currency won’t affect your financial commitment.