Student Name Yeligala Sanketh
Student Registration Number 242P3R2018 Class & Section: MBA & A-sec
Study Level : UG/PG PG Year & Term: 1yr & term1
Subject Name Business Analytics
Name of the Assessment LAB REPORT 1
Date of Submission 23/01/2025
Business analytics
Module-1 introduction to
Business analytics
• The given data is shown below.
Quantity Customer
Date Product Category Region Sales(Rs)
Sold Type
1/5/2023 Mobile Electronics North 12000 1 New
1/6/2023 AC Electronics South 35000 1 Repeat
1/7/2023 Sweaters Apparel East 2500 4 New
25/8/2023 Shirt Apparel North 2000 3 Repeat
25/10/2023 Watch Electronics South 6000 1 New
Watch Electronics West 7000 1 New
20/01/2024
Lab-1 Exercise-1
a) Data Categorization
Categorize the data by different dimensions as region
Procedure: Select Data < Data < Apply filter < Click on downward arrow.
Sales Quantity Customer
Date Product Category Region
(Rs) Sold Type
06-01-2023 AC Electronics South 35000 1 Repeat
Watch Electronics South 6000 1 New
25/10/2023
Sales Quantity Customer
Date Product Category Region
(Rs) Sold Type
05-01-2023 Mobile Electronics North 12000 1 New
Shirt Apparel North 2000 3 Repeat
25/8/2023
Sales Quantity Customer
Date Product Category Region
(Rs) Sold Type
Sweate
07-01-2023 Apparel East 2500 4 New
rs
Sales Quantity Customer
Date Product Category Region
(Rs) Sold Type
Watch Electronics West 7000 1 New
20/01/2024
Categorize data by different dimensions as product category
Sales Quantity Customer
Date Product Category Region
(Rs) Sold Type
05-01-2023 Mobile Electronics North 12000 1 New
06-01-2023 AC Electronics South 35000 1 Repeat
Watch Electronics South 6000 1 New
25/10/2023
Watch Electronics West 7000 1 New
20/01/2024
Sales Quantity Customer
Date Product Category Region
(Rs) Sold Type
07-01-2023 Sweaters Apparel East 2500 4 New
Shirt Apparel North 2000 3 Repeat
25/8/2023
Categorize data by different dimensions as Customer type
Sales Quantity Customer
Date Product Category Region
(Rs) Sold Type
05-01-2023 Mobile Electronics North 12000 1 New
07-01-2023 Sweaters Apparel East 2500 4 New
Watch Electronics South 6000 1 New
25/10/2023
Watch Electronics West 7000 1 New
20/01/2024
Sales Quantity Customer
Date Product Category Region
(Rs) Sold Type
06-01-2023 AC Electronics South 35000 1 Repeat
Shirt Apparel North 2000 3 Repeat
25/8/2023
b) Data Summarization
Calculating average sales and total quantity sold by region and product
Procedure:
1. Apply filter on region/product.
2. We can calculate Avg sales by using a formula
3. Select sales and
4. Enter <= average
To calculate total sales
Enter <=sum(
Region Average Sales Total quantity Sold
West 7000 1
East 2500 4
North 7000 4
South 20500 2
Product Average Sales Total Qty Sold
Mobile 12000 1
AC 35000 1
Shirt 2000 3
Sweaters 2500 4
Watch 6500 2
c) Data Analysis Models
Calculate sales Totals and sales by Customer Type to identify patterns
(New vs returning customers)
Procedure:
1. Apply filter on customer types.
2. Calculate Total sales by using formula
<sum= (
New Repeat
New 27500
Repeat 37000
Total Sales 64500
d) Visualization
Bar chart: sales by region
Procedure:
1. Calculate average sales using formula=average (
2. Select average sales by region < insert < graph
Average
Region Sales
West 7000 Average Sales
East 2500
South
North 7000
North
South 20500
East
West
0 10000 20000 30000
Pie chart: Sales distribution by product category
Procedure:
1. Calculate Average sales of product category by using Formula =Average (
2. Select Average Sales < insert < Graph.
Sales Distrubition
Product Sales
Category Distribution
Apparel 2250
Electronics 15000
Apparel Electronics
Line Chart: Daily Sales over Time to identify the trends.
Procedure:
1. Make a table with data of data and sales
2. Select data < insert < graph
Sales (Rs)
Date Sales (Rs) 40000
30000
05-01-2023 12000 20000
06-01-2023 35000 10000
07-01-2023 2500 0
25/8/2023 2000
25/10/2023 6000
20/01/2024 7000
