The University of Texas at Arlington
Master’s in Business Analytics
Spring 2024
INSY- 5337- 001 DATA WAREHOUSE AND BUSINESS INTELLIGENCE
Assignment -2
Submitted by
Dwarakanath Gutta 1002126239
Instructor
Dr. A. C. Sahoo
1. What is the overall Revenue in USD?
Ans: The Overall Revenue is 1785876679.8
2. What is the Revenue for E-Bike Tailwind in 2010?
Ans: The revenue for E-bike Tailwind in 2010 is 3,524,790.84
3. What is the Sales Quantity of T-shirts to Big Apple Bikes in 2009?
Ans: The Sales Quantity is 22.
4. What Year had the Highest Sales Quantity?
Ans: The year 2011 had the highest sales quantity.
5. What year had the lowest Revenue?
Ans: The year 2009 had the lowest revenue.
6. In the year with the lowest Revenue, which Product had the lowest Revenue?
Ans: The lowest revenue is for the product Water Bottles.
7. What was the Net Revenue for Year in question 6?
Ans: The net revenue is 99,588,879.47
8. In the year that had the highest Net Sales, what division had the highest Net Sales?
Ans: The highest net sales for the year 2017 and the division BI has the highest net sales.
9. For the division in question 8, which customer had the highest Net Sales?
Ans: Bavaria bikes has the highest net sales.
10. In the year with highest Revenue, what division had the highest sales revenue?
Ans:. The highest net revenuefor the year 2017 and the division BI has the highest sales revenue.
11. For the division in question 10, which customer had the highest sales revenue?
Ans: The customer with the most revenue is the Bavaria bikes.
12. What city provided the highest revenue for Accessories in 2011?
Ans: The highest revenue for the accessories in 2011 is Palo Alto city.
13. What was the Top Year in Terms of Revenue?
Ans: In terms of revenue the Top year was 2017.
14. What is the Top Division in the Top Year in Terms of Revenue?
Ans: In the year 2017, BI is the Top division in Terms of revenue.
15. In 2018, for Bicycles, what is the Total Revenue for the Top Three Customers?
Ans: The total revenue for the Top three Customers is 36,883,302.61 (Baveria Bikes, Radlelland and
Beantown Bikes) in 2018.
INSY- 5337
Data Warehousing and Business Intelligence
Academic Integrity
In order for your Assignment/Homework/Project to be accepted you must read the
following, sign this form and attach it to your papers (as the last page of your
assignment).
Academic Integrity: Students enrolled in this course are expected to adhere to the UT Arlington
Honor Code:
I pledge, on my honor, to uphold UT Arlington’s tradition of academic integrity, a tradition
that values hard work and honest effort in the pursuit of academic excellence.
I promise that I will submit only work that I personally create or contribute to group
collaborations, and I will appropriately reference any work from other sources. I will follow
the highest standards of integrity and uphold the spirit of the Honor Code.
Student Name: Dwarakanath Gutta Student ID: 1002126239
Student Signature: Dwarakanath Date: 02/11/2024
