Power BI

Power BI  Difference Between Calculated Column And Measure  Calculated Column / Measure : Calculated Column  :  A calculated column is an extension of a table using a DAX formula that is evaluated for each row. If you are accustomed to using Excel, you will remember that in Excel you often need to copy a formula for each cell of a new column, unless you format your range as a table. This results in each cell potentially having a different formula because of different cell references. When you write a calculated column formula, it is automatically applied to the whole table and evaluated individually for each row. Note: The Total summation value does not give correct values in calculated columns  Example :  Cal is Table name caluculated_Column = cal[cost]/cal[sales] caluculatedMeasure = SUM(cal[cost])/SUM(cal[sales]) Here Total sales/ Total Cost value gives 0.90 in measure 21/19 = 0.90 Where as in calculated column gives 5.00 wrong results sumx_Measure = SUMX(cal, cal[cost]/cal[sales])

Power BI Power BI Architecture :     Power BI architecture has three phases. The first two phases use ETL (extract, transform, and load) process to handle the data. Data Integration:   Data extract from different sources like databases, csv files, excel files, cloud, and different servers...etc Then the data is integrated into a standard format and stored at a common area that's called the staging area. Data Processing: Still, the integrated data is not ready for visualization because the data needs processing before it can be presented. This data is pre-processed. For example, the missing values or redundant values will be removed from the data sets. After that, the business rules will be applied to the data, and it transforms into presentable data. Then this data will be loaded into the data warehouse. Data presentation: once the data is processed. We can present data in visualizations and create reports These visual reports help business end-users to make business decisions b

Power BI Power BI  Components  Components in Power BI are :  Power Query Power Pivot Power View Power Map Power Q&A Power BI Desktop Power BI Website Power BI Mobile Apps Power Query Power Query is one of the important components of Power BI. This can be included in your Excel or can be used as a component of the Power BI Desktop. Using Power Query, you can delete data from numerous data sources and extract data from a wide range of different databases like Oracle, SQL Server, MySQL, and other different databases. You can use Microsoft Exchange, Outlook, Azure…. as sources. You can connect to Facebook as a source and many other applications. You can use an online search or use a web address as the source to fetch the data from that web page. Power Query gives you a graphical  Power Bi Provides a Good GUI that is helpful to transform and use the data as you need, such as the date and time changes, adding columns, changing the types and content, and many different options . It uses a

Power BI  Power BI? Power BI is a Data Visualization and Business Intelligence tool With Power BI you can connect to many data sources to interactive dashboards and BI reports. Power BI suite provides multiple software, connector, and services - Power BI desktop, Power BI service based on Saas, and mobile Power BI apps available for different platforms. This set of services are used by business users to consume data and build BI reports. You can publish your dashboard and visualization tool in the cloud and share it with those who you want. You can work with On-premises as well as Azure/cloud-based data sources. Power BI made of 6 main components, these components released in the market separately, and they can be used even individually. Components of Power BI are:  • Power Query: Data mashup and transformation tool.  • Power Pivot: In-memory tabular data modeling tool  • Power View: Data visualization tool  • Power Map: 3D Geo-spatial data visualization tool  • Power Q&A: Natural