Application Insights Azure portal

So here is the thing. I want to have some analytics on SharePoint online but I don't want to use Google Analytics. I know there is an Office 365 adoption package for PowerBi, been there done that. However I'm missing 1 big feature! That one feature is:

User flow
User Flow Google Analytics
Where do users go when they're on SharePoint? What do they click what pages do they visit? I want to know where the users go in en come out again. Sure with Analytics of Office 365 in the Admin portal or the Adoption package you get a good sense of what is happening in your tenant but you never really know what path they walk. So let's get the grocery shopping list:

  1. Data, we need the data. Where do I find the correct data?
  2. Ok we need a dashboard, PowerBI Desktop should do the trick
  3. We need the Sankey Diagram, that's the diagram Google Analytics also uses
Well part 1 is hard to find, I'm not sure if I'm looking in the right spot but I found Application Insights in the Azure portal. This looks very cool! Some nice features like the Application map and all kinds of reports. Application insights was focused on finding glitches in your app or website, what does go fast what doesn't? So I decided Application Insights should show me some data of what pages are visited, well that's true but it doesn't show the link to the other site or page, well at least I can't find it YET!

Part 2 is of course a no-brainer, PowerBi Desktop will do the trick here! Duh!

Part 3 is pretty cool. The Sankey diagram is a very usefull diagram to show what roads the users has taken to get to their goal. Microsoft released the Sankey Diagram for PowerBi a while back (2015) so I'll hook that up to PowerBi desktop and we're good to go. (PowerBI Sankey)

I asked Microsoft Azure to help me with the data part, I'm not very good in working with queries so maybe they can help me. I'll keep you posted.

Comments

Post a Comment

Popular posts from this blog

Azure Information Protection (AIP)

Image
Let's start with one of my favorites (till now). Azure Information Protection (or AIP). Just imagine the following example: You are working on your Word document and you want to send this document to an external person. You e-mail that document as an attachment. The person opens this document, reads it and puts it on an USB stick to take with him. The USB stick get's lost! Now the document can have fallen into the wrong hands! Now what? OK this is a little bit of a roman but hey it could happen! Active Director Rights Management  First let us go back in time to when AIP didn't exist and there was  Active Directory Rights Management Services .  This was a server role that could be installed on Windows Server 2008 R2, it exists since Windows server 2003! Back then it was called RMS. The RMS client is available  from Windows 2000 and later. So what does RMS do? To explain in simple English: Information with RMS on it has certain policies with it  that would remain
Read more

Tiles modern UI

Image
Back in SharePoint 2013 Microsoft introduced "Promoted links" a feature which enabled users to create tiles quick and easy without any custom code. Since then I've seen Promoted links being used a lot of ways, some better than others. However creating tiles with an image in the background was always a nasty thing to do. People would use the weirdest images as background to indicate what it was, totally not user friendly. Especially the choice of the color was very "weird" you would have tiles with all sort of colors and images (see image below as an example). Promoted links always had one big problem; Scaling! It's not responsive in a way you would want to have it. Since Microsoft introduced Modern UI they have also introduced the webpart "tiles". Tiles enables the user to create custom tiles within their SharePoint site, quick and easy. Cool features of the Tiles webpart. Tiles are responsive! They resize when the screen gets smalle
Read more

Azure Active Directory (AAD)

Image
In my last post I talked about Azure Information Protection (AIP). It was a way of getting a good sense of security in the Cloud. Today I want to talk about a very important feature in Azure: Azure Active Directory (AAD). AAD is a good place to start with security. Users that are allowed or prevented from logging in is your first line of defense. In preview AAD is not something radically new. Microsoft created the Management portal om the new Azure Portal to make it look and feel like the new portal. At this moment the most users will have to use the old portal for AAD but once the new management portal is out of preview we are good to go! What has changed? So who cares? It's a new Mangement portal for AAD. To be honest nothing has really changed, Microsoft just changed the look & feel of the new portal. 3 versions There are 3 versions of the AAD: Free, Basis and Premium. See the link below to decide what versions of AAD you need. Overview AAD subscriptions F
Read more