SQL Update Statement
The UPDATE statement is used to modify the existing records in a table. The syntax is as follows. […]
Blog
Data Life Cycle
What is the data life cycle? Huge amounts of data can make your PC MAAD. Plan: Decide what […]
Data Analyst Skills
In general, what are analytical skills? Analytical skills are qualities and characteristics associated with solving problems using facts. […]
Data-Driven Decision Making
Data-driven decision-making is defined as using facts to guide business strategy. A data analyst finds data, analyzes it, […]
The Data Ecosystem
What is the data ecosystem? A data ecosystem is a group of elements that interact to produce, manage, […]
Business Analytics
Business analytics is “the use of math and statistics to derive meaning from data in order to make […]
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. […]