Getting from disparate data sources to data-driven decisions in minutes

DP4Excel and Power QueryEvery organization stores information in multiple systems and this presents the challenge of how you connect these islands of information to create a single, consolidated view of your business to support data-driven decision-making. Until now this possibility has chiefly been reserved for large organizations with deep pockets.

This is why we’re very excited to reveal that our newest product DecisionPoint™ For Excel, when combined with Microsoft Power Query for Excel, can create this big-picture view for organizations of all shapes and sizes without costing the world.

Continue reading

Top 5 BI and data articles, 8 – 15 December

BI and data articles

“Any fool can know. The point is to understand,” said Einstein.

Do you understand how contextualizing Big Data will help your organization grow? Or what the big hopes for Big Data mean for your business?

To help you understand we have, as usual, put together a list of last week’s best BI and data articles for you to just peruse.

Continue reading

Top 10 charts and how to use them

Top 10 charts

The amount of charts available for you to display your data in can be a bit overwhelming. Which chart should you use to compare one or more measures across a single dimension? When should you use a horizontal bullet chart? And why does everyone hate the pie chart?

So to make it easier for you we’ve made a list of the top 10 charts, accompanied with instructions for use. Which chart is your favorite – the donut, the bar or the line? Whichever one it is, give it a like!

Continue reading

Simplify your business intelligence and increase adoption by learning from Steve Jobs

BI for everyoneWhilst Steve Jobs is rightly most famous for the impact he had on consumer technology, he also had – and is still having – a significant, long term impact on business technology, and business intelligence (BI) in particular.

To my mind Steve Job’s key legacy to BI is not the iPhone or the iPad but rather the mobile apps that they carry, and they are a signpost to how BI is going to change in the future. Let me explain.

Continue reading

Top 6 BI and data articles, 1 – 8 December

BI and data articles

Are you up to date with the latest BI and data news? If you are, you should be able to answer these questions.

Which two data giants partnered this week?

Where is BI software headed, according to Datamation?

What does HTAP stand for?

If you could answer all three – well done, data guru! If not, the answers can be found in the list below.

Continue reading

Our wish list for a merry BI Christmas

All we want for Christmas

It’s December and it’s beginning to look a lot like Christmas! But this year we don’t care about the presents underneath the Christmas tree.

We don’t want Santa to trim our Christmas tree with some decorations bought at Tiffany’s. What we want this year is not on everyone’s list, but it should be on every business intelligence professional’s.

What do you want for Christmas this year? Add it to our list and your wish might come true!

Continue reading

Transforming Marketo data into marketing insights in an interactive dashboard

Marketo dashboardYou may, like us, use Marketo for all your marketing activities. And you may, like us, have noticed that the out of the box reporting tools in Marketo are a little bit, shall we say, modest.

Because of Marketo’s basic out of the box reporting we’ve always exported the data into Excel and used pivot tables to get the view we want and then copying and pasting into PowerPoint to create dashboards. This, however, is not a good solution since the dashboards have no interactivity and the whole process steals precious time from us in the marketing team when we have to update the data in Excel on a weekly basis.

Continue reading

Best business intelligence articles, 24 November – 1 December

Best business intelligence articles

Monday. It’s normal to feel a bit down and out of it.

To make you feel better we’ve compiled a list of last week’s best BI articles, so that you can – to paraphrase Woodrow Wilson – use not only the brains that you have but also the brains you can borrow, to get you back on track.

Continue reading

Data trends to be thankful for

Binary table

The turkey has been stuffed, cooked, carved and consumed, the sides have been prepped and gobbled the pumpkin pie has been baked and demolished.

As you come out of the food coma and start thinking about the bargains that await, we give you our list of data trends we’re thankful for this Thanksgiving.

Continue reading

From raw data to interactive dashboard in minutes

Bring blended data to life, smallerAs a business you will no doubt have all kinds of data coming from different parts of your company. You might have your sales orders in a CRM system and your delivery information as an XML extract from your supply chain system, meaning the data you need to make decisions isn’t in a consistent, useable state.

Before you can gain business insights from your data, or even start to work with it, it needs to be blended into one data source that plays nicely with your BI software. What you need is a tool that does this for you, and that easily integrates with your BI product.

Continue reading