You can create relationships in Power BI between tables. Relationships are useful for some functions to work across multiple tables and produce the result. Relationship between tables also makes visualization and report elements more efficient, because result of selection in one chart can affect another chart from different table. However there is a limitation in Read more about Relationship in Power BI with Multiple Columns[…]
If you be familiar with Power Pivot you know that there is a functionality in Power Pivot for setting a table as a Date Table. This enables time intelligence functions such as year to date to work properly over your data model. However this option is not available in Power BI Desktop. There is no Read more about Secret of Time Intelligence Functions in Power BI[…]
Calculated tables first introduced in September 2015 update of Power BI Desktop. The name speak for itself; these are tables created by calculation. As these are in-memory tables their calculation is based on DAX (Data Analysis eXpression language). There are many benefits of using Calculated tables, such as using them for role playing dimensions (for Read more about Scenarios of Using Calculated Tables in Power BI[…]
Power BI utilizes two built-in map charts; Map and Filled Map. Filled Map is a map that shows data points as Geo-spatial areas rather than points on map. Areas can be continent, country, region, state, city, or county. Working with Filled Map however isn’t as easy and convenient as the map chart is. You need Read more about Power BI Filled Map; the Good, the Bad, and the Ugly[…]
In previous chapters of Power BI from Rookie to Rock Star you’ve learned that Power BI reports and models can be published in Power BI website for sharing, scheduling and some other purposes. One of the features in Power BI website which is unique to Power BI and is not available in many BI tools Read more about Power BI Q&A; How to Ask Questions?[…]
In previous posts of Power BI from Rookie to Rock Star you’ve learned that Power BI has bunch of useful built-in visualizations such as bar chart, column chart, waterfall chart, tree map, and many other visualizations. However there is always requirement for new types of visualizations. You might want to visualize parts of the data Read more about Custom Visuals in Power BI; Build Whatever You Want[…]
Thanks to all who attended on our pre-con, and sessions on SQL Saturday Melbourne. It was an awesome event, and we proud that we’ve been participating there at least as speakers. SQL Saturday Melbourne 2016 had 350 registrations. About 30 technical sessions, with the keynote from Mark Souza. Many international speakers as well as local. Read more about SQL Saturday Melbourne; Presentation Materials[…]
Thanks to all attendees to my webinar yesterday. It was pleasure to have you all attending in this session. I’ve uploaded session slides here and you can download them. Session was mostly demos rather than slides however. Unfortunately there was a technical issue and session didn’t recorded. I will get this recorded offline and upload Read more about Webinar Materials Ready: Power BI Rises; Wonderful Things You Can Do[…]
Power BI can connect to many data sources as you know, and Spark on Azure HDInsight is one of them. In area of working with Big Data applications you would probably hear names such as Hadoop, HDInsight, Spark, Storm, Data Lake and many other names. Spark and Hadoop are both frameworks to work with big Read more about Power BI and Spark on Azure HDInsight; Step by Step Guide[…]
In previous steps you’ve learned how to extract and mash up the data from CSV and automate the process of looping through all CSV files in the source folder. In this step we are going to build visualizations based on the data set we’ve built so far. In this post you will see how easy Read more about Be Fitbit BI Developer in Few Steps: Step 3 Visualization[…]