Microsoft Power Query Training

Microsoft Power Query: Data Cleansing and Processing Course

Power Query can connect to wide range of data sources. Databases such as SQL Server, Oracle, Text files, Big data and Hardtop data sources, online searches and Data feeds, Cloud storage, Facebook, SharePoint and many other types of data storage. Power Query extracts the data from sources, and does transformations such as splitting columns, data conversions, lookups, merge, append, data cleansing and many other data transformations AUTOMATICALLY without the use of VBA.

Why You Should Enroll in this Microsoft Power Query: Data Cleansing and Processing
Course?

• Import / connect to external data from multiple sources
• Automate the data transformation & data cleansing processes
• Combine data from multiple sources into a single source
• Merging data without the need of formulas such as VLOOKUP, INDEX & MATCH
• Perform calculation to aggregate data

HRD Corp Claimable Course

This course is not just eligible for HRD Corp claims, it’s a must-have opportunity for those looking to invest in their personal and professional growth. By taking advantage of the organization’s human resource development program and getting reimbursed for the cost of the course, you’ll not only be boosting your skillset and increasing your knowledge, but you’ll also be maximizing the benefits offered by your employer. Don’t miss out on this incredible opportunity to enhance your career and secure your future success. Make the investment in yourself today and claim your spot in this valuable course.

Course Outline

INTRODUCTION TO POWER QUERY
This module explains what a power query is and how you can download and install
the power query on your computer. Learn how data files are imported / connected
whether it’s a text files, CSV file, database, or any other source. Once the connection is built,
refreshing the connection will automatically load the latest changes.

APPENDING DATA FROM MULTIPLE SOURCES / FORMATS
In this module, you will append data together into one source from multiple
file formats, multiple sources and even an entire folder for the purpose of analysis.
If the source is an Excel file, learn to pull data from
multiple workbooks, multiple sheets, and multiple tables.

MERGING TABLES
This module shows how easy to merge data without using formulas such as
VLOOKUP, INDEX & MATCH. Perform more advanced merges using
Inner, Outer, Full, and Anti Joins. Learn to automate
reconciliations and throw out exceptional items.

POWER QUERY FORMULAS
This module shows how to perform calculations such as SUM, AVERAGE & COUNT just like a pivot table.
More complicated data transformation can be done using “M” language for Power Query.

TRANSFORMING DATA
In Power Query, you will be able to transform selected columns into attribute value pairs
where columns become rows for data analysis which is required for Pivot Tables.
Data that is structured incorrectly can be transformed easily.

CLEANING DIRTY DATA
The complete removal of dirty data from a source is virtually impossible. Power
Query has some tools which can be used to clean some common problems
such as missing data, data formatted incorrectly or date problems.

Why You Should Enroll With Us?

Enrolling with us offers you numerous benefits, including:

Expert instruction
Our instructors are experienced professionals with a deep understanding of Microsoft Excel and Power. The trainer will guide you through every step of the process and provide you with hands-on training and practical tips.

Comprehensive modules
Our course covers everything from the basics of Microsoft Excel to advanced techniques for creating stunning visual effects. Whether you’re a beginner or an experienced person, you’ll find the training you need to take your skills to the next level.

Real-world experience
Our training program features hands-on exercises and real-world projects to help you apply your newly acquired skills and gain practical experience. Upon completion, you’ll be equipped to handle any challenge in Microsoft Excel and Power BI with confidence.

Valuable networking opportunities
By enrolling in our course, you’ll have the opportunity to connect with other aspiring professionals. These connections can be valuable for future projects, collaborations, and career opportunities.

Career Advancement
By mastering Microsoft Excel and Power BI, you’ll gain the skills you need to advance your career and stand out in the job market.

So why wait? Invest in your future success and enroll in our training today!

If you’re interested in learning more about this course and what it has to offer, don’t hesitate to reach out to us! We’d love to hear from you and answer any questions you may have. Our friendly and knowledgeable team is here to help, so please feel free to reach out to us at 1700-81-5520 or email at training@excelacademy.my.

Whether you’re still considering enrolling or have already decided, we’re here to support you every step of the way. So go ahead, and get in touch with us today!