Fundamental of business analytics

Reference no: EM132998969

HI6037 Fundamental of Business Analytics - Practical Case Study and Reporting

Purpose : 1. Analyze and reflect on the alternative methodologies used in developing business information systems

2. Critically analyze requirements modelling and different modelling techniques for developing business information systems

3. develop requirements and specifications and provide conceptual and practical arguments to defend the solutions based on the core principles of information system analysis and design

4. Develop prototypes of information systems demonstrating initiative and problem-solving judgement aligned to client needs and best practices

5. Communicate the requirements for the business functionality of an information system in terms of data required, data storage and processing to technical and non-technical stakeholders

Assignment Description

Scenario
You work as a report developer and analyst. Your manager has supplied you with some data related to the organization and has requested a number of reports. You have been requested to use Microsoft Power BI to analyse the data.
The list of assignment 2 submissions is as below:

2a - Report
Once you have created the required reports you will need to Record the answer and insert a screen shot of the report with the answer highlighted. You are also required to interpret the data and provide an explanation for the results for questions.

2b - Dashboards
Once you have answered the questions and provided required information, on the second part, you need to create 4 dashboards for the data sets with the Power BI tool and there should be at least 6 visualization chart and 1 slicer in each dashboard to visualize different aspect of the data analysis. The more creative dashboards' design the higher mark you get for this section.

Question: 1. What is the maximum longitude? It belongs to which state?

Question: 2. How much is the total gross margin for each state in 2013?

Question: 3. How much is the maximum discount and by which store?

Question: 4. Which city has the maximum sales price in 2014? How much?

Question: 5. The city in Question 4, which product did they sell the highest sales price in 2014?

Question: 6. For the product in Question 4, which year it has the highest original sales price?

Question: 7. Which product category has the highest fixed price in 2013? How much was it in total?

Question: 8. Which month had the lowest gross margin and in which year?

Question: 9. In the year with the lowest profit which product had the lowest profit and how much is that?

Question: 10. In the year with the highest profit which product had the highest profit and how much is that?

Question: 11. For the product with the highest average latitude, had the lowest total stock by which store manager

Attachment:- Practical Case Study.rar

Reference no: EM132998969

Questions Cloud

What improvements to the marketing strategy would recommend : The product life cycle helps to inform decisions made. What improvements to the marketing strategy would recommend for each if you were the marketing manager?

What was the average direct labor hourly rate : Direct labor rate variance = $36,000 unfavorable; Direct labor efficiency variance = $105,300 (?). What was the average direct labor hourly rate

How many units of the product were produced : The company used 20% more direct labor hours than the standard allowed for the units produced. How many units of the product were produced

What amount of gain or loss does hermione realize : What amount of gain or loss does Hermione realize on the formation of the corporation? What amount, if any, does she recognize

Fundamental of business analytics : Analyze and reflect on the alternative methodologies used in developing business information systems and Critically analyze requirements modelling and different

Prepare a cash budget for january and february : The company's cash balance on January 1, 2017, is expected to be $65,160. Prepare a cash budget for January and February in columnar form

What adjusting entry should the company make : What adjusting entry should the company make at the end of the current year to record its estimated bad debts expense

What is theresa return : Theresa purchased a call option on a call option on a stock for $250. The option allows her to purchase the stcck for $40 per share if she exercises the option

How much would you need to deposit in an account now : How much would you need to deposit in an account now in order to have $3000 in the account in 5 years? Assume account earns 8% interest compounded quarterly

User Account

All Pages