This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order.

This webcast focuses on using DAX (Data Analysis eXpressions) to create advanced calculations in Power Pivot data models. We will review what you learned in "Power BI - Go Beyond PivotTables with Power Pivot" and take your calculations to the next level using advanced DAX formulas.

You will learn over 20 DAX functions that will allow you to perform calculations that were not possible with standard Excel. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data like:
month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. You will also learn the DAX calculation process in order to proof and validate your calculations.

We will be using Power Pivot to create our DAX calculations, however, the process is very similar in Power BI Desktop and the functions and formulas are identical. If you are using Power BI Desktop, you should be able to follow along and learn how to create advanced calculations.

This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. (bold) *However, in order to follow along and apply concepts being taught during this session, you need to have the Power Pivot add-in installed.

(bold) Explore the other webcasts in the 2020 Power BI Series:

Power BI - Introduction to MS Power BI Tools

Power BI - Prepare Your Data Efficiently for Excel Analysis

Power BI - Analyze Your Data With Excel Pivot Tables

Power BI - Create Excel Dashboards for Maximum Impact

Power BI - Use Power Query to Transform Your Data

Power BI - Go Beyond PivotTables with Power Pivot

Power BI - Use PBI Desktop to Create Reports and Dashboards

Power BI - Share Your Data Analysis using PowerBI.com

The course provides a concise overview of the Internet of Things (IoT), a global ecosystem of advanced technologies that connect objects to the Internet, each other and people. Discover how new IoT apps and devices are being used to increase operational efficiency, develop post-transaction relationships, and create new revenue streams in enterprises worldwide. You'll walk away with a fundamental understanding of IoT applications and their potential to help accountants boost their relevance, value, and revenue. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing, and reporting information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order.

Power BI Desktop is a new stand-alone tool that adds visualization to your data. This webcast focus is on learning the Power BI Desktop interface, connecting to data sources and creating the visualizations. We will demonstrate the creation of each of the various visualizations and the various options related to each.

We will also show how the visualization can be connected together to provide fully-interactive reports with drill-down capabilities. This webcast does not require any Excel knowledge but understanding Power Pivot and Power Query can reduce your learning curve.

This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. (bold) *However, in order to follow along and apply concepts being taught during this session, you need to have the Power Pivot add-in installed.

Explore the other webcasts in the 2020 Power BI Series:

Power BI - Introduction to MS Power BI Tools

Power BI - Prepare Your Data Efficiently for Excel Analysis

Power BI - Analyze Your Data With Excel Pivot Tables

Power BI - Create Excel Dashboards for Maximum Impact

Power BI - Use Power Query to Transform Your Data

Power BI - Go Beyond PivotTables with Power Pivot

Power BI - Use Advanced Calculations with DAX Formulas

Power BI - Share Your Data Analysis using PowerBI.com

Be the difference your organization needs! Join other CPAs leading and preparing for future growth at the Strategic Finance and Accounting Virtual Conference.

Let's Start 2025 Strong:

- Invest in professional development for yourself.

- Train, educate and develop your team.

- Position your team for the future of finance and accounting.

- Gain confidence in strategic thinking.

- Build your strategy.

- Empower better decisions.

- Influence the future of your organization.

You will hear from a robust lineup of speakers who will offer insights and strategies on:

- Economic movement

- Talent trends

- Fraud vulnerabilities

- Responsible automation

- Integrated thinking and reporting

- Attaining buy-in and implementing change

And you know what they say—the larger the group, the bigger the discount!

- 5-9 attendees = 10% off

- 10+ attendees = 20% off

Call Member Services at 614.764.2727 to register your group.

The course provides a concise overview of more than 200 data visualization tools which can be used by accountants to enhance the visual appeal of their financial work. All resources are easy-to-use web-based applications that require virtually no artistic or design skill - simply drag and drop, point and click, cut and paste, and/or edit text. You'll discover how to create new image content in a snap to better inform, persuade, and inspire action. Participants will walk away with a whole new creative toolkit and skillset that cuts through data clutter, improves analysis and sharpens decision-making. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order.

What good is data analysis if you can't share it? This webcast focuses on using Microsoft’s cloud-based sharing/publishing platform, PowerBI.com. You will learn the interface as well as the benefits of using PowerBI.com. You will also learn how to use PowerBI.com to leverage the work performed in Power Pivot or Power BI Desktop.

Using PowerBI.com to create visuals is very similar to Power BI Desktop, so we will only review this feature. If you want detailed instructions on creating visualizations, please attend the Power BI Desktop webcast.

This class can be taken with no Excel or Power BI Desktop knowledge, but some concepts will be a repeat from those classes and will serve as a knowledge reinforcement for experienced users.

Many data analysts may create models in Power Pivot or Power BI Desktop, so we will spend time focused on how to share that data with PowerBI.com. This will ensure that everyone is looking at the same data, no matter the toolset. PowerBI.com adds the ability to create and share dashboards, so we will also demonstrate how to create visualizations that can be turned into dashboards that allow users to customize their PowerBI.com with dashboards that are meaningful to them.

This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. (bold) *In order to follow along and apply concepts being taught during this session, you need to sign-up for a free PowerBI.com account at www.powerbi.com.

(bold) Explore the other webcasts in the 2020 Power BI Series:

Power BI - Introduction to MS Power BI Tools

Power BI - Prepare Your Data Efficiently for Excel Analysis

Power BI - Analyze Your Data With Excel Pivot Tables

Power BI - Create Excel Dashboards for Maximum Impact

Power BI - Use Power Query to Transform Your Data

Power BI - Go Beyond PivotTables with Power Pivot

Power BI - Use Advanced Calculations with DAX Formulas

Power BI - Use PBI Desktop to Create Reports and Dashboards

Cybersecurity protection is one of the most important responsibilities of every CPA professional to protect the confidentiality of sensitive client information. While there are many aspects of cybersecurity that need to be addressed, the biggest vulnerability to protect against is unauthorized access to your application login credentials. Once your login credentials are breached, the cybercriminal essentially has the keys to your data kingdom. John Higgins, a national leader in the CPA technology, will demonstrate the ease with which you can protect all of your login credentials with maximum security with minimal expense. You will leave this course prepared to deploy this state of the art security tool in your organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Don't look now, but ChatGPT is taking the business world, including the accounting profession, by storm. Every CPA, whether in public accounting or working in corporate, should have a fundamental understanding of ChatGPT and generative AI applications more broadly. This course will provide you with a foundation of knowledge about ChatGPT technology that will prepare you to have conversations with clients, customers, colleagues and service providers. More importantly, you will learn how to leverage ChatGPT to increase your personal productivity. If you feel your ChatGPT knowledge is lacking, that will not be the case after you attend this course, taught by John Higgins, one of the leading technology strategists and thought leaders for the accounting profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take this session! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.