Blog

Data Blog

 

LATEST BLOG POSTS

All Data Analytics/Data Science R Project Excel SQL

Progress Log 104 (R): Basic Data Types

I’m taking an edX course entitled “Introduction to R for Data Science” and all of the concepts described below come from that course. Data Types class() reveals what type a variable is. Logical: otherwise known as boolean values, can either…
CONTINUE READING

Progress Log 103 (R): The True Basics

I’m taking an edX course entitled “Introduction to R for Data Science” and all of the concepts described below come from that course. Console Basic Arithmetic. We can calculate the sum of 1 and 2 by simply typing 1 +…
CONTINUE READING

Progress Log 78 (Python): Choosing a chart for your Project, Univariate and Bivariate Data, Project – Investigate a Dataset

I’m taking a nanodegree course entitled “Data Analysis” by Udacity and all of the concepts described below come from that course.   Choosing a chart for your project         Project     Notes # Remove rows with…
CONTINUE READING

Progress Log 68 (Excel): Moving Averages

I’m taking a nanodegree course entitled “Data Analysis” by Udacity and all of the concepts described below come from that course. Moving Averages   Moving averages smooth out data to make it easier to observe long term trends and not…
CONTINUE READING

Progress Log 67 (SQL): Calculating results with CASE, ELSE, END AS, JOIN

I'm taking a course entitled "Intro to SQL: Querying and managing data" by Khan Academy and all of the concepts described below come from that course.   Calculating results with CASE     Where 220 is considered a high heart…
CONTINUE READING

Progress Log 66 (SQL): AND/OR, Querying IN subqueries, LIKE “%%”, Restricting grouped results with HAVING, AS, AVG, COUNT, GROUP BY

I'm taking a course entitled "Intro to SQL: Querying and managing data" by Khan Academy and all of the concepts described below come from that course.   AND/OR     AUTOINCREMENT: increments values by one from the highest value. In…
CONTINUE READING