Shulou(Shulou.com)06/01 Report--

What is the method of visual analysis of Power BI data? most people do not understand the knowledge points of this article, so the editor summarizes the following contents, detailed contents, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "what is the method of visual analysis of Power BI data?"

Data connection

Tools used: Navicat Premium 12

When you open the database, you can see that the database contains a library of film, which contains a table of newfilm, as shown below.

Open the Power BI software, select the database in getting data, select the My SQL database here, and click Connect.

Server choose the local server here, so enter localhost here and enter film for the database.

Check the newfilm table in the navigator, click load, connect the data, and you can also do some data preprocessing steps to remove weight and fill missing values in the conversion data.

The loaded data already appears on the right side of the interface, containing all the fields of the newfilm table.

Data visualization

Tool used: Power BI

To study the ratings of spring break movies, select the cluster bar chart in Visualization, drag name to the axis, score to the value, uptime to the filter, and select 2021 in the basic filter.

Set the graphic format, select the graphic, set the data color in the format, set the display unit to none in the data label, and set the title of the graphic to beautify it. Similarly, you can make the Spring Festival film length and the number of Spring Festival movie scores.

Here is a motion picture for drag and drop demonstration.

Power BI Motion Picture demonstration

To see the ratings of movies with different themes, select the pie chart in visualization, drag type to the legend, score to the value, drag uptime to the filter, check 2021, and set the pie chart title, data color and other formats.

Data summary, here we choose to use the card chart to achieve the data summary, select the card chart in the visualization, drag the score into the field, and drag it into the filter, select the movie score with the highest score, set the format of the card picture, font size, title, etc., in the same way, you can make other things.

After the chart is set, insert a text box, set a general title, and change the font format.

The final result is as follows.

The result is exported, and you can save the result as a Power BI template, or as a PDF format.

The above is about the content of this article on "what is the method of visual analysis of Power BI data". I believe we all have a certain understanding. I hope the content shared by the editor will be helpful to you. If you want to know more related knowledge, please pay attention to the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.