Question
In order to conduct analysis of gathered data first you have to define types of all used variables: Children, Units Sold, Revenue, Purchase Date, Transaction,
In order to conduct analysis of gathered data first you have to define types of all used variables:
- Children, Units Sold, Revenue, Purchase Date, Transaction, Customer ID
- Calculate and present with Bar chart the percentage of Female and Male customers.
You task is to determine possible connection and relations between various factors such as
- Distribution of Male and Female customers
Present with Graph (Bar or Pie Chart)
- Connection between Gender, Marital status and Revenue
Comment and present with Graph
- Relationship between Product family and Customer profile (marital status, gender). Comment and present with Graph.
If you include Without kids as Filter what can you conclude?
- Relationship between Annual income and Units sold
Comment and present with Graph
- Relationship between Annual Income, State or Province and Revenue
Comment and present with Graph
- Relationship between Annual Income and Product Family
Comment and present with Graph
- The most popular Product family, Product department and Product category
Comment and present with Graph
- State with best Sales statistics i.e. best Revenue
Comment and present with Graph
- What is the Average number of Units Sold in different States?
Comment and present with Graph
- What is the Average Revenue in different States?
Comment and present with Graph
If you think that any other analysis could be beneficial for the company you can added it.
Management Report
As a result of your research and analysis you have to prepare an official Management Report Summary that includes the Graphs and comments related to defined points.
The document should include First page, Table of Contents along with your analysis.
Technical Requirements
For this task you have only to upload Excel sheet with your work.
You can work in several sheets (Step by step) all only in one. Please, provide comments in text box or in a cell if it is not clear enough how you calculate values or obtained some result.
Submission Guidelines
Students should pay close attention to the submission guidelines in order to receive full credit for this assignment.
Save the file as BI_A1_1_Name.xlsx and upload your work on time on Microsoft Teams.
Important Notes
- Start the assignment well in advance of the due date. Last minute problems on your end will not be an excuse for missing a deadline.
- Homework assignments will be discussed in detail during classes with teacher and among the students. All students must participate in analysis, discussion and give their contribution.
Students should e-mail teacher or use Microsoft Teams to ask any questions they have.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started