Fill and Replace Values
There are times when you need to clean your dataset. Suppose you had a simple table of employees […]
Blog
Allocate Data into Buckets or Groups
Suppose we have a table of data that lists employees and their annual salaries. We want to create […]
Split Column by Delimiter
In Power Query transformations, the split column by delimiter has something that you need to be aware of. […]
Text Transformation in Power Query
This post covers a few common text transformations in Power Query. When you are working with a column, […]
Power Query Transformations
Power Query is part of Microsoft Excel. It’s a powerful tool that can help you with repetitive tasks. […]
API Introduction
What is an Application Programming Interface (API)? As a wide definition, the website programmableweb.com says “An Application Programming […]
Data Analytics/Analysis Life Cycle
Data undergoes various stages throughout its life, during its creation, testing, processing, consumption, and reuse. The Data Analytics […]
CI for Predicting Sales
We are finding that we have too many products on our shelves and some of the products aren’t […]
CI Population Unknown and Equal
The previous series of posts was called Inferential Statistics. Let’s now compare “apples to apples”. Last time we […]
Hypothesis Testing Introduction
Series of Posts This post is the first part of a short series of posts called Hypothesis Testing. […]
CI Independent Samples
Let’s work with confidence intervals with two means and independent samples. Let’s work with data where we know […]
CI for Two Populations
What if we had two populations to consider? So far we’ve been looking at single populations. In some […]