Predictive Analytics: Microsoft Excel by Conrad Carlberg (Author). The movie Moneyball made predictive analytics well-known: Now you may apply the identical techniques to assist your corporation win. You don’t want multimillion-greenback software program: All the instruments you need are available in Microsoft Excel, and all of the knowledge and expertise are right right here, in this guide!
Microsoft Excel MVP Conrad Carlberg reveals you find out how to use Excel predictive analytics to unravel actual-world problems in areas starting from sales and advertising operations. Carlberg presents unprecedented perception into constructing highly effective, credible, and dependable forecasts, displaying the right way to achieve deep insights from Excel that might be tough to uncover with expensive instruments equivalent to SAS or SPSS.
You’ll get an extensive collection of downloadable Excel workbooks you possibly can simply adapt to your individual distinctive requirements, plus VBA code-a lot of its open-supply-to streamline several of this guide’s most advanced techniques.
Step by step, you’ll construct on Excel skills you already have, learning advanced strategies that can help you enhance income, scale back costs, and improve productivity. By mastering predictive analytics, you’ll achieve a powerful aggressive advantage in your firm and yourself.
• Study each the “how” and “why” of utilizing data to make higher tactical choices
• Choose the proper analytic approach for every downside
• Use Excel to seize live actual-time information from various sources, including third-celebration websites
• Use logistic regression to foretell behaviors such as “will buy” versus “received by”
• Distinguish random information bounces from real, elementary adjustments
• Forecast time sequence with smoothing and regression
• Assemble extra accurate predictions by utilizing Solver to search out maximum probability estimates
• Manage huge numbers of variables and massive datasets with principal elements evaluation and Varimax factor rotation
• Apply ARIMA (Box-Jenkins) techniques to construct better forecasts and understand their that means
As an inexperienced Demand Analyst I scrambled to understand the educational literature on forecasting. I need pretty swamped and did not know the place to start out until I discovered this book. Carlberg has a way of explaining very complicated issues in a method that a beginner can grasp and an intermediate or expert can learn from. His ebook is humorous, intuitive, and really hits house as to where to begin when diving into predictive analytics. Although I’ve learned by means of the e book and labored through a number of the examples, I maintain the guide close at hand for a fast reference. Nice, great e book!
Predictive Analytics: Microsoft Excel
Conrad Carlberg (Author)
304 pages
Que Publishing; 1 edition (July 12, 2012)
More details about this books.
No comments:
Post a Comment