My Data Analysis and Machine Learning Portfolio

 I analyzed my collection of books on the site goodreads.com. I did this using Excel. I used functions and Power Query to clean the data. I used Pivot Tables, Pivot Charts, and Splicers to visualize the data. The data was downloaded from goodreads.com as a csv file. I first checked for, and removed, any duplicate books.  You can expand the pics below by clicking on them.  Power Query At the site goodreads.com, books are placed into categories called "Bookshelves". Each book is placed by default into a "read" Bookshelf or a "to-read" Bookshelf. Each book can also be placed into additional Bookshelves created by the user. Below is an example (screenshot), for one book, from the Bookshelves column: I used Power Query to separate that cell into 4 columns: I  did the same to split the Author column (not shown) into 2 columns: Last Name and First Name. Functions The Default GR Shelf and the Main Shelf columns (seen above) were used for the visualizations. I use...