Choosing the right visuals for my dataset

[nascaline]

I got a data set and I have no clue which visual I could utilize for data analysis.



My data structure would be something like below and looking for ways to spot normalized and abnormal data.

Project	id	item	price
A	a1	apple; green in colour	5
A	a2	apple; yellow in colour	16
B	b1	apple; purple in colour	3
B	b2	apple; green in colour	7
C	c1	apple; yellow in colour	20
C	c2	apple; purple in colour	9

I have looked into the Normal Distribution table and Scatter chart (with random gitter), and now looking for other visuals / graphs that I can have an alternative way of presentation.



Many Thanks

 

[severynm]

In general, control charts are great for tracking values within a tolerance, but it seems your data does not have a time component, so I wouldn't start with those.

It depends greatly on your data (# independent vs. dependent variables, categorical vs numerical, and/or categorical scale vs continuous number scale) which charts would be the best to use. In general Box and whisker charts, cluster charts, or even just line charts or scatter plots with conditional formatting if a point is above a threshold might all be valid suggestions.

Otherwise, it'll be hard to say exactly what is best without the actual data or knowing what you want to get from the data, i.e. which questions you want to answer from the data.

 

[nascaline]

Thanks severynm.

I guess I would :
1. filtered the items by categories (i.e. apple; green )
2. take average for the price of these items
3. and find a way to indicate whether the filtered items' price are within price range +/- 10 % and 20 % of average

Would there be any example/s that I can follow/ look in to ?

 

[nascaline]

In general, control charts are great for tracking values within a tolerance, but it seems your data does not have a time component, so I wouldn't start with those.

It depends greatly on your data (# independent vs. dependent variables, categorical vs numerical, and/or categorical scale vs continuous number scale) which charts would be the best to use. In general Box and whisker charts, cluster charts, or even just line charts or scatter plots with conditional formatting if a point is above a threshold might all be valid suggestions.

Otherwise, it'll be hard to say exactly what is best without the actual data or knowing what you want to get from the data, i.e. which questions you want to answer from the data.

Thanks severynm.

I guess I would :
1. filtered the items by categories (i.e. apple; green )
2. take average for the price of these items
3. and find a way to indicate whether the filtered items' price are within price range +/- 10 % and 20 % of average

Would there be any example/s that I can follow/ look in to ?

 

[severynm]

I guess I would :
1. filtered the items by categories (i.e. apple; green )
2. take average for the price of these items
3. and find a way to indicate whether the filtered items' price are within price range +/- 10 % and 20 % of average

Would there be any example/s that I can follow/ look in to ?

There's multiple ways to do what you want, and again, it depends on what you want to get out of the report.

1. Do you want to filter the actual data itself according to colors, or just some visuals/tables (more likely)? If so, you might start with a slicer for your color category.
2. Depending on your visuals/what you want, either create a measure to calculate this, or with the price field in a visual, use the average aggregation.
3. This sounds to be like a measure would be the best way to calculate this, and then use some conditional formatting on a visual based off of that measure.

Just search google continuously for what you are trying to do: You might find results from the Power BI Documentation, Power BI Community, or even Stack Exchange particularly helpful.

Edit: On further thought because it sounds like you're so new to Power BI, you might be better suited to some very introductory tutorials. I do not know if you would have access to them, but there are tutorials through Linkedin Learning by Gini von Courter that helped me get the basics. Otherwise you should be able to find some good tutorials around on youtube.