If you have been in Auckland for Saturday 3rd of October and you are a Data Geek you should have been attended or at least heard about our SQL Saturday event. SQL Saturday Auckland #456 has been held in Auckland University of Technology (AUT) yesterday 3rd of October with good turnout of audience and handful Read more about SQL Saturday Auckland #456 In Photos[…]
You may have seen many videos or blog posts so far that Power BI Desktop showed the data on the map visualization based on address, suburb, city, state, and country. Fortunately Bing Map helps a lot to search the point on the map based on address fields. However sometimes you don’t have address fields, actually Read more about How to Do Power BI Mapping With Latitude and Longitude Only[…]
If you’ve followed my Power BI from Rookie to Rockstar book so far, you know that Power BI can reach on-premises data sources as well as cloud based. With Power BI Desktop you simply connect to on-premises data stores, however when the report published into Power BI website there should be a bus connection between Read more about Definitive Guide to Power BI Personal Gateway[…]
Power BI and Power Query can connect to files such as Excel, CSV, text files and on-premises databases such as SQL Server, Oracle, MySQL. Power BI can connect to many data sources on cloud such as Azure SQL Database, Azure SQL Data Warehouse and etc. In this part you will learn how to connect from Read more about Power BI Get Data: From Azure SQL Database[…]
SQL Server 2016 is under a heavy improvement plan, The latest CTP version (Community Test Preview) of it is 2.3 which released as preview three days ago. CTP 2.3 has some new features across all components of SQL Server, such as SSRS, SSAS, SSIS, MDS and etc. Previously I wrote about some new changes in Read more about SSIS 2016; What’s New in CTP 2.3[…]
In Previous section you learned about Power Query through an example of data mash-up of movies. Also prior than that you’ve learned about Power BI and its components in Power BI online book from rookie to rockstar. In this section I would like to start exploration of different data sources in Power BI, and I Read more about Power BI Get Data From Excel: Everything You Need to Know[…]
As another section of the Power BI online book: from Rookie to Rockstar, I would like to get start working with Power Query. From my point of view learning through an example is the best way to learn new technology. For this post I have decided to use movie’s data to be mashed up. I Read more about Get Started with Power Query: Movies Data Mash-Up[…]
In this post you will find materials for the Power BI Mission Possible! session that I speak today in PASS BA Virtual Chapter. Thanks to all attendees of my session in PASS Business Analytics Virtual Chapter today. Unfortunately I hadn’t chance to respond all questions, So here in this blog post I write answers to Read more about Power BI Mission Possible; Webinar Q&A, Recording, and Materials[…]
Almost one month ago Power BI has been released for general availability with shiny new features, and I’ve wrote a blog post about new features in Power BI 2.0 General Availability. at 20th of August Microsoft released an August 2015 update version of Power BI Desktop with some new features. In this post I’ll go Read more about What’s New In Power BI August 2015 Update[…]
Azure Data Factory has been released as general availability 10 days ago. There has been also an extension for Visual Studio published a little earlier for Data Factory. The good news is that now you can create Azure Data Factory projects from Visual Studio. This is a great step forward in development of Data Factory Read more about Azure Data Factory Templates for Visual Studio[…]