eBooks-it.org Logo
eBooks-IT.org Inner Image

Predictive Analytics

Microsoft Excel

Predictive Analytics Image

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

Download Link:

Related Books:

Haskell Financial Data Modeling and Predictive Analytics

Haskell Financial Data Modeling and Predictive Analytics Image
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...

Commercial Data Mining

Processing, Analysis and Modeling for Predictive Analytics Projects
Commercial Data Mining Image
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...

Predictive Analytics with Microsoft Azure Machine Learning

Build and Deploy Actionable Solutions in Minutes
Predictive Analytics with Microsoft Azure Machine Learning Image
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