Master how to automate repetitive tasks, shape and transform data with Power Query and present reports with Power View
What's the course about?
Power View is a data visualization tool that enables the creation of interactive charts, maps and other visuals that bring your data to life in stunning reports.
Power Query is an intuitive tool that lets you manipulate, transform, consolidate, enrich, merge and do much more with your data.
Power Query acts as an "ETL" tool which means it Extracts data from almost any data source, Transforms that data and then Loads it - in our case that's either an Excel worksheet, Power View report or Power Pivot data model.
Here's what other thought about the course:
"Very enjoyable course with many real world examples. Gilly's enthusiasm for the Microsoft Wizardry is wonderful and spurs you on to master it. I look forward to more courses by Gilly!"
- Douglas Paterson
"Very easy to understand"
- Dale Pierce
Who is this course for?
Excel Users
Users that employ Excel 2016 on a daily basis and want to exploit the full power of the new Excel Business Intelligence tools in to improve their reporting and data crunching capabilities HAVE TO TAKE THIS COURSE!
IT & BI Specialists
Professionals that are in charge of the data warehouse management of their company and need to understand how to provide support to analysts who need to extract data from different analytical and relational sources HAVE TO TAKE THIS COURSE!
What's in it for me?
As a Microsoft Excel trainer, I understand that the value of a training course is in making sure students learn skills that they can apply in their daily jobs.
My goal - with every course I create and deliver - is to ensure that all students learn practical skills that can be applied in the real world. To maximize learning, I provide:
Solid instruction
Follow along downloadable files
Practice exercises and solutions
Supporting pdf user guide
Topics Covered
Power View
Discover the Canvas & Visualizations
Switch to Matrix, Cards, Callouts or Charts
Learn how Power View filters data
To Slice or TILE BY - decisions, decisions....
Work with multiple tables and create relationships
Create stunning reports with images and interactive maps
Power Query
Ladies and gentlemen, may I present the Query Editor
Learn how to transform messy data into useful data sets
Append multiple file types together into a single data set
Merge tables - if you like VLookup - you're gonna love this!
Combine multiple Excel files
Create your own custom columns with Power Query “M” language expression builder
Throughout the course we work together building Power View reports and transforming data with Power Query. At the end of each step you have an opportunity to practice creating your own Queries and Reports to help you consolidate, embed and reinforce everything you have learned. I provide a solutions video lecture before moving on to ensure you’re on track and ready to move on.
I provide all the files you need to follow along and a fully supporting pdf user guide detailing all the steps and practice exercises with solutions.
Thanks for taking the time to check out my course. I can't wait to help you take the next step in developing your Microsoft Excel skills. I have used Excel 2016 to demonstrate this fantastic tool and you’ll need Power Pivot installed ready to go.
If you have any questions about the course, feel free to message me here or check out the FREE preview lectures to learn more.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.
Create Power Queries to automate repetitive tasks
Create Power View reports with stunning visuals
Enhance Power View Reports with images and interactive maps
1 Lectures
3 Lectures
4 Lectures
3 Lectures
3 Lectures
6 Lectures
1 Lectures
5 Lectures
4 Lectures
4 Lectures
6 Lectures
3 Lectures
Gilly Dow is an MS Office Master, a Certified Microsoft Excel Expert and Training Consultant with 20 years experience working for the US Military, NHS and multiple private sector companies. Gilly have trained thousands of students from IT Security, MS Office, SAP and Clinical Healthcare applications. GD Teach has been founded especially for Udemy to reach out to a wider...
Excellent
Yes . It was amazing .
I am a collector of Gilly's courses (I have six of them). The only thing I regret is I found her courses too late...I strongly recommend Gilly's courses to all people with different levels...The only difference between Gilly's works and other "ten days to become Excel Master" courses is the bizarre underestimated values...My best wishes for Gilly to reach out to a much bigger community for Excel users.
The exercises are good. They help make for better understanding. Keep it up!
Gilly's natural motivation and witty nature keeps it fun and moving right along. Learning alot, thanks for the great personality ;-) A true educator!
This course has helped me to produce insightful dashboards using power view. I have helped my boss answer some key data question using the map chart and other key functions learnt from the course.
This course will make you work smarter with messy data. It will help you present the data with elegance and flair with a few mouse clicks.
Thank you Gilly for making this brilliant course. Gilly's other courses on Udemy are brilliant as well.
This course exposed many useful tools that I will be able to implement into my work immediately, as well as opens new doors on my resume. I cannot overstate the very thoughtful course design that Gilly uses, as well as her very detailed teaching. I will definitely be taking more of Gilly's courses in the very near future.
Excellent course and the way teacher demonstrate and take us through is amazing. Wonderful teacher
Volume too low. difficult to hear even at full laptop volume and player volume
Your email address will not be published. Required fields are marked *
Michael H.
I now feel like aI have a solid background in using Power Query.