08/27/2015
by Marlon Ribunal
3 Comments

Getting Started With Power BI Desktop: Simple Visualization

This is the third installment of our Getting Started With Power BI Desktop series. The first post is about installation and the second is about getting data. In this post, let’s see how easy it is to create visualization on Power BI Desktop. If you’re quite familiar with creating graphs in Excel, you already got what it takes to start using this powerful visualization tool.

Fire up the Power BI Desktop app. When the splash screen pops up, select the report file (.pbix file) that we saved from the previous post (Consumer_Complaint_US.pbix).

power bi desktop splash screen

You can also open this file by going to the File tab (ribbon) and select the Open an existing report option.

On the left side of the report designer are the Visualizations and Fields panes. Most of the simple visualization tasks are accomplished by drag-and-dropping the components and elements from these panes.

Power BI Desktop Visualization Pane

Let’s create a simple graph for a start.

Select (click) the Bar Chart from the Visualizations pane.

Power BI Desktop Bar Graph

An empty graph then appears on the designer.

Power BI Desktop empty bar graph

Drag-and-drop the State field on the Axis and Issues on the Value.

Axis and Value of the Bar Graph in Power BI Desktop

And, just like that, your first visualization on Power BI Desktop is complete.

Simple Bar Graph in Power BI Desktop

Let’s do some formatting . Click the Brush icon in the visualization pane.

Format Bar Graph in Power BI Desktop

Let’s set some properties to change the appearance of our bar graph. Change whatever you want.

formatting visualization in Power BI Desktop

And here it is…a simple visualization created in Power BI Desktop.

Power BI Desktop Bar Graph

We’ll dig more visualization techniques in the next installments of this Getting Started With Power BI Desktop series.

08/19/2015
by Marlon Ribunal
4 Comments

Getting Started With Power BI Desktop: Getting Data

Now that the Power BI Desktop is installed, let’s get some data. As of this writing, Power BI can get data from 37 different data sources and data connections – File (Excel, CSV, XML, Text), Database (SQL Server, Oracle, IBM DB2, MySQL, PostgreSQL, Terada, etc.), Azure (SQL Database, Azure Marketplace, etc.) and other data connections (Web, OData Feed, Hadoop File, Dynamic CRM Online, Salesforce Objects/Reports, Facebook, etc.).

Let’s work with a CSV file.

Go to Data.gov and download the Customer Complaint Database. Choose the CSV file. Here’s the link: http://catalog.data.gov/dataset/consumer-complaint-database

Data Gov Customer Complaint Database

Save the file where it’s convenient to access it. Let’s fire up the Power BI Desktop app. On the Home tab (ribbon), click Get Data then select CSV.

Get Data From Home Ribbon

The Load dialog displays a preview of the CSV data.

Power BI Load Data Dialog

As you can see from the dialog, aside from the Load option, you can also Edit the data. To simplify this demo, let’s delete some columns (Complaint ID, Submitted via, Company Response, Timely Response?, and Consumer Disputed). Select Choose Columns from the Home ribbon. Un-check the columns that we want to exclude from our data.

Edit Data source in Power BI Desktop

Click OK. Now, were ready to load the data. Click Close & Load from the Home ribbon. Select Close & Load.

Load Data Power BI Desktop

After the data load is finished, the Power BI Desktop brings us to the report designer. You can always go back to the data by clicking the table icon Power BI Desktop Show Data Icon on the left-hand panel.

On the next post, we’ll create our first report.

08/13/2015
by Marlon Ribunal
4 Comments

Getting Started With Power BI Desktop: Installation

Power BI is becoming popular for a lot of reasons. Simply put, Power BI is “BI on your fingertips.” Companies looking to adopt BI technology need not look further. Power BI is easy to learn with its intuitive tools. Gone are the days when building BI solutions always involve massive resources.

Power BI lowers the bar in the BI know-how. It eliminates the complexities of building BI solutions.

Power BI has three (3) components: Power BI, Power BI Mobile, and Power BI Desktop. Power BI is “cloud-based business analytics service.” Power BI Mobile provides you the capability to get connected with your data anywhere you go. Power BI Desktop gives you the platform to author reports intuitively.

In this series, let’s take a look at Power BI Desktop.

Before we get started, let’s see how easy it is to download and install the app.

Go to http://powerbi.microsoft.com/desktop and download Power BI Desktop.

power bi desktop download

 

Once downloaded, execute the executable file to initialize the installation. Note: Power BI Desktop requires Internet Explorer 10 or higher versions.

Install Power BI desktop

Click Next, and just follow the installation wizard. Accept the terms in the app’s license agreement.

POwer Bi Desktop License Agreement

Specify where you want the app installed. I wouldn’t change the default.
default directory of Power Bi Desktop

Confirm installation of the Power BI Desktop app. Click the Install button

confirm installation of power bi desktop

Then wait for the installation to complete. It should only take a couple of minutes.

actual installation of power bi desktop

After the installation is completed, the wizard confirms the success of the installation. Select the Launch Microsoft BI Desktop and click Finish.

completed power bi desktop installation

Wait for the Power BI Desktop to initialize.

power bi desktop initializing

After the successful initialization of the app, the Power BI Desktop splash screen shows up. The screen provides some useful resources to learn more about Power BI. I’d keep the Show this page on startup option checked just so I have  a bookmark to these useful resources. You can also access this screen in the File tab then select Getting Started.

power bi desktop splash

That’s it. Power BI Desktop is now ready for analytics or report development!

Next, let’s get some data for our Power BI Desktop.