Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.
Table.Group
Groups rows in a table based on specified columns and applies aggregations in Power Query.
Assign Rank1 and Rank2
Challenge No. 691: Give the rank1 and rank2 as shown.
Solved using: Python.
Insert Yearly Sum Totals
Challenge No. 660: Insert the sum for the year after the year ends.
Solved using: Python.
Identify Yearly Repeat Customers
Challenge No. 636: Find the unique repeat customers in a year.
Solved using: Python.
Top 3 Salespersons per Quarter
Challenge No. 619: List the top 3 salespersons for every quarter on the basis of total sales in that quarter.
Solved using: Python.
Transpose table, summing values from
Challenge No. 275: Transpose the problem table into result table where value is sum of Values from problem table.
Solved using: Python.
Check ingredient availability for dishes
Challenge No. 274: Problem Table1 contains the list of ingredients which can be used to prepare a dish.
Solved using: Python.
Pick top N by group
Challenge No. 271: From first group, pick up top 1 on the basis of revenue, from second group, pick up top 2 and so on.
Solved using: Python in Excel.
Find Time Extremes by Date
Challenge No. 582: For different dates, document the min and max time and corresponding employees.
Solved using: Python in Excel.
Summarise the table with total
Challenge No. 266: Summarise the table as shown with a total row after each sales person’s data.
Solved using: Python.