Product Line
Showing 57–60 of 345 results
-
Core Data Analytics Module 5: PivotTables
Course Description
This one-hour course provides hands-on practice using PivotTables in Excel®. Learn and apply skills to create, structure and analyze data using this powerful tool, including discussing its benefits and limitations. You will also be introduced to Power Pivot its Online Analytics Processing feature.
Learning Objectives
- Understand the applicable Excel® skills required in making the transition to data analyst
- Understand the uses, benefits and limitations of PivotTables in Excel®
- Apply Excel® skills to create, structure and operate PivotTables using predefined data
- Learn to perform sorting, filtering and calculations within PivotTables
- Understand Online Analytical Processing and when it’s used in Power Pivot
-
Core Data Analytics Module 6: Data Modeling
Course Description
This one-hour course focuses primarily on Microsoft® Excel®’s Power Query, Power Pivot and VLOOKUP feature sets. Users will learn how to join tables using various techniques and add-ons in Excel®, while maintaining data integrity. The majority of the course focuses on hands-on data exercises, as users apply skills like creating relationships and analyzing data with Power Query.
Learning Objectives
- Understand the applicable Excel® skills =required in making the transition to data analyst
- Understand types of data relationships (linear, normal, etc.)
- Learn to apply VLOOKUP and index match formulas in Excel®
- Learn to append and merge multiple data sets
- Create relationships in Power Pivot
-
Core Data Analytics Module 7: Calculated Columns and Dimensions
Course Description
This one-hour course will focus on the use of Excel® with Power BI and Power Query to organize and analyze data. Users will primarily work with calculated columns generated from existing data. They will walk through hands-on exercises to create calculated columns, add dimensions to existing data tables, and create hierarchies within the data tables. Special attention will be paid to Star Schema analytical modeling. To explore practical applications, users will apply the skills to journal entry testing.
Learning Objectives
- Understand the applicable Excel® skills required in making the transition to data analyst
- Understand evaluation context-row and filter context
- Understand the requirements to create calculated columns and apply that understanding to data
- Learn to create a dimension table in Power Query
- Learn to create hierarchies in Excel® with calculated columns
- Apply calculated column skills to a dataset related to journal entry testing.
-
Core Data Analytics Module 8: Advanced Formulas – Array Formulas and DAX Formulas
Course Description
This one-hour data analytics course will introduce you to formulas in Power BI and Microsoft® Excel®. Learn the skills to create and evaluate both array and DAX formulas, and discuss implicit for explicit intersections and measures within the formulas. Then, you will apply your understanding to data and work alongside the instructor to create calculated columns in Power Pivot using DAX and array formulas.
Learning Objectives
- Understand the applicable Excel® skills required in making the transition to data analyst
- Understand the basic requirements to create array and DAX formulas using Power BI and Excel®
- Understand how DAX formulas relate to calculated columns and how they can be created within calculated columns
- Apply understanding of DAX formulas to create calculated columns using Power Pivot
- Learn to create hierarchies in Excel® with calculated columns