• Complain

David Rojas - Data Analysis and Business Modeling with Excel 2013

Here you can read online David Rojas - Data Analysis and Business Modeling with Excel 2013 full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2015, publisher: Packt Publishing, genre: Home and family. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:

Romance novel Science fiction Adventure Detective Science History Home and family Prose Art Politics Computer Non-fiction Religion Business Children Humor

Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.

David Rojas Data Analysis and Business Modeling with Excel 2013
  • Book:
    Data Analysis and Business Modeling with Excel 2013
  • Author:
  • Publisher:
    Packt Publishing
  • Genre:
  • Year:
    2015
  • Rating:
    5 / 5
  • Favourites:
    Add to favourites
  • Your mark:
    • 100
    • 1
    • 2
    • 3
    • 4
    • 5

Data Analysis and Business Modeling with Excel 2013: summary, description and annotation

We offer to read an annotation, description, summary or preface (depends on what the author of the book "Data Analysis and Business Modeling with Excel 2013" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.

Manage, analyze, and visualize data with Microsoft Excel 2013 to transform raw data into ready to use informationAbout This Book

  • Create formulas to help you analyze and explain findings
    • Develop interactive spreadsheets that will impress your audience and give them the ability to slice and dice data
    • A step-by-step guide to learn various ways to model data for businesses with the help of Excel 2013

      Who This Book Is For

      If you want to start using Excel 2013 for data analysis and business modeling and enhance your skills in the data analysis life cycle then this book is for you, whether youre new to Excel or experienced.What You Will Learn

    • Discover what Excel formulas are all about and how to use them in your spreadsheet development
    • Identify bad data and learn cleaning strategies
    • Create interactive spreadsheets that engage and appeal to your audience
    • Leverage Excels powerful built-in tools to get the median, maximum, and minimum values of your data
    • Build impressive tables and combine datasets using Excels built-in functionality
    • Learn the powerful scripting language VBA, allowing you to implement your own custom solutions with ease

      In Detail

      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. Youll learn the basics of SQL syntax and how to connect it to a Microsoft SQL Server Database using Excels data connection tools. You will discover how to spot bad data and strategies to clean that data to make it useful to you. Next, youll learn to create custom columns, identify key metrics, and make decisions based on business rules. Youll create macros using VBA and use Excel 2013s shiny new macros. Finally, at the end of the book, youll be provided with useful shortcuts and tips, enabling you to do efficient data analysis and business modeling with Excel 2013.Style and approach

      This is a step-by-step guide to performing data analysis and business modelling with Excel 2013, complete with examples and tips.

  • David Rojas: author's other books


    Who wrote Data Analysis and Business Modeling with Excel 2013? Find out the surname, the name of the author of the book and a list of all author's works by series.

    Data Analysis and Business Modeling with Excel 2013 — read online for free the complete book (whole text) full work

    Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Data Analysis and Business Modeling with Excel 2013" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

    Light

    Font size:

    Reset

    Interval:

    Bookmark:

    Make
    Data Analysis and Business Modeling with Excel 2013

    Data Analysis and Business Modeling with Excel 2013

    Copyright 2015 Packt Publishing

    All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

    Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

    Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

    First published: October 2015

    Production reference: 1191015

    Published by Packt Publishing Ltd.

    Livery Place

    35 Livery Street

    Birmingham B3 2PB, UK.

    ISBN 978-1-78528-954-5

    www.packtpub.com

    Credits

    Author

    David Rojas

    Reviewers

    Skanda Bhargav

    Manoj Kumar

    Rajesh S

    Kimberly J. E. Williamson

    Commissioning Editor

    Veena Pagare

    Acquisition Editor

    Sonali Vernekar

    Content Development Editor

    Parita Khedekar

    Technical Editor

    Madhunikita Sunil Chindarkar

    Copy Editor

    Rashmi Sawant

    Project Coordinator

    Milton Dsouza

    Proofreader

    Safis Editing

    Indexer

    Hemangini Bari

    Production Coordinator

    Shantanu N. Zagade

    Cover Work

    Shantanu N. Zagade

    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.

    About the Reviewers

    Skanda Bhargav is an engineering graduate from Visvesvaraya Technological University (VTU) in Belgaum, Karnataka, India. He did his major in computer science engineering. He is a Cloudera-certified developer in Apache Hadoop. His interests are big data and Hadoop.

    He is the author of the book Troubleshooting Ubuntu Server , Packt Publishing . He has been a reviewer for the following books and videos:

    • Building Hadoop Clusters
    • Hadoop Cluster Deployment
    • Instant Map Reduce Patterns Hadoop Essentials How-to [Instant]
    • Cloudera Administration Handbook
    • Hadoop Map Reduce v2 Cookbook Second Edition
    • Hadoop Backup and Recovery Solutions

    I would like to thank my family for their immense support and faith in me throughout my learning stage. My friends have brought the confidence in me to a level that makes me bring the best out of myself. I am happy that god has blessed me with such wonderful people around me, without whom, my success as it is today would not have been possible.

    Manoj Kumar holds a degree of bachelor of technology in mining and machinery engineering from the Indian School of Mines, an executive MBA degree in finance and operations from ICFAI and is certified in data science from the Johns Hopkins University. He has over 13 years of work experience in mining, cement, and other industries in multiple countries. Currently, he is working as a subject matter expert and data scientist for Cyient Insights, a data science division of Cyient Ltd. He uses part of data science to perform statistical analysis on domain-specific data (such as sensor and other high frequency, structured and unstructured both, and so on). In order to arrive at conclusions that add value to the business and help in decision making, he focuses on the development and application of high-end mathematical modeling/algorithm of big data, generated by industries (for example, mining and manufacturing).

    Rajesh S is a management professional and graduate in computer science. He has over a decade of experience in retail MNCs. His skills include data analysis and its presentation.

    He has a website that helps, guides, and enriches a lot of professionals who vouch for his excellent coaching through his "Excelhours", a personal coaching program (Microsoft Excel).

    I am grateful to the almighty god for his grace and mercy that has bought me this far and made me the person I am today. I would like to thank my wife Jyoti, who has helped and supported me throughout all my ups and downs in life.

    Kimberly J. E. Williamson is a home-grown data analyst with experience in financial and budget analysis, business tax management, commercial lease analysis, and administration, among other areas. Having built a reputation for proactively learning whatever is needed to excel in her business or personal projects, she loves diving into data and wrangling it into an intelligent form as well as creating best practice processes for the creation, management, and usability of data.

    Kimberly often self-contracts financial or data analysis work through her own company, Strategic Resource Development, LLC, and financially manages this company as well as her husband's company, Sophos, LLC, which owns rental properties. She has worked in a diverse array of environments, such as nonprofit, medical property management, the private loan market, banking, engineering, project management, and so on.

    Although this is the first time she has been formally asked to provide a technical review, in the past she has contributed heavily to the creation and editing of complex in-house accounting and data management procedural guides for commercial lease management.

    I'd like to thank both Jesus Christ and Packt Publishing for giving me the opportunity to explore this new avenue to use my skills (and learn some new ones) as a technical reviewer of this book.

    www.PacktPub.com
    Support files, eBooks, discount offers, and more

    For support files and downloads related to your book, please visit www.PacktPub.com.

    Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at > for more details.

    At www.PacktPub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters and receive exclusive discounts and offers on Packt books and eBooks.

    httpswww2packtpubcombookssubscriptionpacktlib Do you need instant - photo 1
    Next page
    Light

    Font size:

    Reset

    Interval:

    Bookmark:

    Make

    Similar books «Data Analysis and Business Modeling with Excel 2013»

    Look at similar books to Data Analysis and Business Modeling with Excel 2013. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.


    Reviews about «Data Analysis and Business Modeling with Excel 2013»

    Discussion, reviews of the book Data Analysis and Business Modeling with Excel 2013 and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.