I’m excited to share that the draft of my forthcoming book Advancing into Analytics: From Excel to R and Python is now available in its entirety on the O’Reilly Media Online Learning platform. This is the unedited proof of the book as it moves into production.
Check your university or institution for a subscription or consider signing up — it’s the most comprehensive technical learning provider out there.
Data analytics may seem daunting, but if you’re familiar with Excel, you have a head start that can help you make the leap into analytics. Advancing into Analytics will lower your learning curve.
Author George Mount, founder and CEO of Stringfest Analytics, clearly and gently guides intermediate Excel users to a solid understanding of analytics and the data stack. This book demonstrates key statistical concepts from spreadsheets and pivots your existing knowledge about data manipulation into R and Python programming.
With this practical book at your side, you’ll learn how to:
- Explore a dataset for potential research questions to check assumptions and to build hypotheses
- Make compelling business recommendations using inferential statistics
- Load, view, and write datasets using R and Python
- Perform common data wrangling tasks such as sorting, filtering, and aggregating using R and Python
- Navigate and execute code in Jupyter notebooks
- Identify, install, and implement the most useful open source packages for your needs
- And more
Readers will build models visualizing the most important theorems of analytics, transfer their knowledge of data manipulation from Excel to R and Python, and ultimately build and evaluate models in those languages.
I look forward to sharing this book with the community and hope it can help lots of readers move into more advanced analytics without the unnecessary learning frictions I encountered in my own journey.
More to come as the book moves into production (We are thinking late summer final release). I welcome your thoughts on the draft in the meantime.