Sunday, November 29, 2015

Wave Goodbye to Power BI in Office 365, We Won’t Miss You

imageAs it happens with Microsoft products, there are two competing versions of the same thing and eventually one gets phased out. Now it’s Power BI for Office 365’s turn. It had a good run, but Microsoft is finally killing off the initial iteration of Power BI to let its new service move in and run the show. Continue reading as I walk you through What is Power BI, how we got to this point, and what can you do moving forward in your Business Intelligence efforts.

A Little LUCK May Be The Secret Ingredient For Collaboration Success

imageYears ago we discovered something very special – some might even say a “secret ingredient” – to creating and building lasting and productive relationships. It's a new and unique approach to ultimately creating purpose, happiness, and engagement, and when applied within an organization, new ideas and innovation (which ultimately affects revenue and profit as well). We realized that this “ingredient” was actually composed of four very distinct components, that had to be applied in a specific way in order to create the final product of LUCK. Read on to learn how to bring LUCK to your business.

Characteristics of a Failing CRM Project

CRM leadership failure

According to our CPR for CRM study, which is also confirmed by Merkle Group Inc.’s 2013 study, CRM projects have up to a 60% failure rate. In other words, when you launch a CRM project, the chances are that it will end in failure! After a recent webcast discussion of CRM failure, we were asked to engage with a company who had started off strong, but after a few years, they were struggling. The issues they were experiencing were typical of many other companies that we work with.  See if these symptoms sound familiar to you...

Need a Checklist for Every Time You Import Data into Dynamics CRM? We Did Too.

Dynamics CRM Import Checklist

We don’t think we should be the only ones making speedy, efficient imports into Dynamics CRM. Because there’s more than a few necessary steps, we developed this checklist as a way to ensure that data is imported correctly and follows best practices.  Now, we’d like to share it with you. 

Building a Challenger Sale Commercial Teaching Presentation – an eWorkbook

A Workbook for Developing Challenger Sale Presentations
After reading The Challenger Sale some of my concepts about sales were … challenged.

But after reading, discussing, researching and trying, I am now a believer.  In the process, we developed a template that we use to develop our own Challenger Sale presentations - you can download it using the link at the end of this article.

Why Microsoft Social Engagement Could be a Game Changer

image_thumb11Microsoft Social Engagement comes as an evolved form of Microsoft Social Listening, and the name change reflects a changed sentiment of the tool. It Is no longer about simply listening, Social Engagement is now about reaching into the social media world to engage with customers and prospects on a level that has never been reached before.  From setting up watches to know who is talking about your company or product, to monitoring complaints to create prospects, Social Engagement offers a way to keep one eye on your company’s social pulse and the other on prospective customers.

How to Use Date Tables and Auto-refresh Online Data Sources in Power BI

Date tableIf you’ve been paying any attention at all to the world of business intelligence lately, you’ve seen the shift of Microsoft Power BI from the service built-in to Office 365 to the standalone offering from  In today’s post, I want to show you how to leverage the Power BI service and construct your data source so that you can have date tables and OData sources that you can configure scheduled refreshes on. 

Sales Meetings with CRM – Remember to Look Forward

Using CRM for Sales MeetingsAs a sales manager, are you using your CRM solution to plan forward, or simply reflect backward? Planning forward will help you help your team members prioritize their time, make better judgement calls about activities associated with leads/opportunities and ultimately close more deals. This article discusses a more effective way to conduct sales meetings, whether weekly catch-ups with sales reps or all-in sales team calls.

New to Microsoft Dynamics CRM? Have No Fear

If you're like me, walking into the wide world of CRM can make the word "intimidating " look like an understatement. Whether you just need to know enough about CRM to get by, or you are about to dive in to discovering all that CRM has to offer, take a look at the resources and articles below to start navigating the waters of Dynamics CRM.

How is Your CRM Project Doing? Judge for Yourself.

why does our crm suck

Don’t tell my boss, but I hate CRM.

Research suggests that leadership’s opinion of CRM success is often different from the teams using CRM on the front lines.  And IT, Sales, Customer Service and Marketing can all have radically different opinions of an organization’s CRM solution. C5 Insight has introduced a free to download tool that can be used as a self-evaluation to rate the success or failure of your CRM project.

C5 Insight Will Be At CRMUG Summit Next Week Talking About CRM and Collaboration Failure

Next week, both of C5 Insight’s Managing Partners will be at CRMUG Summit in Reno, NV discussing both CRM and Collaboration failure. The truth is, over the last 5 years or so, we have become somewhat obsessed with failure, not necessarily by choice, but because nearly 60% of all new client work for us is what we call CPR work - in other words, project rescue. 

I’ll Be Online Next Week At Collab365 Delivering The Deadly Sins of SharePoint

3 out of every 5 companies using SharePoint struggle
.  If this sounds familiar, then I encourage you to attend Collab365, the free, 24-hour, online conference on Oct 7-8. There will be hundreds of great sessions with some pretty amazing content, and I’ll be delivering my Deadly Sins of SharePoint session, which was developed specifically from the things we have learned from helping struggling organizations.

Sure Way to a CRM Fail: "If We Build CRM [Right], They Will Come”

No one is using our CRM solutionAfter working with hundreds of companies and investing hundreds of hours into CRM success and failure research, there is one thing we have never heard from organizations that have successfully implemented CRM: “Our CRM was such a good tool for our sales team, that they want to use it.”

In other words, CRM is not going to be your Field of Dreams.  If you build it, they won’t come – no matter how good it is.

4 CRM Support Lessons from a Wine Maker

Support Agreement for Salesforce CRM Support Agreement For Microsoft Dynamics CRMWine.  I love it.  And I love visiting wineries whenever I can.  Wine and wine making are such rich sources of history, have an element of the artistic, and just feel closer to the basic and raw elements of the earth.  Like farming, there are a lot of simple lessons in wine making that apply to everything else in life.

But the lessons learned when my wife and I visited a wine maker on a recent trip still came as a surprise – I wasn’t expecting to see the connection between making wine, and improving customer relationship management (CRM) projects with solutions such as Microsoft Dynamics CRM and

Seminars or Snippets - Are You Training Your End Users Wrong?

imageThe truth is, the “training” methods we have been using for decades are dying. And if your organization is still hoping to train users on SharePoint, CRM, or any other technology by sitting them in a room to watch recorded videos or a live individual, I want to offer some suggestions that I believe will transform the way end users adopt and learn new technology. 

What’s Missing from the SharePoint 2016 Preview?

SharePoint 2016 IT PreviewIf you keep up with SharePoint news at all, you have very likely heard that Microsoft recently dropped the beta 1 build of SharePoint 2016 (or more affectionately called the IT Preview) to much fanfare. With the release of the public beta, there are lots of folks in the community who have written about these new features and how to install it. In today's blog I want to discuss the initial highlighted features that are removed from the SharePoint 2016 preview.

Using AutoSPInstaller to Build a Three-Tier SharePoint 2013 Farm – Part 2


Welcome back to part 2 of my short series of using AutoSPInstaller to build a 3-tier multiple server SharePoint farm.  Last time we looked at all of the work we needed to do to get setup and discussed what our end goal was.  Now we can get down to business and start some installation!   I’ll walk you through the most critical part – creating your answer file, then the installation itself.

Maximizing Your “Support” Investment

imageChances are, if a company has invested in a collaboration or relationship management solution without an experienced solution partner offering ongoing coaching, support and training, its internal IT support staff is feeling the sentiments of one or more of the following: “I have 7 other jobs”, “Management thinks it’s just another application, like Outlook”, “I’d rather do anything than try to learn this”, “I don’t spend enough time on this to ever be very good at it”. Have you said, or heard, any of these statements? Then read on.

CRM 2015 UR1 (Spring 2015) Top 10 New Features

What are the 10 most important upgrades available in the Microsoft Dynamics CRM 2015 Spring (UR1) Release?  Read the blog for the details, or thumb through the SlideShare, below, for a quick overview.

Creating a Neglected Accounts View in CRM 2015 UR1+

Everyone wants to know which of their accounts have not been followed up recently.  But using the Neglected Accounts report is just sooo 1995.  Nobody uses reports anymore – we want everything as a view, chart or dashboard!  But until the most recent release of Dynamics CRM, the only way you could create a Neglected Accounts view was thru installing add-on products or developing code.

Using AutoSPInstaller to Build a Three-Tier SharePoint 2013 Farm – Part 1


In this 2-part series I am going to take you through all of the necessary steps to use autospinstaller to build a 3 server farm doing remote installations on Windows Server 2012 R2 with SharePoint 2013 recent CU. (When I say all, I am referring to the SharePoint relevant pieces and the autospinstaller.) Continue reading for SharePoint 2013 (2010) installation.

Getting the Website URL When Importing Leads Into CRM

Extract Website URL from Email Address using Excel for Microsoft CRM Salesforce ImportEver received a trade show list after an event that has email address but doesn’t have website, with a request to import it into your CRM solution? You know those website URLs are locked up inside of the email addresses, but you need to get them imported in a hurry, so you just import it without concern for the website. The problem is that the website can contain critical information. This article explains how to use an Excel formula to quickly pull the website URL out of an email address before importing into your CRM solution.

Forget Technology, Focus On People

imageThe latest technology out there today is compelling and can do great things. And it’s true, a few could revolutionize the very way you do business.  But in an effort to do more with less, move faster than competitors, be agile and lean, and choose “best of breed” technology, we often see organizations forget about the very ones who will make the investment successful and worthwhile.

Sales Rep CRM Quick Tip: How to Start (and Finish) Every Day in CRM

Let’s face it, customer relationship management applications can be confusing. There are lists of lead, accounts, contacts, opportunities and – in some cases – other things like products, quotes and orders. With all of these things you can do, we are frequently asked, “where do I begin and how do I start each day with my CRM application?”

The answer is simple … but how you arrive at the simple solution takes some discipline.

Sales Rep CRM Quick Tip: 4 Steps for CRM Account Management

It costs about 7 times more to win a new customer than it does to retain and grow a relationship with an existing customer.

But most Sales Reps receive very little training on how to prioritize different customer relationships.  Just a little bit of work with your customer relationship management (CRM) system can mean a boost of 10% or more to standard commissions – and to overall sales!

Marketing Automation: Questions To Consider When Selecting A Solution

I recently ran across a staggering statistic: less than 10% of businesses are using a marketing automation solution.

How can this be? What are businesses using to not only create and send email templates to their marketing lists, but also tie in nurture marketing, web forms, landing pages, web tracking, social sharing, campaign management, and more? It’s time to address what to look for during solution selection.

Upgrading From CRM 2011 to CRM 2015?

Microsoft has added a lot of functionality to CRM since version 2011.  If you’re on Microsoft Dynamics CRM 2011 (or earlier), Dynamics CRM 2013 or are on Dynamics CRM 2015 but have not yet applied Update Rollup 1, this article provides a useful list of resources to help you understand the new benefits for your users. 

CRM 2011 to CRM 2015 Update Rollup 1

Quick Tip: Microsoft Dynamics CRM Spring 2015 - Immersive MS Excel

The release of Microsoft Dynamics CRM – Spring 2015 includes a helpful new feature; Immersive Excel. This functionality allows a user to manipulate Dynamics CRM data in MS Excel, without the cumbersome "Export to Re-import" process required in the past.

Defining Failure? Stop Blaming Technology

AKTweet There is a big issue in business these days – blaming technology for people problems.Though it’s true that technology can be fickle and frustrating and even I have often restrained myself from sending my laptop sailing out the window, well…it’s a computer. Can we all just agree, collectively, to assert our human brain’s superiority and stop blaming technology? Here are a few ways to start bringing people back into the mix.

The Components of a Successful Roadmap Engagement – Part Two

8b502c8a42e8fa0cff48581c8792678c[1]In part two of this successful roadmap engagement series, we'll look at Risk and Obstacle Evaluation, Business Case and ROI, Culture Change, Training, Adoption, and Future Planning.

Getting the Most ROI and User Acceptance from Your Business Systems

You may have just made the momentous decision to purchase a new CRM or ERP system, or perhaps you have had your systems for some time. With many companies offering ‘Best of Breed’ business systems, one thing typically remains true: each of these systems are silos of data and information. This blog details real-world benefits of systems integration.

Resolve Stubborn Missing Reusable Workflows in SharePoint Designer

imageHave you ever opened SharePoint Designer, clicked on Workflows, and saw nothing?  I sure did and was able to fix it.  In today's blog post, we'll do a quick primer of SharePoint reusable workflows, then I'll discuss the problem and all the troubleshooting I did to try and fix the issue.  Finally I'll review the magical steps necessary steps I took to actually resolve it.

The Components of a Successful Roadmap Engagement – Part One

thOK1FGFYKThe idea of engaging in a road mapping exercise has gained in popularity in recent years due to the ever changing technology landscape and the pace at which new business process evolves. Contrary to popular belief, a roadmap is not just a pretty Visio! It is not one size fits all, so don’t let the expectations or results of others dictate the expectations for your engagement. This blog series will explore some of the most critical aspects of a road mapping project.

Debugging Plug-in Made Easy for Dynamics CRM Online

imageIs Exception Handling one of the easiest ways to track values of variables used in C# plugin for Dynamics CRM Online? It was really helpful for me, when I found that developers can use the Profiler in the Plugin Registration Tool to debug a C# plugin. Here is a step by step guide for the whole process.

Replace Tasks with Queues for Inside Sales Productivity

queueInside Sales teams are rapidly replacing traditional sales teams.  This approach to sales is resulting in significant productivity gains, improvements in responsiveness to prospects and customers, and cost savings.  It also introduces an ability to have a much tighter and more buyer-driven sales process.  But it also requires some rethinking of the tools used in CRM to support the sales function.

Activity planning and management is one of those areas. Learn how queues can boost the productivity of the Inside Sales team.

Scribe’s 7.9 Release Multi-Threaded Integration Processes

clip_image004The new Scribe Insight 7.9 release offers multi-threaded integration processes for all four of the integration process types available within the Scribe Console, but, let’s clarify. Previous to the Scribe 7.9 release, only one thread was reserved for processing all File, Time and Query based integration processes. This blog discusses what you should know about the newest release.

Single-Threaded vs. Multi-Threaded Translations

When performing a migration or integration of data, one consideration that should be high on your list is translation performance. Today's blog will discuss how to address the processing of multiple records simultaneously, as opposed to a single-threaded process.

Application Publisher vs. Stored Procedure

When building an integration between business systems, or even simply performing a migration from a business system to a flat file extract, a great way to find and extract the data you need is using an application publisher. An application publisher is a purpose built tool that typically uses the API of the application to make available data from the systems objects or entities.

Business Rule or JavaScript in Dynamics CRM…that is the question

Biz Rules IconWith the advent of Business Rules beginning in Dynamics CRM 2013 we now have the ability to implement client-side business logic without having to write javascript functions. How can I determine whether to code my business logic using business rules, javascript or both?

2 Easy Ways to Calculate Working Days Inside a SharePoint Workflow

I’m in the midst of two different major workflows for clients right now, one of them being an HR New Hire Onboarding request and approval process.  One small but critical requirement of the process was that each level of approval needed a two business day wait period. In this post I'll demonstrate 2 easy ways to be able to calculate working or business days inside a SharePoint workflow.

Sales Rep CRM Quick Tip: Use CRM to Identify and Convert More Leads

Did you know it takes an average of 7 contacts to convert an unqualified prospect into a sales qualified lead?  And did you know that 60%-95% of sales leads are never worked at all?  That’s a huge amount of untapped potential!

In this article, we will look at the "3 C's" of lead management using customer relationship management.

Bringing the Cloud Down to Earth

It’s your data. Don’t let great on-line transactional systems limit your analytics needs. Bring the cloud down to earth, then slice and dice to your heart’s content. This blog will discuss three ways to accomplish this.

Sales Rep CRM Quick Tip: Weekly Planning

If you’re not using CRM as a tool to plan your day, week, month – or more – then you’re missing out.  You’re leaving valuable referral sources in the cold.  You’re letting opportunities slip through the cracks.  And you’re letting your competitors snap up your best customers.

This article takes a look at how to use CRM as a planning tool.

CRM Deployment Options…How to Decide?

So you are ready to tackle that all-important CRM initiative for your company. You will need to consider multiple factors in making the initial deployment decision; however there is usually one factor that rises to the greatest importance in making the initial decision.

Some ‘Gotchas’ To Deploying Code In™

One common CRM challenge is keeping your development environment in sync with the production environment. Coding in a development environment that is not in sync with production can lead to many hours of frustration trying to find the ghosts in the code. I find this especially true working in Salesforce.

Dynamics CRM Online - The User ID Associated With The Current Record Is Not Valid

CRM Online Administration Center

A client recently found he could not enable a user he needed to use in one of our sandbox organizations. Every time he tried, he got “The user ID associated with the current record is not valid”. This blog explores the fix.

Coding for Special Characters in Javascript

clip_image002Recently, I was asked to create a button on a form that would take data from the existing form and create a new Salesforce Lead record from it. Sounds simple enough, right? However, intermittently an error was being produced with a somewhat unclear message. This blog details the encoding function I used for the fix!

Measuring Enterprise Social Collaboration

ROI and value of enterprise social collaborationThe days of the production-line worker, the inbox/outbox process and any other repetitive task for humans to perform – are vanishing quickly. With automation, apps and robotics replacing humans at an unprecedented rate, our ability to collaborate to innovate, inspire, inform and to discover new insights might be one of the last ways to differentiate human labor from an automated workforce. But there is a problem. Most organizations have only a vague notion of how they are doing with social collaboration – let alone a vision and measurable goals for how they will make improvements. 

How to use Javascript on Dynamics CRM 2011/2013/2015 form


In this blog I am going to give you a brief explanation about how to use JavaScript libraries at the form level as well as how to create new JavaScript libraries in Microsoft Dynamics CRM 2013 and 2015.


Dynamics CRM Versions and Array Method “indexOf”

image_thumb[1]For one of my recent projects there was a requirement where I had to check the logged in user’s security roles, to find out if the user had been assigned a particular security role. If the user had the security role, there were several JavaScripts that would run. If the user did not have the security role, the JavaScript would not run. This blog explores my efforts to trouble-shoot and cross-test across multiple browsers.

Pages: Previous1234567...10NextReturn Top

About C5 Insight

We are a Microsoft Gold Certified partner focusing on SharePoint, Microsoft Dynamics CRM and  Learn more about us by visiting our website.

We Wrote the Bible on Microsoft SharePoint and Dynamics CRMBook-Microsoft Dynamics CRM 2011 and SharePoint 2010 Bible

Upcoming Events

Why Upgrade from SharePoint 2010?

12/08/15 @ 2:00 PM ET If your organization is considering a move to SharePoint 2013, then this webinar is for you. We know......

Comparing Salesforce and Dynamics CRM for Sales

12/15/15 @ 1:00 PM ET "Our CRM is so good that our sales team members WANT to use it," said no sales manager ever. Are yo... ...

Microsoft Social Engagement: Improving your Marketing LUCK

12/17/15 @ 1:00 PM ET Ready to get social? In this deminar (that's demo + webinar) session, we will take a look at the Mi... ...

Top Downloads

SharePoint 2013 Feedback Solution - collect feedback from users into a custom feedback list that captures their feedback and exactly where they were in SharePoint when they provided it.

Why CRM Fails - research into CRM failure, best practices, and how to recover from a failing project.

The 60 Second Collaboration Readiness Self-Evaluation - is your team really ready to collaborate?  If they're not, software isn't going to help.  Take the quick self-evaluation in each department to understand how well your culture collaborates.

Identify Your Support Gaps - collaboration and CRM projects often fall short when it comes to supporting users, because support for these projects is different from other projects.  



The information herein may be used solely at your own risk.  No warranty is made by the author or by C5 Insight, Inc.

The opinions expressed herein are those of the individual authors and do not necessarily represent C5 Insight, Inc in any way.

Copyright 2011-2013 by C5 Insight