Challenge No. 45: The “Question” table contains product IDs of varying lengths.
Solved using:Excel (LAMBDA, LET, MID), Power Query (List.Transform, List.Zip, Table.AddColumn), Python, R, and VBA.
⭐️⭐️⭐️ Intermediate
Moderate difficulty level.
Combine Tables
Challenge No. 44: The question tables display product sales across various regions for the different months of spring.
Solved using:Excel (DROP, FILTER, HSTACK), Power Query (List.Distinct, Table.Column, Table.ColumnNames), Python, and R.
Sort Table Columns
Challenge No. 43: In the question table (Product sales in different regions), sort the columns in descending order based on their total values.
Solved using:Excel (BYCOL, HSTACK, LAMBDA), Google Sheets, Power Query (List.Skip, Table.Column, Table.ColumnNames), Python, and R.
Duration Since Last Visit!
Challenge No. 38: In the question table, the visiting dates for all 4 agents are provided.
Solved using:Excel (AVERAGE, DROP, EOMONTH), Power Query (List.Transform, Table.AddColumn, Table.Group), Python, and R.
Pareto Line
Challenge No. 36: In Multi-Objective Models, Instead Of A Single Solution, We Encounter A Pareto Front That Includes All Non-Dominant Solutions, And In This Quesion We Want To Extracth All Non Dominant Solutions.
Solved using:Excel (BYROW, FILTER, LAMBDA), Power Query (List.Transform, Table.SelectRows), Python, and R.
P & Down Grades!
Challenge No. 35: In our company, we utilize a grading system to evaluate the technical performance of our agents, assigning grades of C, B, A, and A+.
Solved using:Excel (DROP, FILTER, HSTACK), Power Query (Table.AddColumn, Table.Group), and R.
Customer Return Cycle!
Challenge No. 34: In the question table, sales data for different customers are provided.
Solved using:Excel (DROP, FILTER, HSTACK), Power Query (Table.Group), Python, and R.
Risk Analysis
Challenge No. 30: In risk analysis, activities are categorized into various groups according to their likelihood of occurrence and their impact.
Solved using:Excel, Power Query, Python, and R.
Identifying Customers Staple Products!
Challenge No. 29: In the question table, sales transactions are listed.
Solved using:Excel (CHOOSECOLS, FILTER, HSTACK), Power Query (Text.Combine, Table.Group), Python, and R.
Highlight Merged Cells
Challenge No. 24: In Conditional Formatting write a formula to highlight the merged cells.
Solved using:Excel, R, and VBA.