Decision Analytics: Microsoft Excel Conrad Carlberg
Publisher: Que

Mar 18, 2014 - Tom: It's important to understand what decision is being made with the analytics and how precise the answer has to be. Winston, this practical resource shows you how to tap a simple and cost-effective tool, Microsoft Excel, to solve specific business problems using powerful analytic techniques—and achieve optimum results. Introducing Decision Trees 403. May 14, 2014 - The ideal candidate will have experience preparing executive level presentations as well as the ability to perform rigorous data analysis in Excel or other analytic platforms. Microsoft has enabled all kinds of analytic functions in Excel – chi-square, z-test, etc. Marc: My view is that, like it or not, Excel is here to stay. Excel has continued to evolve in ways Now in the age of Business Intelligence (BI), analytics, and big data, Excel continues to remain relevant as Independent Software Vendors (ISVs) build BI tools as add-ins to the spreadsheet platform. Constructing a Decision Tree 404. 25 Using Classification Trees for Segmentation 403. Tom: In my opinion, Excel is here to stay. Chris Albright's VBA FOR MODELERS, 4TH EDITION is an crucial tool for assisting you learn to This is easily the best book I have ever seen on learning and using VBA for Excel. VII Forecasting New Product Sales 413. Aug 24, 2012 - NodeXL, a free third party add-in, turns excel into a powerful Social Network Analysis (SNA) tool which allows you to do a comprehensive analysis of social network data in the form of network maps. Solver can be massively useful in supporting planning or strategy as it can automatically vary your input decision cells thousands of times subject to whatever constraints you specify until it finds the optimum value of a specified cell (e.g. Oct 17, 2013 - For an operations manager the two limitations have resulted in endless extraction of data from canned transactional reports and manipulation on spreadsheet tools like Microsoft Excel. Then align the precision of the data with the required . Jan 15, 2014 - Written by data analysis expert Wayne L. If not, how do we move beyond it? 6 days ago - VBA for Modelers: Developing Decision Help Systems (with Microsoft Office Excel Printed Access Card) Quick Description. €� and I suspect they will only add more. Unlike the “Dummies” series, this book is geared more towards those with operational or analytic inclinations (not just simply formatting or automating a spreadsheet). May 23, 2014 - Part of that has to do with Microsoft's ubiquity and consistent success, but another significant part of Excel's popularity is directly related to the easy-to-use interface, formulas, and formatting.