Visualizing Financial Performance: Power BI Analysis of Company

School: Southern New Hampshire University - Course: MBA 620 - Subject: Accounting

5-1 POWER BI2 Data sets that are gathered offered an excellent opportunity to provide a comparative evaluation of a variety of information. Through this process, substantial quantities of intelligible information are depicted contextually (Bruns, 2018). As shown below in Figure 1, the sections evaluated for Company A are Total Liabilities & Shareholder's Equity and Total Assets for three years: 2017, 2018, and 2019. Figure 1: Clustered Column Chart for Company A Assets within Company A remained the same during 2017 and 2018, but there was a considerable decrease of $20,000 in 2019. An exponential decrease in assets within a company can be a sign that they are not being used efficiently or there could be a problem internally (Hayes, 2022). This can be contributed to a variety of factors, including total liabilities, which unfortunately followed the same path in 2019 after having an equal stance in 2017 and 2018. However, the decrease this time points towards the organization paying off total liabilities that were owed. In 2019, Company A repaid debts by liquidating particular holdings, thus capital 5-1 POWER BI3 stayed even in 2017-2018, yet rose in 2019. With these changes, the company is showing movement away from deficit to shareholder classification. In conclusion, the number of creditors has been lowered and capital has increased. As shown in Figure 2 below, Company B's Total Liabilities & Shareholder's Equity, and Total Assets demonstrate similar to Company A. Additionally, they too had a substantial drop going into 2019, showing the organization taking steps to improve their financial standing. The number of debts the organization owes dropped considerably between 2017 and 2018. By removing a large number of their financial commitments, the data reveals Company B has reduced total debts substantially in 2019.