Power KPI Matrix and Some sample designs

Didn’t you try out this cool visualization come out from Microsoft lab ?
this would help you to build complex integrated KPIs in a single visualization ,it’s highly customization , refer the it here



also find the below attached PBIDesign document ,which i’m sharing as a reference and to give you an idea.

Data Community Meetup: Azure Data Lake Evening – Dec 2017

Please participate for this grate knowledge sharing event and well known Asanka Padmakumara and  Dinesh Priyankara is doing the session.

Data Community Meetup: Azure Data Lake Evening – Dec 2017

Wednesday, Dec 20, 2017, 6:00 PM

146 Kynsey Road Colombo, LK

60 Dataholics Went

Welcome to an evening of Azure Data Lake before you end the year. SESSION #1: Azure Data Lake: Data Warehousing of the Future The new age of data brings new problems. Apart from the need to store your organization’s transactional data, you now need to store all sorts of other data that your organization collects. This big data along with your trans…

Check out this Meetup →

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

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 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