Description
Book Synopsis:
A practical guide to data mining using SQL and ExcelData Analysis Using SQL and Excel, 2nd Edition shows you how to leverage the two most popular tools for data query and analysis—SQL and Excel—to perform sophisticated data analysis without the need for complex and expensive data mining tools. Written by a leading expert on business data mining, this book shows you how to extract useful business information from relational databases. You'll learn the fundamental techniques before moving into the "where" and "why" of each analysis, and then learn how to design and perform these analyses using SQL and Excel. Examples include SQL and Excel code, and the appendix shows how non-standard constructs are implemented in other major databases, including Oracle and IBM DB2/UDB. The companion website includes datasets and Excel spreadsheets, and the book provides hints, warnings, and technical asides to help you every step of the way.
Data Analysis Using SQL and Excel, 2nd Edition shows you how to perform a wide range of sophisticated analyses using these simple tools, sparing you the significant expense of proprietary data mining tools like SAS.
- Understand core analytic techniques that work with SQL and Excel
- Ensure your analytic approach gets you the results you need
- Design and perform your analysis using SQL and Excel
Data Analysis Using SQL and Excel, 2nd Edition shows you how to best use the tools you already know to achieve expert results.
Details
Are you looking for a practical and cost-effective solution for data analysis? Look no further! Data Analysis Using SQL and Excel is the ultimate guide for leveraging two of the most popular tools in the industry. With this book, you can perform sophisticated data analysis without the need for complex and expensive data mining tools. Written by a leading expert on business data mining, you'll learn how to extract valuable insights from relational databases.
Whether you're a beginner or an experienced analyst, this book has got you covered. Starting with the fundamentals, you'll quickly become familiar with the core analytic techniques that work seamlessly with SQL and Excel. From there, you'll dive into the "where" and "why" of each analysis, learning how to design and execute them effectively. With SQL and Excel code examples, you'll be able to put your newfound knowledge into practice right away.
Worried about compatibility? Don't be! The companion website provides datasets and Excel spreadsheets, and the appendix even shows you how non-standard constructs are implemented in other major databases such as Oracle and IBM DB2/UDB. Plus, the book includes hints, warnings, and technical asides to guide you at every step of the way.
Why spend a fortune on proprietary data mining tools like SAS when you have the tools you already know at your disposal? Data Analysis Using SQL and Excel, 2nd Edition empowers you to achieve expert-level results using the tools you're already familiar with. So why wait? Start unlocking valuable business insights today.
Click here to get your copy of Data Analysis Using SQL and Excel, 2nd Edition and take your data analysis skills to the next level!
Discover More Best Sellers in Databases & Big Data
Shop Databases & Big Data
Organizational Planning and Analysis: Building the Capability to Secure Business Performance
Databases & Big Data - Organizational Planning and Analysis: Building the Capability to Secure Business Performance
Speak Data: Artists, Scientists, Thinkers, and Dreamers on How We Live Our Lives in Numbers
Databases & Big Data - Speak Data: Artists, Scientists, Thinkers, and Dreamers on How We Live Our Lives in Numbers
Databases & Big Data - Bioinformatics with Python Cookbook: Use modern Python libraries and applications to solve real-world computational biology problems, 3rd Edition
Databases & Big Data - Data Engineering with AWS: Acquire the skills to design and build AWS-based data transformation pipelines like a pro
Blockchain Basics: A Non-Technical Introduction in 25 Steps
Databases & Big Data - Blockchain Basics: A Non-Technical Introduction in 25 Steps
Databases & Big Data - Mastering Transformers: Build state-of-the-art models from scratch with advanced natural language processing techniques
Mastering Access 365: An Easy Guide to Building Efficient Databases for Managing Your Data
Databases & Big Data - Mastering Access 365: An Easy Guide to Building Efficient Databases for Managing Your Data
