Data & Analytics

Home/Data & Analytics

What if You Have to Integrate Multiple ERP, CRM, and Billing Systems

Hint: You Don't Have to Wait for a Data Warehouse! What if through mergers, acquisitions, and territorial expansion, your company operating data is now spread out across several ERP, CRM, and billing systems?  How can you combine all the data together into a coherent view of what is going on in finance, marketing, sales, production, warehousing, and distribution? There are three popular approaches, each with its own unique pros [...]

By |2020-07-21T22:14:52+05:00July 21st, 2020|Data & Analytics, ERP, Glimpse - Day One Ready, Merger & Acquisition|Comments Off on What if You Have to Integrate Multiple ERP, CRM, and Billing Systems

The Four Steps to Business Intelligence Dashboard Success

Get Profitable Insights from Your Analytical Dashboards  Business intelligence dashboards make an impressive appearance at presentations.  Their real value results from the insights you gain and the actions you and your team take based on those insights.  There are four key steps you should take to gain the most profitable insights from your investment in the data mining and data visualization that go into your analytical dashboards.  These are steps you [...]

By |2020-07-21T22:40:04+05:00July 18th, 2020|Data & Analytics, ERP, Glimpse - Day One Ready, Merger & Acquisition|Comments Off on The Four Steps to Business Intelligence Dashboard Success

Lead Source Yield

Lead source yield refers to the productivity of a lead source.  This can be measured and reported as the number of leads received per dollar spent for a single lead source.  It can also be measured by the reciprocal, cost per lead. As an example, let us assume that we are using seven different lead sources to drive sales, and that the marketing spend and leads received for the year by [...]

By |2020-07-21T22:48:09+05:00June 25th, 2020|Data & Analytics, Glimpse - Day One Ready, Marketing|Comments Off on Lead Source Yield

We Must Sell Our Way Out Of This

We must sell our way out of this pandemic, we cannot cut our way out, deliver our way out, we have to sell our way out.  The way we will go to market will be different, Zoom Selling will prevail for some time, and the old way of doing things simply will not work anymore.  If we have learned nothing else, we have learned that accurate, timely and clean data is [...]

By |2020-07-21T22:39:05+05:00June 13th, 2020|Data & Analytics, Glimpse - Day One Ready, Marketing|Comments Off on We Must Sell Our Way Out Of This

Creating a Power BI Dashboard: Power Query

This post is the second in a series describing our experience using Microsoft Power BI for an internal dashboard project.  In our first post, Creating A Power BI Dashboard, we discussed our dashboard needs, goals, and our approach. Now, we'll dive into how to actually get the data with Power Query. Our dashboard initially will report on billable and non-billable hours of our consultants, calculating revenue, margin, and utilization. Data Options To build our dashboard, the first [...]

By |2020-07-15T19:34:24+05:00May 26th, 2015|Data & Analytics|Comments Off on Creating a Power BI Dashboard: Power Query

Creating a Power BI Dashboard

This post is the first in a series describing our experience using Microsoft Power BI for an internal dashboard project. When not delivering Business Intelligence/Analytics, Data Warehousing, and Collaboration/Portal solutions to the world's leading brands, we periodically consider ways to improve our own business processes. We recently decided we could improve the way we track and manage our business through updating our dashboards.  Like most companies, we use a number of tools [...]

By |2020-07-15T19:30:56+05:00May 20th, 2015|Data & Analytics|Comments Off on Creating a Power BI Dashboard

Microsoft Mobilizes Business Intelligence with Datazen

News broke last week that Microsoft was putting their money where their Business Intelligence is and has acquired Datazen. Within our own team at Blackstone+Cullen there is always some debate about just what the virtues of the tech world around us are and what it means for business. With all these opinions the best way to share them is through the eyes of each segment. So, here is what a few of [...]

By |2020-07-15T19:30:25+05:00April 23rd, 2015|Data & Analytics|Comments Off on Microsoft Mobilizes Business Intelligence with Datazen