Information Technology

This one-hour course will serve as an introduction to data visualization and reporting using Power BI and Excel. Users will understand the benefits of using Power BI to create data visualizations and how Power BI differs from previous functions in Excel for visualizations. A hands-on exercise will be applied where the user will work alongside...

This one-hour data analytics course will introduce formula arrays and DAX formulas to users in Power BI and Excel. Users will learn the skills to create and evaluate array formulas and DAX formulas. An understanding of implicit or explicit intersections and measures within the formulas will be developed. Users will apply the understanding to data...

The past two years have ushered in an explosion of ransomware attacks affecting businesses and individuals. Many of us read or hear about these attacks, but there is little understanding of how they occur, how a response is undertaken, and how the chances of experiencing one can be reduced. Join us to learn about these...

Accounting and finance professionals have used different forms of automation over the years to improve the efficiency and accuracy of their work. So far, technology has not been able to replace the knowledge, experience, and decision-making of seasoned professionals. Times are rapidly changing. Today, systems easily exceed humans in accuracy and consistency. Artificial intelligence (AI)...

This one-hour course will provide users with hands-on practice using PivotTables and Excel. Users will learn and apply skills to create, structure, and analyze data using PivotTables. The benefits and limitations of PivotTables will be discussed. Users will be introduced to Power Pivot and Online Analytics Processing within it.This course is one in a ten-part...

Even for experienced Excel users, there is a learning curve to using formulas in Power Query (Excel version). This course presents the fundamentals of this concept. In addition, this webinar introduces users to the "M" language in Power Query, as well as types of errors that users may encounter. Hands-on examples reinforce all of these...

A data-driven culture can only occur when there is collaboration, communication, and cooperation between everyone in your organization.Collaboration can only occur in the Power BI ecosystem when your organization works in the cloud with Power BI.com, also known as the Power BI Service, a software as a service available on the Power Platform.This one-hour course...

A merge query combines two queries that have a common column or columns. This course discusses best practices for creating merge queries using Power Query (Excel version) and includes hands-on exercises to enable the user to demonstrate what they have learned.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has...

With the Power BI ecosystem, a complete business intelligence solution, your company can begin the data analytics journey with Excel. Excel contains two data tools of the Power BI ecosystem to begin developing data skills: Power Query and Power Pivot. Beginning your data journey with an application your business users are already familiar with will...