Introduction to Power BI

In this lesson, you will get an understanding of Business Intelligence, Power BI, Prower BI products and Power BI architecture.

Hi Everyone, In this Unit “Introduction to Microsoft Power BI”, we will cover

  • What is Business Intelligence
  • What is Power BI
  • Power BI Products introduced by Microsoft
  • Microsoft Power BI Architecture

What is Business Intelligence?

Let’s start with the first topic which is what is business intelligence. Business intelligence is a set of processes, architectures, and technologies that converts your raw data into meaningful information that drives profitable business actions. Business intelligence combines data mining data visualization data tools and infrastructure and best practices to help the organization to make more data-driven decisions.

What is Data Mining?

Now let’s understand, what data mining is? Data mining is looking for a hidden valid and potentially useful pattern in your data set which means pattern detection in your data set. Which is very common in data analysis? Let’s take the example of online stores like Amazon or supermart like Walmart. If they detect the customer purchase behavior, discover customer shopping patterns that will help them to improve the quality of customer service and achieve better customer retention.

What is Data Visualization?

Now let’s understand what Data Visualization is. Data visualization is a technique that we use to communicate the insights from the data through graphs, charts or indicators.

What is Power BI?

Power bi is the business analytical solution or a tool created by Microsoft that lets you detect pattern in your data, lets you visualize your data and share insights across your organization.

Products Introductions by Microsoft?

Power BI Desktop: Power BI Desktop is a free product. Power BI desktop we use to create reports and then we publish those reports on power BI Services ( or Power BI Server.

Power BI Services ( On power BI services we publish(save) our reports which we create using Power BI desktop. Using Power BI Services, we can share insights anytime, anywhere with colleagues. We can control access by users with specific roles. We can apply row-level security. Power BI Services is Microsoft’s website.

Power BI Server: This is for On-premise reporting solutions. If you don’t want to save your work on Microsoft’s websites and you are looking for an on-premise solution you can go for Power BI Server instead of Power BI services. This is also a paid product. On Power BI Server we have to manage the infrastructure.

Power BI Mobile App: When we publish our reports and dashboards on power BI services, we can access the same using the Power BI Mobile app. We can download Power BI mobile app for android, IOS, and windows from the market place. On mobile apps, we also get the push notifications for data alerts for all the reports for which we have access to power BI Services.


Power BI Architecture:



Using Power BI Desktop, we prepare our reports then we publish our reports on Power BI Services. As power BI services are it’s a website, so the user can access the website using any device like laptop, mobile or desktops. We can direct our data sources to Power BI Services. Now to make our services a Self-BI, for a job like scheduling, refresh we have to install the Power BI gateways. As is Microsoft’s website, so they can’ access out organizational servers for that we install Power BI Gateway’s within our infrastructure. Power BI Gateway acts as a bridge between Power BI services and our organizational data sources.


SEE ALL Add a note
Add your Comment


"The models created by the EC Analytics team enabled us to target our retention efforts and take immediate action to retain at-risk customers.  The insights from their analyses also enabled us to...Read more

Rajib Kumar Jha (Head Customer Support)

Nestle India Private Limited

Recent Posts

EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

Social Media



0124- 4601426

EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED