Challenge No. 11: Extract all item codes that are repeated at least in 3 out of 4 lists presented in the question table.
Solved using:Excel (BYCOL, FILTER, LAMBDA), Power Query (List.Combine, List.Distinct, List.Transform), and R.
Aggregation & Summarization
Summarizing data using various methods.
Inventory Efficiency!!!
Challenge No. 10: The question table shows inventory levels for materials required to produce products, with specific combinations (1 A, 2 B, 3 C per product).
Solved using:Excel (HSTACK, LAMBDA, LET), Power Query (Table.AddColumn, Table.Group), and R.
Find The Length Of The Largest
Challenge No. 9: repetition of a specific pattern!
Identify the longest continuous repetition of the
pattern “+ – -” and “+ -” in the question table for each product.
Solved using:Excel, Power Query, and R.
Calculate Average Inventory Level!
Challenge No. 8: The Question’s table outlines warehouse transactions with records for Initial value (warehouse product count), Add (purchased and incoming products), and Reduce (sold and outgoing products).
Solved using:Excel, and Power Query.
Analyze Customer Purchasing Patterns!
Challenge No. 5: Determine how frequently products are bought together (same invoice number).
Solved using:Excel, and Power Query.
Advanced Calculation
Challenge No. 4: Calculate the mission’s income, where the daily rate starts at $1 on the first day and increases by $1 for the next continuous days (the rate for the third day in the mission is 3$).
Solved using: Excel.
Row Combinations
Challenge No. 3: Extract all possible combinations of ID and result in the right-side table.
Solved using:Excel (BYROW, COUNTA, DROP), Power Query (List.Transform), Python, and Python in Excel.