HOW TO ALTER CHAOTIC DATA IN POWER BI

POWER QUERY
Power Query is a tool in power Bi that is used to clean, transform and prepare data.
By using power query you could perform the following:
filter and sort data
manipulate column to your preference
Clean data
merge and append queries

FILTERING AND SORTING
Filtering and sorting data helps one focus on the most necessary information in ones dataset

DATA CLEANING

Data cleaning is all about clearing "noisy" unrelatable data from your dataset leaving you with important data that will give correct valuable insights.

_Removing duplicates_

To remove duplicates in a datasets is essentials for it may alter the results.

To remove null values or blanks_

For null values one should replaces them with NOT PROVIDED for text or 0 in number formats

MERGING AND APPENDING QUERIES

Merging queries is combining two or more existing tables to one for easier access.
Appending Queries- is when you want to modify or extend the contents of a query, especially when the data is from separate reports or files.

COLUMN MANIPULATION
Column manipulation allows you to add or remove a column in your data.

DATA SHAPING
Data shaping in power query helps the user transform data into your preferred need.
-_Pivoting and unpivoting table - Pivoting tables restructures table, by converting rows into columns and Unpivoting tables converts wide tables to long formats. They both help in better analysis of datasets.

DAX

Data Analysis Expression (DAX)
DAX is used to perform advanced calculation and queries o data

DAX FUNCTIONS
Here are some of the basic DAX functions that are used in power bi :
AGGREGATE FUNCTIONS

1- AVERAGE -

1. SUM - it add ups the values of the selected column
2. MIN -it finds the minimum value in a given column
3. MAX - it identifies the highest value in a column

LOGICAL FUNCTIONS
AND - Combines two logical expression to give a result
OR - It gives a result if at least one or multiple conditions are true, false
NOT - it checks if one value is not equal to the other
IF - it makes a logical comparison between a value and the condition set.
ITERETATIVE X FUNCTIONS
X- FUNCTIONS are used when there is need to perform a preliminary action before a simple aggregation of a column.
The X functions perform row by row calculations taking each row to account and allowing complex calculation that aggregate functions cannot handle.
Examples:
SUM (X) - Sum
AVERAGE (X) -Average
MIN (X)- Min
MAX (X) - Max
COUNT (X) -Quantity

TIME INTELLIGENCE
Time intelligence functions in DAX are used for analyzing trends based on time.