All the data you need.

Tag: Tutorial

✚ How to Make Small Multiples in Excel
Also known as trellis charts, lattice chart, or whatever you want to call them, the technique lets you compare several categories in one view.Tags: Excel
SQL Tutorial: Selecting Ungrouped Columns Without Aggregate Functions
When is a SQL query that returns the correct answer actually wrong? In this tutorial, we're going to take a close look at a very common mistake. It's one that will actually return the right answer, but it's still a mistake that's important to avoid.That probably sounds rather mysterious, so …
✚ How to Make an Animated Beeswarm Chart
Beeswarm charts are useful to highlight individual categories or entities. Animating them can help highlight change over time.Tags: animation, d3js
Data Teams Unite! Countdown to Data + AI Summit Europe
Data + AI Summit 2020 Europe takes place virtually in just a few days,from 17-19 November – and it’s free to attend! Formerly known as Spark + AI Summit, Data + AI Summit will bring together thousands of data teams to learn from practitioners, leaders, innovators and the original creators …
✚ How to make Marimekko Charts in Excel
Marimekko charts, or mosaic plots, allow you to compare categories over two quantitative variables. Tags: Excel
Beginner Python Tutorial: Analyze Your Personal Netflix Data
How much time have you spent watching The Office on Netflix? Find out with this entry-level tutorial on analyzing your own Netflix usage data! The post Beginner Python Tutorial: Analyze Your Personal Netflix Data appeared first on Dataquest.
✚ How to Make Symbol-based Glyph Charts, with R Examples
Using geometric shapes as an encoding can provide another dimension to your charts.Tags: R
✚ How to Make a Heatmap in Excel
Heatmaps quickly translate data tables into a visual form, making them a great tool to explore a new dataset.Tags: Excel
Data Visualization in R with ggplot2: A Beginner Tutorial
A famous general is thought to have said, “A good sketch is better than a long speech.” That advice may have come from the battlefield, but it's applicable in lots of other areas — including data science. "Sketching" out our data by visualizing it using ggplot2 in R is more …
✚ How to Untangle a Spaghetti Line Chart (with R Examples)
Put multiple time series lines on the same plot, and you quickly end up with a mess. Here are practical ways to clean it up.Tags: R
Do You Post Too Much? Analyze Your Personal Facebook Data with Python
As of Q2 2020, Facebook claims more than 2.7 billion active users. That means that if you're reading this article, chances are you're a Facebook user. But just how much of a Facebook user are you? How much do you really post? We can find out using Python! Specifically, we're …
✚ How to Make a Customized Excess Mortality Chart in Excel
Show current evolution against expected historical variability and add one or more series that could account for the difference.Tags: Excel
Tidyverse Basics: Load and Clean Data with R tidyverse Tools
Messy datasets are everywhere. If you want to analyze data, it’s inevitable that you will need to clean data. In this tutorial, we're going to take a look at how to do that using R and some nifty tidyverse tools.We'll load, clean, and prep some Brooklyn real estate data for …
Tutorial: Better Blog Post Analysis with googleAnalyticsR
Learn to compare blog posts on even footing by using R programming and the googleAnalyticsR package for blog data analysis in this free tutorial. The post Tutorial: Better Blog Post Analysis with googleAnalyticsR appeared first on Dataquest.
Getting Started with R Markdown — Guide and Cheatsheet
Learn the fundamentals of R markdown in this in-depth tutorial, or simply use it as a quick reference guide and cheatsheet for R markdown formatting. The post Getting Started with R Markdown — Guide and Cheatsheet appeared first on Dataquest.
Tutorial: Add a Column to a Pandas DataFrame Based on an If-Else Condition
When we’re doing data analysis with Python, we might sometimes want to add a column to a pandas DataFrame based on the values in other columns of the DataFrame.Although this sounds straightforward, it can get a bit complicated if we try to do it using an if-else conditional. Thankfully, there’s …
✚ How to Make a Spiral Chart in R
Using a spiral might not be the best way to encode data. But here's how to do it anyway. Just in case.Tags: R
Financial Services Sessions You Don’t Want to Miss at Spark + AI Summit 2020
Radical transformation is the theme of 2020, with customers demanding personalized products, improved protection against fraud, and digital experiences that match every small shift in behavior. Banks, insurance companies, and institutional investors are even more reliant on big data and AI to meet these demands and to outmaneuver the competition. …