Power BI Executive Summary
Specifically, you must address the following criteria:
Guidelines for Submission
Submit a 2- to 3-page Word document using double spacing, 12-point Times New Roman font, and one-inch margins. Sources should be cited according to APA style. Consult the Shapiro Library APA Style Guide for more information on citations.
Assets, Liability, and Equity: Summarize how the assets, liabilities, and owner’s equity have changed over three years for Company A and Company B. Include screenshots of your data visualization as follows:
Company A: In Power BI, use the provided Company A Financials and construct a set of three clustered column charts, representing:
- The assets of Company A as represented in the data during each of the three years
- The liabilities and owners’ equity over the same three years
Company B: In Power BI, use the provided Company B Financials and construct a set of three clustered column charts, representing:
- The assets of Company B as represented in the data during each of the three years
- The liabilities and owners’ equity over the same three years
Revenue and Earnings: Use the provided income statements to summarize the gross revenue and net earnings for Company A and Company B over three years. Include screenshots of your data visualization as follows:
-
- Company A: In Power BI, use the provided Company A Financials document and construct a line chart illustrating the visual relationship of revenue, gross profit, total expenses, earnings before tax, net earnings, and taxes.
- Company B: In Power BI, use the provided Company B Financials document and construct a line chart illustrating the visual relationship of revenue, gross profit, total expenses, earnings before tax, net earnings, and taxes.
Conclusion: Summarize your observations about the financial performance of both companies. Include any insights you may have about their performance trends or how they have performed compared to each other over the past three years.