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.