It is an honor to announce that I’ve been selected to speak in 4th PASS BA conference happening May 2016 at San Jose, California. I have to thank all organizers who make this great conference happen for their great work, and also choosing me to participate as a speaker. About PASS PASS or Professional Association Read more about I Will Speak at PASS Business Analytics Conference 2016[…]
It is an honour to announce that RADACAD won multiple year’s of consultancy agreement with CLP Group. The area of consultancy is included but not limited to Microsoft Business Intelligence and Data Warehousing, Data Analysis, and Analytics for CLP Group which is the biggest Power and utility provider in Hong Kong covering 80% of residents Read more about RADACAD Won Multiple Years Consultancy Service Agreement with CLP Group[…]
It was my honor to present for the third year in a row in PASS Summit 2015. I’ve seen many familiar faces of #SQLFamily, many MVPs, MCMs, Speakers and PASS HQ. I’ve presented my favorite topic here this year which was: Azure Data Factory vs SSIS. Slides shared in PASS website, but I also uploaded Read more about Slides of my Session at PASS Summit 2015: Azure Data Factory vs SSIS[…]
And the PASS Summit 2015 Starts with the Keynote Good crowd turnout for this summit Blogger table Let’s start then This will be live blog of Pass Keynote day 1, so watch here; 8:21: Narrator of promotion video: 40 zeta bytes of data will be created by 2020 8:22: PASS President Thomas LaRock on stage Read more about PASS Summit 2015 Keynote 1[…]
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[…]