Skip to main content

Introduction

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 language question and answering engine. 

• Power BI Desktop: A powerful companion development tool for Power BI There are many other parts for Power BI as well, such as; 

• PowerBI.com Website; which Power BI data analysis can be shared through this  website and hosted there as cloud service 

• Power BI Mobile Apps; Power BI supported in Android, Apple, and Windows  Phones. 

Power BI built easy graphical user interfaces to follow, so a business user simply could user Power Query or  Power BI desktop to mash up the data without writing even a single line of code. It is on the other hand so powerful with power query formula language (M) and data analysis expression (DAX) that every developer can write complex codes for data mashup and calculated measures to respond to challenging requirements. Power BI components can be used individually or in a combination. Power Query has an add-in for Excel 2010 and Excel 2013, and it is embedded in Excel 2016. The add-in for  Power Query is available for free! for everyone to download and use it alongside existing Excel (as long as it is Excel 2010 or higher versions). Power Pivot has been as an add-in for Excel 2010, from Excel 2013 Power Pivot is embedded in Excel, this add-in is again free to use! Power View is an add-in for Excel 2013, and it is free for use again.  Power Map is an add-in for Excel 2013, it is embedded in Excel 2016 as 3D maps. Power  Q&A doesn’t require any installation or add-in, it is just an engine for the question and answer that works on top of the model's built-in Power BI with other components. 

The components above can be used in a combination. You can mash up the data with  Power Query, and load the result set into the Power Pivot model. You can use the model you’ve built in Power Pivot for data visualization in Power View or Power Map. There is, fortunately, a great development tool that combines three main components of Power  BI. Power BI Desktop is the tool that gives you a combined editor of Power Query, Power  Pivot, and Power View. Power BI Desktop is available as a stand-alone product that can be downloaded separately. With Power BI Desktop you will have all parts of the solution in one holistic view. 




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