# POWER BI - SESSION 1 INTRODUCE ## INTRODUCE Power BI is a BI tool of Microsoft was released in 2014. By the [selecthub](https://www.selecthub.com/business-intelligence-tools/) Power BI is the leading tool in the BI tool market, data is collected as of May 2022 ![](https://i.imgur.com/J99fu6h.png) Power BI can help you: * Create amazing data experiences ![](https://i.imgur.com/ZFZMDiX.png) * Make the most of your big data investments by connecting to all your data sources with the scale to analyze, share, and promote insights ![](https://i.imgur.com/8KFOQW9.png) * Make decisions with confidence ![](https://i.imgur.com/iJBCJuE.png) ## Service **1. Power BI Desktop** : Power BI Desktop is a development tool for Power Query, Power Pivot, and Power View. With Power BI Desktop, you have everything under the same solution, and it is easier to develop BI and data analysis experience. **2. Power BI Service** : Power BI service is the Software as a Service (SaaS) part of Power BI. It is also known as Power BI Online **3. Power BI Apps** : Version for mobile phone ![](https://i.imgur.com/5PsTSDo.jpg) ## Components in PowerBI ### Power Query Similar to Excel Power BI Desktop comes equipped with Power Query Editor. You can use the Power Query Editor to connect to one or many data sources, shape and transform the data. You could modify the data in hand to meet your needs, make it more usable, and then load that model into Power BI Desktop. ![](https://i.imgur.com/SijMV6P.png) ### Dax query (Data Analysis Expressions) DAX is formula expression language used in Analysis Services, **Power BI, and Power Pivot in Excel**. DAX formulas include functions, operators, and values to perform advanced calculations and queries on data in related tables and columns in tabular data models. DAX formulas are used in** measures**, **calculated columns**, **calculated tables**, and **row-level security**. #### Measures Measures are dynamic calculation formulas where the results change depending on context. Measures are used in reporting that support combining and filtering model data by using multiple attributes such as a Power BI report or Excel PivotTable or PivotChart. Measures are created by using the DAX formula bar in the model designer. example ``` dax Total Sales = SUM([Sales Amount]) ``` #### Calculated columns A calculated column is a column that you add to an existing table (in the model designer) and then create a DAX formula that defines the column's values. When a calculated column contains a valid DAX formula, values are calculated for each row as soon as the formula is entered. Values are then stored in the in-memory data model. For example, in a Date table, when the formula is entered into the formula bar: ``` DAX = [Calendar_Year] & " Q" & [Calendar_Quarter] ``` #### Calculated tables A calculated table is a computed object, based on a formula expression, derived from all or part of other tables in the same model. Instead of querying and loading values into your new table's columns from a data source, a DAX formula defines the table's values. Calculated tables can be helpful in a role-playing dimension. An example is the Date table, as OrderDate, ShipDate, or DueDate, depending on the foreign key relationship. By creating a calculated table for ShipDate explicitly, you get a standalone table that is available for queries, as fully operable as any other table. Calculated tables are also useful when configuring a filtered rowset, or a subset or superset of columns from other existing tables. This allows you to keep the original table intact while creating variations of that table to support specific scenarios.