Power Query
Deals with Cleaning of Data and uses “M language” to achieve its purpose.Power Pivot
Deals with Calculations that are performed on the data and uses “DAX” to achieve its purpose.Power View
This is the Data Visualization part of Power BI.What is Query Editor?
Query Editor is an interface for Query transformation in Power BI. It allows you to seamlessly prepare data for BI tasks. Query editor is the GUI where all the data transformation takes place. For the simpler data transformation tasks, no coding is required and all the transformations can be performed by just clicking on the correct button.Getting Started
To get started:- Click on the Home tab in the ribbon.
- From the External Data section, click on Edit Queries.
- Select Edit Queries from the drop-down menu to enter the Query editor.
A new window opens showing the interface for Microsoft Power BI Query Editor.
Creating Columns in Power BI
Columns are created in Power BI to enrich the raw data.
To understand what raw data is: https://powerbitraining.com.au/what-is-raw-data-power-bi-training/
We collect data from any primary or secondary source but to draw out insights from this data we need to transform it into information. Raw data is a collection of facts and figures before it goes through a transformation. Created columns act like a cherry on the cake by providing just the right value for each row and transforming the data into information. Using the query editor, the following columns can be created:
- Index Column: https://powerbitraining.com.au/creating-columns-in-power-bi/
- Date Column: https://powerbitraining.com.au/creating-columns-in-power-bi/
- Conditional Column: https://powerbitraining.com.au/creating-columns-in-power-bi/
- Information Column: https://powerbitraining.com.au/creating-information-custom-and-standard-columns-in-power-bi-power-bi-training-across-australia/
- Custom Column: https://powerbitraining.com.au/creating-information-custom-and-standard-columns-in-power-bi-power-bi-training-across-australia/
- Standard Column: https://powerbitraining.com.au/creating-information-custom-and-standard-columns-in-power-bi-power-bi-training-across-australia/
- Column by Example: https://powerbitraining.com.au/creating-column-by-example-in-power-bi/
- Extracting Column: https://powerbitraining.com.au/extracting-and-formatting-a-column-in-power-bi-power-bi-training-in-sydney/
- Formatting Column: https://powerbitraining.com.au/extracting-and-formatting-a-column-in-power-bi-power-bi-training-in-sydney/
- Statistical Column.
- Scientific Column.
In this blog post, creating statistical and scientific column has been discussed.
Creating Statistical Column
Statistical calculations can be performed in Power BI using Statistical column feature.
To find statistics:
1.Click on Sales Table in the Queries Pane.
2.Click on Product Code column.
3.Click on Transform Tab in the Ribbon Menu.
4.Click on Statistics in the Number Column section.
5. Click on Count Values.
An aggregated view showing the result is created.
6. Now in the query steps section, Click on the cross to the left of the last step.
7. Now, click on Product Code column and click on Transform Tab in the Ribbon Menu.
8. Click on Statistics in the Number Column Section.
9. Click on Count Distinct Values.
Statistics, Standard and Scientific column feature is available in both Transform and Add Column Tabs in the Ribbon Menu. It is important to choose the right tab to get the desired functionality. Transform tab transforms the very column on which the computation is performed. Whereas, Add New Column creates a new additional column where the computations are shown.
Conclusion:
Data transformation is an essential topic of both basic and advanced Power BI trainings because data must be transformed to a format that is suitable for fast and precise data processing and for efficient reporting. Data Transformation involves a wide range of operations such as identifying data sources and data types, cleaning data by removing errors and duplicates along with enriching data and performing aggregations. In this blog post, the method for creating statistical and scientific column using the Power BI query editor has been discussed.
Are you a data analyst and want to learn more about Power BI? Why not sign up for Power BI training in Australia. We provide our services in the following regions
- Power BI Training in Sydney
- Power BI Training in Melbourne
- Power BI Training in Brisbane
- Power BI Training in Canberra
