As the thread name suggests, I'm here to ask about data mining and pivot tables. I'm asking this because, this is my project in my computer class, and this project is 20% of my final grade.

Unlock advanced data analysis in Excel with Power Pivot. Overcome PivotTable limitations and enhance your data insights effortlessly.

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.