Surviving CRM

Working with Microsoft Dynamics 365, day in day out

  • Facebook
  • Google+
  • Instagram
  • Linkedin
  • Twitter
  • About Me
  • Surviving CRM on Google+
  • Dynamics CRM links
  • CRM 2013 QuickStart book
A Million Voices: VoC Survey Results Analysis

Jukka Niiranen May 8, 2016 Leave a Comment

A Million Voices: VoC Survey Results Analysis

A few weeks ago I launched a demo survey built on Voice of the Customer, the brand new survey tool from Microsoft. The goals I had for this exercise were twofold: 1) see how these type of interactive tools could be used in live events like eXtremeCRM 2016 Warsaw, and 2) gain some experience on what it is actually like to work with incoming survey response data inside Dynamics CRM. In this post I’ll mainly be focusing on the latter one, although the example data we’ll be looking at are the live answers you & other readers of this blog submitted via the eXtreme MVP Survey.

VoC_survey_page

As you may know, Voice of the Customer (or VoC as we’ll refer to it from now on) is a pure XRM solution. Although the actual customer facing survey forms are of course not presented via the Dynamics CRM client UI, everything that you use for configuring the survey questions and logic, as well as the incoming survey responses, is managed with CRM entities and stored into the CRM database. The reason this is such a big deal is that most of you will already possess the skills needed for leveraging such data via views, charts and dashboards as it’s just XRM all the way. Furthermore, you’re free to design business processes around the survey functionality with tools like real-time workflows or business rules. Naturally you’re also able to interact with the survey entities and records via the latest CRM Web API, should you come across some integration scenarios where data needs to either flow in or out to another system.

The flip side of this coin is that VoC is unfortunately very XRM-ish to work with. If you compared it to dedicated survey apps that do nothing but questionnaire design (like SurveyMonkey, Surveypal and the likes), survey publishing and response data analysis, then there’s still quite a big gap for Microsoft to work on bridging when it comes to the end user experience of this tool. In a way this is quite understandable since the value proposition of VoC really is all about the tight integration with your customer data and the ability to send survey invitations automatically as a part of your customer facing processes; such as a survey link being emailed to a customer after a support case is closed in CRM, to gather quick ratings and design automatic escalation paths if the KPI’s are not met. Nevertheless, since VoC does also support creating pretty advanced surveys for collecting quantitative data from a broad target group in more traditional campaign style satisfaction surveys, as well as anonymous survey links presented on website, it’s good to understand what it’s like analyzing such data inside Dynamics CRM.

VoC_Survey_Summary_report

There are a lot of components in the VoC solution right out of the box. First off, there are four SSRS reports: Survey Summary, Question Summary, Net Promoter Score and Survey Export. The first two are general purpose reports with tables and charts summarizing the data either across a single survey or a specific question, as illustrated in the screenshots shown here. The NPS report is naturally aimed for this particular survey type, whereas the export one is a single huge matrix for dumping out the raw survey response data into Excel for further manipulation.

VoC_Question_Summary_report

For more interactive data analysis there are eight dashboards in the VoC solution. However, these may not be all that useful for many real life scenarios, since they suffer from the same limitation as all Dynamics CRM dashboards: there are no global filters you can apply for all the dashboard components. Meaning, unlike with an SSRS report launched from CRM, you can’t set the context of the dashboard to be a specific survey. Yes, with the new “interactive experience dashboards” introduced in CRM 2016 you do get this type of filters, but since right now those features are limited to the Interactive Service Hub only (which in turn has a fair number of limitations for general use), it’s not exactly the kind of solution we’d need right here.

That doesn’t mean we couldn’t build pretty dashboards to summarize our survey responses, though. I had a go at this with the eXtreme MVP Survey and it turned out pretty well. Have a look (click for a larger image):

VoC_eXtremeMVP_dashboard_page_1_small

In the survey form I had three pages full of questions and I constructed the corresponding pages as personal CRM dashboards. This allowed me to both monitor the incoming responses during the survey data collection period as well as present the results to the audience at the MVP Showcase session in eXtremeCRM. It looks good, it appears very familiar to existing CRM users and it gets the job done without having to resort to any complex report development. [Read more…]

Filed Under: Features Tagged With: CRM 2016, customization, dashboards, ExtremeCRM, reports, usability, VoC, Voice of the Customer

Your Interaction Network in Dynamics CRM

Jukka Niiranen October 21, 2015 Leave a Comment

Your Interaction Network in Dynamics CRM

One of my posts that seems to remain in high demand, based on the site visitor analytics, is Advanced Queries with Advanced Find. Written over two years ago, people still tend to read it far more often than the newer posts dealing with the latest trends around Dynamics CRM or instructions on how to leverage other platform features like workflows and Business Process Flows. Thinking about the potential audience size, it’s of course understandable that a feature accessible to all CRM users will be much more popular than process configuration tools or the Dynamics product roadmap.

AFAlthough very few updates have been done on the Advanced Find functionality during the 10 years I’ve been using Dynamics CRM, it’s arguably still a real killer feature of the platform, at least when comparing it to the query capabilities of many similar business applications. The fact that you’re able to reference pretty much any related record in your query criteria (and in the CRM data model, absolutely everything is related) means that the tool can be used for building the most complex target group definitions for your marketing campaigns, for example, based on behavioral data stored many relationships away. You only have to use another Microsoft application to understand how powerful such a tool can be in the right hands.

It never hurts to have a good understanding of the CRM data model of your organization when launching Advanced Find to build some queries, since AF is a world of abundance when it comes to the available options to select from. Usually the relationships between records are something you can figure out from the end user UI if you spend a moment thinking about it – although with the “flat” design of CRM 2013+ menus and navigation structures, the front end ain’t as hierarchical in nature as the old popup-heavy UI used to be, thus sometimes leading you astray with the underlying data model. In some cases, though, Advanced Find will allow you to perform queries on entities that are completely invisible to the CRM end user. In this post we’ll take a look at one such entity, the activity party, and explore ways in which we can use it for providing the CRM users information on who they are interacting with.

Ain’t No Party Like The Activity Party…

ActivityParty_Appointment…’Cause in the Activity Party everybody’s connected! OK, so what exactly is this “party” thing then? In the CRM user interface we have activities, which are divided into a number of different types, like email, appointment, phone call, letter, fax (everyone’s favorite default entity, right?) and potentially a selection of custom activity entities for non-standard communication channels like SMS or business specific record types for handling assignments, approvals and these types of work items. Each activity type shares a number of common fields that can be found from the entity called “activity”, which is what allows CRM to show this mixed bag of apples, oranges and pineapples in a single list of fruit activities related to a business record like the customer account.

When we add people into an activity like a meeting invitation (remember: appointments are always invitations now in the server-side sync world, so be careful when including customer contacts there), CRM is not just populating a lookup field on the activity entity with the GUIDs of all the related users, contacts and other resources. What happens behind the scenes is that each of these related records will result in a new activity party record being created. This is an entity that you will not see in the CRM customization UI if you open the default solution. You can read about it in the SDK, or install a tool like the Metadata Browser (found inside the downloadable SDK package) and have a look at its contents from the live system, as we see below.

ActivityParty_Metadata

People who have been tasked to build SSRS reports that deal with activity records will have surely run into the ActivityParty table/view. If you’re interested in learning more about how the data is created and stored into the SQL database, go and read this great investigation by CRM MVP Aileen Gusni. If, on the other hand, you’d rather not spend too much time in Visual Studio / SQL Server Data Tools building reports but rather want to see how to leverage activity parties in Advanced Find, then this is the right article you’re reading right here.

View of “Activities Involving Me”

While activity parties are not accessible as a configurable entity in CRM (because ultimately they’re not), luckily they do exist in the Advanced Find UI. The first scenario in which we can take advantage of this capability is in building a view of activities that uses some criteria that’s not directly available on the activity record itself. Out of the box, CRM provides views like “My Activities” that show the records in which the current user is the owner (and which are open, even though the name of that default view is a bit misleading). Sure, it’s important to understand what’s on your To Do list right now, but sometimes it is beneficial to be able to reflect back a bit and see also what has happened in the past, to understand what you’ve spent your time on and who have you interacted with. For this, we’ll create a brand new view called “Activities Involving Me”.

[Read more…]

Filed Under: Tips Tagged With: activities, Advanced Find, dashboards, search, views

Previewing the New Power BI Experience with Dynamics CRM

Jukka Niiranen December 29, 2014 10 Comments

Previewing the New Power BI Experience with Dynamics CRM

Around one year ago Microsoft introduced the capability to access CRM Online data via Power Query, one of the client side components of the Power BI suite. More precisely, the capability to authenticate with the already existing CRM OData feeds via Office 365 credentials was introduced into PQ, which then allowed us to use CRM Online as one data source in our Power Pivot data models driving Power View visualizations. No Dynamics CRM specific feature had really been developed, but it was the first step on the road of unlocking the cloud data from the analysis limitations that the previous tools (CRM charts & dashboards, SQL Server Reporting Services reports with Fetch XML queries) had imposed on CRM Online customers.

There was a lot left to be desired still. Building reports from the raw OData feeds can be a cumbersome process, since no built-in tools existed for filtering the amount of data pulled from the entity tables. Also, not all the components needed in basic reports, such as optionset labels, were available to be retrieved dynamically from the OData feed. The biggest gap, however, has been the inability to automatically refresh the reports published onto Power BI portal, which means that each report end users would have needed to perform this refresh manually. As a result, Power BI has so far not been a something that I would have suggested to CRM Online customers as a company wide reporting solution, since it’s mainly been suitable for fairly advanced CRM power users building their own reports via Excel 2013.

The Next Generation of Power BI

Just before Christmas Microsoft announced the new Power BI Public Preview, which has a number of impressive looking enhancements to the service offering:

  • Power BI Dashboards
  • Power BI Designer application
  • Apps for iPad and iPhone
  • On-premises SQL Server Analysis Services support

Include in this announcement was also the statement: “In addition to the existing seamless connection with Microsoft Dynamics CRM Online, with today’s release customers can also connect to their data in Salesforce, Zendesk, Marketo, SendGrid, and GitHub with many more to come in the months ahead.” Upon first read, it was easy to interpret it as “nothing new for you Dynamics CRM folks out there right now, better luck in the next update!” This, however, isn’t the case.

PowerBI_Preview_CRM_app

When browsing through the new support site for Power BI I came across a posted idea on supporting Dynamics CRM as a data source, and a very recent comment from a Power BI product manager that the new Public Preview actually included native support for Dynamics CRM. Here’s the article where you can find the exact steps needed for connecting your Power BI Preview instance to Dynamics CRM. As this Preview is only available in the US for now, I decided to spin up a new CRM Online trial org from across the pond and try it out.

What’s in Store for Dynamics CRM Cloud BI?

After going through the process of enrolling for the Power BI Public Preview program with my Office 365 US trial tenant, I completed the steps for connecting to CRM Online. This really is quite a simple process with not too many options. You only have to dig up the OData feed URL from your CRM Online instance. After you’ve added this Microsoft Dynamics CRM app into your Power BI environment, the data retrieval process will start uploading your CRM Online records from one cloud to another. [Read more…]

Filed Under: Featured posts, News and events Tagged With: analytics, cloud, dashboards, OData, Power BI, Power View, reports

Search

About me

I'm a Microsoft Business Solutions MVP from Finland, having worked with the Dynamics 365/CRM system since 2005 and in the field of customer relationship management for over 15 years now. Whenever I feel like saying a thing or two to about Dynamics 365 Customer Engagement, I may post it here on my blog, tweet it, save it to my XRM links or post it on Google+.





Follow on Google+

Read on Feedly (RSS)

follow us in feedly

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Blogroll

  • jukka.niiranen.eu – my personal blog
  • Microsoft Dynamics Community – Feeds from other Dynamics CRM bloggers
  • Microsoft Dynamics CRM Finland – blogging in Finnish

Recent Posts

  • Discussing Spring 2018 Highlights at CRM Rocks
  • Yes, XRM Is The New Common Data Service
  • Microsoft Business Forward 2018 Event and Spring Wave for Dynamics 365
  • Trial & Error: Understanding Dynamics 365 CE Trials
  • In Praise Of Code and No-Code
  • Getting Your MCSE Certification for Microsoft Business Applications
  • Look Out for The End Of Outlook Client
  • From AppSource to Solutions to Dynamics 365 Apps
  • What’s An “App” in Dynamics 365 Anyway?
  • Top 3 Themes for Dynamics 365 in 2017

The CRM QuickStart Book

Need to update your skills for the new Microsoft Dynamics CRM version? Then here's the book for you!

RSS Surviving CRM on Google+

  • Spring Wave for Dynamics 365 is here! There were some major announcements this week at the Microsoft...
  • Is it essential that functional consultants in Dynamics 365 project teams know how to write code? No...
  • Want to learn about the certification options in Microsoft Dynamics 365 Customer Engagement and how ...
  • Why the Apps you install from Microsoft AppSource aren't always the same thing as what the users see...
  • Ever find it confusing when people use the word "app" for different purposes within Microsoft Dynamics...

RSS My latest entries on crmlinks.workdpress.com

  • Solution Installer for XrmToolBox
  • CRM Power BI Viewer
  • StressStimulus Performance Testing for Microsoft Dynamics CRM / 365
  • EasyRepro: Automated UI testing API for Dynamics 365
  • Dynamics 365 Power BI Query Accelerator by Sonoma Partners
  • Entity Relation Diagram Creator for XrmToolBox
  • Dynamics CRM Deployment Wizard
  • CRM Code Editor by Jason Lattimer
  • Dynamics CRM Build Tools
  • Dynamics CRM WordPres plugin by AlexaCRM

Archives

Tags

activities activity feed add-on Azure Browser cloud community Convergence crm5 CRM 2011 crm2011 CRM 2013 CRM 2015 customization development Dynamics 365 ExtremeCRM integration mobile Office 365 online Orion Outlook Polaris PowerApps Power BI process R8 R9 releases reports roadmap salesforce social solution twitter UI update rollup upgrade usability UX Windows 8 workflow wpc XRM

Featured Post

Yes, XRM Is The New Common Data Service

Yes, XRM Is The New Common Data Service

In November 2016 I wrote an article on LinkedIn with the title “No, Common Data Service is not the new XRM”. This was my response to the speculation that had emerged from Microsoft’s announcement of a new cloud-native platform to store, model and integrate business data with other (cloud) applications. This platform called CDS was […]

@jukkan on Twitter

My Tweets

Copyright © 2018 · Streamline Pro Theme on Genesis Framework · WordPress · Log in