5/10/2019

From Traditional BI to Cloud BI Models - One Stop Shopping

Azure Data Factory is picking up steam for many reasons.  Our traditional SSIS is still alive and kicking, and can run in ADF to save time and effort in re-writing existing packages.  ADF is our cloud version of Orchestration, and making strides to become a one stop shop for Extract Transform and Load.

Data Flows provide this functionality and sort of duplicates some of the ETL behavior found in traditional SSIS, still in preview.

And Power BI's presence is seen as more companies leverage the power of web based portal to administer and provide reports.  And Power BI adds new features monthly and / ior weekly, keeping everyone on their toes, but also adding some really cool features.  It also has embedded feature to scale licensing by running within other applications.  So Power BI and SSRS are sort of morphing to some degree.

And Azure Analysis Services allows the Tabular Model flavor which runs on DAX instead of MDX.  And you can import Power BI reports directly into the model to scale at enterprise level.

If we look as Microsoft traditional BI which includes SSRS, SSIS and SSAS, there's a subtle shift underway to cloud based.  This makes perfect sense as "Cloud First" is the new mantra.

You can also see this pattern in IDE's as the new web based Visual Studio Online was recently announced not readily available just yet.

So if you think about it, developers will soon be able to work on any machine, anywhere and anytime.  How cool is that.  Not dependent on specific hardware or specific installation packages except as needed in real time.

You can almost see the similarities between the original mainframes that services all IT needs, and the Cloud which allows remote terminals to connect and run IT needs.  Full circle.  Yet loosely connected.  

It also mirrors the Utility company billing model with pay as you go and how much you consume.

So change is definitely in the air.

And so it goes~!

As always, thanks for reading!