Descriptive analytics to address a business need

Assignment Help Other Subject
Reference no: EM133682265 , Length: word count:1000

Introduction to Business Analytics

Assessment - Industry Report

Assessment Description

The assessment is an in-class assessment using both analytics tools and insightful interpretation to prepare a document on 4 specific questions

Part A: Using Descriptive Analytics to address a business need (300 words)

Imagine you are a car enthusiast interested in the performance of cars (horsepower) compared to their fuel efficiency, given rising fuel costs.

Your descriptive analytics study involves generating insight on how cars differ in their fuel consumption and horsepower based on the driveline differences in the vehicles

To complete this exercise, download exploratory.io
Click "+" next to data frames to upload cars data

Generate a cluster analysis using the variables of miles per gallon in the city, miles per gallon on the highway and horsepower of the vehicle, categorised by its driveline (front wheel drive, rear wheel drive, 4 wheel drive, all wheel drive)

Run and document all reports produced by the analysis, noting the number of data points in each cluster and the number of data points in the total sample

Describe the information shown in each chart or table

Explore the clusters generated using the various charts and provide insights into the results, paying particular attention to how well the cluster analysis has distributed the population in the clusters

Describe the clusters and your level of confidence in using the clusters to describe the driveline characteristics of the cars.

Part B: Using Predictive Analytics to assist with a business problem (200 words)

Imagine you are an investor who has a special interest in trading shares in oil and gas companies. In so doing, you regularly monitor the prices of stocks in this sector. To assist with your future trading activity, you are presently monitoring the historical performance of major oil and gas companies.

However, the information presented covers data that could be considered stale. Therefore, only data from 2003 and after should be used.

You have been asked to produce and document graphs that will allow you to fit trend lines, using a BI tool (Power BI, Tableau) to the oil and gas stock prices provided in the data set.

Following the production of the graph and the subsequent trend lines, you have been asked to provide an insight into which stocks have performed better over time, describing how you came to that conclusion.

Next you need to provide a recommendation on when to buy the various shares.

When is the best month to sell shares for maximising the sales price of your stock?
When is the best month to buy shares for minimising the price of the stock?

Your analysis may include all oil and gas stocks provided or a select few, with justification as to why you selected only these stocks.

Provide a reflection on whether you can rely on historical trends alone in making your investment decisions. What type of market conditions might influence your decision and are there any external factors or considerations that might influence your future judgement?

Part C: Example of Prescriptive Analytics in addressing a business problem (300 words)

Describe how prescriptive analytics can be used as part of a solution to a business problem with reference to ONE real-world business and case study of your own choosing.

You will need to conduct independent research and consult resources provided in the subject. Describe how the chosen business specifically uses prescriptive analytics and provide references.

NOTE: do not use ChatGPT for this section unless you can reference it and show your prompts. You must also verify that you did some research of your own in this section.

Part D: Storytelling (200 words)

Imagine you are a consultant tasked with an analytics exercise to report to a European Union inquiry about the status of resourcing in libraries in 4 European countries, namely:

  • Italy
  • Estonia
  • France
  • Denmark

Use the libraries data set in Tableau or Power BI to build a story as to why library usage may differ in the 4 countries.

Develop some metrics (eg. calculated fields) and illustrate these metrics either on geographic maps or within your insights commentary.

Present your story as a narrative as to what future best practice of resourcing of libraries by countries might be, supported by your visualisations. This may include other factors and assumptions that you may have used and external data you may have either included in your analysis or wish to include. State your assumptions and any additional data you may wish to incorporate into the analysis.

 

Reference no: EM133682265

Questions Cloud

How does your topic relate to a project : How does your topic relate to a project? Use a real-world example from your personal experience if you have one.
Difference between Regulatory License and Revenue License : What is Common Law and what are the Particular types of laws does it cover? What is the difference between a Regulatory License and a Revenue License?
What are the proper responses to the discovery of an error : Was there an error on Marianne's return concerning the installment sale? What are the proper responses to the discovery of an error on a tax return?
Prescriptive analytics in addressing a business problem : Prescriptive Analytics in addressing a business problem - Describe how prescriptive analytics can be used as part of a solution to a business problem
Descriptive analytics to address a business need : Descriptive Analytics to address a business need - Generate a cluster analysis using the variables of miles per gallon in the city, miles per gallon
What are thoughts of some juvenile cases being transferred : What are your thoughts of some juvenile cases being transferred or "waived" to adult courts and with adult punishments.
What future best practice of resourcing of libraries : Consultant tasked with an analytics exercise to report to a European Union inquiry about the status of resourcing in libraries in 4 European countries
Conduct independent research and consult resources : Conduct independent research and consult resources provided in the subject. Describe how the chosen business specifically uses prescriptive analytics
What is plea bargaining : What is plea bargaining? Are there positive incentives to entering into a plea bargain? What are the possible drawbacks to entering into a plea bargain?

Reviews

Write a Review

Other Subject Questions & Answers

  Evaluate the publicity campaign

Select a current or relatively recent example of a publicity campaign associated with a social issue in which you are interested or involved.

  How do you explain the high crime rate in the united states

Does capital punishment deter crime? How do you explain the high crime rate in the United States compared to nations without capital punishment?

  How do you think attrition affects validity

How do you think attrition (the dropping out of participants from your study while the study is underway) affects validity?

  During his campaign for president barack obama used the

1. during his campaign for president barack obama used the phrase post-racial america which was understood to mean that

  Create a discussion of potential solutions

Create a 700-word discussion of potential solutions and the team's decision-making process. Summarize the methods the team used to develop creative solutions.

  Explain what would be the ethical course of action

In each case, answer the questions at the end of the case and give researched references to support your assertions; also, explain what would be the ethical.

  Limited to the shortest possible entry time

The control zone in which response actions should be limited to the shortest possible entry time is the

  How lucys feedback is essential in this review process

When monitoring and evaluating Max's goals and needs in the individualised care plan, explain how Lucy's feedback is essential in this review process.

  Create outline which include the scene crime scene perimeter

Create outline which includes the scene Crime scene perimeter Protecting evidence from contamination Crime scene security Creating crime scene diagram.

  How might a code of conduct help this employee

How might a code of conduct help this employee determine whether or not it is ethical to accept the trip from the bidding company?

  What are the most common mythological themes

How is the word myth used popularly? For example, what does the statement, "It's a myth" mean?

  Prepare a financial analysis on the company

Alcoa Corporation listed in the NYSE with a stock price worth $20.61. Prepare a financial analysis on the company using public information such as the company's

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