Predictive Analytics: Microsoft Excel
| Author | : | |
| Rating | : | 4.78 (582 Votes) |
| Asin | : | 0789749416 |
| Format Type | : | paperback |
| Number of Pages | : | 304 Pages |
| Publish Date | : | 2013-12-23 |
| Language | : | English |
DESCRIPTION:
Counting conservatively, this is Conrad Carlberg’s eleventh book about quantitative analysis using Microsoft Excel, which he still regards with a mix of awe and exasperation. A look back at the “About the Author” paragraph in Carlberg’s first book, published in 1995, shows that the only word that remains accurate is “He.” Scary.
You don’t need multimillion-dollar software: All the tools you need are available in Microsoft Excel, and all the knowledge and skills are right here, in this book! Microsoft Excel MVP Conrad Carlberg shows you how to use Excel predictive analytics to solve real-world problems in areas ranging from sales and marketing to operations. You’ll get an extensive collection of downloadable Excel workbooks you can easily adapt to your own unique requirements, plus VBA code—much of it open-source—to streamline several of this book’s most complex techniques. Step by step, you’ll build on Excel skills you already have, learning advanced techniques that can help you increase revenue, reduce costs, and improve productivity. By mastering predictive analytics, you’ll gain a powerful competitive advantage for your company and yourself. • Learn both the “how” and “why” of using data to make better tactical decisions • Choose the right analytics technique for each problem • Use Excel to capt
"From 0 to competent in From 0 to competent in 300 pages! As an inexperienced Demand Analyst I scrambled to understand the academic literature on forecasting. I was pretty swamped and did not know where to start until I found this book. Carlberg has a way of explaining very complex issues in a way that a beginner can grasp and an intermediate or expert can learn from. . 00 pages!" according to Joseph Johnson. As an inexperienced Demand Analyst I scrambled to understand the academic literature on forecasting. I was pretty swamped and did not know where to start until I found this book. Carlberg has a way of explaining very complex issues in a way that a beginner can grasp and an intermediate or expert can learn from. . A good practiacal approach to the science/art of forecasting. The book is designed for the data analyst vs. the theoretician. The chapters on Exponential Smoothing (Simple and the Holt's method) could get more attention but I understand these topics are addressed in another book. Chapters on logistic regression, principal components analysis, factor analysis and ARIMA are . Not for beginners! Antoine Johnson 3-Stars for now. As a beginner I think I bit off way too much at first. I'm going to start with a "For Dummies" book first on predictive analytics and then go back and re-read this one. I'm pretty Excel savvy so I'm looking forward to applying the concepts - one I actually understand them!
A look back at the “About the Author” paragraph in Carlberg’s first book, published in 1995, shows that the only word that remains accurate is “He.” Scary.. About the AuthorCounting conservatively, this is Conrad Carlberg’s eleventh book about quantitative analysis using Microsoft Excel, which he still regards with a mix of awe and exasperation