Investigate the overall sales and profitability

Assignment Help Accounting Basics
Reference no: EM133776590

Accounting Systems in the Digital Age

Required:

Question 1: Tableau Case Study - Bikes Galore Limited

This assignment is based onBikes Galore Limited, a fictitious company. Bikes Galore Ltdis a large, multinational manufacturing company that produces and distributes bicycles, parts, and accessories for commercial markets in in Australia, Canada, France, Germany, United Kingdom, and United Sates. The company employs 500 workers. Additionally, Bikes Galoreemploys several regional sales teams throughout its market base.

Using Tableau Desktop software and the Bikes Galore Ltd dataset (see Assessment folder), investigate the overall sales and profitability for the company and to identify key areas for improvement and present your findings to the board. Your analysis should include all areas: customers, products, and regions (i.e., locations). Prepare a four (4) page story (i.e. worksheets or dashboards) of your finding and recommendations about the data and must be logically linked from point to point.

The visualisations should contain, at a minimum: 1) Four story points; 2) different chart types, maps, and tables; 3) calculated fields and quick table calculations; 4) filters for data in your visualisations to engage user interaction with your story; and 5) Title and text boxes to explain the charts and diagrams in yourvisualisations.

Question 2: Microsoft Power BI Visualisations - Superstore Dataset
Using Microsoft Power BI, prepare multiple interactive reports from the Superstore dataset provided on the spreadsheet titled "Supertore_23_9_2024.xlsx" (See Assessment folder).

This assignment is based on Superstore Ltd, a fictitious company that produces and distributes furniture, office supplies and technology products in North America and Canada.

Using MS Power BI software and the Superstore dataset (see Assessment folder), investigate the overall sales and profitability for the company and to identify key areas for improvement and present your findings to the board. Your analysis should include all areas: customers, products and regions (i.e., locations). Prepare a four (4) page interactive report (i.e. dashboards or reports) of your finding and recommendations.

The visualisations should contain, at a minimum: 1) Four interactive reports, 2) different chart types, maps, and tables; 3) calculated fields, 4) filters for data in your visualisations to engage user interaction; and 5) Title and text boxes to explain the charts and diagrams in your visualisations.

Reference no: EM133776590

Questions Cloud

What is the result of the suppression of luteinizing hormone : What is the result of the suppression of the luteinizing hormone (LH) surge by progesterone in combination contraceptive agents?
How does legislative impact nurses negatively : The impact of U.S. policies to protect healthcare workers from bloodborne pathogens: The critical role of safety. How does legislative impact nurses negatively?
Do you feel that healthcare workers have enough support : Do you feel that healthcare workers have enough support at this time related to depression, burnout, and anxiety related to COVID 19?
Which aspect of chronic illness is most accurate : Along with learning the types of chronic illnesses, student learn about trends and aspects of chronic illness. Which aspect of chronic illness is most accurate?
Investigate the overall sales and profitability : Produces and distributes bicycles, parts, and accessories for commercial markets in in Australia, Canada, France, Germany, United Kingdom, and United Sates
Approaches to media and communication : Demonstrate your ability to engage academically and critically with the course materials. You will choose a piece of media and a theory studied
Why is it important to ensure the competence of the person : BCBAs are qualified professional with expertise in designing and implementing. Why is it important to ensure competence of the person providing ABA services?
How does legislative impact nurses negatively : Impact of Shift Work on the Health and Safety of Nurses and Patients Berger, Ann M; Hobbs, Barbara B. Clinical. How does legislative impact nurses negatively?
Which can be educated as the cause of the elevations : A 25-year-old patient has been newley diagnosed with hypertension. Which can be educated as the cause of these elevations?

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd