Power Query 2 - Building an Instant Consolidation
Fully automated Self-service Reports
Updated on Apr, 2024
Language - English
Office Productivity,Microsoft Power BI
Lectures -28
Resources -1
Duration -1 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
If you find it takes ages to consolidate data from various sources and process them before generating a report, or if your report users always ask you to provide snap-shots of certain entities or periods, and you may want to have a quicker way of consolidation and a one-size-fits-all report for your report consumers, then this course is for you.
Join me in the course:
- to learn the powerful formulas and advanced functions in Power Query
- to learn how to build an instant consolidation model from scratch
- to understand how to automate your Power Query model for Self-service Reporting!
It does not matter if you are an Excel novice, or an Excel Advanced user, everyone is sure to learn something new, I can guarantee you on that, as this happened to me time and time again when I tuned in to other master’s Excel lessons.
Goals
What will you learn in this course:
- Intermediate to Advanced Excel skills that will help you
- to ace your Excel skills
- to find state-of-the art Excel functions
- to make yourself the go-to-person in their office, or
- to be well positioned for your next promotion!
Prerequisites
What are the prerequisites for this course?
- Basic Excel and Power Query knowledge
- Example: be able to open one Excel file and connect to external data files, etc.
- Recommended prerequisite: Power Query (Part 1): Ultimate Data Transformation
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
5 Lectures
-
Introduction
00:32
00:32
-
Instructor's background
01:14
01:14
-
Why this course?
00:34
00:34
-
What you will get from this course?
00:38
00:38
-
How this course is compared with "other similar courses"?
01:32
01:32
Power Query - from Basic to Intermediate
7 Lectures
Power Query - 6 Powerful Functions
7 Lectures
Advanced - Take it to the Next Level!
5 Lectures
Conclusion
2 Lectures
Supporting Materials
1 Lectures
Instructor Details
Lenny Wu
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now