Challenge No. 15: It may seem unreasonable, but the manager has requested that I convert the question table into the result table, ensuring that information for each product is provided in individual rows.
Solved using:Excel, Power Query, and R.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Analyze Words Combination!
Challenge No. 13: Determine how frequently Words from words list are comes together in article titles.
Solved using:Excel (CHOOSEROWS, IF, LAMBDA), Power Query (Table.AddColumn), 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.
K-Means Clustering Algorithm!
Challenge No. 6: The k-means clustering algorithm is a popular method used in data science and machine learning for partitioning a dataset into k distinct, non-overlapping subsets (clusters) with the below steps.
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.
Custom Grouping! Part 1
Challenge No. 2: Group the rows from the top, which in each group the total cost be lower than 130$.
Solved using:Excel (HSTACK, IF, LAMBDA), and Power Query (Table.Group).