Data Analysis Using SQL and Excel at Dominant Systems Book Store

Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like.

Customer Reviews & Comments
"Data Analysis Using SQL and Excel" is an valuable resource for business intelligence and data mining practitioners in all industries. Having said that, I would like to offer some solid practical advice to potential readers that might not be fluent in statistics or data mining. First, the reader should have a solid understanding of SQL. If the extent of your SQL interaction comes through a program on the level of Access, then you can still benefit from this book, but you will have to apply yourself more than others. Keep in mind, that proprietary releases of SQL might cause problems in directly translating the author's examples. Second, if your statistics knowledge is a little rusty, have a secondary resource on-hand. Sometimes the definitions or explanations of the statistical concepts may not be as intuitive for some readers as they are for others. With those caveats in mind, the reader need only to keep his or her patience and work through the concepts of the first 4-5 chapters. These chapters tend toward simple exposition of the concepts. For those with little patience, it may seem as if it is just a laundry list of concepts with little effort to tie those concepts into practical uses. Thinking like this is a great way to miss the enormous benefits of the book! For me, the "Ah Ha!" moment came in Chapter 6 and 7. The concepts I had worked on in the previous chapters suddenly came together with customer tenure onward, when the techniques use will call to mind everything learned in the previous chapters. In short, spend plenty of time in the first few chapters - the extra effort to master those concepts will only enhance the benefits of later chapters. Lastly, there are a few odd differences between the text and the files downloadable from the web site. Whenever I hit a snag based on the text, opening the accompanying Excel files and seeing the formulas, queries or table/graph structures resolved all issues for me. This is a text that will always have a place on my shelves.

Back To Top