![\"Advancing](\"https:\/\/i0.wp.com\/georgejmount.com\/wp-content\/uploads\/2021\/03\/159894091_10100223583050286_5298112143652260241_o-784x1024.jpg?resize=325%2C424&ssl=1\")
<\/figure>\n<\/div>\nIf you’d like to host a custom workshop based on the book at your organization, have me present at your meetup, or use it in the classroom, check out these pages:<\/p>\n
- \n
- Workshops<\/a><\/li>\n
- For teachers <\/a><\/li>\n<\/ul>\n
Where to buy<\/h2>\n
The book is now available in paperback and as an ebook at these and other booksellers: <\/p>\n
- \n
- Amazon<\/a>: Print, Kindle<\/li>\n
- Alibris<\/a>: Print, EPUB<\/li>\n
- Bookshop.org<\/a>: Print<\/li>\n
- Barnes & Noble<\/a>: Print<\/li>\n
- Books-A-Million<\/a>: Print<\/li>\n
- eBooks.com<\/a>: PDF (paid), EPUB<\/li>\n
- O\u2019Reilly Media Online Learning platform<\/a> (subscription required): Read on your desktop or mobile device. You can also preview the book with a 10-day free subscription to the site. <\/a><\/li>\n<\/ul>\n
Reviews, please <\/strong>\u2b50\u2b50\u2b50\u2b50\u2b50<\/h3>\n
Whether you pick up a paperback, read on your Kindle, or head to O’Reilly Online Learning, please leave a book review.<\/strong> This helps tremendously with the book’s success. If you’re not sure what to include in your review, here are some ideas:<\/p>\n
- \n
- How did you benefit from this book?<\/li>\n
- Who else could benefit from this book and why?<\/li>\n
- What did this book offer that other resources have not?<\/li>\n
- What are two or three takeaways you have after reading?<\/li>\n<\/ul>\n
Book description:<\/strong><\/h2>\n
\n\nData analytics may seem daunting, but if you\u2019re familiar with Excel, you have a head start that can help you make the leap into analytics. Advancing into Analytics<\/em> will lower your learning curve.<\/p>\n
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.<\/p>\n
With this practical book at your side, you\u2019ll learn how to:<\/p>\n
- \n
- Explore a dataset for potential research questions to check assumptions and to build hypotheses<\/li>\n
- Make compelling business recommendations using inferential statistics<\/li>\n
- Load, view, and write datasets using R and Python<\/li>\n
- Perform common data wrangling tasks such as sorting, filtering, and aggregating using R and Python<\/li>\n
- Navigate and execute code in Jupyter notebooks<\/li>\n
- Identify, install, and implement the most useful open source packages for your needs<\/li>\n
- And more<\/li>\n<\/ul>\n
Learning objective<\/h2>\n
A good product expresses and delivers on a promise to its audience. To that end, I include a learning objective in the preface of Advancing into Analytics<\/em>. <\/p>\n
By the end of this book, you should be able to conduct exploratory data analysis and hypothesis testing using a programming language<\/em>.<\/strong> Exploring and testing relationships is core to analytics. With the tools and frameworks you\u2019ll pick up in this book, you will be well positioned to continue learning more advanced data analysis techniques.<\/p>\n
We\u2019ll be using Excel, R, and Python because these are powerful tools, and because they make for a seamless learning journey. Few books cover this combination, even though the progression from spreadsheets into programming is common for analysts, myself included.<\/p>\n
Prerequisites<\/h2>\n
To meet the book’s objectives, I make some technical and technological assumptions: <\/p>\n
Technical Requirements<\/h3>\n
Advancing into Analytics <\/em>was written on a Windows computer with the Office 365 version of Excel for desktop. As long as you have a paid version of Excel 2010 or greater for either Windows or Mac installed on your machine, you should be able to follow along with the majority of the instruction in this book, with some variations, particularly with PivotTables and data visualization.<\/p>\n
R and Python are both free, open source tools available for all major operating systems. I address how to install them later in the book.<\/p>\n
Technological Requirements<\/h3>\n
This book assumes no prior knowledge of R or Python; that said, it does rely on moderate knowledge of Excel to flatten that learning curve.<\/p>\n
The Excel topics you should be familiar with include the following:<\/p>\n
- \n
- Absolute, relative, and mixed cell references<\/li>\n
- Conditional logic and conditional aggregation (
IF()<\/code> statements,SUMIF()<\/code>\/SUMIFS()<\/code>, and so forth)<\/li>\n- Combining data sources (
VLOOKUP()<\/code>,INDEX()<\/code>\/MATCH()<\/code>, and so forth)<\/li>\n- Sorting, filtering, and aggregating data with PivotTables<\/li>\n
- Basic plotting (bar charts, line charts, and so forth)<\/li>\n<\/ul>\n
If you would like more practice with these topics before moving on, I suggest Excel 2019 Bible<\/em> by Michael Alexander et al.<\/em><\/a><\/p>\n
Table of contents<\/h2>\n
I. Foundations of Analytics in Exce<\/strong>l<\/p>\n
1. Foundations of Exploratory Data Analysis
2. Foundations of Probability
3. Foundations of Inferential Statistics
4. Correlation and Regression
5. The Data Analytics Stack <\/p>\nII. From Excel to R<\/strong><\/p>\n
6. First Steps with R for Excel Users
7. Data Structures in R
8. Data Manipulation and Visualization in R
9. Capstone: R for Data Analytics<\/p>\nIII. From Excel to Python<\/strong><\/p>\n
10. First Steps with Python for Excel Users
11. Data Structures in Python
12. Data Manipulation and Visualization in Python
13. Capstone: Python for Data Analytics
14. Conclusion and Next Steps<\/p>\n<\/div>\n<\/div>\nWhat people are saying:<\/h2>\n
\n![\"Selfie](\"https:\/\/i0.wp.com\/georgejmount.com\/wp-content\/uploads\/2021\/04\/178473880_10100232962339116_9173354330756219454_n.jpg?resize=353%2C437&ssl=1\")
I’m obviously pleased with the book, but don’t take my word for it! Check out these reviews: <\/figcaption><\/figure>\n<\/div>\n \n
This book is uniquely poised to be used as both a reference and a primer on business and data analytics.<\/p>\n
Aiden Johnson, Data Scientist & Mentor at Breakthrough Data Science<\/a><\/cite><\/p><\/blockquote>\n
\n
George lays out exactly what you need to do to bridge from Excel into data science and analytics.<\/p>\n
Jordan Goldmeier, Microsoft Excel MVP and Head of Anarchy Data<\/a><\/cite><\/p><\/blockquote>\n
\n
I benefited from this book by learning the technical progression from Excel into Python and R languages. I also took conceptual knowledge of statistics into these playgrounds.<\/p>\n
Joe Balog, Data Analyst at joesphbalog.com<\/a><\/cite><\/p><\/blockquote>\n
\n
The book was written in a way that helps readers transfer their knowledge about data into new tools and techniques in an approachable manner.<\/p>\n
Nicole LaGuerre, Learning & Development Consultant at s1mplythebest.com<\/a><\/cite><\/p><\/blockquote>\n
\n
Not only will the reader become comfortable with using the most popular data analysis programming languages, they will also learn about techniques to wrangle, explore, and visualize data so that it comes to life and tells a story.<\/p>\n
John Dennis, Data Analytics & Data Science Consultant<\/cite><\/p><\/blockquote>\n
\n
I have been looking for the most direct line to acquire the essential skills required to perform in a data analytics\/data science role at an affordable price point. This book provides the closest thing to the roadmap that I\u2019ve been looking for.<\/p>\n
Barry Lilly, Claims Team Manager at Liberty Mutual Insurance<\/cite><\/p><\/blockquote>\n
\n
This book is a gold mine for anyone who wants to level up their analytics game. It\u2019s an excellent review of major analytical concepts and also a great starting point for learning how to munge data programmatically using R or Python.<\/p>\n
Tobias Zwingmann, Senior Data Scientist and Co-founder of RAPYD.AI<\/a><\/cite><\/p><\/blockquote>\n
Companion repo<\/h2>\n
The companion repository for the book is publicly available on GitHub<\/a>. This contains all datasets, workbooks, scripts, exercise solutions, and other files used in the book.<\/p>\n
You can download a compressed folder of the files or, if you are familiar with GitHub, clone it to your computer. <\/p>\n
Updates\/errata<\/h2>\n
5\/19\/2021 <\/strong>(This issue appears to have been resolved by Microsoft)<\/em>: “Mr. Excel” Bill Jelen heard reports of a bug affecting the Data Analytics ToolPak (used in the book) and kindly pointed to an alternative: the XLMiner Analysis ToolPak<\/a>. This free add-in includes all menus and features as used in the book. <\/p>\n
Watch the following video to learn more about XLMiner. Thanks, Mr. Excel! <\/p>\n
\n - Combining data sources (
- Alibris<\/a>: Print, EPUB<\/li>\n
- For teachers <\/a><\/li>\n<\/ul>\n