Neil PatelHistograms and Box PlotsHistograms show us a distribution of values by frequency. We can specify the number of bins we want the histogram to display. In the code…Feb 21, 2019Feb 21, 2019
Neil PatelBar Plots / Scatter PlotsVisualizing data is key in gaining insight into where to dig deeper as well as to see whether correlations appear. In the below, using…Feb 20, 2019Feb 20, 2019
Neil PatelTableau — Sorting, Filtering, Formatting Data — S&P 1000 CompaniesSome Tableau notes before we start:Feb 1, 2019Feb 1, 2019
Neil PatelTableau — Hierarchies and GroupsHierarchies are logical relationships between categories such as Country, State, City. Groups are selections of attributes that you may…Jan 31, 2019Jan 31, 2019
Neil PatelTableau — Joining Data — GoT ProjectWe have two Game of Thrones datasets — one from the TV series and one from the books. Both have information on character deaths and we…Jan 31, 2019Jan 31, 2019
Neil PatelTableau — NYC Data Science AcademyI have done some work with Tableau before, but I am taking the Tableau course with NYC Data Science Academy to go in-depth on Tableau.Jan 30, 2019Jan 30, 2019
Neil PatelStatistics Project — WNBAUsing the dataset located at https://www.kaggle.com/jinxbe/wnba-player-stats-2017, we can run summary statistics on the data and pretty…Jan 25, 2019Jan 25, 2019
Neil PatelProbability and Statistics — GeneralDataquest has so far taught us how to perform basic data analysis and data visualization.Jan 25, 2019Jan 25, 2019
Neil PatelProject — Complex Query on SpendNow we want to find the customer from each country that has spend the most money at our store.Jan 24, 2019Jan 24, 2019
Neil PatelMultiple Views and some complex SQL queriesIn combining views, we can’t simply use JOINs (which JOIN columns). Instead we use UNION.Jan 23, 20191Jan 23, 20191