Power BI Tutorial
The idea of Business Intelligence is something that is strange to very scarcely any individuals nowadays. With newer tools emerging everyday to help explain the crisis of data management, most organizations have already moved in or have plans to utilize Business Intelligence in tackling their crisis. Power BI is Microsoft’s latest BI instrument basically meant to assist everyone with breaking down and envision their data. This Power BI tutorial will give you a total knowledge into Power BI in the accompanying grouping:
- What Is Business Intelligence And Why Do We Need It?
- What Is Data Visualization And Its Importance?
- Need For Power BI
- What Is Power BI?
- Components Of Power BI
- Architecture Of Power BI
- Building Blocks Of Power BI
- Creating A Report Using Power BI
- Power BI Use Case: Wirepas
Power BI Tutorial
What Is Business Intelligence (BI)?
During a time where Business Intelligence has become a bigger space than most trending innovations, in the event that you ask twenty individuals what the term business intelligence implies, you are probably going to find ten different solutions. So let me put it in the least difficult terms without losing its technicality. Business intelligence (BI) is the arrangement of procedures and tools for the transformation of raw data into significant and valuable information for business investigation. To lay it out plainly, Business intelligence is the innovation which gets the right data to the right individuals, at the right time with the goal that they can settle on more compelling business choices.
Over the years, the process of business intelligence has grown and adjusted to help illuminate practically all the difficulties while managing data by including newer tools and procedures. The change that Business Intelligence has seen over the years can be separated into 3 waves, so let us proceed with our Power BI tutorial and investigate these three waves.
1st Wave: Technical (IT To End User)
During the first rush of business intelligence, the end user must be reliant on the IT department for data bits of knowledge. This is on the grounds that it was impractical for end users to create visualizations/reports all alone as tools accessible required specialized information. This reliance on IT department for bits of knowledge resulted in more efforts and time utilization to complete the updates.
2nd Wave: Self-Service (Analyst To End User)
The subsequent wave gave analysts admittance to BI. Presently, individuals with some information on analytics could utilize the BI tools. This implied more groups approached BI and more individuals could have better data experiences, this facilitated its role groups.
3rd Wave: Everyone (End User)
The third wave has made it easier to get to data and create reports, visuals to improve business bits of knowledge. The introduction of tools like Power BI made this transition simple. Presently anyone who has fundamental understanding of the data can create reports to fabricate intuitive and shareable dashboards.
This was about BI, presently let us proceed with our Power BI tutorial and understand another important theme that is related with BI.
What Is Data Visualization And Its Importance?
Data-Visualization – PowerBI Tutorial – EdurekaIn a nutshell, data visualization is only the pictorial or graphical representation of information/data. It provides experiences into complex data sets by imparting the key angles in more intuitive and important manners. Data visualization lies at the intersection of plan, correspondence and information science.
Despite the fact that data visualization has been termed as the key aptitude for research in the twenty-first century, it goes route back. It existed in the late eighteenth century and can be traced back when William Playfair imagined geometrical charts. His bar charts were utilized 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 utilize pictures, charts or graphs to understand and to imagine large measures of complex data, than to experience spreadsheets or reports. Take any picture for instance, we as a whole know the phrase ‘A picture is worth a thousand words’. This is totally true since pictures aren’t only a mere assortment of pixels, they likewise hold a ton of information. This information in visual form is straightforward than reading similar realities in text form.
Data visualization is a brisk and simple approach to pass on ideas or information in a universal manner. Data visualization can help to:
- Distinguish key areas and concealed patterns.
- Show signs of improvement customer experiences.
- Examine and partner data and products properly.
- Make proper predictions.
This was about data visualization. Next, in this Power BI tutorial we would perceive any reason why is Power BI important.
Requirement For Power BI
Following focuses make Power BI one of the prominent tools for data visualization. This Power BI tutorial would be fragmented without understanding these focuses.
- Spot trends in real time: Traditional BI tools like Tableau or Qlikview restrict you to historical examination. By utilizing Power BI you can get to real-time information so you can distinguish trends early. Thusly, you can distinguish issues and improve performance.
- Naturally search concealed experiences: With Power BI, you would auto be able to search data sets for shrouded bits of knowledge in seconds with Quick Insights. Users can essentially pose inquiries and Power BI Q&A will answer their questions with quick impact.
- Custom visualizations: With Custom visuals, Power BI permits you to envision data in pretty much every conceivable way you can envision. Hence you are not limited to something that lies in the container.
- Enterprise-ready: With Power BI and Power BI Desktop, you can securely interface with your own on-premises data sources. With the On-premises Data Gateway, you can associate live to your SQL Server, and other data sources. It gives secure, adaptable and reliable enterprise-grade information innovation.
The previously mentioned reasons make Power BI very important in setting of data visualization. Let us proceed with this Power BI tutorial and understand What is Power BI.
What Is Power BI?
Power BI, well this name has been in the BI market for quite a while. Microsoft group has worked for quite a while to fabricate a big umbrella called Power BI, this umbrella is a combination of a strong visualization, data investigation and a cloud based device.
To characterize 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 without anyone else, without relying upon information innovation staff or database administrators.
Power BI additionally gives you cloud-based BI services, known as “Power BI Services”, alongside a work area 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 empowers the user to break down data effectively, perform various ETL operations and deliver reports with Power BI.
Power BI entryways let you associate with SQL Server databases, Analytical Services, and numerous other data sources to your dashboard in Power BI and reporting portals, insert Power BI reports and dashboards to give you a bound together experience. The picture beneath shows Power BI’s general workflow.
Components Of Power BI
- 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.
Architecture Of Power BI
The following image shows Power BI’s architecture.
Power BI’s architecture has three stages. The first two stages partially use ETL (Extract, Transform and Load) to deal with the data. Let us investigate these stages individually:
1. Data Integration
An organization can be required to manage data that originates from different sources. The data from data sources can be in different record formats. The data is first extracted from different sources which can be your different servers or databases and so forth. This data is then integrated in a standard format and afterward stored at a typical area called as organizing area.
2. Data Processing
The integrated data is as yet not ready for visualization on the grounds that the data needs processing before it can be presented. This data is pre-processed or cleaned. For instance, missing qualities or redundant qualities 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 stacked into the Data Warehouse.
3. Data Presentation
So once the data is stacked and processed now it can be imagined much better with utilization of various visualizations that Power BI has to bring to the table. Utilization of reports, dashboards assist one with representing data in more intuitive manner. These visuals, reports assist business with finishing users to take business choices dependent on the experiences.
The following subject of this Power BI tutorial is building squares of Power BI.
Building Blocks Of Power BI
Everything you do in Power BI can be broken down into following structure blocks. A decent understanding of these structure squares would assist you with understanding ideas and will let you create definite and complex reports.
The essential structure squares of Power BI are the accompanying:
A visual representation of data is called visualization. For instance, a chart or a graph can be utilized to represent data outwardly. Power BI gives you different visualization types, which continue getting refreshed with time. Following picture shows some ordinarily utilized visualizations:
- Guide representation
- Card visualization
- Stacked area chart
- Tree map
- Pie chart
Visualizations can be basic or they can be outwardly unpredictable. However, visualization targets presenting data so that it gives you more experiences in the specific situation, which is otherwise hard to discern from basic data documents.
We realize that data-set is only an assortment of data or information. Power BI harnesses this data to create visualizations. It can be a basic data set or a combination of various sources, which can be filtered and combined to provide a different data set altogether.
For instance, you can arrange data from a wide range of sources like different database handle, an exceed expectations table, and online results of some email mission to create the data set. Having said that, you might need to filter your data before you bring it into Power BI. Filtering lets you center around the data that matters to you. The picture underneath shows an example data set.
With the data set ready, you are free to create visualizations and display different portions of that data set in different ways, and with this, you gain insights.
A collection of visualizations that appear together on one or more pages is a report in Power BI. It is a collection of items that are related to one another.
You can create visualizations, on multiple different pages if necessary, and arrange them in a way that suits your story best. The image below shows a sample report.
A Power BI dashboard is a solitary page interface. It is regularly called a canvas, that utilizes visualizations to recount to a story. Since it is limited to one page, an all around planned dashboard contains just the most-important components of that story. The visualizations you see on the dashboard are called tiles and are stuck to the dashboard from reports.
In Power BI, a tile is a solitary visualization found in a report or on a dashboard. It’s the rectangular box that contains every individual visual.
Power BI gives you the freedom to move or arrange tiles, so you can present the data the manner in which you need to, even while you’re creating a report or a dashboard. You can make the tiles bigger, change their stature or width, and cuddle them up to other tiles the manner in which you need.
o this was about Power BI’s structure blocks, presently I will take this Power BI tutorial above and beyond with a demonstration of creating a straightforward report utilizing Power BI. However, there are not many prerequisites to begin. First of all you need a ‘Power BI Desktop’ introduced on your framework, this is an interface where you can create reports. It can be downloaded for free. You may utilize this connect to download Power BI Desktop.
You will be required to login with an organizational email ID like an institute Email ID or your Email ID of the organization which you work for. It is important you create a record, since this will give you admittance to Power BI Service which is an absolute necessity to distribute your reports and create dashboards.
Creating A Report Using Power BI
The picture underneath shows how a Power BI Desktop’s interface looks. The featured segment in blue color, on the left board shows the report, data and relationship workspaces. Of course, the report workspace will open. This is where you create reports. Underneath the reports workspace is the data workspace which is utilized to see the imported data sets. Last tab is the relations tab which gives you relationship between different variables in a data set, in the event that they are very much characterized. On the right side, you will see visualizations and field workspace.
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.
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.
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.
Power BI Tutorial: Creating Visualizations
Release us back to our report workspace and create a basic report. The first step is to choose a visualization. I would utilize a clustered section chart visualization. At the point when you click on the desired visualization, a layout is created in the report workspace.
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.
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.
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.
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.
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.
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.
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.
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.
Wirepas innovation gathers a wide variety of data through its connectivity service. Every wireless gadget based on Wirepas software innovation can gather and send a tremendous measure of data. This data is gathered in several different ways and afterward stored in database. Picturing this data is critical to getting an overview of the current condition of “things” tracked by the innovation. Wirepas had following deterrents to overcome:
- The data was gathered from a large number of sources and in different formats
- There was trouble in showing the large sensor data gathered for a parcel tracking service
- Discovering which parcel was at what area and when
- What was the parcel’s status
- How could end users understand the gathered IoT data
Wirepas utilized Power BI to overcome all the previously mentioned difficulties. Let us investigate the solution.
This was a smart path for Wirepas to bring their IP to the cloud in a simple and quick usage. The entire project required limited calling time, counseling, and execution.
For Bosch Connected World, this was a simple demonstration of complex data dependent on Azure and Power BI Embedded. Since the workshop, Wirepas has won several new customers who are utilizing its products and dashboards powered by Power BI Embedded.
In the event that you need a definite understanding of this utilization case, at that point you can refer this connection , which will direct you to the page where the real contextual investigation was distributed.
This brings us to the furthest limit of this blog. I trust you enjoyed this Power BI tutorial blog. This was the first blog of the Power BI series. This Power BI tutorial will be trailed by my next blog, which will zero in on Power BI Dashboards, do read that too.