Back in 2016, Microsoft introduced its intentions to refresh its CRM and ERP strategy with Dynamics 365. At the heart of its services was the Common Data Model (CDM). While many called it "out of the box," Microsoft knew bigger plans were coming.
You are here
Technology should assist in making life easier, simpler, and improve productivity for not only you, but your entire team. Microsoft Power BI is now delivering another opportunity for heightened productivity by making it easy to start visualizing data in Excel tables and CSV files.
Not only will you be able to utilize this tool for personal productivity, but you will also be able to share the data and findings easily with the rest of your team -- allowing everyone to benefit from the conclusions and next steps.
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.
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.
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
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.
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.
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.
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?
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.