Data analysts transform raw data to a clean one using Power Bi tool. This process turns disorganized data like duplicates, missing values, replacing missing values and turning them into clear information that aid in decisions.
Workflow steps in Powerbi
Once you open powerbi, one is able to retrive the file from any format like .csv and transorm them to powerbi format. Click transform get data on the top left and select the appropriate data. After that click on transform so as to make changes in your data.
Cleaning the data
A very essential part in ensuring that the data is usable and can clean. Therefore one starts by;
1_._ Removing the duplicates__- Unique columns such as phone number, identification card are used. select the column>click home>remove rows>remove duplicates.
2.Identifying missing values- Missing values in a data set may affect your outcome you need to fill them with UNKNOWN/NOT APPLICABLE for the text columns. For numeric columns we use replace errors because until Power Bi regards it as an error.
Press CTRL+H to replace the missing values.
3.Fixing data types in columns to their appropriate match.
LOGICAL FUNCTIONS
These are functions that make decisions based on conditions.
To add a function use new measure
SUM FUNCTION
Calculates the total of all numbers in a specified column.
-AVERAGE FUNCTION
Calculates the arithmetic mean of numeric values in a specified column.MEDIAN FUNCTION
Returns the middle numberMAX AND MIN FUNCTION
Max function helps you get the highest value while min function helps you get the lowest value.
DAX-refers to Data Analysis Expressions that translate cleaned numbers to business metix.
Creating a table- we have the star and snowflake but star is widely used because it is easy to understand.
For visualization and interactivity we use dashboards- they assist in decision making.
Power BI is a decision accelerator and can be used to discover hidden financial recoveries, reduce operation costs in organizations. used in the health and banking sector.
Top comments (0)