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:
- 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
- Features of PowerBI
- Data Sources in Power BI
- Companies using Power BI
- Steps for Installing Power BI
- Building Blocks Of Power BI
- Creating A Report Using Power BI
- Power BI Use Case: Wirepas
- Difference between Power BI and Tableau
- Difference between Power BI and SSRS
- Difference between Power BI and MSBI
- History of Power BI
- Pros and cons of Power BI
- Power BI Tools
- Who uses Power BI
- Key Terms used in Power BI
You may go through this Microsoft Power BI recording where our
Power BI Certification Training
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 Intel
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.
ver 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 oper the years can be divided into 3 waves, so let us continue with our Power BI tuntunan 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?
In 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
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
invented geometrical charts. His restoran charts were used to represent Scotland’s imports and exports of 17 countries in 1781. These kafe 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 mondial 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 tuntunan would be incomplete without understanding these points.
Spot trends in cak benar-time:
Traditional BI tools like Tableau or Qlikview restrict you to historical analysis. By using Power BI you can access
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.
With Custom visuals, Power BI allows you to visualize data in almost every possible way you can imagine. Thus you are titinada limited to something that lies in the box.
With Power BI and Power BI Desktop, you can securely connect to your own on-premises data sources. With the
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 2022, 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
in Power BI and
portals, embed Power BI reports and dashboards to give you a unified experience.The image below shows Power BI’s general workflow.
Now that we have understood what Power BI is, let us try and understand its important components in the next topic of this Power BI kursus.
Components Of Power BI
Power BI has the following components:
It can be used to search, access, and transform public and/ or dalam data sources.
Power Pivot: It is used in data modeling for in-memory analytics.
You can analyze, visualize and display data as an interactive data visualization using Power View.
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 les and understand Power BI’s architecture.
Architecture Of Power BI
The following image shows Power BI’s architecture.
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
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
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-
– It is used to represent a single value such as Total Sales, etc.
Stacked restoran/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).
– It represents a continuously changing value where increase or decrease in value may be represented by differently colored bars.
- Pie chart– it represents the fractional value of each category of a particular field.
- Map-It is used to represent different information on a map.
- KPI-It represents the continuous progress made towards a bulan-bulanan.
– A slicer has options representing different categories of a field. Selecting that category shows only the information specific to that category in other visuals.
– 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-
- Custom visual files– Custom visuals can be coded and stored in files with .pbiviz extension. This option enables users to import such visuals.
- Organisational visuals– This option can be used to import visuals specific to the user’s organization.
- Marketplace visuals-It is used to import visuals from Microsoft and its fellow community members.
Sourcing Varied Datasets
Datasets in Power BI can be sourced from a variety of sources.
Some common examples of data sources are-
- Power BI datasets
- Power BI dataflows
- SQL Server
- MySQL database
- Analysis Services
While sourcing the data, instead of importing the entire dataset, the user can source a subset of it. This subset may be as saban 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 pengayak applied to the Pclass field in the above dataset.
After applying the filter it shows only the rows belonging to Pclass 2 and 3.
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.
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 proyek 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.
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 okuler.
The height and width of each tile are adjustable. The antaran or position of each tile on the dashboard is adjustable as well.
The Navigation pane is present on the top of the Power BI screen. It has the following tabs-
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 optis 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.
- 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.
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-
- SharePoint folder
- 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 Peladen
- Amazon Redshift
- Google BigQuery
- Actian (Beta)
- AtScale cubes
- BI Connector
- Data Virtuality LDW
- InterSystems IRIS (Beta)
- Jethro (Beta)
- Linkar PICK Style / MultiValue Databases (Beta)
- MariaDB (Beta)
- Amazon Athena (Beta)
Power Platform category
- Power BI datasets
- Power BI dataflows
- Common Data Service (Legacy)
- Power Tribune dataflows (Beta)
- 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)
- 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 Jago merah
- 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)
- SharePoint list
- OData Feed
- Active Directory
- Microsoft Exchange
- Hadoop File (HDFS)
- Hive LLAP
- R script
- Python script
- OLE DB
- Acterys : Model Automation & Planning (Beta)
- Anaplan Connector v1.0 (Beta)
- BQE Core (Beta)
- Bloomberg Data and Analytics (Beta)
- Cherwell (Beta)
- Cognite Data Fusion
- EQuIS (Beta)
- Information Grid (Beta)
- Jamf Menyebelahi (Beta)
- MicroStrategy for Power BI
- QubolePresto (Beta)
- Roamler (Beta)
- Shortcuts Business Insights (Beta)
- 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-
- Rockwell Automation
- Compass Group
Steps for Installing Power BI
- 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-
- Select the file to download and click Next. The Power BI setup is downloaded.
- Open the Power BI setup.
- Click Next.
- Accept the terms and click next.
- Select the Destination folder as required and click next.
- 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
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
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,
e 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.
Power BI Cak bimbingan: 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
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
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
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.
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 jatuh 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
tabs. You perform statistical operations like calculating mean, median, sum and even filter data for various parameters by using
tab. You can use different colour schemes to to make your visualization more appealing and insightful by using theukuran
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 undian 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
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 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 takat following obstacles to overcome:
- The data was collected from millions of sources and in different formats
- There was difficulty in displaying the large penapisan 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:
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 this
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
|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 Tableau||Embedding Report is easier in Power BI|
|Tableau is more expensive.||Power BI is cheaper.|
|It provides better customer support||Its 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
|It can be used to generate both cloud based and peladen 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 taruk 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 well||It 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 AI||No 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 option||It does not have a natural language based Q&A option.|
Difference between Power BI and MSBI
|It can be used by both naive and experienced users||To use it coding knowledge is required.|
|It offers more graphic visualizations||It offers fewer graphic visualizations.|
|It offers less specificity.||It offers more specificity.|
|It is cloud based software||It is not cloud based and is installed locally.|
|It can handle data upto 10 MB||It 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 expertise||Learning 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, 2022.
Pros and cons of Power BI
|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|
|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-
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.
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.
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.
Power BI Report Peladen-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.
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 dalam 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
Dashboard-A dashboard is a single page in Power BI that displays the visuals. Each okuler is called a tile. The tiles may be arranged in any position or order as required by the user.
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.
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.
Data model-Data models are used to optimize the data.They store the data in a table dimensi. They also show the relationship between the data sources. It can be used to create more sophisticated dashboards and reports.
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.
- 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.
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.
SQL Server– It is used to store and manage data. It is used for transactional/operational databases.
Analysis Services– This technology is used to store, optimize, and kamil data used for creating dashboards and reports. It can deal with either tabular or multidimensional data.
- 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.
- Publish– When a user in Power BI publishes a report, the report is sent to the Power BI service in .pbix ukuran. These .pbix files can be shared with other users.
- SaaS– It is an acronym for Software as a Service. It is used for delivering applications on the web.
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.
Cross-penapis– Applying filters on one visual by selecting a type in another visual is called cross-filtering.
- 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:
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 ourPower 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 adv lewat the subject.
Got a question for us? Please mention it in the comments section and we will get back to you.