Before I start details for Delta Architecture lets recap Lambda Architecture first, then you will be able to appreciate the beauty of delta Architecture. Lambda architecture is a popular technique where records are processed by a batch system and streaming system…

Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics.  It gives you the freedom to query data on your terms, using either serverless on-demand or provisioned resources—at scale. SQL Analytics u…

One of the cool feature of cloud is easy to adapt cutting edge technologies. A modern data warehouse(MDW) lets you bring together all your data at any scale easily, and means you can get insights through analytical dashboards, operational reports or advanced analytics…

In this post, I will show how you can perform automated Refresh / Calculate / Sync the Azure Analysis Services models in one go by using Logic Apps and REST calls. Some of pros of using Logic App, apart from being so handy and ready to use enterprise connectors a…

Azure Analysis Services is a fully managed platform as a service (PaaS) that provides enterprise-grade data models in the cloud. Use advanced mashup and modeling features to combine data from multiple data sources, define metrics, and secure your data in a single, tru…

Before I start on Azure B2B and Power BI, If your project has a set of requirements to build and create dashboards based on the data you are collecting from different sources, the design whatever you chose is also depend on 2 factor – the volume of data (events + hist…