Power BI Desktop: Visualize Data Like Never Before

Last updated on Jun 24,2020 6.8K Views
Upasana
Research Analyst, Tech Enthusiast, Currently working on Azure IoT & Data Science... Research Analyst, Tech Enthusiast, Currently working on Azure IoT & Data Science with previous experience in Data Analytics & Business Intelligence.
1 / 5 Blog from Reporting in Power BI

We live in the times of ever-expanding data. And where there’s data, there’s analytics on top of it. Anyone who has ever worked with data or aspires to needs to have hands-on experience with a few tools. One such tool is the Microsoft Power BI Desktop.

I guess that is why you all are here. Because you’ve either heard or read about this new end in-analytics tool by Microsoft. Well, you’ve come to the right place. This blog, specifically, will help you with all you need to get started with Power BI certification training. Hope you enjoy learning this new piece of technology.

In this Power BI Desktop Tutorial, you will be learning the following topics:


So, let’s begin by understanding a little bit about Power BI.

 

What is Power BI?

It is a cloud-based, Business Intelligence Service by Microsoft which provides non-technical Business users with tools for Reporting, Analytics and Visualisation.

All the concepts in the blog are also explained in ample detail in the video given here.

Power BI Full Course – Learn Power BI in 4 Hours | Power BI Tutorial for Beginners | Edureka

 

 

This Edureka video will help you understand and learn Power BI in detail. This video is ideal for both beginners as well as professionals who want to master up their Power BI concepts.

What is Power BI Desktop?

Power BI Desktop allows you to ingest, transform, integrate and enrich your data. Connecting to all your data sources, Power BI Desktop simplifies data evaluation and sharing with scalable dashboards, interactive reports, embedded visuals and more.Power BI Desktop

The most common uses for Power BI Desktop are as follows:

  • Connect to data

  • Transform and clean that data, to create a data model

  • Create visuals, such as charts or graphs, that provide visual representations of the data

  • Create reports that are collections of visuals, on one or more report pages

  • Share reports with others by using the Power BI service

People most often responsible for such tasks are often considered data analysts (sometimes referred to as analysts) or business intelligence professionals (often referred to as report creators).

However, many people who don’t consider themselves an analyst or a report creator use Power BI Desktop to create compelling reports, or to pull data from various sources and build data models, which they can share with their coworkers and organizations.

Creating a Report on the Power BI Desktop basically consists of 3 steps:

  • Import Dataset to Model
  • Play around with Visualizations
  • Create a Report

The more you use it, the better you’ll get at it. So, let’s get started.

Power BI Desktop Installation

It’s a pretty simple process. All you have to do is:

  • Go to powerbi.com
  • Products >> Power BI Desktop >> Downloads page
  • Click on the Download ButtonPower BI Installation

You could just be a free user at first and then download a paid version later if you like. You can see the differences between being a free user and a paid user at the Pricing page. The basic difference only arises with data usage capacity.

You can open your Power BI Desktop directly from here. So, what you see when open the Power BI Desktop are these tutorial videos on building reports, query concepts, etc.Power BI Opening Page

Importing Datasets into Power BI Desktop

The first thing you do in order to build a dashboard is, you connect to data sources. Following are the steps you need to follow to import the datasets.

  • Click on the Get Data button
  • Select the data source you want to connect to. You’ve got excel, csv, azure, etc. You can even scrape data off web pages, so lots of neat stuff.
  • Load it into your model. Getting Data into the Model

Basic Views in Power BI Desktop

So, when you first load your data you see a blank screen. On the left, you see these 3 basic views you have here.

  1. Report View

    Here you’ll create the dashboard.

  2. Data View

    Here you get a preview of your data and make changes if you want to. This is also where you can create a new calculated column.

  3. Relationship View

    Here you can see the relationship in the objects.Views on Power BI Desktop

Pro-Tip

It’s always advisable, to begin with the data view. You basically get the preview of what your data looks like. Here are a few things to take care of, before you actually start creating the dashboard.

  1. Rename columns

    We’re building the dashboard for the user. All the naming conventions and data types are going to appear at the surface and we want it to be as interactive as possible.

  2. Delete Columns

    Anything that’s not absolutely necessary in the model – delete it. Because it’s going to contribute to the size of the model and take up more system resources whilst processing.

  3. Hide Columns

    Hide the columns that you need later for calculation purposes, but the user doesn’t necessarily need to see. The hidden column will appear greyed out and won’t appear in the report view.

    Data View on Power BI Desktop

Once you’re done with all the transformations, you can directly go to the report view of your Power BI Desktop.

Building a Report

Now, you’re ready to start the fun part and it’s creating the report.

It’s pretty easy to work with. So, if I want to create a chart, all I have to do is select your data fields, drag and drop them where it says drag data fields here.Visualization Pane

It should end up looking something like the following.

reports - power bi desktop - edureka-min

Publishing a Report

And now you’re ready to deploy this to the Power BI site. All you must do is click on the Publish Button on the right top corner of the screen. Publish

 

Now that you’ve learned all about the Power BI Desktop, go on and create comprehensive and powerful visualization reports with this technology. You can use these sample datasets to start experimenting with Power BI Desktop.

If you wish to learn Power BI and build a career in Business Intelligence, then check out our Power BI Training Certification 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 over the subject.

 

Comments
0 Comments

Join the discussion

Browse Categories

webinar REGISTER FOR FREE WEBINAR
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP

Subscribe to our Newsletter, and get personalized recommendations.