Forum Discussion

VDS9's avatar
VDS9
Frequent Visitor
2 years ago

Help to clean data

Hi everyone, 

 

I need to create a simple report on behaviour points throughout time period.

 

This is how we get data, what would be the best way to clean it and transform the data?

All I need to see once I buoild the reports, its if behaviour improved or not and if negative points increased or decreased throughout the time..

 

Help Please

 

 

Thanks.

 

I know its a big ask but I need to bring this report tomorrow morning into work.

 

 

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi VDS9 ,
    According to your description, you need to process the data and show the trend after the data changes.
    First, you need to classify or aggregate the data so that you can visualize the statistics of the data at various levels of granularity (type, time, etc.), which can be done technically as 0, 1, or -1. You can do this through grouping in power query, or aggregation functions in dax.
    After you clean up the data and create the dax function, you can show the trend through a visual legend such as a scatterplot or line graph, and determine whether the negative score has increased or decreased throughout the time period from the density of the scatterplot.
    You can refer to this document to learn how to create a scatterplot:
    Scatter, bubble, and dot plot charts in Power BI - Power BI | Microsoft Learn


    Best regards,

    Albert He

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly