Data Analysis and Business Modeling with Excel 2013

by David Rojas

Overview

Excel 2013 is one of the easiest to use data analysis tools you will ever come across. Its simplicity and powerful features has made it the go to tool for all your data needs. Complex operations with Excel, such as creating charts and graphs, visualization, and analyzing data make it a great tool for managers, data scientists, financial data analysts, and those who work closely with data. Learning data analysis and will help you bring your data skills to the next level.

This book starts by walking you through creating your own data and bringing data into Excel from various sources. You'll learn the basics of SQL syntax and how to connect it to a Microsoft SQL Server Database using Excel's data connection tools. You will discover how to spot bad data and strategies to clean that data to make it useful to you. Next, you'll learn to create custom columns, identify key metrics, and make decisions based on business rules. You'll create macros using VBA and use Excel 2013's shiny new macros. Finally, at the end of the book, you'll be provided with useful shortcuts and tips, enabling you to do efficient data analysis and business modeling with Excel 2013.

Product Details

ISBN-13:	9781785289545
Publisher:	Packt Publishing
Publication date:	10/22/2015
Pages:	226
Product dimensions:	7.50(w) x 9.25(h) x 0.48(d)

About the Author

David Rojas is a data enthusiast and Python evangelist. Currently, he is enjoying his time as a consultant in the data world. He lives in the Silicon Valley and is active within the data community. After receiving a degree from the University of Florida as an industrial and systems engineer and obtaining a minor in sales engineering, he received his state license as an engineer in training. Soon thereafter, he pursued a career change to the IT world as a data analyst and discovered his passion for data using various tools in order to manage and analyze data in a better way. After many years of working in a wide range of odd data roles, such as reporting, gathering requirements, writing documentation, working with databases, and working with flat files, he decided to make his love for data a reality and started his own business (www.hedaro.com). You will often find his work being cited by various professors and other data enthusiasts around the Bay Area.