Hybrid, End-to-End; Power BI, Azure SQL Database, Data Factory

With the announcement of Power BI a week ago and with great features in this product, there are many opportunities that this product and service can be used. Power BI can be used alongside some other Azure services, and even On-Premises services to build an end-to-end enterprise BI and Data Analysis Solution. In this post ...

Read More

Power BI Waterfall Chart: What’s That All About?

Posted by on Jul 29, 2015 in Power BI | 11 Comments

You’ve heard the news about Power BI Desktop release with bunch of new features. If you don’t, read blog post here to understand new features of Power BI. Waterfall chart is one of the new visualization elements in this product. For finance people this chart makes sense, but not everyone knows the usage of that. ...

Read More

Day Number of Year, Power Query Custom Function

Posted by on Jul 28, 2015 in Power BI, Power Query | 3 Comments

There are number of Date and DateTime built-in functions in Power Query which are really helpful. There is also a function for DayNumberOfYear. However I’ve thought it would be a good example to go through writing a function that uses Generators, Each singleton function, and error handling all inside a custom function. Through this post ...

Read More

SSAS Tabular Live Power BI Connection

Posted by on Jul 27, 2015 in Power BI, SSAS | 4 Comments

When Power BI 2.0 released as General Availability I’ve published a post that highlights all new features in this product. One of the features was SSAS Tabular Live Power BI Connection. In this post I want to explore more what the Live connection means and what are advantages of this type of connection. Power BI ...

Read More

Power BI: How to Analyze FIFA 2014 Worldcup

Posted by on Jul 26, 2015 in Power BI | 4 Comments

It was sometimes ago that I’ve posted some data analysis that I’ve done with Power BI Designer on FIFA 2014 Worldcup results. In this post I want to take you through the process of how to achieve that analysis. This post is an introduction to Power BI features with the example of FIFA 2014 Worldcup ...

Read More

Introduction to Power BI Designer

Posted by on May 15, 2015 in Power BI | No Comments

Power BI Designer is the new Editor for Power BI main components which are: Power Query, Power Pivot, and Power View. Power BI Designer made building Power BI solutions easier with an integrated solution. Power BI Designer’s files can be easily uploaded into Power BI site. In this tutorial video you will learn basics of ...

Read More