Daniel Wikar Personal blog about Analytics, Big Data, Microsoft and IT

Power BI - Confirmed to be available on-premise within SQL Server 2016

In my opinion one of the most interesting outcomes from Microsoft Ignite 2016 is the confirmation that Power BI will be available as an on-premise feature within SQL Server 2016 (Reporting Services). As usual we didn’t get any ETA apart from “we’re not too far off” and “in a not too distant future”.

Link to full video: Create a modern enterprise reporting and mobile BI solution with SQL Server 2016

Comment

ERP World View

erp-world

During my career I have encountered numerous different ERP systems, vendors, consultants and specialists. Something that has struck me as common for many (but not all) ERP professionals is the lack of understanding for the need of other enterprise applications and/or integration of the same. Many also seem to favor customizations within the ERP rather than making it a part of a service-oriented landscape with other enterprise or business unit specific applications.

“Documentation? Well, we do have some ER diagrams but they’re not complete or up to date.”

“Why would you like to extract data out from the ERP?”

“Services? Interfaces? We’d suggest you to take a look in the database if you really need some of our data.”

“We already have that in our ERP, not as good but it would still be better to use that.”

“Integrate? Wouldn’t it be better to just migrate the data into the ERP?”

Anyone with similar experiences or maybe the opposite?

Comment

Power BI Desktop/Azure now supports SSAS Multidimensional

Ever since the possibility to create a data source connecting Power BI to an on-premises SSAS Tabular instance the same was requested for Multidimensional (MOLAP) cubes and now the time has finally come!

Details on how to connect it through Power BI Desktop can be found here: Connect to SSAS Multidimensional Models in Power BI Desktop

Setting up the Power BI Gateway: Manage your enterprise data source - Analysis Services

Comment

Reblog - Datazen now able to use MDX generated by SSMS

Since the latest release Datazen is now able to use MDX queries generated through SQL Server Management Studio. Christopher Finlan wrote about it is his blog post New Datazen Server Build Brings some MDX Magic and no use repeating the same here so I’ll just post the link as a reblog.

Happy dashboarding!

Comment

Dynamics AX7 (Rainier) - BI/Analytics Preview

It has been known for a while that Dynamics AX7 (Codename Rainier) would come with significant changes to the BI & Analytics features. Not much has been known about the details but about a week ago Microsoft released a video revealing some of the upcoming news. Thanks to Nurlin Aberra, DynaAX, for the tip.

You can find the actual video here, www.youtube.com/watch?v=jepSqjGkuxE. I extracted some of the most interesting bits into snippets below together with some personal comments.

Perspectives

dax7-bi-preview-02

Personally I only have experience with BI in AX2012 R3 but have been working with the Microsoft BI stack outside of AX since 2007. The experience of AX BI has been a bit so-so especially since we often want to combine the data from AX with historical data and/or data from other sources. I still see the BI features in AX mainly as operational, analytics closer and more integrated to the business processes.

Workspaces

dax7-bi-preview-01

Moving from the role centers into more personalized and process-centric views - a welcome change.

Flavors of reporting in Dynamics AX

dax7-bi-preview-03

Reporting still feels a bit scattered. Interesting to see whether the new BI features in SQL Server 2016 (such as Datazen) will be leveraged in the on-prem version of AX7.

How a developer consumes aggregate data in AX7

dax7-bi-preview-04

“Aggregate Measurements” becoming an alternative to the SSAS cubes. Initally it was unclear which underlying technology is actually used (In-memory OLTP, Tabular Models, etc) but during the Q&A it was “demystified” by talking about the SQL Server columnstore indexes and read-only secondaries. I have a feel this can’t be all to it (same Aggregate Measurements deployed twice to enable Excel self-service analytics?) and it require further detailing ahead.

In-Memory Real-time vs SSAS Cube

dax7-bi-preview-05

Developer view in Visual Studio. Notice the options for both InMemoryRealTime and SSAS Cube.

AX 2012 BI capabilities are GREAT - but hard to implement

dax7-bi-preview-06

Agree to all the boxes in red. Good to see the AX team acknowledging and aiming to fill the gaps.

Aggregate models - Deployment choices

dax7-bi-preview-07

dax7-bi-preview-08

Here we can see the difference between the two deployment options. Nonclustered Columnstore Index (NCCI) or SSAS. Multi-dimensional or Tabular not mentioned - referring to MDX a give-away for MOLAP?

AX7 - Power BI

dax7-bi-preview-09

dax7-bi-preview-10

dax7-bi-preview-11

dax7-bi-preview-12

dax7-bi-preview-13

Not much to mention here apart from it becoming a two-way integration of Power BI. Data out from and reports/dashboards back into AX.

Data extraction / Data mashup

It was once again expressed that if you want to extract data from AX to integrate into an external data warehouse DIXF is the way to go. If you want to consume data irregularly for data mashups exposing queries through OData will still be available much like today.

Comment