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 https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-december-feature-summary/

Also  see the interesting technique on Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=n-OWNaCUU0o

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

What is Microsoft Azure Data Lake?

Microsoft Azure Data Lake is a highly scalable data storage and analytics service. The service is hosted in¬†Azure, Microsoft’s public cloud, and is largely intended for¬†big datastorage and analysis.¬†Like other¬†data lakes, Azure Data Lake allows developers, scientists, business professionals and other users to gain insight from large, complex data sets. To do this, users write¬†queries¬†that process data and generate results. Because Azure Data Lake is a¬†cloud computing service, it gives customers a faster and more efficient alternative to deploying and managing big data infrastructure within their own data centers.

As with most data lake offerings, the Azure Data Lake service is composed of two parts: data storage and data analytics. Users can store enormous volumes of structured, semi-structured or unstructured data produced from any application, ranging from large archival stores to small, time-sensitive transactional data. According to Microsoft, users can provision Azure Data Lake to store terabytes or even exabytes of data. The storage service also provides high throughput for fast data processing.

On the analytics side, Azure Data Lake users can produce their own code for specific data transformation and analysis tasks, or use existing tools, such as Microsoft’s Analytics Platform System or Azure Data Lake Analytics, to query data sets.

Azure Data Lake is based on the Apache Hadoop YARN (Yet Another Resource Negotiator) cluster management platform and is intended to scale dynamically within the Azure public cloud. This helps the service accommodate the needs of big data projects, which tend to be compute-intensive.

Users can write their own processing code for Azure Data Lake with a programming language such as U-SQL, which merges SQL structure and user-specific code. This also allows users to run analytics across SQL servers in Azure, as well as across Azure SQL Database and Azure SQL Data Warehouse. This unifies access to most data sources in Azure.

Pricing for Azure Data Lake contains numerous components, including storage capacity, the number of analytics units (AUs) per minute, the number of completed jobs and the cost of managed Hadoop and Spark clusters. The Azure Pricing Calculator can help users determine exact data lake costs.

Reference: http://searchcloudcomputing.techtarget.com/definition/Microsoft-Azure-Data-Lake

What is Power BI?

Power BI is a suite of business analytics tools to analyze data and share insights. Power BI dashboards provide a 360-degree view for business users with their most important metrics in one place, updated in real time, and available on all of their devices. With one click, users can explore the data behind their dashboard using intuitive tools that make finding answers easy. Creating a dashboard is simple, thanks to hundreds of connections to popular business applications, complete with prebuilt dashboards to help you get up and running quickly. And you can access your data and reports from anywhere with the Power BI Mobileapps, which update automatically with any changes to your data.

If you are a data analyst delivering reporting and analytics to your organization, Power BI lets you be productive and creative with what you build. Power BI Desktop is a feature-rich data mashup and report authoring tool. Combine data from disparate databases, files, and web services with visual tools that help you understand and fix data quality and formatting issues automatically. With over 20 built-in visuals and a vibrant community of custom visualizations, create stunning reports that communicate your message effectively. With the Power BI service, publish reports securely to your organization and setup automatic data refresh so everyone has the latest information.

Power BI can unify all of your organization’s data, whether in the cloud or on-premises. Using the Power BI gateways, you can connect SQL Server databases, Analysis Services models, and many other data sources to your same dashboards in Power BI. If you already have reporting portals or applications, embed Power BI reports and dashboards for a unified experience.

Reference: https://powerbi.microsoft.com/en-us/what-is-power-bi