Pulak KabirBeing a ‘Data Analyst’Becoming a data analyst is often challenging but at the same time, an interesting journey to go through.Nov 4, 2023Nov 4, 2023
Pulak KabirSalesforce: Average Deal Size part 1Assume that Salesforce customers pay on a per user basis (also referred to as per seat model). Given a table of contracts data, write a…Feb 16, 2023Feb 16, 2023
Pulak KabirBest-selling Products at Amazon?Write an SQL query to find the best-selling product in each product category. If there are two or more products with the same sales…Feb 16, 2023Feb 16, 2023
Pulak KabirManhattan, NYC Area Code at VerizonThe first 3 digits of American phone numbers, after the international code (of +1) are called the area code.Feb 16, 2023Feb 16, 2023
Pulak KabirRolling 3-day earnings at StripeAssume you are given the table below containing information on user transactions on Stripe. Write a query to obtain all of the users’…Feb 16, 2023Feb 16, 2023
Pulak KabirCompensation Outliers at Accenture?A team at Accenture is helping a Fortune 500 client revamp their compensation and benefits program. The first step in this analysis is to…Feb 15, 2023Feb 15, 2023
Pulak KabirRepeat Purchases on Multiple days at Stitch FixAssume you are given the table below containing information on user purchases. Write a query to obtain the number of users who purchased…Feb 15, 2023Feb 15, 2023
Pulak KabirInvalid Search Results on GoogleAssume you are given the table below containing the information on the searches attempted and the percentage of invalid searches by…Feb 15, 2023Feb 15, 2023
Pulak KabirCumulative purchases of Product at AmazonAssume you are given the table below for the purchasing activity by order date and product type. Write a query to calculate the cumulative…Feb 15, 2023Feb 15, 2023
Pulak KabirSalesforce: Average Deal SizeSalesforce customers pay on a per user basis (also referred to as per seat model).Feb 15, 2023Feb 15, 2023