An e-commerce company recorded sales data over the last 24 months. The data shows an increase in sales during the first quarter, followed by a significant decline in the middle of the year due to changes in market trends.

As a business analyst:

1. Analyze the sales patterns using descriptive statistical methods.

2. Calculate the mean, median, and standard deviation of the sales data.

3. Identify the factors that caused the decline in sales.

4. Provide business strategy recommendations based on the available data.

5. Explain whether the company is experiencing sustainable growth or not.

This question is about computer programming system.

Overview

This assessment task requires you to submit your answers to the questions provided in a word document. You need to transfer the results from the excel file into the word document.

In addition, please submit your detail Excel file with a tab explaining everything you did (state the formula, what this for,…). This is to cross-check the process.

If you think there is any issue or unclarity in any question, please make your assumptions (if there is any) and clearly explain them in your report.

Report Length: less than 2500 words

Please review the attachment detail assignment guide before start doing the assignment!

Assessment Details

Please download the questions 1, 2, 3 data for questions 1, 2 and 3.

The dataset is adopted from:

Question 1 (20 marks)

The provided dataset contains real-world data quality issues that must be addressed before any analysis can be performed.

Create a table with four columns: Variable, Missing Values, Outliers, and Errors. In the Variable column, list the names of all columns in the dataset. For each variable, record the corresponding count of missing values, outliers, and errors found.

Note that errors may include invalid entries such as impossible numeric values (e.g. a negative price or zero number of doors), nonsensical codes, or data type mismatches.

Once the audit table is complete, clean the dataset by addressing all identified issues. Report the total number of rows remaining after cleaning and briefly explain the strategy you applied for each type of issue (removal, imputation, correction, etc.).

Variable	Missing Values	Outliers	Errors
Variable 1
Variable 2

Question 2 (20 marks)

Develop six visualisations that best illustrate which variables have the strongest relationship with Price.

Only figures are accepted tables will receive no marks

To identify the strongest relationships, you are advised to generate a larger pool of visuals (around 2030) and select the six most effective. Only include the final six visualisations in your report.

Include a variety of visualisation types

Ensure your six selected visuals cover both categorical and numerical variables.

Question 3 (30 marks)

Develop a regression model predicting Price as the outcome variable.

Refine the model using different strategies (e.g. including/excluding variables) to improve accuracy

Present the final regression equation

Interpret the equation explain how specific variables influence Price

Assess the model’s accuracy, including limitations and potential areas for improvement

Note: the accuracy of real world data may be low.

Note: Excel’s regression tool has a limit on the number of variables (16 variables) it can handle simultaneously. You are therefore expected to select only the most relevant predictors before building your model.

Question 4 (10 marks)

The following screenshot (please find in the second tab of data file or attachment name question 4 screenshot) is taken from the logistics regression output from the data set attached question 4 data. The response variable that is called card is a binary variable which is considered as success (yes or 1) if the application of the customer for a credit card is accepted.

Write the logistics regression equation based on the output? Interpret the results.

Calculate the probability of class 1 for the output variable considering cut-off values of 30% and 70%.

Calculate overall error, sensitivity, and specificity for both cut-off values. Explain the steps of calculations.

Explain which cut-off value is a better measure in this business context.

Question 5 (20 marks)

A logistics company, SwiftMove, is planning a promotional campaign by placing advertisements across three online freight and logistics directories. The marketing manager has labelled these platforms as X, Y, and Z.

Estimated reach, cost per advertisement, and maximum allowed placements for each platform are provided in the table below.

Limitations	Platform X	Platform Y	Platform Z
Estimated audience reach per advertisement	110,000	42,000	75,000
Cost per advertisement for the first 5 advertisements	2,800	600	950
Cost per advertisement for more than 5 advertisements	2,400	600	950
Maximum acceptable number of advertisements	18	25	30

To maintain a balanced campaign:

Platform Y advertisements must not exceed 65% of the total number of advertisements placed

Platform X must account for at least 25% of the total advertisements placed

The total advertising budget is capped at $54,000

Platform X offers a tiered discount based on order volume; Platforms Y and Z have fixed rates. (For example, if 8 advertisements are ordered on Platform X and the first 5 are priced at $2,800 and the remaining at $2,400, the total cost would be 5$2,800 + 3$2,400 = $21,200.)

Part a) How many advertisements should be placed on each platform to maximise total audience reach? Clearly define the decision variables, objective function, and constraints. Build the model in Excel and save the worksheet (named Question 5 Part a) in your submission file.

Part b) Rewrite the model to determine: at what price per advertisement must

Platform X charge so that exactly 9 advertisements are allocated to Platform X, assuming the company still aims to maximise total audience reach? Assume the rates for Platforms Y and Z remain unchanged.

Rubric:

	Criteria	Ratings	Pts
	Q1	Excellent detection and management of errors, missing values and outliers.	20 pts
	Q2	Choice of visualisation technique is appropriate. Details of visual (axis title, data to ink ratio) are presented properly. Interpretations are appropriate. Reasonable arguments are presented.	20 pts
	Q 3	Correct presentation of – regression table – regression equation – interpretations	30 pts
	Q 4	Correct presentation of – confusion matrix and accuracy measures – interpretations	10 pts
	Q 5	The optimisation model is correct. The model is solved correctly. Excellent interpretations are presented.	20 pts

APPENDIX 4.1 Getting Started with Tableau

What Is Tableau?

Tableau is a stand-alone data visualization software that has gained tremendous popularity for its attractive output, versatility, and ease of use. Tableau is designed to allow users with little technical experience to develop attractive visualizations interactively and to drill down the data for business insights. Users can easily switch between different visualizations to select the most compelling graphs for their storytelling. In addition, Tableau allows users to create interactive dashboards, which can display real-time data, to support business decision making.

Note on Accessing Tableau for Your Assignment

For this assignment, you can use Tableau Public, a free and user-friendly platform to create and share interactive data visualizations.

What is Tableau Public? Tableau Public is a free platform that allows you to explore, design, and publicly share your data visualizations (also known as vizzes). You can create vizzes directly through the web authoring tool or by downloading the Tableau Desktop Public Edition at no cost.

If you already have Tableau Desktop Professional Edition, you can still publish your work to Tableau Public for free.

Why use Tableau Public?

• Its free and accessible
• It provides millions of public visualizations to explore and learn from
• It helps you build your data skills
• You can create an online portfolio of your work
• Youll be part of a global data community that shares, collaborates, and grows together
• To get started, visit:

Accessing an Excel File in Tableau

When you open Tableau for the first time, you should see a screen that is similar to Figure below. This is Tableaus Start Page, and it consists of three panes: the Connect pane, the Open pane, and the Discover pane. We can access different data file types using the Connect pane. We can use sample data sets provided by Tableau through the Open pane. And finally, we can learn about ways to use Tableau through the Discover pane.

We use the Transactions data file to illustrate how to import an Excel file into Tableau. From the menu, select File > Open, navigate to the Transactions data file, and then click Open. This step opens Tableaus Data Source screen and is shown in Figure below. The lower half of the screen shows a preview of the Transactions data file. In order to save the data file as a Tableau Workbook with an extension .twb, go to the menu and select File > Save.

Creating a Bar Chart in Tableau

• Open the Transactions data file.
• Click on the Sheet 1 tab on the lower left side of the Data Source screen to open the authoring workspace. In the Data tab, you should see all the variables in the Transactions data file. Tableau automatically generates summary variables such as the total number of observations [Sheet1(Count)].
• Drag the Repeat variable from the Data tab to the Columns shelf and the Sheet1(Count) variable to the Rows shelf. [For a horizontal bar chart, put the Repeat variable in the Rows shelf and the Sheet1(Count) variable in the Columns shelf.]
• Tableau offers a number of ways to format the bar chart. For example, to show the frequencies for each category, go to the menu at the top and select Analysis > Show mark labels. To edit the title on the y-axis, right-click on the y-axis and choose Edit Axis. Under Axis Titles, change Count of Sheet 1 to Frequency, and then close the dialog box.

Creating a Histogram in Tableau

• Open the Transactions data file.
• Click on the Sheet 1 tab on the lower left side of the Data Source screen.
• Drag the Income variable from the Data tab to the Rows shelf.
• On the top right side, select the Show Me tab and then select the Histogram icon. Tableau shows the default histogram.
• From the Data tab, right-click on Income (bin) and select Edit. . . . After Size of bins enter 50. Click OK.
• To edit the title on the y-axis, right-click on the y-axis and choose Edit Axis. Under Axis Titles, change Count of Income to Frequency, and then close the dialog box. To edit the title on the x-axis, right-click on the x-axis and choose Edit Axis. Under Axis Titles, change Income(bin) to Income (in $1,000s), and then close the dialog box.

Creating a Scatterplot in Tableau

• Open the Transactions data file.
• Click on the Sheet 1 tab on the lower left side of the Data Source screen.
• Drag the Income variable to the Columns shelf (for placement on the x-axis) and drag the Purchase variable to the Rows shelf (for placement on the y-axis). Note that after this step, Tableau displays only a single circle in the scatterplot. This is because Tableau is plotting the sum of the values of Purchase against the sum of the values of Income. In the next step, we will force Tableau to plot the values of Purchase and Income for each customer.
• Go to the Data tab, click on Customer, and select Convert to Dimension. This sets the level of detail to customers. Then drag Customer to the Detail box in the Marks card.

Creating a Bubble Plot in Tableau

• Open the Birth_Life data file.
• Click on the Sheet 1 tab on the lower left of the Data Source screen.
• Drag the Life_Exp variable to the Columns shelf (for placement on the x-axis) and drag the Birth_Rate variable to the Rows shelf (for placement on the y-axis).
• Drag Country_Name to the Detail button in the Marks card to set the level of detail to countries.
• Drag the GNI variable to the Size button in the Marks card to size the bubbles based on each countrys GNI.
• For increased clarity, from the Marks card, we select the Shape button to fill each circle and the Size button to increase the size of each bubble.
• Drag SUM(Merck) from the Rows shelf to the Apple vertical axis area, as shown by the red arrow in Figure 4A.9. You should now see Apple and Merck on the same axis.
• To edit the title on the x-axis, right-click on the x-axis and choose Edit Axis. Under Axis Titles, change Day of Date to Date, and then close the dialog box. Similarly, to edit the title on the y-axis, right-click on the y-axis and choose Edit Axis. Under Axis Titles, change Value to Stock Price (in $), and then close the dialog box.

Creating a Heat Map in Tableau

• Open the Bookstores data file.
• Click on the Sheet 1 tab on the lower left side of the Data Source screen.
• Drag the BookType variable to the Columns shelf and drag the BookStore variable to the Rows shelf.
• Drag the Bookstores (Count) variable to the Color button on the Marks card. Then drag the Bookstores (Count) variable to the Label button on the Marks card.
• On the top right side, select the Show Me tab and then select the Highlight Tables icon.
• Select the Color button on the Marks card and select Edit Colors. . . . Set Pallete from Automatic to Red-Green Diverging. Click OK.

Creating a Stacked Column Chart in Tableau

• Open the Promotion data file.
• Click on the Sheet 1 tab on the lower left side of the Data Source screen.
• In order to create a stacked column chart, drag the Location variable to the Columns shelf and the Sheet1 (Count) variable to the Rows shelf.
• Drag the Purchase variable to the Color button in the Marks pane. This step changes the color of each column based on the Purchase categories (yes or no).
• From the menu at the top, select Analysis > Show Mark Labels; this will add frequencies to the stacked column chart.
• To edit the title on the y-axis, right-click on the y-axis and choose Edit Axis. Under Axis Titles, change Count of Promotion to Frequency, and then close the dialog box.

Creating a Line Chart in Tableau

• Open the Apple_Merck data file.
• Click on the Sheet 1 tab on the lower left of the Data Source screen.
• Drag the Date variable to the Columns shelf (for placement on the x-axis). Then click on the YEAR(Date) in the Columns shelf and select Day (select the Day option with a complete date, i.e., May 8, 2015). You should now see DAY(Date) in the Columns shelf. Drag the Apple variable and the Merck variable to the Rows shelf (for placement on the y-axis).
• From the Marks card, select the drop-down menu and change the chart type from Automatic to Line. You will see separate line charts for Apple and Mercksee Figure 4A.9. We will combine the two line charts in the next step.

Requirements:

For this assignment, your task is to create and submit a video demonstrating your understanding of Tableau. The video should provide a step-by-step guide on how to get started with Tableau, import data, and the various types of visualizations or graphs presented in the assignments. The purpose of the video is to help students understand the fundamental features and functionalities of Tableau and how to use them effectively for data analysis and visualization tasks.

1) 800 to 1000 word paper summarizing van Wijk’s paper “The Value of Visualization” (5% of final grade).

25% penalty for shorter than 800 words. 50% penalty for longer than 1,000 words.

2) 5 pages paper on your visualization project (20% of final grade).
25% penalty for shorter than 5 pages. 50% penalty for longer than 5 pages.

Attached are the nessesary files.

Each student will submit an individual report (word limit 2,000 words). This report will consist of the following sections laid out as follows:

1.Provide the introduction of the project on which you worked as a team member. Discuss its planning, execution, and evaluation phase. Critically analyse the tools and techniques used in project management. (600 words, 30%)

2.Identify the stakeholders of the project and evaluate the potential causes of conflicts amongst stakeholders for your chosen project. Assess the risk associated with the project during various project life cycle stages and the risk mitigation strategies (1000 words, 50%)

3.Reflect on your role as a member of project analyst team. Critically analyse the project team dynamics amongst the team members and role of the team leadership in creating effective project teams to achieve objectives by applying SCRUM Agile Leadership. (400 words, 20%).

More instructions in the assignments brief. APA style of referencing.I need more than 20 references and in text citations which not older than 5 years.

Consider checking the Grading criteria for the Assessment

below are the original files,

we need to add two more visualizations (They are already added but dont appear on the published link, we neeed to recreate them and publish and share link)-recreating visualization 5 and 6

this are the two items am fixing, right

1. dot map on the united states. and a heat map

2. fix the variables in the text to show the tuition %

If you look at the word document , tthey are thare already make similar visualizations, publist and replace the link and send back

i have done all visualizations, need someone to publish it and share the link using tablue public so i can share to others through link

i have done all visualizations, need someone to publish it and share the link using tablue public so i can share to others through link

i have done all visualizations, need someone to publish it and share the link using tablue public so i can share to others through link