Business Analytics Assignment – Learning Outcomes – Apply quantitative reasoning skills to analyse..

/in /by

Business Analytics Assignment –

Learning Outcomes –

Apply quantitative reasoning skills to analyse business performance.

Use contemporary data analysis tools to analyse business performance.

General Description / Requirements –

The assignment requires that you analyse a data set, interpret and draw conclusions from your analysis, and then convey your conclusions in a written email. The assignment must be completed individually. The assignment, together with the appropriate cover page including unit name, name of the student, and student number, must be submitted by the due date electronically in CloudDeakin. When submitting electronically, you must check that you have submitted the work correctly by following the instructions provided in CloudDeakin. Please note that we will NOT accept any hard copies or assignments submitted via email.

The assignment uses the file A1.xlsx which can be downloaded from CloudDeakin. Analysis of the data requires the use of techniques studied from Topics 1 to 4.

Scenario –

The Peaceful Tree is an Australia's Fair Trade business. Claudia Brady started the Peaceful Tree in 2015 to empower women to support their families. Now, they have grown to four stores across Australia. The Peaceful Tree sells beautiful products handmade by artisans around the world. The Peaceful Tree has artisan partners practice fair trade principles, and every purchase from the Peaceful Tree generates income for the artisans and their families. In 2017, the Peaceful Tree introduced an online marketplace to enable customers to make their purchases online. The broad company planning and direction takes place at their head office in Melbourne. The founder, who is the current general manager (Claudia Brady) has asked you, Sam Mannix, to conduct exploratory and descriptive analysis to gain a better understanding of the Peaceful Tree's performance.

Assignment instructions –

The assignment consists of three parts:

Part 1: Data Analysis

When conducting the analysis, you will apply techniques from descriptive analytics, visualisations, and probabilities; hence you will use various tables, graphs, and summary measures. Sometimes we refer to this type of analysis as “exploratory analysis”. When exploring data, we often produce more results than we eventually use in the final report, but by investigating the data from a number of angles, we can develop a much better 'feel' for the data: a deeper understanding of the data.

In order to prepare a reply to the General Manager, you will need to examine and analyse the dataset thoroughly. The General Manager has asked a number of questions. The following guidelines for each question should be considered carefully:

1. A summary of sales: To answer this question you should calculate, then analyse the total sales by itself. You should derive summary measures and check for unusual data.

2. Sales by stores: Investigate any particular relationship between sales and stores. Remember to include the online marketspace as the fifth store.

3. Sales by weekdays: Explore any particular relationship between total sales and weekdays. You can be creative and combine some weekdays to get a more meaningful conclusion.

4. Sales by month: Research any particular relationship between sales and months. You can extract months from date.

5. Sales by number of visitors: To answer this question you should calculate the total number of visitors for each day. Then, you can analyse any potential relationship between sales and number of visitors.

6. Probability: To answer this question, you need to do the calculations for each store separately using the relevant Excel functions.

The analysis section you submit should be no more than 8 pages of computer output (i.e., output that you have copied into a Word document from Microsoft Excel). When you conduct your analysis, you will produce much more than this initially, but you should trim it down to only show the most relevant results in your maximum of 8 pages (of analysis). Where possible, it is always useful to produce both numerical and graphical statistical summaries as sometimes, something is revealed in one that is not obvious in the other. Within the Word document, your analysis should be presented in the same numbered sequence (and contain that same numbered sequence) that the questions have been asked by Claudia Brady (the General Manager). Your analysis should be clearly labelled and grouped around each question. Poorly presented, unorganised analysis or excessive output (more than 8 pages) will be penalised.

It is usual, when writing any professional document, to caption any tabular or graphical output professionally. For example, TABLE 1: Summary statistics for the measure Gross Profit.

Part 2: Email

You are required to reply by email, detailing essential information and conclusions from your data analysis. You are allowed no more than 2 pages to convey your written conclusions. Your 2 page email will be included as a front section to your 8 pages analysis. A document 10 pages in length.

Keep the English simple and the explanations succinct. Avoid the use of technical statistical jargon. Your reader will not necessarily understand even simple statistical terms, thus your task is to convert your analysis into plain, simple, easy to understand language.

Part 3: Interactive Dashboard

The minimum requirement is a neat, functional, interactive dashboard. It is expected that the dashboard includes up to 4 interactive components.

Following question will guide you designing an interactive dashboard.

1. What are the most appropriate visualisations for the dashboard?

2. What about choices of colour?

3. How can I use hierarchy and dimension?

4. How can I make the dashboard interactive?

It’s an “Object Modelling” Assignment. There is an attached PDF for this assignment topic for case..

/in /by

It's an “Object Modelling” Assignment.

There is an attached PDF for this assignment topic for case studies. The task must have this PDF Topic “Barchester city counsel Car Park System”.

Task:

Investigate the effectiveness of business information systems of the given case study. To do this, you are required to submit a complete report which includes an analysis of functionality, resources required, the broad feasibility of the project (i.e., risks) and proposed outcome based on the analysis of the case study.

Choose one of the case studies from the following two case studies and use this case study to complete assessment item 1, assessment item 2, and assessment item 3.

The Assessment Item 1 must be submitted in order to proceed Assessment Item 2 and 3.

The Assignment format should be:

1. Title page
2.Table of contents
3. Introduction
4.Business case/ Problem
5. Functionality
5.1 Functional
5.2 Non-functional
6. Resources
6.1 Hardware
6.2 Software
7.Risks
7.1 Strategy
7.2 Possible Risks
8. Outcome
8.1 Objectives
8.2 Benifits
9. References.

Assignment Task Assume, you are planning to start up a business of your choice. Please prepare a 5..

/in /by

Assignment Task
Assume, you are planning to start up a business of your choice. Please prepare a 5 year business plan with following headings

Executive Summary

Business Environment

Vision, Mission and goals
Products and services
Business, organisation and finance structures
Strength, Weaknesses, Opportunities and Threat (SWOT)analysis
Premises, plant and equipment
Information systems and telecommunications
Intellectual property, licences and memberships Insurances

Goals, milestones, strategies

Goals and milestones
Marketing
Sales
Customer management and retention
Pricing
Suitable business strategy

Business competition

The industry
Target market
Market competition
Influence of Five forces

Financial forecasts
Set-up costs
Profit and loss forecast
Cash flow forecast
Balance sheet forecast
Break-even analysis

You should aim to include a minimum of 6 references (more is better), of which some should be peer-reviewed academic journals. However, this is a short assignment, with a real-world focus, so extensive referencing is not required.

The following guidelines are to assist you with presentation and layout:
– Cover page should include name, student number, unit number, unit name, assessment number, assessment name, and date
– Use Arial, Calibri, or Tahoma, 12 pt font
– Double spacing
– Double justification of text
– Headers and footers on all pages other than the cover page – headers and footers should contain your name and student number, the unit number and name, and a page number

There are new and exciting developments that are taking place in the Business Intelligence…

/in /by

There are new and exciting developments that are taking place in the Business Intelligence literature that is constantly shaping the use and implementation of Business Intelligence and Data warehousing tools and applications in organizations. The primary objective of this research project is to provide a forum for students to investigate the practice, approaches and understanding of business intelligence as it is being applied in the real world to realize organizational objectives. Some of the potential research questions include:

1. How can data analytics provide business value to organisations?

2. How do cultural and organisational issues impact the data analytics?

3. What is the impact of data analytics in novel and interesting domains such sports, healthcare and cybersecurity? (Students are expected to choose only one domain)

Students are expected to choose one of the 3 research questions. There are two deliverables to this project.

1. First is the Proposal of the chosen research question. You are expected to deliver a shoer 5-minute presentation in class for feedback and approval by lecturer/tutor in week 7 during the lab time.

2. Final deliverable consists of a group presentation in week 10 and a brief report in week 11. Presentation of your findings in this project would be of about 20-minute duration.

LAW OF BUSINESS ORGANISATIONS ASSIGNMENT- QUESTION 1- Describe how a partner may be liable to…

/in /by

LAW OF BUSINESS ORGANISATIONS ASSIGNMENT-

QUESTION 1-

Describe how a partner may be liable to creditors of the partnership based on the acts of other partners.  Explain how that liability could be established despite the lack of any real or actual authority in the particular partner dealing with the outsider. Further, suggest any means by which a partner could try to limit any such potential liability you have discussed above.

QUESTION 2-

Marlin Fishing Pty Ltd carries on the business of commercial fishing. The company is run by 4 directors; Michael and his three (3) sons Dan, Terence and Pat. They are also the only shareholders and hold equal interests.

The company has a constitution that requires that all contracts to be entered into on behalf of the company must in the first instance be approved by a meeting of the directors and that the company seal should be affixed. The constitution expressed that when the company seal was affixed it needed to be accompanied by the signatures of two (2) directors.

Michael discovers a new boat for sale which would considerably improve the ability of the fishermen to stay at sea longer and better keep the catch of fish. He decides to purchase the boat on behalf of the company believing that his sons would agree with the decision. He dealt with a friend of his who ran Commercial Vessels Pty Ltd. His friend knew what Michael did and assumed he ran the family commercial fishing business, so he was very happy to deal with him. Michael simply signed the contract: 'Michael, for and on behalf of, Marlin Fishing Pty Ltd'.

When Dan, Terence and Pat learned of the purchase of the new boat they refuse to ratify the contract and do not wish to spend the company funds on such a vessel at this time. Advise the sons whether the company will be bound by the contract and also identify any possible consequences for Michael.

2000 words, need it as per the guidelines, both question require to introduction, Body and conclusion each question 1000 words.

Statistics for Business Assessment Task – Purposes: This assignment develops students’ ability to…

/in /by

Statistics for Business Assessment Task –

Purposes: This assignment develops students' ability to interpret interpretation and analyseis of statistics in the media as well as the writtwritingen and oral presentation skills.

The Group Assignment comprised of two parts:

Part A – Written Assignment and

Part B – Oral Presentation

This assignment will require selection of an industry of interest or topic of interest based on statistical data available from Australian Bureau of Statistics (ABS) for statistical analysis.

In planning to carry out a test of hypothesis based on J designed experiment or research study under investigation, you have to state the goal o' the experiment or research (for example, such as what are the effects of consumer price index on food retailing?) and design a null and alternative hypotheseis. The assignment requires explanation o' proper methodology and address ofes all relevant questions under investigation.

These are key parts of the assignment –

Introduction

Hypotheses

Testing of Hypotheses

Interpretation

Conclusion

References

Value of Information Assessment – IT Portfolio Theory Learning Outcomes Critically analyse how…

/in /by

Value of Information Assessment – IT Portfolio Theory

Learning Outcomes

Critically analyse how information and IT can generate business value and improve the firm's overall competitiveness.

Discipline-specific knowledge and capabilities: appropriate to the level of study related to a discipline or profession.

Critical Thinking: evaluating information using critical and analytical thinking and judgement.

Purpose – This is an individual assignment, which requires you to develop an understanding of how information and IT can generate business value and improve a business's overall competitiveness, and then produce a 1500-word report on your findings.

Instructions – First read the case titled: Predicting consumer tastes with big data at Gap.

Develop responses to the following questions:

Task 1:

1a. Identify various IT assets and their business value returns mentioned in the case study using the IT Portfolio theory.

1b. To what extent does this organisation have an IT portfolio which provides a balanced view of value, risk and return?

Task 2:

2a. Based on the Resource based view of the firm (RBV), develop a list of resources and capabilities that the organisation has access to.

2b. How do you think that resources and capabilities add value and rarity for Gap?

Attachment:- Assignment Files.rar

Assignment 1. Aims: To analyse a set of data (in Microsoft Excel), and write a brief report (in…

/in /by

Assignment

1. Aims:

To analyse a set of data (in Microsoft Excel), and write a brief  report (in Microsoft Word), identifying and explaining your insights  into the operation of Todd Restaurants.

2. Learning Objectives:

In the process of this assessment task you will:

Plan, schedule and execute project tasks with a view to improve your personal productivity;

Gain awareness of some typical issues related to the operation of a small-to-medium size business;

Use the functionality of Microsoft Excel to manipulate data, analyse it and visualise it in tabular and chart form; and

Use the functionality of Microsoft Word to write a brief report of your business observations and recommendations.

3. Case Background:

Feastive Restaurants offer a national chain of full-service,  casual-themed restaurants across Australia. You have been offered the  job of vice president of operations for Feastive Restaurants. During  your first week on the job, David Feast, your boss and CEO of the  company, has asked you to provide an analysis of how well the company's  restaurants are performing. Specifically, he would like to know which  units and regions are performing extremely well, which are performing  moderately well, and which are underperforming.

4. Assignment Instructions:

The CEO asks you to identify where to spend time and focus efforts to improve the overall health of the company.

1. Review and use the data that Mr Feast has provided you from the  Festive restaurants data warehouse in the  itech1005_2017-27_assign_Data.xlsx file. Rename the spreadsheet as:  Lastname_StudentID.xlsx.

2. Use the Information worksheet for your calculations and analysis to provide results for each of the following tasks:

Use 'Restaurant Size (by Sales)' column in 'Information' worksheet  to categorise each restaurant size as 'Small', 'Medium', 'Large' or  'Huge' according to their 'Annual Sales' by using the following table.  (You need to use VLOOKUP function for this; and the table needs to be  stored in the 'Information' worksheet:)

Annual   Sales Levels

Size   Label

$0

Small

$1,000,000

Medium

$2,000,000

Large

$3,000,000

Huge

Calculate the number of years each restaurant is operating in the  'Restaurant Age (years)' column. Hint: you need to use a formula that  calculates (the current date – 'Restaurant Opening Date')/365.25.

Calculate the 'Taxes payable on annual sales' by each restaurant  for annual sales using the following information. All restaurants pay a  base tax rate of 15% based upon sales and in addition some regions  require additional taxes, as the table underneath indicates, and in one  case the additional rate depends on the value of sales. Hint: a similar  method might be used as for restaurant size but VLOOKUP only works on  ordered/sorted lists while other formulae will work for unsorted lists -  requires some research

For example a small restaurant in Victoria with $1000 sales must pay $200 total taxes.

Region

Regional Business Tax Rate

Victoria Small   – Medium 5%

Large   – Huge 7.5%

NSW

7%

Queensland

5%

SA

6%

WA

0

NT

6%

TAS

5%

ACT

7.5%

Calculate 'Cost of Sales ($)' on 'Information' worksheet. Use  'Advertising (% sales)' column in 'Information' worksheet to calculate  actual advertising costs for each restaurant with all additional costs  of sales calculated using the following table. The percentages applied  for costs of sales (aside from advertising costs, which each restaurant  decides for itself) are independent of region:

Area

Total   Cost of Sales (not including advertising) as Percentage of Sales

City

60%

Metro

52%

Country

56%

For example, a city restaurant with $1000 sales has $600 cost of sales in addition to any advertising costs.

Calculate 'Profit ($)' for each restaurant on the 'Information'  worksheet. Profit is a basic calculation of: sales – cost of sales -  advertising costs – taxes.

Calculate 'Sales per Seat ($)', 'Sales per square metre ($)',  'Profit per Seat ($)', and 'Profit per square metre ($)' in relevant  columns on the 'Information' worksheet.

Calculate the Sum (i.e.Total), Mean, Median, Maximum, Minimum,  Range and Standard Deviation for all relevant columns, at the bottom of  the dataset on the 'Information' worksheet.

3. Using the 'Information' worksheet, Mr Feast needs to have summary  tables for each of (i) region, (ii) area and (iii) restaurant size. The  summaries should include the following:

a. Total Annual Sales

b. Total number of Seats

c. Average Annual Sales

d. Average Store Age (years)

e. Total number of Restaurants

f. Total number of advertising Restaurants

Use the table in the 'Summary Report' worksheet for your  calculations. For this report you should not use any Pivot Table  analyses.  Instead you need to use functions such as SUMIF, AVERAGEIF,  COUNTIFS, etc…

The report table needs to be sorted by ' Total Annual Sales' column in descending order.

All the cells in the summary tables need to be formatted appropriately.

4. Using the Information worksheet, Mr Feast also needs to have some analyses report for the following specific questions:

a. Which region has the highest 'Annual Sales' for 'Large' size restaurants?

b. Which region has the lowest 'Annual Sales' for 'Large' size restaurants?

c. Which region has the best 'Average Profit' for 'Small' size restaurants?

d. Which region has the worst 'Average Profit' for 'Small' size restaurants?

e. Which area has the lowest 'Profit per square metre' for 'Medium' size restaurants?

f. Which area has the highest 'Profit per square metre' for 'Medium' size restaurants?

g. What is the total number of seats for 'Medium' size restaurants in the region with highest total 'Annual Sales'?

h. What is the average floorspace for 'Huge' size restaurants in the region with highest 'Annual Sales'?

i. What is the restaurant with the best 'Annual Sales' at the worst region?

j. What is the restaurant with the worst 'Annual Sales' in the best region?

k. What is the restaurant with the lowest 'Age' in the highest 'Annual Sales' area?

l. What is the restaurant with the highest 'Age' in the lowest 'Annual Sales' area?

m. What is the most profitable restaurant with no advertising expenditure?

n. What is the least profitable restaurant with no advertising expenditure?

You should use Pivot Tables for these analyses – include these on  the 'Pivot Tables' worksheet. Provide your answers on the 'Specific  Questions Summary' worksheet using cell referencing to the results from  your pivot tables.

Note: Create as many pivot tables as needed to show your results but  be sure to use filtering and/or sorting where needed to get exact  results.

Important: Be sure to follow the instructions for the pivots tables at the top of the 'Pivot tables' worksheet.

For each of the paired questions a-b, c-d, e-f, provide a chart  with clear indication of the best/worst results. You can show both best  and worst in a same chart – include these three charts (i.e. graphs) on  the 'Charts' worksheet.

Note: Create as many additional charts as needed to demonstrate your  results for the specific questions and the report (see below).

Important: be sure to follow the instructions for charts at the top of the 'Charts' worksheet.

5. Prepare a Report in Microsoft Word that includes:

An introduction

The results from the Excel worksheets. You need to follow the exact  question sequence and copy and paste the necessary analyses (pivot  tables, summary tables and graphs) from the Excel file into the report.

Discussion of your observations and your recommendations for Festive Restaurants. In your report include discussion of:

i. restaurants, areas and regions which are performing extremely well  and/or poorly (if any) and what might be done to improve; and

ii. whether Festive Restaurants should spend more or less on advertising (e.g. in certain areas or regions)?

iii. the types of data quality issues the company might be  experiencing from analysis of the provided dataset and how they might be  overcome.

Note: you are looking for distinctive features or patterns in the  data you have created in order to report meaningfully to Mr Feast. For  example, you might consider how restaurants of like-size are performing  relative to each other.

Business Intelligence and Data Warehousing Individual Assignment Purpose: To encourage and provide..

/in /by

Business Intelligence and Data Warehousing Individual Assignment

Purpose: To encourage and provide students on-hands experiences of using SAPAnalytics tools to explore, extract and analyse enterprise data.

This is a business analytics project aimed at generating innovative analytics solutions. It will allow students to show innovation and creativity in applying SAP Business Object/Predictive Analytics and designing useful visualization solutions and predictive models for different types of analytics problems.

The topic will be on environmental issues. Your main task is to apply any of the analytical tools to develop innovative analytics visualization solutions and predictive models with regards to environment, e.g. climate change, energy consumption, carbon footprint, greenhouse gas emission, pollution dashboard, etc. Besides the suggested datasets/sources, you may apply any other real-world dataset to illustrate your approach (the different datasets can be combined too). Please find the attached sample reports.

You will also submit a 9-10 pages report (about 3000 words not counting cover page and references) of this project. At least 15 references in your report must be from peerreviewed sources. Include any and all sources of information including any person(s) you interviewed for this project.

Tasks –

What are the BI reporting solution/dashboards you will need to develop for the Senior Executives of chosen data Set- You must have at least two types of analytics i.e Predictive/prescriptive/ descriptive.

Design Mobile application using QSR code for your insights /solutions/dashboard – Please provide your QSR code in your assignment.

Justify why these BI reporting solution/dashboards are chosen and why those attributes are present and laid out in the fashion you proposed (feel free to include all other relevant justifications using the academic articles). Note: To ensure that you discuss this task properly, you must include visual samples of the reports you produce (i.e. the screenshots of the BI report/dashboard must be presented and explained in the written report; use 'Snipping tool'), and also include any assumptions that you may have made about the analysis in yourassignment report (i.e. the report to the senior executive team of the company).

Furthermore, the CEO would like to improve the operations. Based on your BI analysis and the insights gained from “Data Set”, make some logical recommendations to the CEO, and justify why/how your proposal could enhance company operations, sales etc. Include the relevant screenshots of the BI analysis, and also any assumptions that you may have made about the analysis.

Report is well-written and presented professionally, containing:

Title page

Executive Summary (outlining the scope of report, key findings and recommendations)

Table of Contents

Appropriate use of headings within report

Appropriate use of figures (i.e. graphs, summary tables) and

References (APA Style)- in text and bibliography (10 articles)

Assignment Files –

https://www.dropbox.com/s/vzxjcce2297tzn2/Data%20Warehousing%20Individual%20Assignment.rar?dl=0

Business Information Systems Assignment – In this assignment, a scenario is presented in the form of

/in /by

Business Information Systems Assignment –

In this assignment, a scenario is presented in the form of a description of a security company. Based on your understanding on the scenario, you are asked to write a report answering the questions at the end of this assignment. Your report should be approximately 1800-2000 words.

Case Study: Security Services Limited (SSL)

Questions – Considering the description of SSL, write a report by answering the following questions.

1. Analyse how SSL may identify the value that it obtains from its current portfolio of information systems and evaluate the techniques that may be used in assessing future IS investments.

2. In many parts of the company, it is clear that SSL do not have a coherent IS strategy. Analyse how it may construct an IS strategy that is supportive of its business strategy and the benefits that it would derive from this.

3. Analyse the strategic potential for greater investment in information systems and technology at SSL both from a divisional and company-wide perspective. Could business process re-engineering be a useful tool in maximising the potential of IS and IT within the company? Explain and justify your answers.

4. Describe the current location of IS functions within SSL. Recommend the best location for IT services in the future.

Attachment:- Assignment File – Case Study.rar