Business Analytics
Business analytics is “the use of math and statistics to derive meaning from data in order to make […]
Mike
Number Transformations
Number transformations in Power Query are simple to do, but there is something you need to watch out […]
Remove Duplicates
In Power Query it is easy to remove duplicates. There is however something to be aware of. Power […]
Kaggle Introduction
What is Kaggle? Wikipedia says: “Kaggle, a subsidiary of Google LLC, is an online community of data scientists […]
Fill and Replace Values
There are times when you need to clean your dataset. Suppose you had a simple table of employees […]
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 […]