Messy data is a huge business Risk it can be very misleading and if decision are made using messy data this could be very expensive and can kill a company silently.
Any skilled data analyst strife's to understand the data before touching it. They will get its meaning before any decision is taken using the data.
power bi provides a platform where messy data is cleaned through the power query through sum functions listed below:
Cleaned using the trim function to remove extra spaces.
Remove hidden characters using the Clean function.
Standardize texts using the Upper/lower Function.
Remove Duplicates.
Removing Blanks among others.
Data Modelling In Power Bi
This function is very crucial cause it helps in functions Listed below:
Giving accurate calculation.
Improving The Performance of a report.
Making an Analysis fast and easier.
Modeling Involves organizing and structuring data, here tables are organized in schemas and are joined with relationship Keys
What Is a key
It is a Particular column in a table with unique identifiers which are used to connect other Tables.
Tables are classified into two main categories:
Fact Tables
Dimension Tables
The two tables are connected into a schemas
Some of the major Schemas Widely used Includes:
Star Schema
In this type of a table the fact table is placed at the middle and is surrounded by the other dimension tables as shown below,
Snowflake
This Schema has one main table and the supporting Tables branch out like snowflakes as seen below:
Once the data has been analyzed and modelled the analyst can now use DAX to give meaning to the data.
What Is DAX
"It's just Excel math... but supercharged!" 🚀
What can DAX do
Dax adds meaning to data this is by allowing logical functions listed below:
Simple calculations: Add up sales, count customers, find averages
Time comparisons: This year vs last year, month-over-month growth
Filtering: Calculate sales for just one region or product
1.Custom metrics: Profit margins, conversion rates, customer retention.
With our data being meaningful we can now display it with the Main KPI'S On a Dashboard
What's a DashBoard in Power Bi
Normally a dashboard Should answer Question Not add more Question.
it looks like such:
Giving the most important numbers and charts that enhance the understanding of what happening to the business at a glance.
Essentials KPI`S To Be Displayed on the dash board
revenue/sales Answers the important question of whether revenue is increasing or decreasing.
Profit
This KPI Answer the question whether we are making any money from the the revenue received less all the expenses.
Growth Trend Shows the direction in which the business is moving either on the decline or improving thus informed decisions are made.
Customer The question as to who is buying from the business and what they are buying is answered by this KPI Thus the Business is able to know where to invest in.
Performance Vs Target
Every business has got its goals so with this KPI its possible to know whether we are achieving our goals.
In conclusion Power Bi is A very Key Tool in any business and should be subscribed to by data analysist When it comes to making informed decision using data.
Top comments (0)