Azure Data Bricks Deep dive

 

Azure Data Bricks – the fast, easy and collaborative Apache Spark-based analytics platform , do you need to learn ?? please register

 

Language Date Registration link
English November 28, 2018 Technical Deep Dive on Cloud Scale Analytics: Azure Data Bricks
English November 29, 2018 Technical Deep Dive on Cloud Scale Analytics: Azure Data Bricks
English December 13, 2018 Technical Deep Dive on Cloud Scale Analytics: Azure Data Bricks
English February 14, 2019 Technical Deep Dive on Cloud Scale Analytics: Azure Data Bricks

 

 

AI Capabilities for Power BI

There is a reason why in just few years Power BI has managed to become a market leader in Business Analytics and Business Intelligence.
The platform carries with itself the classic Microsoft attribute “Made for the User” from design to the actual platform itself.

happy to announces that new AI capabilities integrated with PowerBI , please refer the below and sign up for the preview early

https://powerbi.microsoft.com/en-us/blog/power-bi-announces-new-ai-capabilities/

Sign up for the preview here.

Power BI & Azure ML Better Together

also this a nice article on how to use AML with Power BI to deliver advance analytics to end users

https://powerbi.microsoft.com/en-us/blog/power-bi-azure-ml/

Power BI Desktop August 2018 Feature Summary

Power BI Report Server – For On-Premise BI Solutions

Hi All,

Power BI Report Server is now part of Power BI Premium. Power BI Premium, with Power BI Report Server will get you covered with a complete solution. Power BI Premium provides dedicated capacity in the cloud and enhanced performance – without requiring per-user licenses for those consuming reports. And, it includes Power BI Report Server for on-premises reporting too.

Try this link to get started with Power BI Report Server (Download FREE trial). You just have to fill small form and that will kick the download. And good thing is – you can use any valid email address of yours for this download to work.

What Power BI Report Server comprises of: Power BI Report Server is an on-premises report server with a web portal in which you display and manage reports and KPIs, along with the tools to create Power BI reports, paginated reports, mobile reports, and KPIs.

 

See the comparison of Power BI Report Server with SQL Server Reporting Services (SSRS)
https://docs.microsoft.com/en-us/power-bi/report-server/get-started#comparing-power-bi-report-server

See the comparison of Power BI Report Server with Power BI Service (i.e. www.powerbi.com)
https://docs.microsoft.com/en-us/power-bi/report-server/compare-report-server-service

Don’t forget to see the licensing terms
https://docs.microsoft.com/en-us/power-bi/report-server/get-started#licensing-power-bi-report-server

Get yourself familiarized with features of Power BI Report Server
https://docs.microsoft.com/en-us/power-bi/report-server/get-started

If you still want to get a complete glance of it then watch a video presentation from Microsoft Ignite session here.

Power BI July 2018 Update

                                                                             July update
Data modeling

The most exciting feature of July release is Composite models. This feature lets you seamlessly extend your DirectQuery models with other DirectQuery sources or even imported data. earlier it wasn’t possible to connect many DirectQuery to the same report or with import data.

With this release, that barrier has been removed and single report can combine with one or more DirectQuery source /import data set.

Find out more

Many to many relationship

this is one of the most awaited feature and with this  you can join tables using a cardinality of Many to Many, and create data models that contain multiple data sources easier and more intuitively. The many-to-many relationship feature is part of the larger composite models

Find more here

Analytics (Distribution factor insights)

How you find out new type of insight with your existing data ,now you can find through it Insights feature, which finds different filters that create significant different distributions compared with the original graph. You’ll notice in the insights, we use the stepped line to represent the original chart and the bars of the combo chart to represent the new distribution

More here

Visualization and formatting

More on the visualization and formatting here

Power BI with Visio visual intigrations

This article explain how easily can integrate your viso diagram with PowerBI , even with complex drawing like floor visualization, map or simple workflow diagram can be integrated , also it would be interact with other visuals like slicers,charts,matrix etc.. and user can slicing and dicing

https://support.office.com/en-us/article/add-visio-visualizations-to-power-bi-reports-4f09be62-f436-45c2-93b0-4a0f66b1f5a7

DirectQuery in Analysis Services: Best practices, performance, use cases

if you have large data set which cannot loaded to PowerBI model then available options are DirectQuery or Live connection, the best way is to define your data model in the data source and connect to PowerBI,

Microsoft has given Analysis Service both on-prem as well as Azure to get the same experience , Tabular model becoming a more popular and the same technology is being used PowerBI too ( both using same in-memory engine )

for more details on DirectQuery in AS refer below