Our Services

Get 15% Discount on your First Order

MBA 620 Module Five Power BI Executive Summary Guidelines and RubricOverview To measure the financial performance of any company, it is important to

March 28, 2024

MBA 620 Module Five Power BI Executive Summary Guidelines and RubricOverview

To measure the financial performance of any company, it is important to analyze its four key financial statements: balance sheets, income statements, cash flow statements, and shareholders’ equity statements. In this assignment, you will:

Visually present the balance sheet to depict what each company owns and what it owes over the past three years.
Visually present the income statement to depict how much money a company made and spent over the past three years.

The visual presentation and analysis will help you understand and compare the performance of both the companies to be acquired and eventually will help you build your recommendation for the acquisition.

Prompt

Use the provided data sets of Company A and Company B to create data visualizations of their financial performance in Power BI. Then, based on the visualizations, write an executive summary interpreting the financial performance of Company A and Company B. Include screenshots from your data visualizations as needed in your summary. Follow the directions in the Power BI Executive Summary Assignment User Manual.

To complete this assignment, you will use Power BI software that is located within the virtual desktop infrastructure (VDI).

Specifically, you must address the following criteria:

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:
1. Company A: In Power BI, use the provided Company A Financials and construct a set of three clustered column charts, representing:
  1. The assets of Company A as represented in the data during each of the three years
  2. The liabilities and owners’ equity over the same three years
  3. Once the column charts are created, summarize the insights about how the assets, liability, and equity have changed over three years, as presented in the visualizations using Power BI
2. Company B: In Power BI, use the provided Company B Financials and construct a set of three clustered column charts, representing:
  1. The assets of Company B as represented in the data during each of the three years
  2. The liabilities and owners’ equity over the same three years
  3. Once the column charts are created, summarize the insights about how the assets, liability, and equity have changed over three years, as presented in the visualizations using Power BI
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:
1. 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.
2. 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.

What to Submit

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.

HR Management

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

What is the importance of training and development in an organization? How would the training and development contribute to the success of your employees a

What is the importance of training and development in an organization? How would the training and development contribute to the success of your employees and your organization; past or present? What role do the HR professionals have in creating a learning organization? What experiences, positive or negative, have you had

In this project, you will demonstrate your mastery of the following competencies: Prepare and present internal and external reports. Monitor and evaluate

In this project, you will demonstrate your mastery of the following competencies: Prepare and present internal and external reports. Monitor and evaluate performance. Recommend opportunities for performance improvements. Scenario You are a former Navy officer and fighter pilot, and you are now the controller of a division of TransGlobal Airlines,

In this project, you will demonstrate your mastery of the following competency: Evaluate creative and innovative organizational structures Recommend

In this project, you will demonstrate your mastery of the following competency: Evaluate creative and innovative organizational structures Recommend alternative innovations to solve an internal or market need Implement creative and innovative processes within an organization Scenario You work as a middle manager for one of the top U.S. producers

“The most influential person in your life” Her high school softball coach Mrs. Sanders is the most influential person in her life Needs to be a minimum of

“The most influential person in your life” Her high school softball coach Mrs. Sanders is the most influential person in her life Needs to be a minimum of 500 wordd

Maret-Competitive Pay Plan Using the Point Plan Job Evaluation Method Turnitin will check all papers.

Portfolio project in a PowerPoint presentation. I will do the voice over

In Milestone Two, you recommended a strategic plan to the organization from the course scenario for the IoT innovation project. Now that senior management

In Milestone Two, you recommended a strategic plan to the organization from the course scenario for the IoT innovation project. Now that senior management of this company has approved your recommendation, your task is to recommend ways the organization can better support innovation. Remember that your perspective is still that

You have almost completed your analysis of Companies A and B and are scheduled to deliver your proposal to the board. While researching to ensure accurate

You have almost completed your analysis of Companies A and B and are scheduled to deliver your proposal to the board. While researching to ensure accurate and up-to-date data, you learn that two of Company B’s aircraft have been grounded over the past couple of months due to technical issues,

INTRODUCTION An organization’s sustainable competitive advantage is derived largely from intangible assets: human, social, and intellectual capital. Human

INTRODUCTION An organization’s sustainable competitive advantage is derived largely from intangible assets: human, social, and intellectual capital. Human resource professionals enable current and future organizational competitiveness by ensuring that people with the skills, knowledge, and abilities needed to produce these resources are in adequate supply. This is accomplished through employee

Prepare and upload in Canvas a 10-minute voice-over PowerPoint presentation of the results of your research project along with a 4-page double spaced

Prepare and upload in Canvas a 10-minute voice-over PowerPoint presentation of the results of your research project along with a 4-page double spaced report that should be fully cited, double-spaced paper with a minimum of 5 references. Need a female to do this with a female interviewee

Hello, I am in need of assistance with the attached assignment. Please review for plagiarism prior to sending it to me.

As a Human Resources Generalist, part of your role is to assist with the sustainment of the employee lifecycle. An employee lifecycle is an HR model that

As a Human Resources Generalist, part of your role is to assist with the sustainment of the employee lifecycle. An employee lifecycle is an HR model that identifies the different stages an employee advances through an organization. For this assignment, research at least two scholarly resources supporting your essay.

Some entrepreneurs will identify a problem a community has and then attempt to solve the problem that they, themselves, believe is important. However, the

Some entrepreneurs will identify a problem a community has and then attempt to solve the problem that they, themselves, believe is important. However, the community being served may not view the entrepreneur’s perceived problem to be an issue and may not support a proposed solution. It is critical that the

n your role as controller of a division of TransGlobal Airlines, you are responsible for assessing the possible acquisition of the two identified small

n your role as controller of a division of TransGlobal Airlines, you are responsible for assessing the possible acquisition of the two identified small airlines in the Caribbean specializing in chartered flights for luxury vacations using light aircraft (60 passengers or less). One of the important steps in this acquisition

You work as a middle manager for one of the top U.S. producers of luxury and mass-market automobiles and trucks. The company from the course scenario has

You work as a middle manager for one of the top U.S. producers of luxury and mass-market automobiles and trucks. The company from the course scenario has decided to incorporate internet of things (IoT) technology in its vehicles (also called connected cars). Often organizations have to choose from multiple innovative implementation

Organizational creativity and innovation have proven to be challenging concepts to measure. There is not a particular output that indicates organizational

Organizational creativity and innovation have proven to be challenging concepts to measure. There is not a particular output that indicates organizational levels of innovation. To flourish, innovation and creativity must be fostered within the organization. They must be established as cultural values in order for the organization to see the

You have been tasked to merge the staffs of two organizations, one based in the United States and one in a foreign country, which your company has just

You have been tasked to merge the staffs of two organizations, one based in the United States and one in a foreign country, which your company has just acquired. Using a fictitious company of your choosing, create a PowerPoint presentation of at least 10 slides (not counting the title slide

You are the controller of a public Fortune 500 airline, TransGlobal Airlines. The airline utilizes a fleet of corporate jets for private charter by Fortune

You are the controller of a public Fortune 500 airline, TransGlobal Airlines. The airline utilizes a fleet of corporate jets for private charter by Fortune 500 clients at several major airports. Your company is looking to acquire smaller aviation firms as part of an overall growth strategy. In addition to