Learning Microsoft Power BI Lesson 2

Learning Microsoft Power BI Lesson 2

The post “Learning Microsoft Power BI Lesson 2” takes you through installing and connecting to “Power BI Desktop” and “Power BI Service”.

Power BI – Desktop:

This is a windows desktop application and we can download and install from here:

Learning Microsoft Power BI Lesson 2

This is a straight forward process to install Power BI Desktop. Once you download the file and install it:

Learning Microsoft Power BI Lesson 2 Learning Microsoft Power BI Lesson 2 Learning Microsoft Power BI Lesson 2 Learning Microsoft Power BI Lesson 2 Learning Microsoft Power BI Lesson 2

Now we installed Power BI desktop, we’ll explore these options in next lesion. Now we’ll see how to connect to Power BI Service.

Power BI Service:

This is a cloud based (SaaS) service where we can create, publish and share reports with in your organization. As per the Power BI work flow, we create reports using Power BI Desktop, publish reports to Power BI Service and Share reports with others so that they can view reports in the BI service or on Power BI Mobile App.

But setting up / signing up to Power BI service is not that easy as it’s only available with Pro Version license. But we can try with 60-Day trial version.

Here you can sign-up to Power BI Service:

Learning Microsoft Power BI Lesson 2 Learning Microsoft Power BI Lesson 2 Learning Microsoft Power BI Lesson 2

Here the problem is we can’t use the personal email to sign up with Power BI Service rather we should use a work or office email.

  • If you want to sign-up using your office email ID, check with your office policy and take the required approval from the enterprise (Infosec / Audit / Security) team
  • Try setting up a free account at Office 365 then we can use that email account to sign-up to Power BI Service Pro version.
  • Setup trial for Office 365 “Home” & “Portal

 Once you are ready with the required email ID then sign up for Power BI Service:

Learning Microsoft Power BI Lesson 2 Learning Microsoft Power BI Lesson 2

Summary:

  • We understand how to download and Install Power BI Desktop
  • Setting up a new account and signing to Power BI Service
  • Setting up Office 365 account for a trial version and we used that account for logging into Power BI
  • Even the Office 365 account expired the same account will work with Power BI

Now we all set with Power BI Desktop and Power BI Service, in Lesson 3 we’ll start exploring options for Power BI Desktop

About Power BI, Power BI Introduction

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

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?

Ans:

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?

Ans:

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?

Ans:

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?

Ans:

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.

Summary:

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?

Ans:

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?

Ans:

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?

Ans:

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?

Ans:

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:

Sisense

Tableau

QlikView

SAP Business Objects

ElasticSearch

MicroStrategy

Etc…..

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

Ans:

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?

Ans:

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 , , , , , | 4 Comments