Predictive Analytics

Author: Conrad Carlberg
Publisher: Que Publishing
ISBN: 9780132967259
Release Date: 2012-07-02
Genre: Business & Economics

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

Predictive Analytics

Author: Conrad George Carlberg
Publisher: Pearson Education
ISBN: 9780789749413
Release Date: 2012-07-02
Genre: Business & Economics

Explains how to use Excel predictive analytics to solve problems in areas ranging from sales and marketing to operations. Reveals how to build credible and reliable forecasts. Describes advanced techniques to build revenue, reduce costs and improve productivity. Includes downloadable Excel workbooks to adapt to your own requirements.

More Predictive Analytics

Author: Conrad Carlberg
Publisher: Que Publishing
ISBN: 9780134070933
Release Date: 2015-08-18
Genre: Computers

Accurate, practical Excel predictive analysis: powerful smoothing techniques for serious data crunchers! In More Predictive Analytics, Microsoft Excel® MVP Conrad Carlberg shows how to use intuitive smoothing techniques to make remarkably accurate predictions. You won’t have to write a line of code--all you need is Excel and this all-new, crystal-clear tutorial. Carlberg goes beyond his highly-praised Predictive Analytics, introducing proven methods for creating more specific, actionable forecasts. You’ll learn how to predict what customers will spend on a given product next year… project how many patients your hospital will admit next quarter… tease out the effects of seasonality (or patterns that recur over a day, year, or any other period)… distinguish real trends from mere “noise.” Drawing on more than 20 years of experience, Carlberg helps you master powerful techniques such as autocorrelation, differencing, Holt-Winters, backcasting, polynomial regression, exponential smoothing, and multiplicative modeling. Step by step, you’ll learn how to make the most of built-in Excel tools to gain far deeper insights from your data. To help you get better results faster, Carlberg provides downloadable Excel workbooks you can easily adapt for your own projects. If you’re ready to make better forecasts for better decision-making, you’re ready for More Predictive Analytics. Discover when and how to use smoothing instead of regression Test your data for trends and seasonality Compare sets of observations with the autocorrelation function Analyze trended time series with Excel’s Solver and Analysis ToolPak Use Holt's linear exponential smoothing to forecast the next level and trend, and extend forecasts further into the future Initialize your forecasts with a solid baseline Improve your initial forecasts with backcasting and optimization Fully reflect simple or complex seasonal patterns in your forecasts Account for sudden, unexpected changes in trends, from fads to new viral infections Use range names to control complex forecasting models more easily Compare additive and multiplicative models, and use the right model for each task

Decision Analytics

Author: Conrad George Carlberg
Publisher: Que Publishing
ISBN: 9780789751683
Release Date: 2013
Genre: Business & Economics

Explains how to distil big data into manageable sets and use them to optimise business and investment decisions. Reveals techniques to improve a wide range of decisions, and use simple Excel charts to grasp the results. Includes downloadable Excel workbooks to adapt to your own requirements.

Statistik mit Excel f r Dummies

Author: Joseph Schmuller
Publisher: John Wiley & Sons
ISBN: 9783527811700
Release Date: 2017-02-17
Genre: Computers

Statistiken und Aussagen zu Wahrscheinlichkeiten begegnen uns heute überall: Die Umsatzentwicklung in Unternehmen, Hochrechnungen für Wahlergebnisse, PISA-Ergebnisse fünfzehnjähriger Schüler sind nur drei von zahlreichen Beispielen. Joseph Schmuller zeigt Ihnen in diesem Buch, wie Sie die Zahlen in den Griff bekommen und Daten, Statistiken und Wahrscheinlichkeiten richtig lesen und interpretieren. Dafür brauchen Sie keinen Statistikkurs zu belegen und kein Mathegenie zu sein. Für alles gibt es in Excel die passende Funktion und das passende Werkzeug. So können Sie Theorie und Praxis sofort miteinander verbinden.

Controllinginstrumente mit Excel umsetzen inkl Arbeitshilfen online

Author: Andreas Klein
Publisher: Haufe-Lexware
ISBN: 9783648117620
Release Date: 2018-12-11
Genre: Business & Economics

!-- Generated by XStandard version 2.0.1.0 on 2018-10-30T14:47:42 -- Excel gehört zu den wichtigsten Werkzeugen eines erfolgreichen Controllers. Die Gründe dafür liegen in der hohen Flexibilität und Vielseitigkeit des Programms, das trotz stetig wachsendem Funktionsumfangs intuitiv zu bedienen ist. Dieses Buch bietet Ihnen ein breites Spektrum von praktischen Tools und professionellen Anwendungen sowie ergänzende Gestaltungsempfehlungen. Unsere Experten klären Fragen der Anwendung von Excel, stellen zahlreiche Musterlösungen mit unterschiedlichem Komplexitätsgrad vor und geben Ihnen Tipps für den effizienten Einsatz von Excel. Inhalte: Tabellen und Diagramme empfängergerecht gestalten und einsetzen Auswertungen in Excel optimieren Add-ins wie PowerPivot und Solver effektiv nutzen Einfacher Einstieg in Predictive Analytics mit Excel und R Empfehlungen für den erfolgreichen Excel-Einsatz für Einsteiger und Profis Arbeitshilfen online: Ausführliche Musterlösungen zur schnellen Anwendung

Microsoft Excel 2013 Data Analysis and Business Modeling

Author: Wayne Winston
Publisher: Pearson Education
ISBN: 9780735681071
Release Date: 2014-01-15
Genre: Business & Economics

Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables—and how to effectively build a relational data source inside an Excel workbook. Solve real business problems with Excel—and sharpen your edge Summarize data with PivotTables and Descriptive Statistics Explore new trends in predictive and prescriptive analytics Use Excel Trend Curves, multiple regression, and exponential smoothing Master advanced Excel functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Make your charts more effective with the Power View tool Tame complex optimization problems with Excel Solver Run Monte Carlo simulations on stock prices and bidding models Apply important modeling tools such as the Inquire add-in

Foundations of Predictive Analytics

Author: James Wu
Publisher: CRC Press
ISBN: 9781439869482
Release Date: 2012-02-15
Genre: Business & Economics

Drawing on the authors’ two decades of experience in applied modeling and data mining, Foundations of Predictive Analytics presents the fundamental background required for analyzing data and building models for many practical applications, such as consumer behavior modeling, risk and marketing analytics, and other areas. It also discusses a variety of practical topics that are frequently missing from similar texts. The book begins with the statistical and linear algebra/matrix foundation of modeling methods, from distributions to cumulant and copula functions to Cornish–Fisher expansion and other useful but hard-to-find statistical techniques. It then describes common and unusual linear methods as well as popular nonlinear modeling approaches, including additive models, trees, support vector machine, fuzzy systems, clustering, naïve Bayes, and neural nets. The authors go on to cover methodologies used in time series and forecasting, such as ARIMA, GARCH, and survival analysis. They also present a range of optimization techniques and explore several special topics, such as Dempster–Shafer theory. An in-depth collection of the most important fundamental material on predictive analytics, this self-contained book provides the necessary information for understanding various techniques for exploratory data analysis and modeling. It explains the algorithmic details behind each technique (including underlying assumptions and mathematical formulations) and shows how to prepare and encode data, select variables, use model goodness measures, normalize odds, and perform reject inference. Web Resource The book’s website at www.DataMinerXL.com offers the DataMinerXL software for building predictive models. The site also includes more examples and information on modeling.

Organizational Productivity and Performance Measurements Using Predictive Modeling and Analytics

Author: Tavana, Madjid
Publisher: IGI Global
ISBN: 9781522506553
Release Date: 2016-09-21
Genre: Business & Economics

Businesses are collecting massive amounts of data every day as a way to better understand their processes, competition, and the markets they serve. This data can be used to increase organizational productivity and performance; however, is essential that organizations collecting large data sets have the tools available to them to fully understand the data they are collecting. Organizational Productivity and Performance Measurements Using Predictive Modeling and Analytics takes a critical look at methods for enhancing an organization’s operations and day-to-day activities through the effective use of data. Focusing on a variety of applications of predictive analytics within organizations of all types, this critical publication is an essential resource for business managers, data scientists, graduate-level students, and researchers.

PowerPivot for Business Intelligence Using Excel and SharePoint

Author: Barry Ralston
Publisher: Apress
ISBN: 9781430233817
Release Date: 2011-07-14
Genre: Computers

PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for SharePoint. Data can be pulled in from any of the leading database platforms, as well as from spreadsheets and flat files. PowerPivot for Business Intelligence Using Excel and SharePoint is your key to mastering PowerPivot. The book takes a scenario-based approach to showing you how to collect data, to mine that data through insightful analysis, and to draw conclusions that drive business performance. Each chapter in the book is focused on a specific challenge that you’ll encounter when using PowerPivot. Each chapter takes you through a solution technique that’s been proven in the real world. Covers the leading technology for bringing data analytics to the desktop Presents real-world solutions to real-world scenarios Written by a Microsoft Virtual Technical Specialist (VTS) for business intelligence

Datenanalyse mit Python

Author: Wes McKinney
Publisher: O'Reilly
ISBN: 9783960102144
Release Date: 2018-10-29
Genre: Computers

Erfahren Sie alles über das Manipulieren, Bereinigen, Verarbeiten und Aufbereiten von Datensätzen mit Python: Aktualisiert auf Python 3.6, zeigt Ihnen dieses konsequent praxisbezogene Buch anhand konkreter Fallbeispiele, wie Sie eine Vielzahl von typischen Datenanalyse-Problemen effektiv lösen. Gleichzeitig lernen Sie die neuesten Versionen von pandas, NumPy, IPython und Jupyter kennen.Geschrieben von Wes McKinney, dem Begründer des pandas-Projekts, bietet Datenanalyse mit Python einen praktischen Einstieg in die Data-Science-Tools von Python. Das Buch eignet sich sowohl für Datenanalysten, für die Python Neuland ist, als auch für Python-Programmierer, die sich in Data Science und Scientific Computing einarbeiten wollen. Daten und zugehöriges Material des Buchs sind auf GitHub verfügbar.Aus dem Inhalt:Nutzen Sie die IPython-Shell und Jupyter Notebook für das explorative ComputingLernen Sie Grundfunktionen und fortgeschrittene Features von NumPy kennenSetzen Sie die Datenanalyse-Tools der pandasBibliothek einVerwenden Sie flexible Werkzeuge zum Laden, Bereinigen, Transformieren, Zusammenführen und Umformen von DatenErstellen Sie interformative Visualisierungen mit matplotlibWenden Sie die GroupBy-Mechanismen von pandas an, um Datensätzen zurechtzuschneiden, umzugestalten und zusammenzufassenAnalysieren und manipulieren Sie verschiedenste Zeitreihen-DatenFür diese aktualisierte 2. Auflage wurde der gesamte Code an Python 3.6 und die neuesten Versionen der pandas-Bibliothek angepasst. Neu in dieser Auflage: Informationen zu fortgeschrittenen pandas-Tools sowie eine kurze Einführung in statsmodels und scikit-learn.

Predictive Analytics For Dummies

Author: Dr. Anasse Bari
Publisher: John Wiley & Sons
ISBN: 9781118729410
Release Date: 2014-03-06
Genre: Business & Economics

Combine business sense, statistics, and computers in a new and intuitive way, thanks to Big Data Predictive analytics is a branch of data mining that helps predict probabilities and trends. Predictive Analytics For Dummies explores the power of predictive analytics and how you can use it to make valuable predictions for your business, or in fields such as advertising, fraud detection, politics, and others. This practical book does not bog you down with loads of mathematical or scientific theory, but instead helps you quickly see how to use the right algorithms and tools to collect and analyze data and apply it to make predictions. Topics include using structured and unstructured data, building models, creating a predictive analysis roadmap, setting realistic goals, budgeting, and much more. Shows readers how to use Big Data and data mining to discover patterns and make predictions for tech-savvy businesses Helps readers see how to shepherd predictive analytics projects through their companies Explains just enough of the science and math, but also focuses on practical issues such as protecting project budgets, making good presentations, and more Covers nuts-and-bolts topics including predictive analytics basics, using structured and unstructured data, data mining, and algorithms and techniques for analyzing data Also covers clustering, association, and statistical models; creating a predictive analytics roadmap; and applying predictions to the web, marketing, finance, health care, and elsewhere Propose, produce, and protect predictive analytics projects through your company with Predictive Analytics For Dummies.