Showing posts with label analytics. Show all posts
Showing posts with label analytics. Show all posts

3/07/2012

Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables Review

Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables
Average Reviews:

(More customer reviews)
The third updated edition of Microsoft Excel Data Analysis offers an excellent visual approach to professional-level computer instruction in Excel, and uses web-based applications as keys to creating formulas, working with functions, performing predictions, automating Excel with macros, and adding color and customizing results. No Excel collection should be without this!


Click Here to see more reviews about: Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables

Advanced techniques for Excel power users
Crunch and analyze Excel data the way the professionals do with this clean, uncluttered, visual guide to advanced Excel techniques. Using numerous screenshots and easy-to-follow numbered steps, this book clearly shows you how to perform professional-level modeling, charting, data access, data slicing, and other functions. You'll find super techniques for getting the most out of Excel's statistical and financial functions, Excel PivotTables and PivotCharts, Excel Solver, and more.
Provides a clear look at power-using Excel, the world's leading spreadsheet application from Microsoft, and part of the new Microsoft Office 2010 suite
Expands your Excel knowledge and helps you use Excel data more efficiently
Demonstrates how to retrieve data from databases;; cut, slice, and pivot data using PivotTables; model data and chart data; and use advanced formulas
Explores all features and functions in friendly, two-color pages packed with screenshots, numbered steps, and other visual graphics that clearly show you how to accomplish tasks
Includes practical examples, tips, and advice to help you get the most out of Excel's features and functions

Learn Excel at the highest levels with this practical guide.

Buy NowGet 34% OFF

Click here for more information about Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables

Read More...

9/18/2011

Predictive Modeling with SAS Enterprise Miner: Practical Solutions for Business Applications Review

Predictive Modeling with SAS Enterprise Miner: Practical Solutions for Business Applications
Average Reviews:

(More customer reviews)
Excellent book with detailed illustration of steps using Eminer. Great for users of Eminer with understanding of data mining methods.

Click Here to see more reviews about: Predictive Modeling with SAS Enterprise Miner: Practical Solutions for Business Applications

Predictive Modeling with SAS Enterprise Miner: Practical Solutions for Business Applications demonstrates how to make the fullest use of SAS Enterprise Miner software. Kattamuri Sarma provides an in-depth explanation of the methodology and the theory behind each tool that he covers, and then shows you how the software performs the tasks. Step by step, you'll be able to compare manual calculations with the calculations that are performed by SAS Enterprise Miner. Examples from the insurance and banking industries are based on simulated, but realistic, data. The approaches discussed in this book are relevant to any industry.
Here are a few of the topics discussed in detail:
data collection and data cleaning
data exploration
decision trees and regression trees
logistic regression models
neural networks
variable selection and variable transformation

You need this book if you are a graduate student interested in predictive modeling, an expert in data mining who is not familiar with SAS Enterprise Miner, or a business analyst who needs an introduction to predictive modeling using SAS Enterprise Miner. To get the most from this book, you should be familiar with elements of statistical inference and probability, simple algebra, ordinary least squares, logistic regression, and Base SAS software.

Buy NowGet 17% OFF

Click here for more information about Predictive Modeling with SAS Enterprise Miner: Practical Solutions for Business Applications

Read More...

8/02/2011

Next Generation Excel: Modeling in Excel for Analysts and MBAs (Wiley Finance) Review

Next Generation Excel: Modeling in Excel for Analysts and MBAs (Wiley Finance)
Average Reviews:

(More customer reviews)
I heartily recommend this book to anyone that uses Excel on a daily basis for business analysis or for MBA students. Early in the introduction, Dr. Gottlieb promises that if you use Excel for 10 hours a week or more, this book will save you hundreds of hours per year. He delivers!
You don't need to build an excel spreadsheet to calculate that this book is worth many times its cover price to users of excel. Even if you are a "power user" you will quiclky find tips that will make you more efficient.
I was fortunate enough to take an Excel class from Dr. Gottlieb a few years ago during the "crash math course" week while getting an MBA at Columbia University. I don't want to offend any of my esteemed professors, but those few hours with Dr. Gottlieb were probably more useful than several of my semester-long courses to me. I currently use Excel for 3-4 hours per day to analyze stocks at my hedge fund and his tips have saved me hours and helped to make my graphical representation of data look top-notch.
This book is not a basic "how-to" or "for dummies" book on Excel. It is the perfect book for you if you use Excel frequently, but are frustrated that you have to perform certain repetitive keystrokes or clicks to get it do what you want. Perhaps you want your charts to look better. Maybe you didn't even know that you could have custom lists built in, for example, instead of manually entering FQ01, FQ02, etc. You can add trend lines to graphs; you can format parts of graphs differently than other parts. You can name cells, groups of cells to make your work easier.
Dr. Gottlieb exposes the many keystroke shortcuts that can make your daily grind with Excel less laborious. His book is laid out in a very concise, neat organization. I think the best way to really benefit from it is to power through entire sections that apply to your work and try his examples. He provides some problems at the end of each chapter (he is in academia, after all) but mercifully; he provides the answers, too!
This book is only about 280 pages long, but don't let that fool you, if you compare it to some other Excel books with 800 pages. He has more time-saving information in it than books 2 or 3 times as long. The beauty of his book is everything he shows is something an analyst using Excel in the real world actually uses it for. He is not just running through every menu, detailing every useless capability of Excel, like the other books.
This is the key advantage to Dr. Gottlieb's book. He has a list of over 50,000 people that he sends his "tip of the month" to and they (like me) are not shy about emailing him questions. This gives him keen insight into what real Excel jockeys are interested in, and he addresses those issues in this book. Get it today and you will discover many things that Excel can do for you, in a much easier way than you are using it today!

Click Here to see more reviews about: Next Generation Excel: Modeling in Excel for Analysts and MBAs (Wiley Finance)

Dr. Isaac Gottlieb personally trained 35 of our top analysts and finance professionals in a customized advanced Excel seminar. Many of the tools covered in this book were part of this well-received training. For the past five years, Isaac's monthly Excel-Tip-Of-The-Month newsletter has been a personal favorite of mine. In an age where email overload is common, I always look forward to his email and many of my associates and team members around the world are part of his over 50,000 monthly recipients. This compilation is a must-have for any finance professional who wants to be a better business partner and truly add value in a more efficient manner!
Anthony N. Caspio, CMAVice President - FinanceSealed Air Corporation
Excel has been one of the most powerful applications of recent times, but most users, unfortunately, only scratch its surface. Prof. Gottlieb's book leverages his years of Excel workshops in the US, Europe and Asia, and he unleashes the tremendous potential and power of Excel. His to-the-point explanations and his innovative screenshots bring Excel alive to readers who may just have a working knowledge of the software. This amazing volume is an application-oriented book for Excel users who want answers fast, and who need to maximize the application's awesome potential.
Prof. Farrokh Langdana, Ph.D.Director, Rutgers Executive MBAProfessor, Rutgers Business School
If I should thank Microsoft for inventing Excel, then I would like to thank Dr. Isaac Gottlieb more for teaching me how to use it to solve the real problems in my real work. Keep going Isaac!
Wu HaowenDirector of International ProgramsSchool of Management, Dalian University of Technology
Isaac Gottlieb's Next Generation Excel is an invaluable resource. The fruit of many years of teaching Excel to university business students, Gottlieb's book covers the topics that the Excel user needs to become more efficient and sophisticated. It is easy to read and follow. A wonderful book!
Simon BenningaProfessor of Finance, Faculty of Management, Tel Aviv UniversityAuthor of Principles of Finance with Excel
As an avid user of Excel, several years ago I came across Isaac's Excel-Tip-Of-The-Month newsletter. I quickly realized that Isaac exploits Excel to the "next usability level." Like his monthly newsletters, Isaac has composed a book that is clear and concise similarly reflecting his teaching methods. This book helps intermediate users to rapidly acquire Excel-pro skills, while allowing advanced users to grasp concepts in one single pass-through. Furthermore, Isaac takes day-to-day challenges and provides elegant ease of use solutions.
Moshe CastielManager, IT – Technology & OperationsTIAA-CREF
Next Generation Excel presents an interesting perspective on the resourcefulness of Microsoft Excel like never before. This book is an excellent and a much-needed resource to MBA students, educators and Excel enthusiasts. In reviewing this book, the principal criteria included content, organization and Excel add-on files. The book is neatly organized into sections; starting with basic Excel tools and functions, commonly used statistical tools, what-if-analysis and then moving on to advanced data features, solver-add ins and various other ToolPaks, nicely complemented with the Excel snapshots to provide a user friendly experience. As a result, one can jump directly to the relevant sections and use the Excel files provided to get a more hands-on experience. The right mix of theory and practice, is the unique selling point (USP) of this book!
Anirudha "Andy" Vaidya, MBACEOAVS System

Buy NowGet 37% OFF

Click here for more information about Next Generation Excel: Modeling in Excel for Analysts and MBAs (Wiley Finance)

Read More...

8/01/2011

Corporate Valuation Modeling: A Step-by-Step Guide (Wiley Finance) Review

Corporate Valuation Modeling: A Step-by-Step Guide (Wiley Finance)
Average Reviews:

(More customer reviews)
There are many different variations on the basic DCF valuation model. Every bank has one, every business school has one, and everyone modifies it for their own purposes.
Keith's book offers some distinct advantages: (1) It actually walks you through the steps of building the model, instead of simply typing the inputs into one. This will ensure you understand it, but it might take some time to build it. (The full model is included for people who want to skip the typing). (2) Secondly, it is a "full blown" model and not a simplified version of one. While the first is common, and the second is common, the combination is (in my experience) uncommon.
More interestingly, (3) this model is more advanced than most of the others out there. The primary improvement is he has more "checks and balances" thrown in. The model has little checks that make sure cash ties through, that the extra cash pays off the debt, that capital expenditures are accounted for and that their depreciation pours through the income statement etc. This is invaluable. It does make it complicated, and sometimes I had circular references that were hard to fix, but this just forced me to deal with what was really going on in the model.
All in all, nicely done.

Click Here to see more reviews about: Corporate Valuation Modeling: A Step-by-Step Guide (Wiley Finance)

A critical guide to corporate valuation modeling
Valuation is at the heart of everything that Wall Street does. Every day, millions of transactions to purchase or sell companies take place based on prices created by the activities of all market participants. In this book, author Keith Allman provides you with a core model to value companies.
Corporate Valuation Modeling takes you step-by-step through the process of creating a powerful corporate valuation model. Each chapter skillfully discusses the theory of the concept, followed by Model Builder instructions that inform you of every step necessary to create the template model. Many chapters also include a validation section that shows techniques and implementations that you can employ to make sure the model is working properly.
Walks you through the full process of constructing a fully dynamic corporate valuation model
A Tool Box section at the end of each chapter assists readers who may be less skilled in Excel techniques and functions

Complete with a companion CD-ROM that contains constructed models, this book is an essential guide to understanding the intricacies of corporate valuation modeling.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Buy NowGet 37% OFF

Click here for more information about Corporate Valuation Modeling: A Step-by-Step Guide (Wiley Finance)

Read More...

7/28/2011

Management Science: The Art of Modeling with Spreadsheets Review

Management Science: The Art of Modeling with Spreadsheets
Average Reviews:

(More customer reviews)
This book takes time to adjust to the crowded typesetting first. Then it gets more interesting as you read more of it. The authors know the subject in depth as well as breath. One problem I have with my students is that many of them do not have the quantitative background required of the book, but the level of the book is what we should aim for in the future. We have to raise the level of our education. The book is well written except for some expected typos for a new edition.

Click Here to see more reviews about: Management Science: The Art of Modeling with Spreadsheets

Now in its third edition, Management Science helps business professionals gain the essential skills needed to develop real expertise in business modeling. The biggest change in the text is the conversion of software from Crystal Ball to Risk Solver to reflect changes in the field. More coverage of management science topics has been added. Broader coverage of Excel demonstrates how to create models. Additional open-ended case studies that are less structured have also been included along with new exercises. These changes will help business professionals learn how to apply the information in the field.

Buy Now

Click here for more information about Management Science: The Art of Modeling with Spreadsheets

Read More...

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Bpg -- Other) Review

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Bpg -- Other)
Average Reviews:

(More customer reviews)
Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Bpg -- Other)
This book should be on the desk of anyone analyzing data. It IS NOT for someone who doesn't know Excel 2007 and the basics of analyzing or working with data.
However, I've gone through Chapter 39 and have found this book is filled with all kinds of errors. I couldn't find any place on the internet that addresses these errors. Files missing or wrong (ie. Chapter 9 solution file problem numbers are incorrect), examples not matching my Office, Home, Student 2007 version (ie. pg. 43 references a DATEIF function that doesn't exist), plus many more.
The author or Microsoft needs to do a better job of proofreading or at least have a website where readers can post the errors they find so everybody using this book doesn't spend their time refinding the same errors.

Click Here to see more reviews about: Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Bpg -- Other)


Master the analysis and business modeling techniques that help you transform your data into bottom-line results. Award-winning business professor and corporate consultant Wayne Winston shares the best of his real-world experience in this practical guide—now updated for Excel 2007. Use Wayne's proven practices and hands-on exercises to help you work smarter, make better decisions, and gain the competitive edge.

Solve real-world business problems with Excel 2007!

Maximize profits—determine NPV, optimize your product mix, calculate ROI
Create best, worst, and most-likely case scenarios for sales
Analyze investment performance and help minimize risk
Track your personal finances, calculate loan terms, and plan for retirement
Use trend and seasonality to forecast revenue
Estimate a product's demand curve and manage inventory with precision Interpret the effects of price and advertising on sales
Assign a dollar value to customer loyalty
Solve work scheduling problems and shorten wait times for customer service queues
PLUS—predict outcomes of sporting events, presidential elections, and more!

CD Includes:

Sample files from each chapter
Problem-and-solution sets—build your expertise!
Fully searchable eBook

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.


Buy NowGet 40% OFF

Click here for more information about Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Bpg -- Other)

Read More...