AI and Power Platform Part-1 - AI with Power BI

 AI has become ubiquitously exploding and seems like every business application is now infused with it. This is also the case with many of the Microsoft business apps - Dynamics 365 and Power Platform. In this blog series I will explore the infusion of AI in the Microsoft Power Platform and business outcome benefits from it. To start this blog is about AI with(in) Power BI. 

There are many wonderful reasons to use Power BI -

1.    It is now the 'defacto' visualization tool for data with Microsoft

2.     Analytics using Power BI is easy to learn 

3.     It has built in AI capabilities that can be used without writing any code.

If you were not aware of the #3 above than now is the time to explore some of the AI capabilities. 

Power BI has many AI and AI related capabilities OOTB as detailed below -

1. Key Influencers - Provides impact and influence of key contributors on the result.

Key Influencers

The above report helps to answer Sales questions such as - What is the biggest influencer for an opportunity to be won? (or Lost) (discount as in this case and you may not need AI for that). The point is that we now have the power to quickly identify the key influencers on a particular business results. There is no more detailed modeling or manipulation of data needed and helps in understanding patterns and taking actions based on the key influencers.

2. Decomposition Tree - ability to quickly do a root cause and ad-hoc analysis using AI Splits.

Decomposition Tree

In this case we can drill down from Sales to a hierarchy of Sales by Category - by Product - by Region. The AI here is where to drill down using AI Splits to get to the next highest or lowest value. For example below shows that David So has the highest Opportunity values path.

AI Splits - Highest Opportunity value

This can be useful in identifying the biggest opportunity owner from an ocean of Sales data and making sure that the business results are met.
 

3. Anomaly detection - Auto detect anomalies in data and generate dynamic text summaries. Identifying anomalies in data may not be new but auto generating a paragraph that explains the anomaly can be very useful. It can also provide answers to specific questions. Lets look at the revenue line chart where there is a sharp decline in revenue. 

Anomaly detection

I can select the lowest point and right click > analyze > explain the decrease and Power BI shows me various possible reasons to identify the anomaly.

Analysis results

So now I know all the possible reasons there was a decrease in revenue in plain English. (If only it could tell me who is blank 😀 )

Additionally there are many other AI options like Q&A and Insights which provide great benefits to users.

You can add the AI insights to a report page using the Insert > AI visuals option or pick the AI visuals from the Visualizations pane.

I hope this helps in getting you started using AI in Power BI and let me know about your experience.

I will write more about AI in Power Platform in my future blogs. Thanks for reading.

@mihircrm

365WithoutCode

Teams and Power BI - Enable visual collaboration

 The integration of Power BI with Microsoft Teams has enabled enterprise wide collaboration on data and visual presentations. This brings new ways of generating team insights where remote teams can review the data and provide feedback to improve the visuals. 

Power BI and Teams - Visual collaboration 

There are multiple ways you can share the Reports and Visuals from Power BI service into a Teams Chat or Channel. This blog describes some of the options for using Power BI within Teams.

1. Power BI App in Teams - You can add the Power BI app to teams which will enable directly working in the Power BI Service from within Teams itself. 

Power BI app in Teams

2. You can also add a Power BI tab to a Teams Channel. This enables to collaborate on the Power BI report within the channel. 

Power BI - Add as a tab to Teams Channel

Note - When selecting to add a tab - you can only add a Power BI Report but not a dashboard to the channel.

3. Chat in Teams - You can chat in teams from a Power BI Report / Dashboard or even a visual. This inserts a link in teams chat for the shared content. 

 

Visual tile - Chat in Teams

4. Link preview - You can add a link to a Power BI - Report / Dashboard or App in Teams chat and a link preview is shown. The user can open the Power BI visualization from within Teams.

Link preview in Teams

Things to note -

1. In order for the Teams integration with Power BI - the users will need a Power BI Pro or Premium per user license or the Power BI Report is in a Power BI - Premium capacity. 

2. Users within the Team will need to be shared the reports and given access to the underlying dataset to enable them access to the content. One way to enable this is to share access to the Report workspace to the Microsoft 365 Teams group 

Microsoft 365 group access to Power BI workspace

3. Power BI dashboard cannot be added as a tab to Team channels. Also the Link preview does not work in Meeting Chat or Private Channels

4. Make sure that the Power BI Teams integration is enabled in the Admin Portal > Tenant settings. (by default it is enabled)

Teams integration is enabled

I hope that this helps you in integrating Power BI and collaborating within Microsoft Teams. Let me know how you have gained from the Team insights which are enabled with this new feature.

Thanks for reading

@mihircrm

365withoutCode

Power BI Template Apps - Power BI with Dataverse (D365) Part-2

 In my earlier blog I had written about connecting with PowerBI and Dataverse (D365) using the CDS or Dataverse connector. You can also use the Power BI template Apps that Microsoft has provided to see your Sales or Service data in PowerBI.com

As always there are pre-requisites for using the Apps. They are - 1. You need to have a Power BI - Pro license for all users who want to consume the app and also 2. Admin access to install the App and connect to D365.

So now that we have the requisite license and access let us install the template app. There are 3 D365 - Power BI template apps. They are shown below with demo data

1. Sales Analytics. https://tinyurl.com/88g43r2m

Sales Analytics Power BI App

2. Process Analytics: https://tinyurl.com/5ybgdqze

Process Analytics App

(I am not a fan of the background bluish color but that can be removed using PBI desktop as I have mentioned below)

3. Customer Service Analytics: https://tinyurl.com/3a2v2pmg

For this demo I was unable to get the demo data loaded in the app or connect the app to D365. This is from the Appstore -

Customer Service Analytics Power BI

I will write about the Sales Analytics App below -

1. Install - Go to https://tinyurl.com/88g43r2m  and click on Get it now (or in PowerBI.com go to Get Data and search for Sales Analytics app)

2. Once the app is installed you will see the App in PowerBI.com You will be able to see the App with demo data. You can also connect the App to your specific D365 / Dataverse instance. Once connected the D365 instance data will load into PowerBI.com

You get the below different reports in Sales Analytics App. 

3. You can than analyze the data in PowerBI or you can import the dashboard into D365. (I will write more about this in my later blogs)

4. The OOTB app does not have any custom tables and you will need to customize the App. This is now possible by downloading the Power BI report and importing the PBIX file into Power BI desktop.  Use the link below for downloading the Sales Analytics or Process Analytics Power BI report PBIX file.     

        https://tinyurl.com/1royw6my

5. Now you can add the custom tables and columns to the Power BI reports and create your own App.

I believe that the template apps are a very good starting point to use Power BI with Dataverse. Let me know if you have any questions or any other ideas of using Power BI with Dataverse / D365. 

Thanks for reading

@mihircrm / 365withoutcode

Getting started using Power BI with Dataverse (D365) - Part-1

Power BI has become one of the top data visualization tools. In every project that I have worked on, the default option to visualize, analyze and reporting tool with Microsoft Dynamics 365 is Power BI. It is a natural out of the box fit and Microsoft is doing its best to make the default choice with Dataverse. 

I have written earlier about D365 and Power BI but in the journey of evolution,  the Power Platform has very much changed and it is time to have a fresh look.  In this blog series we will ponder over the ways to -

1. Connect Power BI with Dataverse (D365) - This blog #1

2. Perform D365 data transformations & generate valuable AI insights in Power BI

3. Create and import data visualizations in Power Platform from Power BI

4. Limitations and things to consider (like security) when using Dataverse and Power BI

PBI dashboard with D365

Pre-requisite - In order to get started with Power BI you will need the following -

1. A D365 / Dataverse environment - You can get a trail of Dynamics 365 using trials.dynamics.com

2. Power BI (free or paid) license - PowerBI.com

3. Power BI desktop (download free from PowerBI.com)

Once you have done the above we are ready to play with D365 and Power BI

A - Setup needed - For this blog series we will need the capability of adding Power BI visuals into D365 (dashboards and visuals) as well as enable the TDS (Tabular Data Stream) endpoint. This is done by going to admin.powerplatform.microsoft.com and select your D365 environment (tip - its not the default one). Environment > Settings > Product > Features and enable the 2 highlighted below

B - Connecting Power BI with Dataverse (D365)

1. Once you have the above and downloaded the Power BI desktop latest version (note the version changes ever month) you can click on > Get Data. 

This will open up a myriad of options (enough to baffle you and maybe you feel like in a candy store), but lets focus on the Power Platform for now. Select Power Platform and you have 2 main options (dataflows is not the topic of my current blog, maybe in the future) 

Connect options

Dataverse connector is the latest one offered (I am going to use it for this blog) The limitation here is that the size of the dataset is limited to 80MB. If your needs are more than 80 MB (which is quite obvious when using large datasets) use the CDS legacy connector. I am hoping that the Dataverse connector allows larger datasets in the near future. 

Once you click on connect with Dataverse. it will ask you if you want to import data or do a Direct Query. For this blog I am going to import the data into Power BI. At this time it is important to note that there is an important security difference between importing data into Power BI and using Data query. I will revisit this in my next blog.

Connectivity mode

Another thing that you will need to enter is the environment domain. It used to be simply coping your D365 domain url but Microsoft has made it a little complex. Now you are supposed to enter the url without https:// and remove the / in the end (had to do this twice just to get it right) If you don't know what is your environment domain url Go to Make.powerapps.com select your environment (not default) and click on Settings > Session details. 

Instance url

Once you have the details and click 'ok' you may be prompted to sign in (if you are not already signed in) and then shown the Navigator window to chose from the tables to import into Power BI. 

Select Table

Once you select a table make sure to select 'Transform Data' which will open up the Power Query Editor 

Select columns to import

Here click on Manage Columns and you will be able to select which columns you want to import. It is important to know the Dataverse data model to be able to understand what columns you will need to create your visualizations.

Once you have selected the columns click on Apply and this will start the import process. In my next blog we will look at the options for working with D365 data in Power BI. 

Hope this helps you to get started with using Power BI with Dataverse (D365). Thanks for reading.

@mihircrm

365WithoutCode

Industry accelerators - Dynamics 365 - Introduction - 1

   Microsoft has introduced Industry accelerators which provide specific industry vertical solutions. This blog series is to discuss and learn about the latest in the Industry accelerator updates including the Oct. Wave-2 release.

What are Industry Accelerators ? - 

• They are Industry specific vertical solutions as envisioned by Microsoft. 
• They are built upon the foundational components within Microsoft Power Platform and Dynamics 365
• Microsoft has made them freely available on the AppSource an Github. 

There are currently 7 Industry Accelerators - 

1. Automotive
2. Education
3. Financial Services
4. HealthCare
5. Manufacturing
6. Media and Communications
7. Non Profit

The above accelerators is also an opportunity for ISVs and developers who can build upon and extend them to create their own industry specific vertical solutions 

As a Dynamics 365 - solution architect / business consultant, this helps to understand specific industry business scenario. It also can help to guide you on how best to design a solution for the industry specific requirements. 

In my future blogs I will write more about each of the industry accelerators, the latest updates and I hope it helps to provide more insights in the specific industry verticals.

Thanks for reading. 

Mihir 

365WithoutCode

Analytics using Power BI & Dynamics 365 - Part-2 The Desktop

This is a part of my multi-series blog about analytics with Power BI and D365. Part-1 of the blog is here. This blog focuses on Power BI Desktop.

In order to gain insights from data it is imperative for users to be able to easily create their own visuals and do as needed analytics. Power BI Desktop allows you to connect, create and publish the analysis, reports and visualizations. 

Below is an example of a custom dashboard I created using Power BI desktop & Dynamics 365 Sales. 

The pie charts on top show the Opportunity and Cases breakdown by Account. This information may not be seen as valuable. Now in the bottom are line and bar charts, where I have combined the data and am able to gain some valuable insights.

1. There are few accounts which have good opportunity pipeline and also have high # of cases open for them. So I can ask my customer service and sales team to work together to make sure the open cases are resolved on priority. 
2. There are few high opportunity accounts with no activities, so there is not much communication going on with those accounts. This is a flag and I would ask the Sales associate to focus more on those accounts to successfully close the opportunities.

As you can see, using Power BI desktop you can build custom visualizations of your data and get deeper insights which can help you improve your customer engagement. 

The below are the steps to integrate Power BI desktop and Dynamics 365. Assuming you have already created a Power BI account and have an instance of Dynamics 365 online ready.

1.        Download and install Power BI desktop from here.
2.        Open Power BI desktop and select Get Data, click on more and select online services and double click on Dynamics 365 online

   

   3.   In the Web API url enter the service root url (you can copy from Dynamics 365 - settings > customization's > developer resources). Remember to change the v9.0 to v8.1 (this may be temporary till Power BI connects with v9.0) 

4.  Use the Organization account to connect to the Dynamics 365 instance.

5.  Once connected, the Navigator window will open and it will load the entities. Select the entity you want to include and click Load.

6.   This brings the entity and its relationship along with the data into the desktop. This may take time if you have large amount of data.

Now you can start creating the visuals and reports. Once done you can save the report and also publish the same to PowerBI.com

Things to note –

• Recent sources will save the connection info, so you don’t need to do all the steps again
• Once the report is published to PowerBI.com you can create dashboards and share the same with other users

Hope the above gets you started using Power BI desktop with Dynamics 365. Thanks for reading.

Mihir Shah

365WithoutCode