Power BI

Practice dividing the page into 3-6 sections and place your visuals within those sections.

Missed the introduction to this series? See Become your organization’s strategic advisor by using Machine Learning and Power BI   Having interviewed and worked with hundreds of business analysts and P&L owners, I am impressed by the capacity of human intuition. People who have been in role for more ...

In the September 2016 update of the Power BI Desktop, the Power BI team took the first step toward providing Power BI users with the possibility to add forecasting to charts. Forecasting, a fundamental component of data mining, is one of the first steps towards providing artificial intelligence to u...

Missed the introduction to this series? See Become your organization’s strategic advisor by using Machine Learning and Power BI   Reviewing individual business units and benchmarking them against one another is an important process to verify that investment levels are still appropriate. Working as a...

Some of the data sources have option both to import data as well as use live connection. But there is no easy method to change it once you already built your report. So you should rather carefully decide which method you’re going to use upfront. To make this decision right, it is good to know limita...

Missed the previous parts of this series? See Become your organization’s strategic advisor by using Machine Learning and Power BI   Forecasting is an important part of most management positions. Knowing how many products will sell where and when, informs resource decisions like staffing and inventor...

Today, I'm going to run through my thought process and also how I developed a recent Power BI showcase submission that has proven to be very popular, based on understanding your customers better.      You can use the submission here   Here's a short video also which highlights the insights that you...

What this is going to explain below is how I use a parameter that a user has entered to make a Dynamic Calculated Measure based on the Parameter entered. Example Scenario In my model I have got Par…

It was only recently that I discovered this

We are excited to announce a better way for you to navigate Power BI, quickly get to the dashboards that you access most often, and easily browse through all of your content. During this Preview

Announcement Update: For those who missed out on the webinar Announcement: Friends, short notice, but in about 2 hours, I (Avi) will be presenting in the

A description on how to simply combine manual and system data in a Power BI Data Model.

Last week’s blog post on merging tables using Outer joins has proved to be pretty popular.  (I guess I’m not the only one who struggled with this concept!) This week we’ll look at the remaining three options, showing how to … Continue reading →

Over the past year or so, we

Power BI Desktop November update is out. This blog post shows you how the function authoring experience got improved both in creation and editing.

Today we released the November update of the Power BI Desktop. It is filled with many exciting features including our newest analytics feature, clustering. We

Nov 26, 2016 Microsoft's Guy in a Cube has been providing tips and tricks for Power BI and Business Intelligence on his

A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure that can be summed across some dimensions, but not all. Typically

Infographic visualizations are getting increasingly popular, and have been widely adopted in the real world. As research reveals, they can improve the effectiveness of visualizations by making data quickly understood and easily remembered. However, current data visualization systems lack supports for generating infographics. Infographic Designer (a.k.a. InfoNice), released as a Power BI custom visual, enables easy creation […]

October 24, 2016 The Power BI Admin Portal gives organizations the ability to view usage data and set controls and limits on how Power BI is used throughout the organization.

Today, I am happy to announce availability of the Power BI data alert connector for Microsoft Flow. By combining the power of Power BI data alerts with the hundreds of actions available for Flow,

Q&A (Natural Query Language) is by far one of the features that I find really gives the WOW factor when showing people the capabilities of Power BI. And in my opinion it is awesome. So I though…

One Power BI feature that almost passed me by (because it was released in August while I was on holiday) was the ability to create streaming datasets in the Power BI web app and push data to them v…