We focus on technology that is in high demand in accounting and the larger business world. Most of the software we use provides academic licenses for learning. You can learn more about educational licenses at the following links:
Alteryx
Alteryx is a powerful tool used to process and prepare data. It is easy-to-use, equipped with advanced technology, and becoming more commonly used by companies around the world, especially at the Big 4 accounting firms. Alteryx is also widely used by many mid-sized firms as well.
Microsoft Excel
Excel is the industry leading spreadsheet tool where users can analyze and visualize data to enhance business processes. No matter where one ends up, Excel is a critical tool that is valued by nearly all companies.
Microsoft Office 365 Products (includes Excel)
Power BI
Power BI is a data visualization software that is integrated into the Microsoft Suite. For example, data stored in Excel is updated in real time in Power BI. Companies are using Power BI more because of its useful integration and its affordability.
Power BI Desktop License Information
Python
Python is a widely-used programming language known for its simplicity and versatility. Its extensive libraries and frameworks make it easy to build complex applications quickly. Its ease of use and flexibility make it a valuable tool for businesses seeking to automate tasks or streamline their workflow.
Download Python or run Python in Google Colabs
Robotic Process Automation (RPA) with Microsoft’s Power Automate
Power Automate is a low-code robotic process automation (RPA) program that helps users create automated workflows between apps and services.
Power Automate for Desktop License Information
SQL
SQL (Structured Query Language) is a programming language used to manage and manipulate data in relational databases. It is a standard language used by most database management systems, and its syntax is relatively simple and straightforward. SQL allows users to perform a wide range of operations on data, such as querying, updating, deleting, and inserting data into databases.
SQL can be run in “fiddles” like http://sqlfiddle.com/, in Microsoft Access databases, or in most other databases.
Tableau
Tableau is a leading visualization software that can turn a company’s data into a meaningful report. Many companies use Tableau dashboards to track progress towards Key Performance Indicators (KPIs). The possibilities of data visualization are endless.
Other Technologies
We will post challenges with other softwares and add information about using them here.