Power BI for Beginners and Dummies

What is Power BI?

Power BI is a data analytics and visualization software from Microsoft.

Microsoft Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Power BI has more than 100 data connectors which allows users to easily and seamlessly connect to various data sets.
In simple terms, Power BI is a data analytics software in the Microsoft Office 365 application suit.

Introducing Microsoft Power BI Amazon Product Link

This book is great for beginners and this is one of the best seller books of Power BI in Amazon. This has 4.5+ rating and has kindle edition as well.

Why Use Power BI?

Today’s business world has changed and it is hugely Data Driven. Small to large organizations, all use Data and Data Analytics to make decisions about sales, new project expansions, market trends and many more. Even though every company has access to data but it can be intimidating to try to understand it without a background data-analytics or statistics. Moreover data needs to be represented in an interactive and understandable UI to make it meaningful. Power BI comes to the rescue for such data analytics requirements.

Power BI is free to use but Pay to consume software, which means you can use it for free but you cannot share your analytics reports and dashboards with anyone using free license. So if you are willing to learn data analytics, then you can get started for free by creating a Microsoft account.

Power BI Application Type

Power BI has three different applications, Power BI desktop application, Power BI web app (SAAS), and mobile app. All the three applications allows users to create, share power bi reports effective and easily.

Introducing Microsoft Power BI – Amazon Link

This book is great for beginners and this is one of the best seller books on Power BI in Amazon. This has 4.5+ rating and has kindle edition as well.

Components of Power BI

What is Power BI Training

The major building blocks of Power BI are: datasets, reports, and dashboards. Some other important components are workspaces, apps etc.

>> Datasets

dataset in Power BI is a collection of data that you import or connect to. Datasets are associated with workspaces and a single dataset can be part of many workspaces.

>> Reports

A Power BI report is one or more pages of visualizations such as line charts, maps, and tree maps. You can create reports from scratch within Power BI, import them or Power BI can create them when you connect to datasets.
There are two modes to view and interact with reports: Reading view and Editing view. By default, the report opens in Reading view. Just select Edit report to open it in Editing view.

>> Dashboards

dashboard is a single canvas that contains zero or more tiles and widgets. Each tile pinned from a report.
Okay if we are just pinning reports then why do we need a dashboard ? well, there are a few reasons for creating a dashboard, below are a few of them

  • You can see all the information at a glance and no need to go through multiple reports
  • You can create different dashboards for different requirements
  • Dashboard is a way to ensure that everyone in team is seeing the correct reports / data.

>> Workspaces

Workspaces are containers for dashboards, reports, datasets, and dataflows in Power BI. There are two types of workspaces: My workspace and workspaces.
My workspace is the personal workspace for any Power BI customer to work with your own content. Only user has access to his workspace.
Workspaces are used to collaborate and share content with colleagues. You can add colleagues to your workspaces and collaborate on dashboards, reports, and datasets.

>> Apps

Power BI apps are just an easy way of sharing Power BI Dashboards/reports with many users (organizations). Moreover, consumers do not need a pro license to access Apps.

Rich Dad Poor Dad: Amazon Product Link

Know what the Rich Teach Their Kids About Money That the Poor and Middle Class Do Not!

Some Tutorial Videos

Videos are always good for learning a new thing. Hence I have included few free and paid videos which you can check if you are interested in learning more about Power BI.

Create your First Report

It is recommended to create Power BI reports in Power BI desktop app but for simplicity, we will create in web app directly. To download desktop app, search for Pwoer Apps in windows app store. After following the below steps, your report should look like the following.

Power-BI-report-example
Power BI report example

For this example I have used this free data which I found on the internet

  • Follow this steps to create your first report
    1. Navigate to Power BI web service app
    2. Click on Get data at the bottom right corner and choose Files > Local File
    3. Choose the above excel file and choose Import Data into Power BI
    4. After successfully importing the data navigate to My Workspace. You should be able to see a new dashboard as shown in the below image.
Power-BI-create-Report-in-web-service
Power-BI-create-Report
power bi training my workspace
my workspace
  1. Next, click on the dashboard to open it. Then click on the blank report inside it.
  2. Next mark the columns as show in the below image.
power bi training
choose columns as you want to show

Next Steps

Introducing Microsoft Power BI Amazon Product Link

This book is great for beginners and this is one of the best seller books of Power BI in Amazon. This has 4.5+ rating and has kindle edition as well.

That’s all I have for this Power BI beginner training course, I hope this training has helped you to learn more about Power BI features and its capabilities. To learn more check this Microsoft documentation.

Please Help us Grow!

I hope you have found this article helpful. If you are happy with the document, please use the below links when you buy something from Amazon to help us grow.

How this works?

Amazon affiliate program gives a small (%)share of price to the referrers, so feel free to buy anything.
Below are some Amazon affiliate links, if you open amazon application/website using these links and buy something, (it can be one of the below items or anything of your choice) Then Amazon will give us a little percentage(%) of the money you spend on Amazon. To know more check this document.

Amazon Affiliate Links

$350-Best Student laptop
Amazon In, Amazon US

$600-Work laptop
Amazon In, Amazon US

$989– High performance
Amazon In, Amazon US

Headset – $15.99
Amazon In, Amazon US

Lightspeed Mouse – $39
Amazon In, Amazon US

Keyboard – $29
Amazon In, Amazon US

The Psychology of Money
Amazon In, Amazon

Atomic Habits:
Amazon In, Amazon

Find Balance and Purpose in Life
Amazon In, Amazon

$30, Smart Watch for Smart you
Amazon In, Amazon US, Amazon UK

Work comfortably with $110
Amazon In, Amazon US, Amazon UK

Exercise at home
Amazon In, Amazon US, Amazon UK

More Ways to Help

Thank you
For your Contribution


Newbietechie.com
Author @ramizmollahmd

About Ramiz

Ramiz is a professional working in an MNC as a business and technology consultant for quite a few years now. Ramiz is proficient in various Microsoft tools and technologies. He is a tech enthusiast and an active blogger. Ramiz spends his free time playing games or watching movies. He writes blogs to share his knowledge with the world and to make it a better place to live.


Leave a Comment