Udemy: Power Query

[LeeAndro]

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 40 lectures (5 hour, 36 mins) | Size: 2.75 GB

If you have been wasting vast amounts of at work trying to gather, fix and combine your Excel data before you've ever done any analysis and reporting, then let our resident Data expert show you how Power Query can transform the way you work!

What you'll learn

Complete Mastery of Power Query

Introduction to getting data from various sources and cleaning it up

Rapidly transpose, pivot and un-pivot your data to make it useful

How you can quickly combine multiple data sets by appending and joining

Speed up your data queries with duplication and tweaking parameters

Troubleshoot your queries and set up auto refreshing of your data

Requirements

You need to have an intermediate level of skill with Excel and be comfortable with Data Analysis techniqes including Pivot Tables, SUMIF/COUNTIF formulas, sorting and filtering

Access to Excel 219 (365) or 2016, 213, 2010, 2007

Description

HOW POWER QUERY CAN PREVENT WASTING



Power Query is the No.1 Excel feature added in the last decade because it can help you get data from various sources, no matter what format it is and clean it all up for you with nothing more than a few clicks! Specifically, there are two ways Power Query saves you vast amounts of :

If you have reports that are frequently updated, then you just create a 'Query' from a source of data then all you need to do is press refresh every you need to update, and Power Query will carry out all the little steps needed to clean up your data

If you work with messy or unstructured data that consumes a lot of your to clean up, then Power Query has some functions that instantly fix your data such as unpivoting, appending, joining and transposing to name a few

Power Query's magic is in saving you from all the usual ways to clean up your Excel data that are far too -consuming. But it's not just Excel data you clean up, it's any data from most Databases, SAP, Salesforce, SharePoint and so on.

HOW THIS COURSE WILL HELP YOU

This video course is taught by our in-house Data expert Ross Hughes who has over 30 years of experience working with Data in senior technical roles within major companies. In a few short hours of self-paced training, Ross will have you going through the full cycle of 'Getting, Transfog and Refreshing' your data, after which it will be ready for quick analysis and report.

Ross' experience is priceless, he shows you how to harness Power Query like few can and having him, teaching you 'over his shoulder' is more than worth the price of the course.

WHAT YOU WILL LEARN:

You will learn all you need to know about Power Query to help you deal with difficult data challenges.

· Introduction to getting data from various sources and cleaning it up

· Rapidly transpose, pivot and un-pivot your data to make it useful

· How you can quickly combine multiple data sets by appending and joining

· Speed up your data queries with duplication and tweaking parameters

· Troubleshoot your queries and set up auto-refreshing of your data

Who this course is for:

This is great for Data Analysts, Business Intelligence Analysts, MI Analysts, Project Managers, PMOs and even Accountants (Including Finance Partners & Financial Controllers)who deal with lots of complex data



DOWNLOAD
uploadgig

https://uploadgig.com/file/download/5c8A06e70C2a65A7/PLUN16O6_.Power_Query_.part1.rar
https://uploadgig.com/file/download/32e5634cDa807410/PLUN16O6_.Power_Query_.part2.rar
https://uploadgig.com/file/download/7652e72f46Dcb304/PLUN16O6_.Power_Query_.part3.rar

rapidgator

https://rapidgator.net/file/315496c2590b0ddabe4903677dee4d9e/PLUN16O6_.Power_Query_.part1.rar
https://rapidgator.net/file/d4012a14b5a8afa1231cabf658fc6f25/PLUN16O6_.Power_Query_.part2.rar
https://rapidgator.net/file/f3235128f548fde24a40abef22f080aa/PLUN16O6_.Power_Query_.part3.rar

nitroflare

http://nitroflare.com/view/FF65E3944D0F474/PLUN16O6_.Power_Query_.part1.rar
http://nitroflare.com/view/FB70567C05850EF/PLUN16O6_.Power_Query_.part2.rar
http://nitroflare.com/view/D2A3E9A3C3CC062/PLUN16O6_.Power_Query_.part3.rar