Data analytics may seem daunting, but if you're an experienced Excel user, you have a unique head start. With this hands-on guide, intermediate Excel users will gain a solid understanding of analytics and the data stack. By the time you complete this book, you'll be able to conduct exploratory data analysis and hypothesis testing using a programming language.
Exploring and testing relationships are core to analytics. By using the tools and frameworks in this book, you'll be well positioned to continue learning more advanced data analysis techniques. Author George Mount, founder and CEO of Stringfest Analytics, demonstrates key statistical concepts with spreadsheets, then pivots your existing knowledge about data manipulation into R and Python programming.
This practical book guides you
Foundations of analytics in Use Excel to test relationships between variables and build compelling demonstrations of important concepts in statistics and analyticsFrom Excel to Cleanly transfer what you've learned about working with data from Excel to RFrom Excel to Learn how to pivot your Excel data chops into Python and conduct a complete data analysis
"Advancing Into Analytics" is a well-written book that serves as a great introduction to data analysis. Highly recommend this book to anyone looking to improve their data analysis abilities beyond Excel.
I knew this was going to be a good one when it started with a comparison between Pawn Stars and data analytics: two of my interests that I had yet to draw any sort of connection between.