Category: Self-Service BI

Mobile BI, Power BI, Power BI Desktop

Hold Your Dashboards in Your Pocket, Part 2: Use Your Predefined Dashboards on Your Windows Devices

In a previous post, “Hold Your Dashboards in Your Pocket, Part 1: Use Your Predefined Dashboards on Your IOS Devices“, I explained how to use Power BI app on your IOS devices.

In this post I express how to use Power BI app on your Windows devices. It’s relatively easy to install and use the Windows app.

  • Go to www.powerbi.com and click on the “Download from Windows Store” button


  • It automatically leads to the app page on your Windows Store
  • Click Install to install the app


  • After the app installed successfully open it from start menu

060215_0105_HoldYourDas3.png

  • Click Sign In


 Continue reading “Hold Your Dashboards in Your Pocket, Part 2: Use Your Predefined Dashboards on Your Windows Devices” →

Mobile BI, Power BI, Power BI Desktop

Hold Your Dashboards in Your Pocket, Part 1: Use Your Predefined Dashboards on Your IOS Devices

Now it is time to take a step further and learn how to access our dashboards from our IOS or Windows devices. Microsoft designed a very good and handy app for IOS and Windows based tablets. At the moment the Windows app is only available for your laptop or on your Windows based tablet device. First of all you need to download the app on your device.

In this post I explain how to use your IOS devices to browse your dashboards everywhere that you have access to the Internet.

iPhone:

  • Sign-in into Microsoft Power BI website
  • From the right menu click on Download then click on “Power BI for IOS”

  • Click “Download on the App Store”

  • Select your IOS device and then click on “View in iTunes”

Continue reading “Hold Your Dashboards in Your Pocket, Part 1: Use Your Predefined Dashboards on Your IOS Devices” →

Power BI, Power BI Desktop, Uncategorized

Build You First Dashboard in Microsoft Power BI Designer, Access Analytics Everywhere

This is the third article from Power BI Designer series. To fully understand this article you need to read my previous posts “Build Your First Report in Microsoft Power BI Designer Part 1, Basics” and “Build Your First Report in Microsoft Power Bi Designer Part 2, Make it More User Friendly” as well. In this article I explain how to publish your predefined reports on www.powerbi.com website which is free. So after publishing the reports, you can create flashy reports very easily. By very easily, I mean it! Creating dashboards is even easier than dragging report objects and dropping them somewhere on the tool! I’ll explain how that is possible. Actually, it is all about the awesomeness of the online BI Designer.

Frist of all, you need to create an account in www.powerbi.com. Unfortunately, you’ll need to have a corporate email address that means you’re NOT allowed to use free email accounts like MSN, Hotmail, Yahoo, and Gmail and so on. But, if you’re a student with a valid university email address or if you’re an employee with a corporate email address, then you’ll be fine.

Let’s start.

  • Browse www.powerbi.com
  • Enter your valid email corporate or university email address then click on “Use it Free”

Continue reading “Build You First Dashboard in Microsoft Power BI Designer, Access Analytics Everywhere” →

Power BI, Power Query

Build your First Report in Microsoft Power BI Designer Part 2, Make it More User Friendly

PBID

In this post I would like to explain more details about Power BI Designer features. In the previous post you learnt how to create some very simple reports. However, those reports were just for testing general features of the tool. For instance we didn’t even play with very simple features like renaming the dimension or fact tables and members to user friendly names. In this article not only do I explain some of the simple ones, but also I’ll go through some of the more advanced ones.

Again, as per my previous post, I’m using AdventureWorksDW2012 as a source database.  We imported “Internet Sales” into the designer and we created some reports and one new page and we saved the reports on disc. So we have all the requirements on hand. Let’s go…

Making names more user friendly:

  • Open the *.pbix report file in Power BI Designer
  • Double click on “DimCurrency” to rename it to “Currency”. We need to do the same for all other objects

image

  • We also need to do the same for the fields which are getting used on the reports

image

Continue reading “Build your First Report in Microsoft Power BI Designer Part 2, Make it More User Friendly” →