Category Archives for "Analytics Tutorials"

How to PIVOT in SQL

Pivot – This keyword in MS SQL Server is used to convert the rows to columns for a table and perform aggregations on a specific column. Please note, this keyword will not be able to remove/impact records from the table. It only interchanges the rows to columns in the output result set only. The original […]

How to Find Outliers in SQL

Finding outliers in your data is easier than you think. You can use statistics concepts to identify the threshold where outliers may fall. One of the most accurate ways is to use the Z-Score.  This score is composed of the mean, standard deviation, and current value.  You see from the image below how this is […]

How to Create a VLOOKUP

If you are a data analyst or any professional who uses Excel, you may need to create a Vlookup. So before I begin with showing you how to create a Vlookup, let’s get down to to the details of what one is. What is a Vlookup? Vlookup allows a user to lookup the value that […]

SQL MUST Interview Questions & Answers (Level 1 MYSQL)

These questions cover what data analysts would face at an entry-level to the intermediate range for SQL. Depending on the organization and role, the requirement for SQL knowledge may increase. However, these will cover the main concepts from joins, subqueries, grouping, alias, and filtering. You can practice all these SQL queries on our free platform: […]

Data Analysis for Beginners | An Easy Guide

Data Analytics vs Data Science Let’s first help you to define the difference between these two terms. Data analytics is a strategy-based science that can help you analyze raw data, allowing for trend detection and answering questions. Data analysis helps you to draw the right conclusions from a huge batch of data. Moreover, it helps […]

Alteryx for Beginners

Summary: In this article “Alteryx for Beginners”, we are going to learn how to use Alteryx and some of the key data skills (like blend, filter, analyze etc.) Following are the topics that, I am going to mention in this article you can also try out the Alteryx A to Z BootCamp Course with Real […]

How to Build Google Analytics User Personas & Profiles

Building a Google Analytics Personas or  Customer Profile is an essential practice that all marketers should use. This profile can be quickly created using Google Analytics and Excel. However, it must be said that there are issues with data collected from Google Analytics such as this data is just a sample. However, the sample size […]

Digital Attribution Models in Google Analytics

Digital attribution models are a an attempt to assign credit to a particular channel. This action becomes increasingly complex because user do not act in predetermined path.  However, if you have more than one form of advertising that you are using to drive conversion, then attribution is a must. The the last click model is […]

Use Google Analytics to Create Custom Facebook Audience

Google Analytics is the best tool to create custom Facebook Audience segments for you social media advertisement. This paring is a match made in heaven. Often people start their journey into Facebook Advertising either targeting a wide audience or guessing at interest group. However, using Google Analytics cuts out the guesswork and allows you to […]

Learn The Best Time to Publish Blog Posts

Problem: When is the best time to publish blog posts? Solution: Use analytics to identify the ideal time to publish. Requirements: Google Analytics Time to implement: 5 minutes Knowing best time to publish content can be the key to increasing engagement,, sales, and shares. There are tons of people who say lunchtime is the ideal […]