What you'll learn

Learn how to use Excel Power Query to CONNECT and TRANSFORM data in Excel

Have a COMPREHENSIVE understanding of connecting and transfog data using Excel 2016

Load data into Excel from multiple DIFFERENT SOURCES such as SQL Server, CSV, XML, JSON and SQL Analysis Services

Transform data by filtering, chag data types, removing columns and perfog BASIC transformations

Perform ADVANCED transformation such as Meg, Appending, Unpivoting, Grouping and custom calculations

Learn to CLEAN data and LOAD data using parameters

Life access to course materials and practice activities from an experienced Udemy instructor

Requirements

You should be able to work with data in Excel and do basic reporting

Excel 2016 or above

Description

**** Updated June 2020 - This best selling Udemy Power BI course has been updated with new content ****

Recent reviews:

The concepts learned will save a lot of in prepping data for further analysis from standardized say monthly spreadsheets that have data in columns where from an analysis point you would require rows. Just the concept of un-pivoting has paid for the course."

"I am into certifications and this course is aligned to the MCSA BI Reporting!"

"Wonderful Power Query course. I highly recommend it!!!"

**** Life access to course materials and practice activities. ****

This course is presented by Ian Littlejohn - who with over 75 000 students is one of the most popular instructors on Udemy. Ian provides world leading courses on Excel, Power Pivot, Power BI and Google Data Studio.

Skills in data analysis, reporting and the creation of dashboards are HIGHLY valued in today's business environment. Excel is now recognized as the most commonly used data analysis tool in the world for the development of reports, data analysis and dashboards.

In this course you will learn to use Power Query to consume and transform data.

In this class (the first module of my 3 part "Excel Master Class" Series), you will cover:

Introduction and Course Content

Basic Data Transformations - Learn about filtering data, chag data types, adding new columns and removing columns

Advanced Data Transformations - Meg data into one table, Appending data, Grouping data, conditional rules and custom fields

Data Cleansing - Techniques and skills to clean up your data

Connecting to Data Sources - Learn how to connect and access data from a variety of different data sources including, files, databases, web URL and SQL Analysis Services

We look forward to having you on our course as we learn and explore the incredible power of Microsoft Excel.

Please note that this course is the first course in a series of three courses for the Excel Master Class series. Search for my instructor profile to purchase these other courses.

Course 1 - Power Query -Consume and Transform Data

Course 2 - Power Pivot - Data Modeling and DAX Formulas

Course 3 - Pivot Tables and Pivot Charts

Who this course is for:

Excel users who want to learn how to IMPORT and TRANSFORM data in Excel

Learners who want to learn ADVANCED techniques for preparing data for analysis



DOWNLOAD
uploadgig


rapidgator


nitroflare