Learning Microsoft Power BI Lesson 1

Learning Microsoft Power BI Lesson 1

The post “Learning Microsoft Power BI Lesson 1” is the introduction lesson for Power BI. We would like to concentrate more on implementing rather than theory but before that we should understand basic things:

Q. Where we can find the Power BI software?


Here is the link to download Power BI desktop cersion.

Click on Start Free Download Free

Install the downloaded software

Q. Does Microsoft provides any documentation / Tutorial?


Yes! Microsoft is providing the guided learning tutorial

Here is the link for the Microsoft Power BI Tutorial.

Q. What are the main components of Power BI?


Below are the components of Power BI. These are released to market separately also we can use these components individually.

Power BI Desktop: Desktop application for developing BI reports

Power BI Service: SaaS (Soft as a Service) cloud based solution for authoring and sharing the BI reports

Power BI Mobile App: Power BI supports mobile OS Android, iOS and Windows.

Power Query: Is a free add-in for Excel (2010 & 2013) and embedded in Excel 2016. It allows users an easy way to discover, combine and refine data all within the familiar Excel interface.

Power Pivot: Is an In-memory tabular data modelling tool, it’s a free add-in for Excel 2010 and embedded from Excel 2013 and higher.

Power View: It’s a data visualization tool that lets you create interactive charts, graphs, maps, and other visuals. It’s a free add-in from Excel 2013

Power Map: It’s a 3 Dimensional data visualization tool. It’s a free add-in for Excel 2013 and embedded as a “3D Maps” in Excel 2016

Power Q&A: Natural language question and answering engine, it doesn’t require any separate installation or add-in.

Q. What are the Building Blocks of Power BI?


Before going to learn designing the first reports we should understand the building blocks of Power BI. Below are the basic building blocks in Power BI:

  • Visualizations
  • Datasets
  • Reports
  • Dashboards
  • Tiles

Visualizations: A visualization (sometimes also referred to as a visual) is a visual representation of data, such as a chart, a graph, a color-coded map, or other interesting things you can create to represent your data visually. Below image shows a collection of different visualizations regarding travel analysis:

Learning Microsoft Power BI Lesson 1

Dataset: Is a source / Input for Power BI to create visualizations. It can also get data from multiple sources such as SQL Server, Excel, MySQL etc.

Reports: A report is a collection of visualizations that appear together in one or more pages. Ex: Representing product sales for a division. Based on the business requirement we can represent and organize visualizations in one or more pages. Below we are viewing the Page 3 from a 6page report:

Learning Microsoft Power BI Lesson 1

Dashboards: A dash board represents a single page from a report or a group of visualizations. It’s just like a Dashboard in Cricket, in your Car, your user dashboard in Insurance portal, e-store user dashboard etc.

Tiles: A tile is a single visualization in a dashboard. It’s the rectangular box that contains each individual visual.


Here in this introduction lesson we have gone through:

  • Power BI software details
  • Microsoft tutorial details
  • Power BI Components
  • Building Blocks of Power BI

In Next Lesson we will focus on setting up Power BI Desktop and Power BI Service.

Posted in Power BI, SQL Development | Tagged , , , , | 5 Comments

Learn Microsoft Power BI

Learn Microsoft Power BI

This post will give you a small introduction on How to “Learn Microsoft Power BI”. I thought of blogging on Microsoft Power BI when I meet one of my friends. He wants to learn Power BI, he tried to join an institute but end of the day he found it’s difficult to manage the time due to a tight job schedule and odd timings. I suggested him to start self-learning and that’s one of the best ways to learn a new technology and I promised him that I’ll help on something. So let’s see the insights of Microsoft Power BI.

 Q. What is Power BI?


Power BI is a cloud based self-service business intelligence tool where we can easily create, publish and share business reports and dashboards. It’s easy because the end users need not to write a program / algorithm to create reports and it does just require a basic training on how to use Power BI.

Q. Why Power BI?


In order to answer this question we should know why business reports and dashboards are required? And the answer is:

  • Analyze the past trends
  • Predict the future trends
  • Identify the business growth area

Power BI features:

  • Allow non-technical business users to create reports themselves
  • Access your business reports from anywhere securely
  • You can customize the visualizations
  • Power BI’s user interface is fairly intuitive for those users familiar with Excel
  • Easy to learn and implement
  • Embed Power BI reports in your applications
  • We can happily use the free version for small and mid-scale organizations

Q. What are the licensing costs?


Power BI available in three versions:

Power BI Desktop: It’s free to use in your organization or as an individual user

Power BI Pro: Professional license (10$ Per Month per user) adds more features

Power BI Premium: Can benefit the large scale enterprises.

For version vise features please have a look at here.

Q. What are other alternatives for Microsoft Power BI?


Power BI is one of the top Self-Service business intelligence tools, but it always might not suits your business requirement. Below are the some of the alternatives available in market:




SAP Business Objects




Q. What are the prerequisites to learn Microsoft Power BI?


Just 30 min of your valuable time per day and a desire to learn Power BI nothing else

It would be helpful if you know:

  • Microsoft Excel
  • Pivot Tables
  • Basics of Dimensions, Facts and Cubes
  • Basic SQL Queries

Q. What are the Jobs / roles available for Microsoft Power BI?


You may hardly find the dedicated Power BI developer roles but adding a Power BI skill to your profile might increase 20 to 30 percent of weightage based on your profile back ground. If you are working in analytics, business intelligence, SQL development, .NET, Sales, Business Development & Management (Non-Technical) etc. will surely helpful for you to grow. But as per the current market trend mostly Power BI is asking along with the other Microsoft product experience ex: MSBI, SQL Server Developer, Microsoft Dynamics, Data warehousing

Let’s start learning Power BI.

Posted in Power BI, SQL Development | Tagged , , , , , | 3 Comments

Are we heading Towards Recession Again

Are we heading towards recession againThe post “Are we heading towards recession again?” is mainly intended for SQL Developers and DBA’s. Global economy growth sustainability, corporate targets, investments, stock market, oil price, unemployment, dollar value and major Bank balance sheets may decide the recession. Since we are not the financial experts we really can’t get into this stuff but Information Technology is the top industry to have a huge impact if recession hits. From the technology point we can clearly observe that there are major changes has been taken place and it has a direct impact on employment:

  • “Cloud computing”
  • “Automations”
  • “Artificial Intelligence”

Q. “Are we heading towards recession again?”


Yes!!! If you are not ready for the “CHANGE”

No!!! If you are capable to addict the “CHANGE”

Q. How to stop the recession?


You really can’t stop the financial crisis but you can handle it with the persistent preparation. As per the financial market analysts economic downturn might hit the recession but it might be mild one not like in 2007. There is no clear pattern that can exactly predict the recession and how long it will be but we have enough resources available to face the crisis.

Q. How can I get ready for the change?


Continue reading

Posted in Miscellaneous, SQL Development, SQL Server DBA | Tagged , , , , | 19 Comments