Challenges categorized by topic.
Challenge No. 102: In the historical sales table, identify and extract the dates where the sales value on that date is greater than the sales on the previous date.
Solved using:Excel (DROP, FILTER, IF), Google Sheets, Power Query (Table.AddColumn, Table.AddIndexColumn, Table.SelectColumns), Python, Python in Excel, R, and VBA.
Challenge No. 90: Find the 4th breakdown date of machines, only if total number of breakdowns > 4.
Solved using: Python.
Challenge No. 25: If in a group of IDs, first occurrence of event Z appears with a category of Temporary, then all Values should be Yes otherwise No.
Solved using: Power Query.
Challenge No. 20: Analyse the sales data by Financial Year and Financial Quaters
Assume the Financial year starts in April
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Challenge No. 100: Consider the IDs in the question table.
Solved using:Excel (CHAR, COUNTIF, COUNTIFS), Google Sheets, Power Query (List.Transform, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Challenge No. 99: Randomly select 4 unique staff members using the following procedure:
1- Randomly select a department out of 5 departments with equal probability.
Solved using:Excel, Power Query, and R.
Challenge No. 98: In the Question table, historical sales values are provided in a single cell, including the Date, Product Name, and Quantity, but in a disorganized order.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Contains, Text.Split), Python, Python in Excel, and R.
Challenge No. 77: — This week will be FIFA World Cup week.
Solved using: SQL.
Challenge No. 76: — This week will be FIFA World Cup week.
Solved using: Power Query.
Challenge No. 17: Sum the total sales per Week Excluding Weekends
Dynamic array function allowed but
Extra marks for Legacy Array Functions or PowerQuery Solution.
Solved using: Power Query.
