Home > Courses > Power Query & Power Pivot for Deep Analysis with Excel

Power Query & Power Pivot for Deep Analysis with Excel

Name: Power Query & Power Pivot for Deep Analysis with Excel
Price: 500.00 SGD
Rating: 4.3 (227 reviews)

Training Provider: INTELLISOFT SYSTEMS

Course Reference: TGS-2024049574

S$500

Original: S$1,000

Save S$500

About This Course

The Power Query and Power Pivot For Deep Analysis With Excel is a practical, hands-on course to teach you how to load, clean, and analyze data quickly and easily.

Section 1: Review Data with Power Query
Build Foundational skills for data handling with Power Query. You will begin by understanding different data types and methods to query data from various sources, such as tables, ranges, and external Excel files. Learn to manipulate columns and rows, add custom and conditional columns, and perform basic sorting and filtering. You will pick the necessary tools to prepare and clean data effectively, moving to more sophisticated analysis.

Section 2: Data Analysis with Power Query and Power Pivot
Introduction to intermediate techniques combining Power Query & Power Pivot in Excel for Data Analysis. You learn explore complex formulas, nested functions, and advanced data structuring methods like pivoting, appending, and grouping data. This unit is crucial for learners to begin conducting predictive modeling and contextual targeting. Apply both technical and conceptual knowledge to solve business problems, using the data structures you create and manipulate with Power Pivot & perform deeper, more insightful data analysis.

Section 3: Advanced Data Analysis using Power Query
Deep Dive into advanced data analysis techniques, focusing on more complex functionalities within Power Query, such as various types of joins, fuzzy matching, and dealing with inconsistent data sets. This unit covers sophisticated methods to merge data and enhance the quality of the analysis, executing Power Query analytics tools to uncover key analytics findings, trends, and consumer insights. You will build strong skills to handle complex scenarios where data from multiple sources needs to be consolidated and analyzed critically.

Join this Power Query & Power Pivot for Deep Analysis With Excel and Master Advanced Skills in Data Analysis & Data Visualization with Intellisoft.

What You'll Learn

Power Query is a feature in Excel that allows you to quickly import data from multiple sources and easily clean, transform, and reshape it to suit your needs. We show you how to use this powerful, time-saving tool to do deep cleansing of data, and then do a deeper analysis of data with Miclosoft Excel's Power Pivot. This course teaches you how to import, merge, rearrange, and clean data, as well as how to repeat the process with one click if the data changes. Discover how to split columns, unpivot data, and use joins to merge, segment, and compare datasets.

Data Analysis Expressions (DAX) allow Microsoft Excel users to create powerful calculated fields in Power Pivot. In this course, you will learn how to use the DAX language and Power Pivot to explore and analyze relational data models. You will master how to add calculated columns and measures to data models in Excel. We highlight the differences between calculated columns and DAX measures, covers common DAX formulas and functions, and discusses best practices for working with DAX and Power Pivot.

Full of dozens of tips, tricks & techniques in this comprehensive, practical, hands-on training using Power Query and Power Pivot in Excel for Deep Data Analysis.

Entry Requirements

• Aged 21 and above
• Have minimum GCE “N”, “O” or “A” Level / NITEC or a diploma qualification and minimum 1 year of working experience; and
• Have a Basic English language proficiency