An updated version of this tutorial (including a video lecture) is available here: https://businessintelligist.com/?p=2718 This tutorial shows how to create a Star Schema using Power BI Desktop. Data for the tutorial can be obtained by downloading Excel file from here Very often our analysis starts with a flat data set that contains all of the … Continue reading Power BI Desktop Tutorial: Building a Star Schema from an Excel Source
Category: Power BI
The Definitive Guide on Collaboration in Power BI. Tutorial on Groups, Sharing, Coauthoring and Content Packs.
Well, not really that definitive actually… Before we jump into the details, I have to admit that I fully expect this post get outdated very soon. The collaboration features that have been released with GA of PowerBI 2.0 on July 24th 2015 are still not very refined and are very likely to become much more … Continue reading The Definitive Guide on Collaboration in Power BI. Tutorial on Groups, Sharing, Coauthoring and Content Packs.
Power BI Desktop is Available to Download
Power BI Desktop is the new name for Power BI Designer. There are some feature incompatibilities to be aware of, check out this link for details https://support.powerbi.com/knowledgebase/articles/663517
Check List for Running Analysis Services in Azure for Power BI
This comes up a lot so I wanted to make a quick check list of steps necessary to run SQL Server Analysis Services in Azure and expose it as a data set in Power BI. Create a new VM in Azure Join the new VM to your corporate domain (may require networking configuration and VPN … Continue reading Check List for Running Analysis Services in Azure for Power BI
Waterfall Charts in Microsoft Power BI
As you may have already noticed, Microsoft introduced a couple of new visualizations in powerbi.com yesterday. One new type that I am particularly excited about is a waterfall chart. Normally, when I think of a waterfall chart I am thinking of something like the chart above. You can see blue bars representing begging and end … Continue reading Waterfall Charts in Microsoft Power BI
Formatting and Group Collaboration is FINALLY(!!!) available in PowerBI.com
Other than formatting, group collaboration may have been one of the features that we all needed the most and now it is finally here. Click on the down arrow next to My Workspace and you will see an option to create a new group. And now the big one – formatting is here as well!!!
Content Packs Can Now Be Created in PowerBI.com
Click on a Gear box in the top right to get an option to create a new Content Pack or view the existing ones. Content packs are a way to deploy existing Power BI content (Dashboards, Reports, Dataset) in a read only fashion. All you have to do is specify who will have access to … Continue reading Content Packs Can Now Be Created in PowerBI.com
How to Track / Analyze Q&A Usage in Power BI
Please follow the following steps if you would like to see what questions are being asked in Power Q&A: 1. Go into your Power BI App (if you don't have the shortcut handy you can click on the Gear icon on the top right->Site Contents->Power BI and then 2. Click on the Gear icon again … Continue reading How to Track / Analyze Q&A Usage in Power BI
Microsoft Added Formatting to Q&A so I wrote a quick Power Q&A Tutorial
Microsoft Power BI team has released a lot of new features to http://app.powerbi.com including lots of formatting enhancements for Q&A (please follow this link for additional details http://blogs.msdn.com/b/powerbi/archive/2015/07/15/new-capabilities-added-to-power-bi.aspx ) In this post I wanted to show you how you might get started on Power Q&A using the Retail Analysis Sample that is currently available in … Continue reading Microsoft Added Formatting to Q&A so I wrote a quick Power Q&A Tutorial
Power BI Now Supports Refresh for Designer-built Datasets
Refresh has been a bit of an issue with Power BI. The "old" version of Power BI bundled with Office 365 supports refreshing Power Pivot models against a lot of different data source types using the Power BI Gateway. The "new" version at PowerBI.com until recently only supported refresh of Power Pivot models and only … Continue reading Power BI Now Supports Refresh for Designer-built Datasets
business intelligist 