Book Details:
Publisher: | Que Publishing |
Series: |
Que
|
Author: | Conrad Carlberg |
Edition: | 1 |
ISBN-10: | 0789749416 |
ISBN-13: | 9780789749413 |
Pages: | 304 |
Published: | Jul 12 2012 |
Posted: | Nov 19 2014 |
Language: | English |
Book format: | PDF |
Book size: | 12.24 MB |
Book Description:
Excel predictive analytics for serious data crunchers! The movie Moneyball made predictive analytics famous: Now you can apply the same techniques to help your business win. 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. Carlberg offers unprecedented insight into building powerful, credible, and reliable forecasts, showing how to gain deep insights from Excel that would be difficult to uncover with costly tools such as SAS or SPSS. 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 capture live real-time data from diverse sources, including third-party websites Use logistic regression to predict behaviors such as 'will buy' versus 'won't buy' Distinguish random data bounces from real, fundamental changes Forecast time series with smoothing and regression Construct more accurate predictions by using Solver to find maximum likelihood estimates Manage huge numbers of variables and enormous datasets with principal components analysis and Varimax factor rotation Apply ARIMA (Box-Jenkins) techniques to build better forecasts and understand their meaning
Get an in-depth analysis of financial time series from the perspective of a functional programmer Overview Understand the foundations of financial stochastic processes Build robust models quickly and efficiently Tackle the complexity of parallel programming In Detail Haskell is one of the three most influential functional programming languages available today along with Lisp and Standard ML. When used for financial analysis, you can achieve a much-improved level of prediction and clear problem descriptions. Haskell Financial Data Modeling and Predictive Analytics is a hands-on guide that employs a mix of theory and practice. Starting with the basics of Haskell, this book walks you through the mathematics involved and how this is implemented in Hask...
Processing, Analysis and Modeling for Predictive Analytics Projects
Whether you are brand new to data mining or working on your tenth predictive analytics project, Commercial Data Mining will be there for you as an accessible reference outlining the entire process and related themes. In this book, you'll learn that your organization does not need a huge volume of data or a Fortune 500 budget to generate business using existing information assets. Expert author David Nettleton guides you through the process from beginning to end and covers everything from business objectives to data sources, and selection to analysis and predictive modeling. Commercial Data Mining includes case studies and practical examples from Nettleton's more than 20 years of commercial experience. Real-world cases covering customer loyalty, cros...
Build and Deploy Actionable Solutions in Minutes
Data Science and Machine Learning are in high demand, as customers are increasingly looking for ways to glean insights from all their data. More customers now realize that Business Intelligence is not enough as the volume, speed and complexity of data now defy traditional analytics tools. While Business Intelligence addresses descriptive and diagnostic analysis, Data Science unlocks new opportunities through predictive and prescriptive analysis. The purpose of this book is to provide a gentle and instructionally organized introduction to the field of data science and machine learning, with a focus on building and deploying predictive models. The book also provides a thorough overview of the Microsoft Azure Machine Learning service using task oriented...
2007 - 2021 © eBooks-IT.org