Tag Archives for " MS Power BI "

Need ideas for new posts?

Power BI Community

Let your Visitors, Google Analytics and Power BI help you!

Original sourceMicrosoft Power BI Community - Ruth Pozuelo - Curbia Blog

If you are like me, you have probably stared at a white page wondering what your next topic should be on your blog or what additional content could be relevant for my site. I have written about the everything, what else could be said?

With our new dashboard, you will get help from your site visitors to get ideas on new topics.To be able to recreate this dashboard you need to configure site search in your site.

Don’t, worry it is very easy to do.

What insights can we get with this dashboard?

As we normally do, let’s start with the results first:


Curbal blog

In this dashboard you will be able to understand:

  • Find ideas for new content
  • Find new topics that your readers would be interested in
  • Understand if your blog is driving the right users to your site
  • Are your important pages hidden from your readers?
  • What is your audience looking for in your site
  • Publish your content on the most relevant places on your site.

As we normally do, let’s start with the results first:

What insights can we get with this dashboard?

If you would like to see a live version of the dashboard, you can watch it in our YouTube Channel, but if you prefer text, continue reading.

Don't want to create the Power BI file?

If you are a member on our site (it's free), you can download it by following this link. You will also get an in-depth guide on how to use the dashboard.

You will need also to change the data source from my account to your Google account.

Creating the dashboard: Get Data

Building the Dashboard


Create the visualisations

Custom visualisations

Now its your turn, what gold is your site search hiding?

Google records EVERTHING you look for

Big Data

Good or bad you may be surprised to learn Google makes some of this data available to you and I!

So with total abandonment, let’s explore all this lovely data.

So let’s begin at the beginning?

We start by using a website called Google Trends.

To be able to make use of this service you really need a Google account.

If you don’t have one, you can sign up for free account, by clicking here...

Your browser choice is entirely your own but why not use Chrome for this exercise.

Using your preferred browser, in the address bar type https://www.google.com/trends/ The site will enable you and I, to learn what other people are looking for on Google and how frequently they do so.

Recently England hosted the Rugby World Cup and this was reported as being a success for all. So let’s investigate the supposition.

Begin by typing the term “2015 Rugby World Cup” then press the enter key or click the search button.

Reviewing the regional interest section, I was surprised to learn Fiji leads global interest in rugby, ahead of New Zealand. I was shocked and surprised to learn England wasn’t even listed.

Use Google Trends to learn what people are looking for.

Let’s enter another search term, this time “Winter” and below the “Worldwide” search field select the UK.

It’s not surprising the search term “Winter” begins to increase from August onwards and declines in April.

If you choose a southern hemisphere country, the results are reversed. Scroll down to see related searches.

You can run searches to find out which sports are popular in which countries.

Just add a comma between each sport for example “soccer, cricket, rugby, snooker”. Question the returns, do you think there is a pattern, does the country have an imperial past and has that influenced their sporting interests.

Men are from Mars and woman are from Venus?

Click to Tweet

Men are from Mars and woman are from Venus?

Obviously the answer is NO.

But are there any differences in the way people choose presents for their partners?

To make it interesting conduct a worldwide search by typing in “gift for men, gift for woman” and then “gift for boyfriend, gift for girlfriend” then “gift for husband, gift for wife”.

Look at country differences and investigate what occurs when the term changes gift for men and gift for woman then search for gift boyfriend and gift girlfriend.

Change the time period to compare changes.

  • Try the last twelve months.
  • Last ninety days the last hour.

Assuming you wish to manipulate the data further using Excel or spreadsheet application download the CSV file. To do this Google requires you to have an account. Once logged in you will be able to download the CSV file.

There are other resources for example Wikipedia. Visit http://stats.grok.se/ and in article name box type “Christmas”, “Bank of England” try changing the time period.

If you are interested in investigating the surges in Wikipedia Bank of England article, try searching for corresponding time period by visiting online newspapers, broadcasters’ website for example BBC business section reports.

Well done, if you’ve read this far. My very hearty congratulations.

Why not spend a few minutes investigating what else is out there for FREE.

Power your business ahead of your competitors with free open data

Data Insight


Data Insight

Business Reports

Huge comprehensive and accurate data sets covering a wide range of topics held by public bodies and large companies can be used to MAKE MONEY.

It’s not just for the tech savvy wanting to create a hot new app either.

OPEN DATA can become an integral part in IMPROVING business intelligence, planning and research.

Here’s an introductory guide to structuring a plan and cherry picking the best of what’s available online.

Your first step, RESEARCH

Your biggest challenge will be DEFINING your QUESTIONS.

To help you to define what you need to focus upon begin by asking and answering questions. Talk to your staff, your customers or clients and seek to understand your competition.

Your next step is to NOT, reinvent the wheel.

Find out what data sets have already been completed. Don’t think a particular dataset isn’t available there is a good chance it has and if it hasn’t you can probably create one from a combination of sources.

NEXT - locate your resources.

You probably already have many of the tools you need if you don’t - there are FREE tools to get you up and running.

For example, many open data resources provide downloadable CSV files.

Using Microsoft (MS) Excel, you will be able to interrogate your CSV files using tools such as power map, power query, power pivot & Power BI.

There are other tools such as Datawrapper, Quadrigram and Tableau.

Developing visional representation of your data queries - will help you to make sense of your data.

Next build a team

The more complex your project the greater the likelihood is; you will discover gaps in the range of skills available within your organisation so be prepared to supplement your team with outside resources. You will also need to think about the long-term implications of the project.

Open data is by in large free to use.

However, costs may be incurred if you use huge volumes of data.

The data can be adopted for proprietary purposes, but that doesn’t mean you own that data.

For example, if you, setup a company using open data then go on to sell the company you must declare your use of third party data sets.

If you fail do so you could face a legal claim even if years have passed.

Of course if do declare this your intellectual property value probably reduces.