Analyzing data with Power BI

 Analyzing data with Power BI

There is an easy way of analyzing the existing data. For database professionals, the best source of data is always from a database. However, in real-world there are many data sources just sitting on an Excel file or series of CSV or text files in a shared folder. Data Analysts should be able to do a quick data analysis with this data. Power BI made things simple and easy.

What is Data Analysis?

Data analysis is a process of inspecting, transforming, and monitoring to turn raw data into valuable insights. Data Insights helps in making the required decisions for the growth of business and company. To lead a data-driven approach for a business, it is important to analyze the data in deep. Various techniques for Data Analysis in Power BI will be interesting and beneficial for you to learn.

Explore Statistics

1. Visit the ‘Reports‘ tab to start creating visuals and charts.

2. Select or drag any visualization and paste it on the screen. We used a stacked column chart on the left and an Area chart on the right, as shown in the above image.

3. Visit this ‘Fields‘ section to manage your charts or visualization.

4. These are all the properties of a chart, and these properties change depending on the chart you select. You can play with all these properties to learn them better. Let’s discuss some most used ‘Fields’ in a chart.

• Axis – It is the X-Axis of the area chart. The fields section is currently assigned with Country Codes in the above image, and the same is reflected in the chart on the X-Axis.
• Legend – This field is used to compare data present in a single field. When some field like Country is assigned in Legend, the chart will show the country various colors to compare them easily.
• Values – This the Y-Axis of the area chart.

5. Click on the drop-down button present at the end of the values field. Here you can apply some operators on the values field.

6. Power BI will reflect all the changes you made in the fields section on the chart. Here, our graph will change the shape depending on the operator and the resultant values on the Y-Axis.