CPE Catalog & Events
Surgent's Create Measures in Power BI That Define Your Metrics
Available Until
TBD
4.00 Credits
Member Price: $149
The fundamentals of DAX and its role in Power BI Complex DAX functions and formulas for creating sophisticated measures Time-based functions to analyze data over different periods Techniques for ensuring accuracy and reliability in your DAX measures Employing PivotTables in Power BI to test and confirm the effectiveness of DAX measures
Surgent's Create Paginated Reports with Power BI Report Builder
Available Until
TBD
2.00 Credits
Member Price: $89
Overview of Power BI Report Builder, its interface, and integration with the Power BI ecosystem Techniques for setting up professional layouts, including headers, footers, and managing pagination Connecting to various data sources and preparing data for reporting Utilizing Power BI’s visualization tools for impactful data presentation Subreports, drill-through capabilities, and dynamic expressions Guidelines for publishing reports to the Power BI service and sharing them with relevant stakeholders
Surgent's Create Visuals in Power BI to Successfully Analyze Data
Available Until
TBD
4.00 Credits
Member Price: $149
The layout, tools, and features of Power BI Desktop The online environment of Power BI for report creation How to integrate Power Pivot models into Power BI for more complex data analysis The step-by-step process to create compelling visuals and understand the importance of visual context in data storytelling The variety of visuals available in Power BI and their appropriate applications The advanced features of Power BI Desktop that enhance data manipulation and visualization capabilities How to create dynamic and interactive reports that engage and inform Uploading and managing reports on PowerBI.com for wider access and collaboration
Surgent's Critical Conversations: Having the "Hard to Have" Discussions
Available Until
TBD
2.00 Credits
Member Price: $89
Identifying when issues need immediate resolution Approaches for preparing for and having difficult conversations Effective communication skills for challenging conversations
Surgent's Critical Issues Involving Taxation of Construction Contractors
Available Until
TBD
4.00 Credits
Member Price: $129
The impact of recent legislation on the construction industry How to qualify for the “small contractor exemption” and its advantages to the taxpayer Options available to the “small” contractor regarding taxation of long-term contracts How the choice of entity impacts taxation of contractors How AMT impacts the construction industry IRC §460 and “large” contractors How “uninstalled materials” impact taxation of contractors How the “look-back” rules impact contractors How the “10 percent method” can allow certain contractors to defer recognizing taxable income Critical tax planning strategies for contractors
Surgent's Critical Issues Involving Taxation of Construction Contractors
Available Until
TBD
4.00 Credits
Member Price: $79
The impact of recent legislation on the construction industry How to qualify for the small contractor exemption and its advantages for the taxpayer Options available to small contractors regarding taxation of long-term contracts How the choice of entity impacts taxation of contractors How AMT impacts the construction industry IRC §460 and large contractors How uninstalled materials impact taxation of contractors Look-back rules Using the 10 percent method to allow certain contractors to defer recognizing taxable income Critical tax planning strategies for contractors
Surgent's Crowdfunding: A General Overview
Available Until
TBD
1.00 Credits
Member Price: $49
How crowdfunding works The different types of crowdfunding programs Popular crowdfunding platforms Strategies for building a crowdfunding community Creating a crowdfunding campaign Running a crowdfunding campaign
Surgent's Current Developments and Best Practices for Today's CFOs and Controllers
Available Until
TBD
8.00 Credits
Member Price: $159
Economic update Leadership and management changes as a result of the pandemic Expense control that works Understanding our changing workforce and working environment Financial risk analysis Enterprise risk management Metrics and benchmarking Improving bank relationships and cash management Social media's place in our organizations
Surgent's Current Issues in Accounting and Auditing: An Annual Update
Available Until
TBD
4.00 Credits
Member Price: $129
Recently issued but newly implemented Accounting Standards Updates (ASUs), the PCC Update, and items on the FASB’s Technical Agenda New ASUs covering common control leases, crypto assets (e.g., cryptocurrency), and income tax disclosures Leases – Topic 842 Recently issued SASs and other AICPA activity through SAS No. 149 Detailed review of SAS No. 145 Other important A&A practice matters
Surgent's Current Issues in Accounting and Auditing: An Annual Update
Available Until
TBD
4.00 Credits
Member Price: $79
Recently issued but newly implemented Accounting Standards Updates (ASUs), the PCC Update, and items on the FASB’s Technical Agenda New ASUs covering disaggregated expenses, crypto assets (e.g., cryptocurrency), and business combinations Results and findings of the FASB’s Final (Stage 3) Post-Implementation Review (PIR) Report on Topic 606 Recently issued SASs and other AICPA activity through SAS No. 149 Detailed review of the three new Statement on Quality Management Standards (SQMS 1, SQMS 2, and SQMS 3) Other important A&A practice matters
Surgent's Data Analytics Readiness Series: Advanced Formulas- Array Formulas and DAX Formulas
Available Until
TBD
1.00 Credits
Member Price: $59
Key to understanding array formulas is Implicit Intersection How to enter and evaluate an array formula Examples- array and DAX formulas Array formulas- Implicit Intersection Understanding DAX formulas Calculated columns and measures Evaluation context Context transition Implicit vs explicit measures Examples- DAX formulas Creating a calculated column in Power Pivot
Surgent's Data Analytics Readiness Series: Artificial Intelligence- Basic Concepts in Excel
Available Until
TBD
1.00 Credits
Member Price: $59
Understanding difference between supervised and unsupervised learning Formulas in Excel (Correl and Trend and Forecast) Linear regression What is artificial intelligence? Examples- artificial intelligence Forecast function Trend function Regression in Excel with the data analysis ToolPak Creating a prediction model
Surgent's Data Analytics Readiness Series: Calculated Columns and Dimensions
Available Until
TBD
1.00 Credits
Member Price: $59
Where can you create a calculated column? Understanding evaluation context- row and filter context When does evaluation of the formula occur (before, as, or after the data is loaded?) Understanding storage requirements of calculated columns Understanding the analytical data model of the Star Schema Dimensions Facts Exercises- calculated columns Adding a calculated column in a table in Excel Creating a dimension table in Power Query Creating a hierarchy in Excel with calculated columns Adding a calculated column in Power Query JE testing with calculated columns Other test- opening balances
Surgent's Data Analytics Readiness Series: Data Extraction and Data Sources
Available Until
TBD
1.00 Credits
Member Price: $59
Introduction to a Data Analytics Workflow (will be re-introduced in final class to bring all concepts together) Overview of various definitions of data analytics Data analytics needs multiple sources of data Introduction to Power Query (Get & Transform)- on data tab in Excel Exercise- connecting to various Data Sources Importing Excel workbook into Power Query Connecting to a website in Power Query
Surgent's Data Analytics Readiness Series: Data Modeling
Available Until
TBD
1.00 Credits
Member Price: $59
How to join tables using VLOOKUP Power Query- append queries and merge queries Power Pivot- Creating a relationship via diagram view Types of relationships Data integrity Normalization Facts vs dimension tables Exercises- data modeling VLOOKUP and index match formula Appending data in Power Query Merging data in Power Query Connection only queries Creating a relationship in Power Pivot
Surgent's Data Analytics Readiness Series: Data Preparation Using Get and Transform
Available Until
TBD
1.00 Credits
Member Price: $59
An ETL tool- Extract Transform and Load How Power Query ups your game in data analytics Interface components of Power Query Column level and table actions Power Query is a sequential macro recorder What is M Code? Exercise- cleaning and transforming a general ledger
Surgent's Data Analytics Readiness Series: Excel Tables
Available Until
TBD
1.00 Credits
Member Price: $59
Creating a table Parts to a table Benefits of an Excel table Structured references How it helps to create formulas Formulas are column based not cell based Tables are data sources for Power Query Exercises- tables Creating a table Resizing a table Removing duplicates Descriptive Statistics using the Total Row Inserting a slicer Creating formulas using structured references
Surgent's Data Analytics Readiness Series: Formulas, Named Ranges, and Formula Auditing
Available Until
TBD
1.00 Credits
Member Price: $59
Named ranges- how they help in creating formulas Naming conventions and why they are important What you need to know to master formulas How to audit your formulas to limit errors Exercises- formulas Named ranges How to enter a formula- best practices to improve skill levels
Surgent's Data Analytics Readiness Series: PivotTables
Available Until
TBD
1.00 Credits
Member Price: $59
Fields in a PivotTable Benefits of PivotTable Contextual tabs for a PivotTable Field setting dialog box Value field setting dialog box Pivot table options Exercises- PivotTables Creating a PivotTable Grouping by date Sorting a PivotTable Filtering a PivotTable Calculations in a PivotTable Slicers and timelines Introduces OLAP (Online Analytical Processing) pivot tables in Power Pivot
Surgent's Data Analytics Readiness Series: Visualizations and Reporting
Available Until
TBD
1.00 Credits
Member Price: $59
Visualization tools in Excel (camera, slicers, and timelines) Data view- why it went away. Power BI is the visualization tool to use All concepts learned in course are brought together in this last class to create a dashboard: Power Query- to extract transform and load data for the dashboard Power Pivot -to create the data model for the dashboard DAX formulas- for pivot tables to calculate values needed for model Pivot tables and charts- to create visualizations Camera tool to create dashboard Exercise- Using the data analytics workflow introduced in first class of series- to create dashboard for JE testing Journal entry by month and income statement accounts Descriptive statistics of journal entries Number of journal entry by month Journal entries by day of week Round journal entries Evaluate output of journal entry analytic Other approaches What are the false positives (noise)? Next steps in data analytics journey