Individual Part Course
Showing 17–20 of 53 results
-
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
-
Core Data Analytics Module 9: Artificial Intelligence – Basic Concepts in Excel
Course Description
This one-hour course serves as an introduction to artificial intelligence (AI) and how it’s utilized in Microsoft® Excel®. First, you’ll learn the basics of linear regression and its application. Then, you’ll learn AI functions such as forecasting, trend analysis, regression analysis and predictive modeling.
Learning Objectives
- Understand the applicable Excel® skills that will be required in making the transition to data analyst
- Understand what artificial intelligence is and how it relates to data analytics
- Understand the basics of performing linear regression and apply that understanding to data
- Be able to accurately model data and create a prediction model
- Be able to apply trend analysis and forecasting functions to data in Excel®
-
CPA Review Scholarship: Auditing and Attestation (AUD)
A.S.A.P.® Technology, Surgent’s proprietary adaptive learning software identifies each student’s knowledge gaps and generates personalized study plans to close them, while real-time algorithms optimize for efficiency along the way. As a result, Surgent students achieve an 92% pass rate*, while saving up to 400 hours of study time.
AUD includes nearly 2,200 multiple-choice questions, 110+ task-based simulations, and 90+ “bite-sized” videos, which are focused on specific, digestible topics and come with customized study notes. The following topics are covered: Ethics, Professional Responsibilities & General Principles, Assessing Risk and Developing a Planned Response, Performing Further Procedures and Obtaining Evidence, and Forming Conclusions and Reporting.
*88% pass rate based on Surgent students who achieved a ReadySCORE of 75 or more across all content areas, topics, and question types.
