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?[…]
It is with great pleasure to announce that I will be speaking in SqlBits 2016 Liverpool which happens from 4th to 7th May 2016. I will be speaking one of my favorite topics which is comparing SSIS as on-premises ETL tool with Azure Data Factory as cloud data ingestion service. My session scheduled for 4pm Read more about I Will Speak at SqlBits; Azure Data Factory vs SSIS[…]
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[…]
It was about 4 years ago that I’ve wrote a custom function to split a delimited string in T-SQL. I’ve wrote that because there was no split function for SQL Server at that time. Fortunately SQL Server 2016 comes with new excitements, and built-in split function is one of them. The new String_Split function is Read more about Split Function in SQL Server 2016[…]
Thanks to all attendees to my session today at SQL Saturday Sydney. It was a pleasure to have you all in front of me, and having those great questions and feedback from you. This was my second time in Sydney, and I’m looking forward to the next gathering hopefully next year. Special Thanks to Grant Read more about Presentation Materials for My Session at SQL Saturday Sydney 2016[…]
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[…]