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 I’ll just explain one example scenario of Hybrid and End-to-End BI solution that uses below technologies;

  • Data Sources On-Premises
  • Azure Data Factory or SSIS with Azure Pack for Data extraction and transformation
  • Azure SQL Database or Azure SQL Data Warehouse as the database / data warehouse engine in cloud
  • Power BI as the data analysis and front-end tool


I’ll Speak in Microsoft Ignite (TechED) New Zealand 2015; First time

It is a honor for me that I’ve been selected to speak in Microsoft Ignite New Zealand 2015. Microsoft Ignite New Zealand 2015 (TechED) is an annual conference for developers and IT professionals put on by Microsoft. It is held in several locations around the world. and it’s the biggest annual technology event in New Zealand. This conference gives Read more about I’ll Speak in Microsoft Ignite (TechED) New Zealand 2015; First time[…]

Walk-through Steps: I’m New to BI, Where to Start? – Part 7: Azure

Many organizations nowadays are in transition from on-premises to cloud, and many of them use hybrid solutions where part of the computing will be done in cloud and the rest on-premises. The trend nowadays is to use cloud to have better maintenance, lower costs, more reliable solutions, lower administrative efforts, and powerful shared resources. In BI world there is a high demand for solutions to be on cloud, some computing services such as data transfer and ETL to be done on cloud, some data analysis and mining solutions happens on cloud, and even data to be stored on cloud data warehouse at some stage. There are many BI vendors in the market, but there are few who provide BI on the cloud.


Walk-through Steps: I’m New to BI, Where to Start? – Part 6: Data Mining


Data Scientist is a hot job nowadays in the market and there are lots of demand for it. Data Science origins from the BI field and sits under umbrella of Business Intelligence, because the data science and data mining helps decision makers in their decision making process. To have an idea about how data mining can solve real world issues, think about loyalty program of the super market that you usually use close to  your home. Loyalty program simply analyze your purchase history and based on that it comes up with some suggestion and prediction about your next purchases and will promote that through your cell phone text messages or email or even flyers directly addressed to your home address.


Configure Data Management Gateway from Azure Portal

Today I’ve faced an issue; when the Power BI Admin Center does not work I want to configure and set up Data Management Gateway. Data Management Gateways is a service that install on your machine or any on premises server, and allow cloud services (such as Power BI or Azure Data Factory) to connect to Read more about Configure Data Management Gateway from Azure Portal[…]