Self-Study Text
(SSTE428/26) Surgent’s Max the Tax: Metaverse
Your client, Multi-Mega Markets Corporation (MMM), a global conglomerate with businesses in entertainment, fashion, retail, software, technology and other industries, is looking for advice on the state of the metaverse. They are considering starting a new subsidiary in the metaverse called The MegaVerse (TMV). Your help is needed to share accurate information about the metaverse,...
Read More
Self-Study Video
(SSTE445/26) Surgent’s Power Query Series: Adding Columns for Data Enrichment
Using a variety of hands-on exercises, this course enables users to learn how to add columns using Power Query (Excel version). Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access...
Read More
Self-Study Video
(SSTE443/26) Surgent’s Power Query Series: Editor – The User Interface of Power Query
This course introduces users to the Power Query Editor, using the Excel version of Power Query, and includes a hands-on transformation exercise using the editor. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously...
Read More
Self-Study Video
(SSTE438/26) Surgent’s Power Query Series: Use Cases
This course presents five use cases for specific data issues a user may encounter in Power Query (Excel version). Through hands-on examples, users are guided through the process of overcoming each of these issues.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel...
Read More
Self-Study Video
(SSTE442/26) Surgent’s Power Query Series: Making a Connection
This course explores the workflow of making connections to various data sources using the Excel version of Power Query. Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It...
Read More
Self-Study Video
(SSTE419/26) Surgent’s Power BI Desktop: DAX Formulas, Reporting, and Visualizations
Power BI Desktop is the authoring tool for the Power BI Ecosystem and is an essential component of the Power BI ecosystem. Power BI Desktop is a free application that is available for download.This one-hour course will demonstrate the capabilities of Power BI Desktop as your company continues its journey to increasing its data skills...
Read More
Self-Study Video
(SSTE408/26) Surgent’s Data Analytics Readiness Series: Data Extraction and Data Sources
This one-hour course serves as the introductory module to data analytics. Users of the course will learn the basic terminology used in performing data analytic-based tasks or working with data analytics. An understanding of the sources of data and importance in combining multiples sources will be developed. Users will be introduced to and will practice...
Read More
Self-Study Video
(SSTE414/26) Surgent’s Data Analytics Readiness Series: Calculated Columns and Dimensions
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....
Read More
Self-Study Video
(SSTE449/26) Surgent’s Power Query Series: Useful Transformations
This course covers a number of useful transformations using Power Query (Excel version) to clean, enrich, and shape data. Coverage includes pivoting and unpivoting, filtering and grouping, fuzzy matching, and more, with hands-on exercises for users to practice these skills.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a...
Read More
Self-Study Video
(SSTE421/26) Surgent’s Data Security: Best Practices to Protect Your Business and Yourself
Data security is a front-of-mind topic for most businesses because the risk and cost statistics are sobering. Each of us is in the crosshairs because a typical internet-connected computer faces a cyberattack every 39 seconds. Businesses of all sizes should be cognizant of the ethical issues that must be considered when planning their approach to...
Read More