Webinar Materials: Power BI Under the Hood

Pass DW BI VC Power BI Under the Hood with Soheil BakhshiI’d like to thank you all for attending the webinar held on 30th September 2016. I talked about some amazing under cover aspects of Power BI Desktop model. In this session you learnt:

If you’ve missed the webinar you can watch it online here:

Download the Power Point presentation file here.:

Download (PPTX, 1.91MB)

Here is the PDF version of presentation:

Download (PDF, 534KB)

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”

Build Your First Report in Microsoft Power BI Designer Part 1, Basics

image

First of all I would like to briefly explain Microsoft Power BI Designer. Then we’ll see how easy we can create a report using designer. I will use Adventure Works DW database as the source database.

Microsoft Power BI Designer is basically an integration of Power Query and Power View. Saying that the tool is still a preview version and it’s NOT actually a released product we’ll expect to see more features when it’s released. Some features like PowerPivot models expected to be available to the release version. At the moment PowerPivot models are not available in the designer, but, hopefully Microsoft will add it to the tool. So I added an idea into BI in SQL vNext as I believe it would be great to have PowerPivot functionalities included in the release version of the product. We’ll see what happens.

Let’s have a look at the tool. At the first look, I would like to say it’s an amazing tool integrating lots of awesome features all together with ease of use. It’s so fun to use the tool to create very effective and flashy reports in a short amount of time. First of all you need to download the designer from here.  Install the designer and open it. I’ll use AdventureWorksDW2012 as the source database.

Open the Microsoft Power BI Designer Preview. If you want to get more familiar with the tool click on the videos on the startup screen.

·         To connect to SQL Server click on “Get Data” or “New Source”

clip_image002

Continue reading “Build Your First Report in Microsoft Power BI Designer Part 1, Basics”