Power BI Tutorial: A Step by Step Guide with Examples

Last updated on Nov 21,2022 60.6K Views

Vishal is a technology enthusiast working as a Research Analyst at Edureka.... Vishal is a technology enthusiast working as a Research Analyst at Edureka. He has expertise in domains like Big data, Machine Learning,Statistical Analysis and...
2 / 2 Blog from Introduction to Power BI

The concept of Business Intelligence is something that is alien to very few people these days. With newer tools emerging every day to help solve the crisis of data management, most organizations have already moved in or have plans to use Business Intelligence in solving their crisis. Power BI is Microsoft’s latest BI tool mainly aimed to help everyone analyze and visualize their data. This Power BI tutorial for beginners will give you a complete insight into Power BI in the following sequence:

  1. What Is Business Intelligence And Why Do We Need It?
  2. What Is Data Visualization And Its Importance?
  3. Need For Power BI
  4. What Is Power BI?
  5. Components Of Power BI
  6. Architecture Of Power BI
  7. Features of PowerBI
  8. Data Sources in Power BI
  9. Companies using Power BI
  10. Steps for Installing Power BI
  11. Building Blocks Of Power BI
  12. Creating A Report Using Power BI
  13. Power BI Use Case: Wirepas
  14. Difference between Power BI and Tableau
  15. Difference between Power BI and SSRS
  16. Difference between Power BI and MSBI
  17. History of Power BI
  18. Pros and cons of Power BI
  19. Power BI Tools
  20. Who uses Power BI
  21. Key Terms used in Power BI

You may go through this Microsoft Power BI recording where our Power BI Certification Training expert has explained the topics in a detailed manner with examples that will help you to understand the concepts better.

Power BI Tutorial For Beginners | Power BI Training | Edureka

This video will help you to understand what is BI as well as Power BI. Then moving on in this video we have discussed the components and building blocks of Power BI.

Power BI Tutorial for Beginners

Let us begin this Power BI tutorial by addressing the most essential and fundamental question, what exactly is Business Intelligence?

What Is Business Intelligence (BI)?

In an age where Business Intelligence has become a bigger domain than most trending technologies if you ask twenty people what the term business intelligence means, you are likely to get ten different answers. So let me put it in the simplest terms without losing the technicality of it. Business intelligence (BI) is the set of techniques and tools for the transformation of raw data into meaningful and useful information for business analysis. To put it simply, Business intelligence is the technology that gets the right data to the right people, at the right time so that they can make more effective business decisions.

The image below shows the benefits of Business Intelligence. 

BI - Power BI Tutorial - Edureka

Over the years, the process of business intelligence has grown and adapted to help solve almost all the challenges while dealing with data by involving newer tools and techniques. The change that Business Intelligence has seen over the years can be divided into 3 waves, so let us continue with our Power BI tutorial and take a look at these three waves.

1st Wave: Technical (IT To End User)

During the first wave of business intelligence, the end-user had to be dependent on the IT department for data insights. This is because it was not possible for end-users to create visualizations/ reports on their own as tools available required technical knowledge. This dependence on the IT department for insights resulted in more effort and time consumption to get the updates done.

2nd Wave: Self-Service (Analyst To End User)

The second wave gave analysts access to BI. Now, people with some knowledge of analytics could use the BI tools. This meant more teams had access to BI and more people could have better data insights, this eased the role of IT teams.

3rd Wave: Everyone (End User)

The third wave has made it easier to access data and create reports, visuals to get better business insights. The introduction of tools like Power BI made this transition easy. Now anybody who has basic understanding of the data can create reports to build intuitive and shareable dashboards.

This was about BI, now let us continue with our Power BI tutorial and understand another important topic that is associated with  BI.

What Is Data Visualization And Its Importance?

Data-Visualisation - PowerBI Tutorial - EdurekaIn a nutshell, data visualization is nothing but the pictorial or graphical representation of information/ data. It provides insights into complex data sets by communicating the key aspects in more intuitive and meaningful ways. Data visualization lies at the intersection of design, communication, and information science.

Even though data visualization has been termed as the key skill for research in the twenty-first century, it goes way back. It existed in the late 18th century and can be traced back to when William Playfair invented geometrical charts. His bar charts were used to represent Scotland’s imports and exports of 17 countries in 1781. These bar charts constituted a pure solution to the problem of discrete quantitative comparison.

Why Is Data Visualization Important?

The way, human brain processes information, it is easier to use images, charts, or graphs to understand and to visualize large amounts of complex data than to go through spreadsheets or reports. Take any image, for example, we all know the phrase ‘An image is worth a thousand words. This is completely true because images aren’t just a mere collection of pixels, they also hold a lot of information. This information in visual form is easy to understand than reading the same facts in text form.

Data visualization is a quick and easy way to convey concepts or information in a universal manner. Data visualization can help to:

  • Identify key areas and hidden patterns.
  • Get factors that give better customer insights.
  • Analyze and associate data and products properly.
  • Make proper predictions.

This was about data visualization. Next, in this Power BI tutorial, we would see why is Power BI important.

Need For Power BI

The following points make Power BI one of the prominent tools for data visualization. This Power BI tutorial would be incomplete without understanding these points.

  • Spot trends in real-time: Traditional BI tools like Tableau or Qlikview restrict you to historical analysis. By using Power BI you can access real-time information so you can identify trends early. By doing so, you can identify issues and improve performance. 
  • Automatically search hidden insights: With Power BI, you can auto search data sets for hidden insights in seconds with Quick Insights. Users can simply ask questions and Power BI Q&A will answer their questions with immediate effect.
  • Custom visualizations: With Custom visuals, Power BI allows you to visualize data in almost every possible way you can imagine. Thus you are not limited to something that lies in the box.
  • Enterprise-ready: With Power BI and Power BI Desktop, you can securely connect to your own on-premises data sources. With the On-premises Data Gateway, you can connect live to your SQL Server and other data sources. It gives secure, scalable, and reliable enterprise-grade information technology.

The above-mentioned reasons make Power BI very important in the context of data visualization. Let us continue with this Power BI tutorial for Beginners and understand What is Power BI.

What Is Power BI?

Power BI, well this name has been in the BI market for quite a long time. Microsoft team has worked for a long time to build a big umbrella called Power BI, this umbrella is a combination of a strong visualization, data analysis, and a cloud-based tool.

To define it, Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators.

Power BI also gives you cloud-based BI services, known as “Power BI Services”, along with a desktop-based interface, called “Power BI Desktop”. It offers data warehouse capabilities, including data preparation, data discovery, and interactive dashboards. In March 2016, Microsoft released an additional service called Power BI Embedded on its Azure cloud platform which enables the user to analyze data easily, perform various ETL operations and deliver reports with Power BI.

Power BI gateways let you connect with SQL Server databases, Analytical Services, and many other data sources to your dashboard in Power BI and reporting portals, embed Power BI reports and dashboards to give you a unified experience. The image below shows Power BI’s general workflow.

Workflow - Power BI Tutorial - EdurekaNow that we have understood what Power BI is, let us try and understand its important components in the next topic of this Power BI tutorial.

Components Of Power BI

Power BI has the following components: 

components - Power BI Tutorial - Edureka

  • Power Query: It can be used to search, access, and transform public and/ or internal data sources.
  • Power Pivot: It is used in data modeling for in-memory analytics.
  • Power View: You can analyze, visualize and display data as an interactive data visualization using Power View.
  • Power Map: It brings data to life with interactive geographical visualization.
  • Power BI Service: You can share data views and workbooks which are refresh-able from on-premises and cloud based data sources.
  • Power BI Q&A: Ask questions and get immediate answers with natural language query.
  • Data Management Gateway: By using this component you get periodic data refreshers, expose tables and view data feeds.
  • Data Catalog: User can easily discover and reuse queries using Data Catalog. Metadata can be facilitated for search functionality.

Now that we have seen the above mentioned components. Let us continue with this Power BI tutorial and understand Power BI’s architecture. 

Architecture Of Power BI

The following image shows Power BI’s architecture.

ARCHITECTURE - Power BI Tutorial - Edureka

Power BI’s architecture has three phases. The first two phases partially use ETL (Extract, Transform and Load) to handle the data. Let us take a look at these phases one by one:

1. Data Integration

An organisation can be required to deal with data that comes from different sources. The data from data sources can be in different file formats. The data is first extracted from different sources which can be your different servers or databases etc. This data is then integrated in a standard format and then stored at a common area called as staging area.

2. Data Processing

The integrated data is still not ready for visualization because the data needs processing before it can be presented. This data is pre-processed or cleaned. For example, missing values or redundant values are removed from the data set. After the data is cleaned, business rules are applied to the data and it is transformed into presentable data. This data is then loaded into the Data Warehouse.

3. Data Presentation

So once the data is loaded and processed now it can be visualized much better with use of various visualizations that Power BI has to offer. Use of reports, dashboards help one represent data in more intuitive manner. These visuals, reports help business end users to take business decisions based on the insights. 

 

Features of Power BI

  1. Visualizations:

Power BI offers the functionality to visually represent our data or a subset of it so that it can be used to draw inferences or gain a deeper understanding of the data. These visuals can be bar graphs, pie charts, etc. Following are some examples of basic visual options provided in Power BI-

  1. Card – It is used to represent a single value such as Total Sales, etc.
  2. Stacked bar/column chart – they combine a line chart( which joins points representing some values with a line) and a bar/column chart(which represents a value against the purpose and other optional fields).
  3. Waterfall chart – It represents a continuously changing value where increase or decrease in value may be represented by differently colored bars.
  4. Pie chart– it represents the fractional value of each category of a particular field.
  5. Map-It is used to represent different information on a map.
  6. KPI-It represents the continuous progress made towards a target.
  7. Slicer – A slicer has options representing different categories of a field. Selecting that category shows only the information specific to that category in other visuals.
  8. Table – A table represents data in tabular form, i.e rows, and columns.

The following is an example of 4 basic visuals(Slicer, table, pie chart and stacked column chart) created using Power BI.

Apart from these basic visuals, there are options of obtaining more visuals as well. By clicking on the ‘Get more visuals’ option we obtain the following options-

  1. Custom visual files– Custom visuals can be coded and stored in files with .pbiviz extension. This option enables users to import such visuals.
  2.  Organisational visuals– This option can be used to import visuals specific to the user’s organization.
  3.  Marketplace visuals-It is used to import visuals from Microsoft and its fellow community members.

 

  1. Sourcing Varied Datasets

Datasets in Power BI can be sourced from a  variety of sources.

Some common examples of data sources are-

  •         Excel
  •         Power BI datasets
  •         Power BI dataflows
  •         SQL Server
  •         MySQL database
  •         Analysis Services
  •         Azure
  •         Text/CSV
  •         Oracle
  •         PDF
  •         Access
  •         XML
  •         JSON

 

  1. Datasets Filtration

 

While sourcing the data, instead of importing the entire dataset, the user can source a subset of it. This subset may be as per the user requirement. Data may be integrated with Excel, SQL database, Azure, Facebook, MailChimp, etc.

Data can be sourced from either a single source or from more than one source. The following is an example of a dataset sourced in Power BI-

Click on Transform data.

The user can choose the rows or columns as required by him and thus create the desired subset. This selection can be based on a condition such as selecting rows containing values for a particular field in a specific range.

The following image shows a filter applied to the Pclass field in the above dataset.

 

After applying the filter it shows only the rows belonging to Pclass 2 and 3.

 

 

  1. Reports:

A collection of visualizations relevant to a particular topic in Power BI form a dashboard. A combination of these dashboards forms a report.  A report contains visuals related to a particular topic. The user may add any number of pages in the report. Each page is a single screen containing the visuals. The pages can be arranged in the order as required by the user.

The image below shows a sample report.

  1. Dashboards:

All the visuals appearing on a single Power BI page form a dashboard. It is a single page in a report. The visuals can be arranged in any order or position. Since it is a single page a dashboard generally contains only the most important or relevant visuals. Each dashboard can be shared with other users as well.

 

  1. Flexible Tiles

In Power BI, a tile is a single visualization found in a report or on a dashboard. A tile can be thought of as a square or rectangular boundary containing a single visual.

The height and width of each tile are adjustable. The order or position of each tile on the dashboard is adjustable as well.

 

  1. Navigation Pane

 

The Navigation pane is present on the top of the Power BI screen. It has the following tabs-

  •         File
  •         Home
  •         Insert
  •         Modelling
  •         View
  •         Help

There is a range of options in each tab to work with.

8.     Q & A Box

Click on the Q&A button in the Insert tab. The Q & A question box is available where users can type any question related to the data in natural language. Power BI will automatically try to auto complete the question using techniques like rephrasing, autofill, suggestions, etc. The answer is returned in form of visual or text. The user has the option of converting the Text reply to a visual as well.

The below image shows a question asked in natural language (spelling corrected automatically) and its answer in number which can also be converted to a visual.

 

The following image shows the answer converted to a visual.

 

9.     DAX Data Analysis Function

To perform functions on data, the user can use some predefined DAX Data Analysis functions. There are currently around 200 DAX predefined functions available in power BI. DAX or Data Analysis Expressions is a language used to interact with data on platforms like Power BI, PowerPivot and SSAS. It is simple and easy to learn and use.

 

10.   Support  & suggestion

In the Help tab, the user has a variety of options including support to resolve any query. The user can also give feedback or suggestions for improvement.

 

  1. Integration with R

Power BI can be integrated with R scripts as well. This helps in data cleaning, data shaping and thus obtaining advanced analytics.

  1. Security-

Power BI provides robust security where access to each member is controlled. It provides quick responses to security threats. It also provides features like continuous monitoring, reporting, data protection, and unified endpoint management.

 

Data Sources in Power BI

A collection of data that can be imported in PowerBI is known as a dataset. Through the Get Data feature, Power BI users can select from a range of data sources. The data sources can range anywhere from on-premise to cloud-based, unstructured to structured. New data sources are added every month. Data may be sourced from one or many different sources that can be combined together.

To source the data, click on the Get Data icon on the top of the screen. The data sources available for each category are as follows-

File category:

  • Excel
  • Text/CSV
  • XML
  • JSON
  • Folder
  • PDF
  • Parquet
  • SharePoint folder

 

Database category

  • SQL Server database
  • Access database
  • SQL Server Analysis Services database
  • Oracle database
  • IBM Db2 database
  • IBM Informix database (Beta)
  • IBM Netezza
  • MySQL database
  • PostgreSQL database
  • Sybase database
  • Teradata database
  • SAP HANA database
  • SAP Business Warehouse Application Server
  • SAP Business Warehouse Message Server
  • Amazon Redshift
  • Impala
  • Google BigQuery
  • Vertica
  • Snowflake
  • Essbase
  • Actian (Beta)
  • AtScale cubes
  • BI Connector
  • Data Virtuality LDW
  • Denodo
  • Dremio
  • Exasol
  • Indexima
  • InterSystems IRIS (Beta)
  • Jethro (Beta)
  • Kyligence
  • Linkar PICK Style / MultiValue Databases (Beta)
  • MariaDB (Beta)
  • MarkLogic
  • Amazon Athena (Beta)

Power Platform category 

  • Power BI datasets
  • Power BI dataflows
  • Common Data Service (Legacy)
  • Dataverse
  • Power Platform dataflows (Beta)

Azure category 

  • Azure SQL Database
  • Azure Synapse Analytics (SQL DW)
  • Azure Analysis Services database
  • Azure Database for PostgreSQL
  • Azure Blob Storage
  • Azure Table Storage
  • Azure Cosmos DB
  • Azure Data Explorer (Kusto)
  • Azure Data Lake Storage Gen2
  • Azure Data Lake Storage Gen1
  • Azure HDInsight (HDFS)
  • Azure HDInsight Spark
  • HDInsight Interactive Query
  • Azure Cost Management
  • Azure Databricks
  • Azure Time Series Insights (Beta)

 Online Services category 

  • SharePoint Online List
  • Microsoft Exchange Online
  • Dynamics 365 (online)
  • Dynamics NAV
  • Dynamics 365 Business Central
  • Dynamics 365 Business Central (on-premises)
  • Microsoft Azure Consumption Insights (Beta)
  • Azure DevOps (Boards only)
  • Azure DevOps Server (Boards only)
  • Salesforce Objects
  • Salesforce Reports
  • Google Analytics
  • Adobe Analytics
  • appFigures (Beta)
  • Data.World – Get Dataset (Beta)
  • GitHub (Beta)
  • LinkedIn Sales Navigator (Beta)
  • Marketo (Beta)
  • Mixpanel (Beta)
  • Planview Enterprise One – PRM (Beta)
  • QuickBooks Online (Beta)
  • Smartsheet
  • SparkPost (Beta)
  • SweetIQ (Beta)
  • Planview Enterprise One – CTM (Beta)
  • Twilio (Beta)
  • Zendesk (Beta)
  • Asana (Beta)
  • Assemble Views (Beta)
  • Automation Anywhere
  • Emigo Data Source
  • Entersoft Business Suite (Beta)
  • eWay-CRM (Beta)
  • FactSet Analytics
  • Palantir Foundry
  • Hexagon PPM Smart API
  • Industrial App Store
  • Intune Data Warehouse (Beta)
  • Projectplace for Power BI
  • Product Insights (beta)
  • Quick Base
  • SoftOne BI (beta)
  • Spigit (Beta)
  • TeamDesk (Beta)
  • Webtrends Analytics (Beta)
  • Witivio (Beta)
  • Workplace Analytics (Beta)
  • Zoho Creator (Beta)
  • Dynamics 365 Customer Insights (Beta)

Other categories

    • Web
    • SharePoint list
    • OData Feed
    • Active Directory
    • Microsoft Exchange
    • Hadoop File (HDFS)
    • Spark
    • Hive LLAP
    • R script
    • Python script
    • ODBC
    • OLE DB
    • Acterys : Model Automation & Planning (Beta)
    • Anaplan Connector v1.0 (Beta)
    • Solver
    • BQE Core (Beta)
    • Bloomberg Data and Analytics (Beta)
    • Cherwell (Beta)
    • Cognite Data Fusion
    • EQuIS (Beta)
    • FHIR
    • Information Grid (Beta)
    • Jamf Pro (Beta)
    • Kognitwin
    • MicroStrategy for Power BI
    • Paxata
    • QubolePresto (Beta)
    • Roamler (Beta)
    • Shortcuts Business Insights (Beta)
    • Siteimprove
    • Starburst Enterprise
    • SumTotal (Beta)
    • SurveyMonkey (Beta)

    • Microsoft Teams Personal Analytics (Beta)
    • Tenforce (Smart)List
    • TIBCO(R) Data Virtualization (Beta)
    • Vena (Beta)
    • Vessel Insight (Beta)

  • Zucchetti HR Infinity (Beta)
  • Blank Query

Companies using Power BI

The following are some of the companies currently using Power BI-

  1. Stryker
  2. Dematic
  3. Rockwell Automation
  4. GEICO
  5. Compass Group
  6. Helm

 

Steps for Installing Power BI 

  1. First go to the Microsoft Power BI desktop website- https://powerbi.microsoft.com/en-us/desktop/

 

2. Click on the Download  Free Button. The following Page appears.

 

3. Choose the language and click the Download button. The following page appears-

  1. Select the file to download and click Next. The Power BI setup is downloaded.
  2. Open the Power BI setup.
  1. Click Next.
  2. Accept the terms and click next.

  1. Select the Destination folder as required and click next.
  2. Click on Install.

The setup is installed.

12. Click Finish.

 Power BI desktop installation is complete.

 

Now I am going to take this Power BI tutorial a step further with a demonstration of creating a simple report using Power BI. However, there are few prerequisites to get started. First of all you need a ‘Power BI Desktop’ installed on your system, this is an interface where you can create reports. It can be downloaded for free. You may use this link to download Power BI Desktop.

You will be required to login with an organisational email ID like an institute Email ID or your Email ID of the organisation which you work for. It is important you create an account, because this will give you access to Power BI Service which is a must to publish your reports and create dashboards.

Once you have downloaded the Power BI Desktop. You would be needing a data set to visualize it. I would be using the finance data set created by Microsoft and it can be downloaded using this link.

Creating A Report Using Power BI

The image below shows how a Power BI Desktop’s interface looks. The highlighted section in blue colour, on the left panel shows the report, data and relationship workspaces. By default, the report workspace will open. This is where you create reports. Below the reports workspace is the data workspace which is used to see the imported data sets. Last tab is the relations tab which gives you relationship between different variables in a data set, if they are well defined. On the right side, you will see visualizations and field workspace.

PowerBIDesktop - PowerBI Tutorial - Edureka

Power BI Tutorial: Importing Data 

So let us import the finance data set in Power BI. You can click on the Get Data tab which is highlighted in the image below and load the data for usage. 

get data - Power BI Tutorial - Edureka

I have gone ahead and added the finance data set. Power BI will ask you whether you want to load data or edit it. I have simply loaded it because the data set won’t be needing any editing.

Load - Power BI Tutorial - Edureka

You can view by clicking on the data tab on the left hand corner of the interface. If you have taken a look at the data you would understand it is simple data about few countries and their sales in general. In the right corner of the screen, you can see all the fields the data set has. Use the image below for reference.

Data - Power BI Tutorial - Edureka

Power BI Tutorial: Creating Visualizations

Let us go back to our report workspace and create a simple report. The first step is to select a visualization. I would be using a clustered column chart visualization. When you click on the desired visualization, a template is created in the report workspace.

Visualization - Power BI Tutorial - Edureka

Now that we have selected a visualization, I am going to visualize sales and profits on Y-axis and date on X-axis. Since you are using Power BI, you don’t have to worry about complexities of choosing the axis. You just select the fields and it is reflected in the graph. Refer the image below.

visual1 - Power BI Tutorial - Edureka

You can even drag and drop fields on the visualization and the changes would be reflected immediately. In the image below, I have dragged the ‘profit’ field.

visual3 - Power BI Tutorial - Edureka

You can resize these visualizations by just dragging the borders or even move the image by just clicking and placing it anywhere in the workspace.

visual4 - Power BI Tutorial - Edureka

You can even change graphics based on timelines by just clicking. I have changed the yearly representation of the sales data in the above graph to monthly representation. And the insights have changed completely. You can refer the image below to see those changes.

Click - Power BI Tutorial - Edureka

Below the visualization panel you have fields and format tabs. You perform statistical operations like calculating mean, median, sum and even filter data for various parameters by using fields tab. You can use different colour schemes to to make your visualization more appealing and insightful by using the format tab. The image below shows how you can change the colour of the fields used in the visualization.

Visual - Power BI Tutorial - Edureka

We have successfully created a visualization. Creating visualisations in Power BI is as simple as this. I hope by now, you are comfortable enough to create visualizations on your own. You can even go ahead and publish your reports to the web. The image below shows how to publish a report in Power BI.

Publish - Power BI Tutorial - Edureka

Once you publish a report, Power BI will give you a link. You can click on that link and view your report after it is published. For your reference, I have created few other visualizations in a report and published it. You can that report in the form of GIF below. The following have been visualized:

  • Clustered column chart for sales and profits representation
  • Map representation of countries for gross sales
  • Card visualization for sales price
  • Tree map for units sold by different countries.
  • Pie chart for quarterly sales

When you create a report like this in your Power BI Desktop, you will get insights and you can drill-down into the stats. This can be achieved by clicking on different fields that are present in your visualizations.

dashboard - power bi tutorial - edureka

You may choose the visuals that suits your requirement and experiment accordingly. There are a lot of visualizations to try and experiment. Also, when it comes to visualization, no two individuals visualize data in the same way, so your reports may turn out differently. So this is how you can create reports and edit them using Power BI.

Let us now move ahead and take a look at the last topic of this Power BI tutorial. 

Power BI Use Case: Wirepas

Let us take a look at this use case and understand how Wirepas used Power BI to visualize a massive amount of sensor-collected data quickly, easily, and effectively.

About the company

Wirepas focuses on providing the most reliable, optimised, and scalable device connectivity to its customers. With Wirepas, customers can digitalise their current business processes and innovate for new disruptive models. Wirepas has its headquarters in Tampere, Finland, and offices in France, Germany, South Korea and the United States and was established in 2010 in Tampere.

Challenges 

Wirepas technology collects a wide variety of data through its connectivity service. Every wireless device built on Wirepas software technology can collect and send a huge amount of data. This data is collected in several ways and then stored in database. Visualizing this data is key to getting an overview of the current state of “things” tracked by the technology. Wirepas had following obstacles to overcome: 

  • The data was collected from millions of sources and in different formats
  • There was difficulty in displaying the large sensor data collected for a parcel tracking service
  • Finding which parcel was at what location and when
  • What was the parcel’s status
  • How could end users understand the collected IoT data

Wirepas used Power BI to overcome all the above mentioned challenges. Let us take a look at the solution.

Solution and delivery

Acquire the data

The data was imported from different sources and cleaned up using Power BI and Query Editor.

Design the report using Power BI Desktop

After importing and cleaning up the data from 1 million sensors, Power BI  was used to design dashboard that enabled the customers, to get overviews of all data and enable them to drill down to one single parcel and the parcel history

Create a Power BI workspace

To create the Power BI workspace in Azure, the Power BI-CLI was used. Back then, there was no UI available to create workspaces for Power BI in Azure. Therefore, they used the Power BI command line tool for managing Power BI Embedded workspace collections.

Embed Power BI in a web app

Power BI Embedded enabled developers to embed reports in almost every kind of app. This was the easiest way to embed the report into a website.

The following architecture was used to overcome the overall problem:

use case - Power BI Tutorial - Edureka

Conclusion

This was a smart way for Wirepas to bring their IP to the cloud in an easy and fast implementation. The whole project needed limited calling time, consulting, and implementation.

For Bosch Connected World, this was an easy demonstration of complex data based on Azure and Power BI Embedded. Since the workshop, Wirepas has won several new customers who are using its products and dashboards powered by Power BI Embedded. 

If you need a detailed understanding of this use case then you can refer thislink, which will direct you to the page where the actual case study was published.

Difference between Power BI and Tableau

It uses DAX language for calculating and measuring columns

TableauPower BI
It can handle large volumes of data better.It is better suited to smaller datasets.
It is slightly more difficult to use than power BI.It is easier to use and more user friendly.
Embedding Report is more difficult in TableauEmbedding Report is easier in Power BI
Tableau is more expensive.Power BI is cheaper.
It provides better customer supportIts customer support is not that great.
It is used more by users with better expertise.It is used by both naive and expert users.
It provides the facility for the storage of data.It does not provide data storage facility.
It can connect to multiple data sources in a single network.Power BI can connect to only a few limited data sources.
It uses MDX language for calculating and measuring columns.
It is used by medium and large organizations.It is used by small, medium and large organizations.
It is used more for longer run operations and analysis.It is used for generating personalized visualizations and reports.
Licensing is more flexible.Power Bi has strict licensing.

 

Difference between Power BI and SSRS

Power BISSRS
It can be used to generate both cloud based and server based reports.It can be used only for server based reports.
It is more user friendly.It is comparatively more difficult to use.
It is open source and available to all.It is a paid tool
It uses more graphic visualization and coding skills are not required to use it.Coding skills are required to gain expertise in SSRS..
It deals with structured and unstructured data.It deals with structured and semi structured data.
Power BI is the successor of SRSS  and has more features.It has fewer features.
It can be accessed on the mobile app as wellIt cannot be accessed on mobile.
Coding knowledge is not required to gain expertise.Coding knowledge is required to gain expertise.
It provides the facility for integration with AINo integration facility provided with AI
Licensing is required only for Pro and Premium services.Licensing is required for multiple editions.
Implementation is easy.Implementation is more complex.
It has a natural language based Q&A optionIt does not have a natural language based Q&A option.

 

Difference between Power BI and MSBI

Power BIMSBI
It can be used by both naive and experienced usersTo use it coding knowledge is required.
It offers more graphic visualizationsIt offers fewer graphic visualizations.
It offers less specificity.It offers more specificity.
It is cloud based softwareIt is not cloud based and is installed locally.
It can handle data upto 10 MBIt can handle larger volumes of data.
Duration of free version is 60 days.Duration of free version is 180 days.
Learning M and DAX languages is required to gain expertiseLearning MDX language is required to gain expertise
It has a more high level representation of visuals.It is used for a more detailed representation of visuals.
It can be used to create data models along with visuals and reports.It cannot be used to create data models.

 

History of Power BI

  • The Power BI application idea was first proposed by Thierry D’Hers and Amir Netz at Microsoft.
  • The original project name was Gemini. 
  • It was released as an excel add-in in 2009 named ‘PowerPivot’.
  • It slowly became popular.
  • In 2010 it was named project Crescent.
  • It was available publicly on July 11, 2011.

 

Pros and cons of Power BI

PROS
It is open source and available free of cost.
Can Import data from native as well as other connected datasets
It is updated on a regular basis by taking in suggestions from users.
Since data is stored in a centralized location, it can be accessed from anywhere.
It offers interactive graphical visualization and so is user friendly and easy to use.
Power BI Embedded allows users to embed Power BI graphs, visuals and reports into emails and websites.
Users also have the option to upload and view data in excel.
It can integrate on premise and other data sources through personal gateways
There is no memory constraint when shifting to cloud

 

CONS
The language required to use Power BI, i.e. DAX is not easy to use.
It can handle data upto 10 MB only.
Power BI does not perform too well with more than 1 interlinked table.
The user interface of Power BI is crowded making it difficult to view the reports.
It is difficult to gain expertise in advanced Power BI tools like Gateways, Power BI Report Server, Power BI Services.
It does not provide data cleaning feature
There is limited data sharing
The process of generating visuals and reports requires manual effort and cannot be automated.

Power BI tools

The following are the various Power BI tools available-

  1. Power BI Desktop-It is the primary tool of Power BI used to generate models and reports from scratch. It is open source and free to all.
  2. Power BI service-It is an online Power BI service and it can be accessed on the cloud. The data models and reports are hosted on Software as a Service (SaaS). Managing and sharing of reports, etc are done through the cloud. It is a paid tool.
  3. Power BI Data Gateway-They are used to access in premise datasets eg.DirectQuery, Import, Live Query, etc. on the cloud. Gateways are installed by BI Admin.
  4. Power BI Report Server-It is used to host paginated reports, KPIs, mobile and desktop based reports. It is installed and managed by the IT team. It is updated every 4 months.
  5. Power BI Mobile Apps-This tool is used for viewing reports on Mobile including iOS, Android, and Windows applications. The reports are stored on Power BI Service Report Server. It is managed through Microsoft Intune.

 

Who uses Power BI

Power BI is used by these types of profiles:

  • Data analysts
  • Business intelligence professionals
  • Naive users without a technical background

Power BI is often used by management to draw insights and inferences about a company’s forecasts, customer behavior, etc. It can also be used to track an organization’s internal employee performance, etc.

Microsoft Power BI is most often used by companies with 50-200 employees and 10M-50M dollars in revenue.

 

Key terms used in Power BI

The following are some of the key terms used in Power BI

  1. Dashboard-A dashboard is a single page in Power BI that displays the visuals. Each visual is called a tile. The tiles may be arranged in any position or order as required by the user.
  2. Drill down– There can be a hierarchy in which topics are maintained on a dashboard. The drill-down facility provides the user the option of expanding any one topic visualization without leaving the page by clicking on a particular level topic.
  3. Drill through-Drill through facility enables the user to navigate from one report to another by clicking on a part of a visual in a report. A well designed dashboard contains the broader topics which may be expanded by drill through in other reports.
  4. Data model-Data models are used to optimize the data.They store the data in a table format. They also show the relationship between the data sources. It can be used to create more sophisticated dashboards and reports.
  5. Data mart-Data mart is a relational database where data required for modeling is stored. It can be a subset of a larger data warehouse as well.
  6. Power BI Embedded– Power BI Embedded is a product used by developers to embed the Power BI dashboards and reports into their own apps, sites and tools.
  7. Power view– It is a highly interactive and easy to use tool used to create dashboards and reports. Power View requires Analysis Services cubes, tabular models or PowerPivot models. It cannot be used for data in a relational database.
  8. SQL Server– It is used to store and manage data. It is used for transactional/operational databases.
  9. Analysis Services– This technology is used to store, optimize, and model data used for creating dashboards and reports. It can deal with either tabular or multidimensional data.
  10. On premises– On-premise resources are those resources that are located in an organization’s own facilities rather than being accessible for all on the web.
  11. Publish– When a user in Power BI publishes a report, the report is sent to the Power BI service in .pbix format. These .pbix files can be shared with other users.
  12. SaaS– It is an acronym for Software as a Service. It is used for delivering applications on the web.
  13. Correlation– Correlation refers to how 2 things are correlated. A positive correlation means that when one quantity increases, the other also increases. While negative correlation means that with the increase in the first thing’s quantity, the second thing’s quantity decreases.
  14. Cross-filter– Applying filters on one visual by selecting a type in another visual is called cross-filtering.
  15. Gateways– Gateways are used to connect to on-premises data sources. Access to the in-premise data is provided to cloud or mobile-based services through a gateway.

There are several other keywords as well, that you should know of. Please check the following link for more keywords:

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-glossary

This brings us to the end of this blog. I hope you liked this Power BI tutorial blog. This was the first blog of the Power BI  series. This Power BI tutorial will be followed by my next blog, which will focus on Power BI Dashboards, do read that as well.

Subscribe to our youtube channel to get new updates..!

If you wish to learn Power BI and build a career in data visualization or BI, then check out our Power BI Training in Bangalore which comes with instructor-led live training and real-life project experience. This training will help you understand Power BI in-depth and help you achieve mastery over the subject.

Also, If you wish to build a career in business intelligence, our Business Intelligence Course will help you mine that data and enhance the decision-making processes throughout your organization.

Got a question for us? Please mention it in the comments section and we will get back to you.

Upcoming Batches For Microsoft Power BI Certification Training Course
Course NameDate
Microsoft Power BI Certification Training Course

Class Starts on 5th December,2022

5th December

MON-FRI (Weekday Batch)
View Details
Microsoft Power BI Certification Training Course

Class Starts on 17th December,2022

17th December

SAT&SUN (Weekend Batch)
View Details
Microsoft Power BI Certification Training Course

Class Starts on 2nd January,2023

2nd January

MON-FRI (Weekday Batch)
View Details
Comments
2 Comments
  • velia says:

    Recent survey reveals that more than 75% people are engrossed into on-line jobs. On line arena is now bigger and even better and making a lot of make money online opportunities. Working from home online tasks are becoming poplar and transforming individual’s day-to-day lives. Precisely why it is popular? This is because it lets you do the job from anywhere and anytime. You will enjoy more time to devote with your family members and can plan out journeys for getaways. Men and women are making great income of $32000 per week by utilizing the efficient and intelligent techniques. Performing right work in a right direction will definitely lead us in direction of becoming successful. You will start to earn from the 1st day once you visit our website. >>>>> ACT NOW

Join the discussion

Browse Categories

webinar REGISTER FOR FREE WEBINAR
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP

Subscribe to our Newsletter, and get personalized recommendations.

image not found!
image not found!

Power BI Tutorial: A Step by Step Guide with Examples

edureka.co