Microsoft Azure Learning

Azure Data engineer

This is a very cool ,level 100 course to understand the different tools and technologies in Azure data platform. recommend to all data lover to follow and star exploring.

Their role can add tremendous value to both business intelligence and data science projects. It is widely regarded that data wrangling can consume a substantial amount of time on such projects. Having the Data Engineer perform these tasks can accelerate the development of these projects and enable Data Scientists to focus on other areas of their work.

Both Database Administrators and Business Intelligence professionals can easily transition to a data engineer role by learning the new tools and technology used to process these large amounts of data effectively

PowerBI December update

Please look at the latest release PowerBI features.

I would like to highlite two key features which all most you like

1.Drill filters other visuals

Ability for other visuals on your report to be filtered as you drill down in a visual

2. Q&A for report creation (preview)

Q&A feature for each visual and it’s on-prem 🙂

Refer the URL

Also  see the interesting technique on Dynamically change chart axis in Power BI

Hybrid BI Reference Architecture with Analysis Services

This overview shows that Microsoft has been delivering BI capabilities to help customers model, analyze, and deliver business insights, which can be consumed by business users on mobile devices.

You will see here how Microsoft map component/services on-prem to cloud to deliver hybrid model.

this would help customers analyze high volumes of data, which might already be stored in the cloud, for example in an Azure SQL Data Warehouse, we are now enabling BI semantic data modeling capabilities in the cloud.

Azure Analysis Services, is based on the proven analytics engine in SQL Server 2016 Analysis Services. Customers can access data sources across on-premises and the cloud, model that data, and provide business users with a simplified view of their data to enable interactive self-service BI and data discovery using their preferred data visualization tool.

These three offer share the same processing in-memory engine On-Prem SQL Analysis Services,
Azure Analysis Services and Power BI