Challenge No. 33: Generate the answer as shown.
Solved using: SQL.
Table.AddColumn
Adds a new column to a table with computed values in Power Query.
Top Countries by Medals
Challenge No. 117: Gold, Silver and Bronze have weightage of 4, 2 & 1 respectively.
Solved using: SQL.
Form quarterfinal pairs by FIFA
Challenge No. 32: — This is the last problem in the series of FIFA world cup challenges.
Solved using: SQL.
Matching Tables!
Challenge No. 107: In a survey, 10 questions were asked to both
a manager and an expert, and they responded
to some of them.
Solved using:Excel (CHOOSECOLS, FILTER, HSTACK), Google Sheets, Power Query (List.PositionOf, List.Transform, Table.AddColumn), Python, Python in Excel, and R.
Identify FIFA father-son pairs by
Challenge No. 31: — This is the second last problem in the series of FIFA world cup challenges —
Identify the father son duo from the data set of FIFA World cups (some data changed).
Solved using: SQL.
Count Palindromes in Range
Challenge No. 107: Palindrome numbers are those which are same even when read from backwards.
Solved using: Python in Excel.
Custom Average!
Challenge No. 103: Today is 20/08/2024, and we’re calculating the average delivery time per product in days.
Solved using:Excel (AVERAGE, CHOOSECOLS, FILTER), Google Sheets, Power Query (Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Pair clubs so each team
Challenge No. 27: There are 9 clubs and every club has to play with remaining 8 clubs once only.
Solved using: Power Query (Table.AddColumn).
Pivoting Data
Challenge No. 22: Pivot the Customer’s table
Create a Total for each Month
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Compare Rows! Part 1
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.