(For the README file and code, please click here.)

Executive Summary

In September/October 2023, I developed a Power BI dashboard with my teammates, who are accountants and programmers so that we could easily visualize our datasets.

Tools Used

• Programming languages: SQL, R

• To create dashboard: Power BI

Method

To create the datasets, I ran SQL code for one dataset, and exported an Excel spreadsheet as a CSV file, which I data-cleaned in RStudio using R. I also had to de-concatenate text found in one column into two parts and place those into two new columns.