What is the difference between powerbi and excel?
Seven poems 2020-11-25 19:45:37
stay PowerBI In the visualization object of , There are two 「 form 」 object , The function of a table is not only to provide detailed data in a report , It is also often used to test the return result of a measure ,

PowerBI and Excel What's the difference between forms ?


Because they are very simple to use , Drag in the field to display the data , Looks like Excel The forms are no different , First contact PowerBI People can use it easily , But they are far more functional than they seem .

The following is a comprehensive introduction from connotation to appearance PowerBI The table in .

Let's take a look at the more complicated “ matrix ” object , Take the sales data of this electronic product as an example ,

PowerBI and Excel What's the difference between forms ?


choice “ matrix ”, Put... In the date table [ date ] Drag into 【 That's ok 】, The system will automatically layer the date field , hold [ The product name ] Drag into 【 Column 】,[ Sales amount ] Drag into 【 value 】, A form comes out ,

PowerBI and Excel What's the difference between forms ?


From a static point of view , This is a simple form , but PowerBI Of course, it doesn't look like this , Its tables are also dynamic 、 Interconvertible .

Drilling and interacting

Because when you add a date , Dates have been automatically layered , So you can drill in various date granularity directly on the line ,

This is drilling through the row header , If there are hierarchical dimensions on the column header as well , Drilling operation can also be carried out .

Put field [ The product name ] Drag into 【 Column 】 in , At this time, there is a drop-down box in the upper left corner , You can choose 【 That's ok 】/【 Column 】 Drilling ,

PowerBI and Excel What's the difference between forms ?


Use the drill button above to operate , Drill through is applied to all categories , If you want to drill through only one of these categories , You can also use the right-click operation , Drilling flexibility is greatly enhanced ,

PowerBI and Excel What's the difference between forms ?


About drilling , You can also refer to :PowerBI skill : Drilling of charts

In essence, tables are also visual objects , So it's no different from other charts , Not only can you drill into , Of course, you can also interact with other charts , It can also be screened 、 Or cross select other visualization objects , I'm not going to show you one by one .

Format is set

PowerBI The default table is the style above , You can change the style in the formatting ,

PowerBI and Excel What's the difference between forms ?


I can't help but make complaints about it , One of these system styles is worse than the other , The default one is the most pleasing , If not satisfied , We can also use Fonts 、 Color 、 Various custom settings such as borders , For example, I personally like to set this simple ,

PowerBI and Excel What's the difference between forms ?


The most eye-catching format setting is conditional format , You can set various color scales .

Background color scale

Turn on the background color scale , The default effect is also striking , Let's order 【 Advanced controls 】 Set it up ,

PowerBI and Excel What's the difference between forms ?


There are several settings to choose from , We set the color divergence directly according to the maximum value and minimum value , The background color scale effect is as follows :

PowerBI and Excel What's the difference between forms ?


The larger the amount , The darker the background color .

Font color scale

Set as above , I won't repeat , Look directly at the effect ,

PowerBI and Excel What's the difference between forms ?


Data bar

The most commonly used one should be this data bar , The effect is as follows ,

PowerBI and Excel What's the difference between forms ?


The data bar can also set different colors for positive and negative values , You can set it up yourself .

Finally, except for “ matrix ” The other one “ surface ”, Just drag the corresponding field into the value , It's a simple form , You can also format data bars like a matrix , But you can't use drilling and other functions , There was nothing to introduce , Until I saw this function : Automatically find clusters .

Automatically find clusters

This function can automatically transfer the information in the form , Automatically divide the data into different sets according to the internal relationship of the data , And automatically create a new field .

But use the auto find cluster feature , You need only one dimension in the table , And no more than 15 A measure of , If not , It will prompt :

PowerBI and Excel What's the difference between forms ?


Let's demonstrate this function :

Suppose there are scores of different brands of thermos cups , Create two new measures : The average of product score and service attitude score , We add the brand name and these two metrics to the table ,

PowerBI and Excel What's the difference between forms ?


Click on the three points in the upper right corner of the table , This menu will appear , choice 【 Automatically find clusters 】,

PowerBI and Excel What's the difference between forms ?


Then a field is automatically created and automatically displayed in the table ,

PowerBI and Excel What's the difference between forms ?


You can't see in the table what the new cluster is for , I don't know how the system is divided into different clusters , But we can put that data into a scatter plot , Let's see what rules they have ,

PowerBI and Excel What's the difference between forms ?


It is obvious from the scatter diagram that , Different clusters are clustered in different areas according to different colors , The brands of these thermos cups are divided into different collection levels according to product rating and service attitude , That's the power of auto discovery clustering .

After the table is automatically divided into clusters , This new field , It can be used in other visual objects , Like the scatter plot above , Can let us find the law between the data faster .

The above functions , Have you ever used them ?
版权声明
本文为[Seven poems]所创,转载请带上原文链接,感谢
https://fheadline.com/2020/11/20201125194407959h.html
相似文章

2021-08-09