Challenge No. 110: After reconciling the company’s bank transactions with the records in the financial department, discrepancies were found between 5 rows of bank transactions and 7 rows of financial records.
Solved using: Excel.
⭐️⭐️⭐️⭐️⭐️Expert
Highly advanced challenges.
Form quarterfinal pairs by FIFA
Challenge No. 32: — This is the last problem in the series of FIFA world cup challenges.
Solved using: SQL.
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.
Find max finals gap for
Challenge No. 29: — This week is FIFA world cup challenges —
If a country has appeared more than once in finals, find the maximum gap in years for next – previous appearance for that country.
Solved using: SQL.
Repeat Winners within 20 Years
Challenge No. 70: — This week will be FIFA World Cup week.
Solved using: SQL.
Count Out-In Quarter Difference
Challenge No. 18: (Excel formulas also welcome)
List the count of quarters for only those rows where Out Quarter > In Quarter.
Solved using: Power Query.
Traveling Salesman Problem
Challenge No. 90: The Traveling Salesman Problem (TSP) is a well-known problem in mathematics used to determine the optimal travel path that visits all cities exactly once with the minimum cost.
Solved using:Excel, Power Query, Python, and R.
Count Unique Subjects Per Row
Challenge No. 6: (Excel formulas also welcome)
Count the no.
Solved using: Power Query (Table.TransformColumns).
Divide values among people listed
Challenge No. 4: Generate the result table as shown.
Solved using: Power Query.
Convex Hulls (Gift Wrapping Algorithm)!
Challenge No. 80: The Convex Hull Algorithm leads to the smallest convex area (Polygon) that includes all the points in the dataset.
Solved using:Excel, Python, and R.