Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Free Learning

You're reading from Hands-On Machine Learning with Microsoft Excel 2019 Build complete data analysis flows, from data collection to visualization

Product type Paperback

Published in Apr 2019

Publisher Packt

ISBN-13 9781789345377

Length 254 pages

Edition 1st Edition

Tools

Excel

Concepts

Data Analysis

Author (1):

Julio Cesar Rodriguez Martino

View More author details

Table of Contents (17) Chapters

Preface

1. Section 1: Machine Learning Basics FREE CHAPTER

2. Implementing Machine Learning Algorithms

3. Hands-On Examples of Machine Learning Models

4. Section 2: Data Collection and Preparation

5. Importing Data into Excel from Different Data Sources

6. Data Cleansing and Preliminary Data Analysis

7. Correlations and the Importance of Variables

8. Section 3: Analytics and Machine Learning Models

9. Data Mining Models in Excel Hands-On Examples

10. Implementing Time Series

11. Section 4: Data Visualization and Advanced Machine Learning

12. Visualizing Data in Diagrams, Histograms, and Maps

13. Artificial Neural Networks

14. Azure and Excel - Machine Learning in the Cloud

15. The Future of Machine Learning

16. Assessment

Questions

How can the unexplainable, random associations be avoided in a Market Basket Analysis?
If we find a correlation between two products or two departments in a given store, can this be generalized to other places?
Some columns in the cohort matrix show zeroes starting at a given date. What does this mean in the context of the current dataset?
The last rows in the cohort matrix show zero consistently. What does this mean in the context of the current dataset?
How would you maximize the amount of money spent by customers as time passes?

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (1)

Cesar Rodriguez Martino

Julio Cesar Rodriguez Martino is a machine learning (ML) and artificial intelligence (AI) platform architect, focusing on applying the latest techniques and models in these fields to optimize, automate, and improve the work of tax and accounting consultants. The main tool used in this practice is the MS Office platform, which Azure services complement perfectly by adding intelligence to the different tasks. Julio's background is in experimental physics, where he learned and applied advanced statistical and data analysis methods. He also teaches university courses and provides in-company training on machine learning and analytics, and has a lot of experience leading data science teams.

See other products by Cesar Rodriguez Martino