I'd go straight to a cloud/big data database for analytics if I were you (i'm a senior engineer at a national bank, using AWS)
Consider PrestoDB, Spark, Hive or Redshift
This book has some interesting analytics / data mining applications in pure SQL: https://www.amazon.ca/Data-Analysis-Using-SQL-Excel-dp-111902143X/dp/111902143X/ref=dp_ob_image_bk
I used that book in a course I taught
Might be a bit advanced for you, however
Any suggestions for Excel learning resources? I recently purchased this book, which looks great. I'd love some suggestions of resources that complement this book.
My background, for context: I'm a Python developer -- I do most of my data wrangling & ML work on top of pandas (& numpy).
I should add specific to your original question — a great resource and guidance for data analysis using sql and excel is the book by the same title. https://www.amazon.com/Data-Analysis-Using-SQL-Excel/dp/111902143X