You are here

BI

With Data Comes Power

With Data Comes Power

In the Brothers Grimm fairy tale “Rumpelstiltskin,” a poor miller’s daughter was able to spin ordinary straw into gold. In many ways, business data is similar in nature: a series of ordinary tables contain rows and columns of data representing business entities, objects, transactions, interactions, numbers, dates and other bits of information that can be transformed into something of value to your business.

The Power of Clean, Quality Data

Your company invests in a Customer Relationship Management (CRM) system. It works diligently to have the system implemented and adopted across the entire company and ensure effective usage. However, if your team is not consistently keeping the Lead, Account, Contact, Opportunity and Service Ticket data clean for continued use, your firm is missing out on the benefits of CRM.

VSTS Test Results Reporting with Power BI

Would you like to use Power BI to build data visualizations around your Visual Studio Team Services user stories, test cases and test results?

Here are the steps to get you there: 

1. In the VSTS Work hub, build a query in VSTS to extract user stories and their associated test cases

Managing PowerBI Groups

Publishing reports under the workspace of a username works great when only one person is in charge of managing it. Unfortunately, PowerBI doesn’t allow us to give other users edit privileges on those reports, which limits effective collaboration with the rest of the team. 

Fortunately, PowerBI gives us the option to create groups which come with the ability to fine-tune permissions for other users. This feature requires a Power BI Pro license and is not available in the free version. 

Make Better, Data-Driven Decisions

What if you had a secret weapon? A tool that could tell you if a decision was smart before it was made or pointed you in a positive direction? You wouldn’t leave home without it. It would not leave your side. That tool does exist for businesses, with the proper support and training. It is your company’s own data. Your company can hone in on what its data can reveal to not only help you understand your past but, more importantly, to shed some light on your future.

Data as an Asset

The foundation of any business is composed of three things: the products/services offered, the people who keep the company running and the data that demonstrates past decisions and supports future decisions. Data is the backbone of every business. It is filled with useful nuggets of information, detailing past business trends, successes (and failures) and opportunities for growth moving forward. The data can assist your business in many ways, including in the development of new offerings, boosting total revenue and better managing your company’s costs.

Data's Role in Content Marketing

In the world of marketing, increased viewership could mean opening the door to more conversations. More conversations could lead to new clients, long-term relationships and new revenue. However, the debate continues: What type of content should your company be publishing to serve as seeds for those conversations?

Embedding PowerBI Report into CRM Form

With the last spring wave update, Microsoft gave us the ability to embed PowerBI visualizations into CRM dashboards. If we want to display a report on a CRM form, we don’t have a native support to do that just yet.

However there are multiple approaches that allows us to embed a PowerBI report via an iFrame. In this blog post, I’m going to elaborate on the easiest approach and discuss its pros and cons.

Data's Seven Deadly Sins

Data's Seven Deadly Sins

The sales and marketing data available can be overwhelming yet very powerful. But it's also useless if you don't know how to use it. Here is a list of the seven most common data use mistakes found in marketing operations:

Multiple QlikView Select in Field String Values

I have a list box in QlikView that has an order status field. It had three values: Open, Posted and Deleted. I had a situation in QlikView where when the document opens I wanted to select Open and Posted, but not Deleted. Someone suggested that I use Open|Posted in the search string. Unfortunately, that didn’t work. I searched and searched and found plenty of different ways suggesting to do it and none worked except for using a macro. I didn’t want to use a macro and I knew there had to be a way.

Pages