Please give step-by-step instructions for each question below. Thank you so much! I'll rate:)

Assessment Section 1 Carey's Extreme Sports Minicase 1 Carey's Extreme Sports is an eCommerce store specializing in selling extreme sports products. The products include equipment, apparel, and other items related to extreme sports. Founded in 2015 in Arizona, US, the company has grown from a high-end sports gear equipment company into a national extreme sports brand with operations in 50 States and close to 1000 employees working for the company. The world of Carey's Extreme has traditionally conjured up images of inclusivity, sophistication, and elegance, attracting both wealthy and not-so-wealthy crowds, including college students. At the same time, the company sells several products that are used in "niche" sports with limited expansion opportunities. You have been recently hired in the strategy and marketing group and tasked with understanding the current state of the company's day-to-day operations and discovering potential growth in both revenue and profit. You believe that after understanding the performance of each product based on its sales and profitability, possible strategies could be developed to discover potential growth opportunities and increased profitability. The assignment's objective is to better understand the profitability of various products sold by the company. (1.1) The Transaction worksheet provides the date and time of each transaction. To do analysis on the days of the week each transaction occurred complete the Weekday column 1 (1.2) Using Category as the primary disaggregation, how may branches would you have from the starting point? Use the Task 2 worksheet as your work area and select your answer from the drop down in cell B3). (1.3) Which of the product categories is the most profitable? Use the Task 3 worksheet as your work area and select your answer from the drop down in cell B3. (1.4 Which month had the most total profit? Use the Task 4 worksheet as your work area and select your answer from the drop down in cell B3). (1.5) Which day of the week, did the company have the least total revenue? Use the Task 5 worksheet as your work area and select your answer from the drop down in cell B3). \begin{tabular}{|l|l|} \hline Data Dictionary & \\ \hline Transaction date & Date of the transaction (purchase of a product) \\ \hline Transaction time & Date of the transaction (purchase of a product) \\ \hline Order ID & Unique identification of an ecommerce order \\ \hline Product ID & Unique identification of a product. The same product can feature in multiple orders \\ \hline Category & The category the product belongs to. This is the broad classification of the different categories currently available in the store \\ \hline Brand & The company that makes the product. \\ \hline Price & Price of the product \\ \hline User ID & Unique identification of the user purchasing the product(s). \\ \hline Revenue & Price times Quantity for product. \\ \hline Cost & Cost of the product. \\ \hline Profit & Profit per product \\ \hline Customer Rating & Rating by the customer. On a scale of 1 to 5 - 1 being the lowest and 5 being the highest (good) rating \\ \hline Customer Age & Age of the customer \\ \hline \end{tabular} B 1 2 How many branches would you have from the starting point? 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 C D E Use the area below to complete your analysis. Data Dictionary Transactions Task 2 Task 3 Task 4 Task 5 Assessment Section 1 Carey's Extreme Sports Minicase 1 Carey's Extreme Sports is an eCommerce store specializing in selling extreme sports products. The products include equipment, apparel, and other items related to extreme sports. Founded in 2015 in Arizona, US, the company has grown from a high-end sports gear equipment company into a national extreme sports brand with operations in 50 States and close to 1000 employees working for the company. The world of Carey's Extreme has traditionally conjured up images of inclusivity, sophistication, and elegance, attracting both wealthy and not-so-wealthy crowds, including college students. At the same time, the company sells several products that are used in "niche" sports with limited expansion opportunities. You have been recently hired in the strategy and marketing group and tasked with understanding the current state of the company's day-to-day operations and discovering potential growth in both revenue and profit. You believe that after understanding the performance of each product based on its sales and profitability, possible strategies could be developed to discover potential growth opportunities and increased profitability. The assignment's objective is to better understand the profitability of various products sold by the company. (1.1) The Transaction worksheet provides the date and time of each transaction. To do analysis on the days of the week each transaction occurred complete the Weekday column 1 (1.2) Using Category as the primary disaggregation, how may branches would you have from the starting point? Use the Task 2 worksheet as your work area and select your answer from the drop down in cell B3). (1.3) Which of the product categories is the most profitable? Use the Task 3 worksheet as your work area and select your answer from the drop down in cell B3. (1.4 Which month had the most total profit? Use the Task 4 worksheet as your work area and select your answer from the drop down in cell B3). (1.5) Which day of the week, did the company have the least total revenue? Use the Task 5 worksheet as your work area and select your answer from the drop down in cell B3). \begin{tabular}{|l|l|} \hline Data Dictionary & \\ \hline Transaction date & Date of the transaction (purchase of a product) \\ \hline Transaction time & Date of the transaction (purchase of a product) \\ \hline Order ID & Unique identification of an ecommerce order \\ \hline Product ID & Unique identification of a product. The same product can feature in multiple orders \\ \hline Category & The category the product belongs to. This is the broad classification of the different categories currently available in the store \\ \hline Brand & The company that makes the product. \\ \hline Price & Price of the product \\ \hline User ID & Unique identification of the user purchasing the product(s). \\ \hline Revenue & Price times Quantity for product. \\ \hline Cost & Cost of the product. \\ \hline Profit & Profit per product \\ \hline Customer Rating & Rating by the customer. On a scale of 1 to 5 - 1 being the lowest and 5 being the highest (good) rating \\ \hline Customer Age & Age of the customer \\ \hline \end{tabular} B 1 2 How many branches would you have from the starting point? 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 C D E Use the area below to complete your analysis. Data Dictionary Transactions Task 2 Task 3 Task 4 Task 5