Book Image

Data Analysis and Business Modeling with Excel 2013

Book Image

Data Analysis and Business Modeling with Excel 2013

Overview of this book

Table of Contents (18 chapters)
Data Analysis and Business Modeling with Excel 2013
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
10
Creating Interactive Spreadsheets Using Tables and Slicers
Index

Summary


The sections in this chapter were designed to teach you how to connect to a Microsoft SQL Server database using Excel's data connection tools. You will be able to gather data from one or many tables in a database. We also covered how to leverage SQL and selectively pull just the data we are looking for into Excel. In the next chapter, we will get acquainted with the next stage of the data analysis life cycle, that is, preparing your data.