Making Data Analytics Easier

Everyone in business has data. We collect data on our customers, our products, our support and much more.  Often the data that we want to use and understand is in disparate sources making it hard to create reports and connections.  These connections are often what can drive innovation and growth. 

There are lots of services on the Internet and tools that companies like Denver DataMan build to bring data together.  But the questions is always, why can I not just see this data in the tools I use?

Data Schema IconThe challenge is that data comes in lots of different shapes, sizes, and organizational patterns, or as we geeks call it, schemas.  If I want to compare data from two sources, I need to make sure I am comparing the same attributes. Hence, a new schema must be born that can account for the data that I am comparing. For example, if one source has data separated by hours and another by days, I will combine the hours so that they can be shown as days.  

Microsoft has announced that they are making strides toward easing this bottleneck.  They are releasing what they call Common Data Schema (CDS) that will connect popular software like Salesforce,  Microsoft Dynamics 365 and others that have yet to be announced.  These data sources will slide into their existing Power BI Software that is also seeing improvements.  

This will enhance the apps that Power BI can connect to and further the ways that companies can analyze data in one place.  

For example, if you want to correlate sales in your brick and mortar store with customer use of Google Business listings or Google paid searches, you could do this in a more stream-line fashion. 

You can also read more in this article from VentureBeat.

Blog Tags
Related Service

Using Text to Columns to Separate Text in Excel

I found myself with forgetting how to easily reformat dates in Excel. The existing was in Excel and the dates like this “1943-08-24T00:00:00Z” I need the dates in DD/MM/YYYY format.

The first thing I tried was to use the left function to extract the first 10 characters which gets me the date.  However, for some reason, the left function would not let me change the output to the right date formula. 

Then a friend of mine suggested I try Excel Text to Columns.  Here is how you do that.

1.  Go to the Data tab 

2.  Select the column(s) you want to split.

3. Click Excel Text to Columns

4.  Select Delimited from the next screen.

Step 1 of 3

5.  Select your delimiter. This is the character that will be used to break the current column into multiple columns. In my case, I needed a custom delimiter of "T"

Step 2 of 3

6. In the third and final step, you select where your new columns should go and how they should be formatted. In my case, I select the correct date format.

Step 3 of 3

With just a few clicks I was able to solve my problem.

Subscribe to Data Manipulation