Skip to main content

Power BI Components

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 simple language, Power Query M Formula Language, Power Query also uses a powerful formula language as code behind called M. M is much more powerful than the GUI built for it. There are many functionalities in M that cannot be accessed through a graphical user interface. 

Power Pivot 

Power Pivot is a data modeling and calculation engine. It is used for modeling simple and complex data. the modeling engine would provide you a great place to build your star schema,  calculate measures and columns, build relationships through entities, and so on. that can be viewed in Pivot tables. It provides you a huge space to create your design. Pivot uses Data Analysis eXpression language (DAX) for building measures and calculated columns. DAX is a powerful functional language, and there are heaps of  functions for that in the library


Power View 

The main data visualization component of Power BI is Power View. Power View is an interactive data visualization that can connect to data sources and fetch the metadata to be used for data analysis. Power View has many charts for visualization in its list. With Power View, you can filter data for each visualization component or even for the entire report. Slicers can be used for better slicing and dicing of data.


Power Map 


Power Map is used to visualize geospatial data in 3D mode. As soon as the visualization renders in 3D mode, it provides another dimension to it. In Power Map, you can assume one attribute as the length of a column in 3D and another attribute as a heatmap view. Based on a geographical location, the data can be highlighted. You can highlight data based on the Geo-graphical location such as country, city, state,  and street address. Power Map works with Bing maps to get the best visualization based on  Geo-graphical either latitude and longitude or country, state, city, and street address information. Power Map is an add-in for Excel 2013 and embedded in Excel 2016.


Power BI Desktop 

Power BI Desktop is a new component in the Power BI suite. It is an integrated development tool for Power Query, Power Pivot, and Power View. It lets you build advanced queries, models, and reports. With Power BI Desktop, it is easy to advance your skills in BI and your experience in data analytics.


Power BI Website 

Power BI solution can be published to the PowerBI website. On the Power BI website, the data source can be scheduled to refresh (depends on the source and is it supported for scheduled data refresh or not). Dashboards can be created for the report, and they can be shared with others. Power BI website even gives you the ability to slice and dice the data online without requiring any other tools, just a simple web browser. You can be built reports and visualizations directly on the Power BI site as well. 


Power Q&A 

Power Q&A is a natural language engine for questions and answers to your data model.  Once you’ve built your data model and deployed that into the Power BI website, then you or your users can ask questions and get answers easily. There are some tips and tricks about how to build your data model so it can answer questions in the best way which will be covered in future chapters. Power Q&A and works with Power View for the data visualizations. So users can simply ask questions such as Number of Customers by  Country, and Power Q&A will answer their question in a map view with numbers as bubbles, Fantastic, isn’t it?


Power BI Mobile Apps 

There are mobile apps for three main mobile OS providers: Android, Apple, and  Windows Phone. These apps give you an interactive view of dashboards and reports in the Power BI site, you can share them even from the mobile app. You can highlight part of the report, write a note on it and share it with others.



Power BI Pricing 

Power BI provides these premium services for free! You can create your account on the PowerBI.com website just now for free. Many components of Power BI can be used individually for free as well. you can download and install Power BI Desktop, Power Query add-in, Power Pivot add-in, Power View add-in, and Power Map add-in all for free! There are some features of these products that are reserved for paid versions, however,  such as Power BI Pro which gives you some more features of the product. 

Comments

Post a Comment

Popular posts from this blog

Bookmarks and Buttons

Power BI   Bookmarks and Buttons Select some columns into a table : Copy Visual and Paste, change it to Bar Chart by selecting any one of the columns and overlap both visuals: Goto View → Enable selection Pane and Bookmark Pane In selection Pane, we Can hide and Display visuals Bookmarks helpful to display state of visualizations : Now, Create a bookmark : → Add Buttons   → Capture Visuvals by hiding required visuals  Now,  → Hide the Table and Off button create bookmark and capture bar chart Hide the bar chart and On Button, create bookmark and capture table Click on Bookmark1 and select the visible button and Enable action in the properties pane Type: Bookmark Bookmark: Bookmark2 Click on Bookmark2 and select the visible button and Enable action in the properties pane Type: Bookmark Bookmark: Bookmark1 Now, Ctrl+click on buttons to Capture Visuals
Post a Comment
Read more

Connection to DB, Difference Between Direct Query and Import Mode

Power BI  Connection to DB, Difference Between Direct Query and Import Mode Goto Home → Get data → SQL Server Fill Required Fields : Click on ‘Ok’ Validate Credentials then Load the data : Difference Between Import Mode and direct Query : Import Mode : → copy of data into power bi file(PBIX) → Writing data into a file → when it is published. It doesn't require anything to pull the data into a file and it is extremely fast because it writes in a powerBI file Limits Up to the size of data - Don't Have Premium Account Import option : 1GB Limits Up to the size of data - Have Premium Account Import option : 10GB Direct Mode : Need Connection to data source every time It doesn't write data into a pbix file. Every time it reads data from the server  A little bit slow compared to import mode → when it is published. It requires Gateway Connection  to pull data into the service Dataset Limitation using direct query  1 Million Rows Limited Functionalities in Direct query whereas in im
Post a Comment
Read more

Publish reports Into Service

Power BI Publish reports Into Service In Order signup for Power BI Service, You need a Student or corporate account  Link To Create Power BI Service Account :  https://signup.microsoft.com/signup?sku=a403ebcc-fae0-4ca2-8c8c-7a907fd6c235&email=&ru=https%3A%2F%2Fapp.powerbi.com%3Fpbi_source%3Dweb%26redirectedFromSignup%3D1%26noSignUpCheck%3D1 Now, Open Power BI desktop and build some report Sign in Your Account Once Sign In : Publish the report into your account It asks a workspace to publish Mywoksapce is the default workspace In order to create your own workspace. We need a pro/ Premium service account Once got Published check-in service Service has 3 types of accounts : Free, Pro, and Premium Version Sign Into Service : https://powerbi.microsoft.com/en-us/landing/signin/
Post a Comment
Read more