Information Technology

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...

This course teaches the user how to perform data transformations in Power Query, using a hands-on approach. 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 also enables...

This final course in the series covers advanced features in Power Query (Excel version), including functions and parameters and basics of data modeling in Power BI and Power Pivot. Multiple hands-on examples help to reinforce these concepts.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that...

As the rewards from data continue to grow, companies must recognize the value of data to remain competitive in the current digital economy. Companies that use data in their business processes are outperforming those that do not. Data skills will become necessary in the next few years, and your employees will need them to perform...

This course is designed for the Excel user to begin their data analytics journey with an introduction to a product created for their skill set: Power Query, using the 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...

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...

In this one-hour course, users will apply Excel and Power BI tools and skills directly to tables in Excel. Users will work alongside the instructor to create named tables, create structured references, enter formulas, and prepare the tables for input into Power Query. Users will be introduced to the preparation of the first level of...

This one-hour course will serve as an introduction to artificial intelligence and how artificial intelligence is utilized in Excel. Users will be introduced to correlation and trend functions in Excel. The basics of linear regression and its application in Excel will be discussed. Specific attention will be given to artificial intelligence functions in Excel, including,...

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...