Power BI

25 Jan 2014 How to connect to IBM DB2 from Power Query

SQL Server 2014 has been released since the 1st of April and there are some really cool features that might help you and your organization and can definitely justify an upgrade. In my job as a SQL consultant, I have a lot of different customers and none of them is currently working on SQL Server 2014 or is planning to upgrade to this new version. I find it really hard to convince my clients to upgrade or even install it for a brand new installation. Why is it so hard to convince people to start using SQL Server 2014…? After questioning my customers I figured out these 5 reasons?

31 Jan 2015 How to get Google Analytics data in Power Query

Microsoft Power Query is an Excel add-in that helps you gather, transform and analyse data from various sources. It's a very powerful tool and a must have for anyone interested in BI, no matter how experienced. Microsoft also releases frequent updates of this add-in, including new source connections. Google Analytics is a powerful tool for monitoring and analyzing your website traffic. It helps you know who is visiting, what they are looking for and how they are getting there.

09 Mar 2015 How to create a date table in PowerPivot with one single value

Calculations that make comparisons to previous quarters or to the same period one year ago are very important in all business intelligence tools. DAX, the formula language in PowerPivot, allows you to define such calculations by means of Time Intelligence Functions . However, in order to use these, you need to include a Date dimension table in your PowerPivot model. When you do not have access to a date table in your ICT network, you will be able to create one on the spot after reading this post.

18 Mar 2015 Boosting self-service BI: Microsoft Power BI

Susan walks into her office and wants to assign a job to Tom about absenteeism. But ironically it seems he's not at work because he's ill. So she decides to try doing the job herself. She takes her laptop and opens Power BI Designer for the first time. It looks enough like Excel to make her confident about using it. In no time she works through the data that the IT department has prepared, creates a report about employees and absenteeism over time and publishes it to the internal HR portal.

04 May 2015 Webinar: hands-on with Power Query

Microsoft Power Query is Excel-like software from Microsoft that helps you gather, transform and analyse data from a wide variety of sources. In our webinar we explained how to use Power Query in your daily work by guiding you through some examples

25 Jun 2015 Webinar replay: hands-on with Power View

Microsoft Power View is a useful add-on for Excel that helps you to visualize your data so that you can share and interpret information and present it to your customers. Check out our webinar replay with lots of demo's.

28 Aug 2015 What to expect from Datazen

What to expect from this tool, recently acquired by Microsoft? Here are some of the features that make Datazen a great and enterprise ready application.

13 Oct 2015 How to create a date table in Power BI in 2 simple steps

With the introduction of "Calculated Columns" in Power BI Desktop things got easier. In this blogpost I will show you how to create a complete date table is just 2 simple steps.

27 Oct 2015 Power Query Beyond the Ribbon: Types

Some time ago I gave a session on SQL Server Days about Power Query. I really enjoyed speaking there. The title of the session was “Power Query Beyond The Ribbon”. I have to admit a major strength of Power Query is that you can do pretty much everything only by using the ribbon. However this doesn’t mean that learning something about M, the Power Query Formula Language, is a waste of time. With M you can solve some complex problems, automate parts or simplify your solution.

24 Nov 2015 Visual tool for turning business requirements into reality

“Visualize to involve, write to describe" In business intelligence we extract data from anywhere. Beside the technical structures that define how the data is stored, we also need to understand the business processes behind that structure. It’s all in the name, right

14 Jun 2016 Data warehouse and self-service BI tools: friends or foes?

Looking at the BI marketplace today, a lot of products and vendors are telling us that we don't need data warehouses to create those flashy and easy-to-use reports and dashboards. Although from a technical point of view this statement could be valid, in the real world you are not only using the data warehouse to gather information in one location. In the real world we see that a data warehouse does much more than that.

05 Mar 2018 Niets beter dan Coca-Cola

Marktleider worden is poepsimpel als je het vergelijkt met marktleider blijven. Je moet je eigenheid bewaren – want dat is waarvoor het gros van je klanten voor jou kiest. Tegelijkertijd moet je meegroeien met een almaar bewegende markt – want alleen zo geraak je aan nieuwe klanten.

18 Feb 2016 Power BI voor iedereen door iedereen

Niemand minder dan Satya Nadella, de CEO van Microsoft himself, kondigde begin deze maand Power BI Publish to Web aan. Dat is een nieuwe functie in de analytische visualisatietool Power BI, waarmee je vanaf nu gemakkelijk online gegevens kunt delen. Het enige wat je daarvoor moet doen is in Power BI een link naar een rapport of visualisatie van je gegevens creëren.

16 Oct 2015 Stad Turnhout maakte een betaalbaar rapport over z’n personeelskost

Het stadsbestuur van Turnhout wilde weten hoeveel de werkelijke personeelskost verschilde van de gebudgetteerde kost. Zo kon het zijn toekomstige budgetten nog verfijnder opstellen en daarnaast ook sneller en correct rapporteren aan de gemeenteraad.

17 Sep 2015 Zien ze het BI-bos nog door de bomen bij Microsoft?

Deze vraag krijg ik de laatste tijd vaak voorgeschoteld van klanten die advies vragen welke richting ze uit moeten met hun Business Intelligence. Sinds de overname van Datazen en de grote update van Power BI afgelopen zomer beginnen alle puzzelstukjes in elkaar te vallen en kunnen we spreken van een compleet BI-platform dat zeer concurrentieel is ten opzichte van de andere spelers in de markt.

09 Aug 2016 Coaching

Data warehousing has been a hot topic for a couple of years now. In the beginning this was especially something for larger organisations with vast amounts of data spread all over the company. But over time we have seen a shift in type of organisations needing data warehouses solutions. Also smaller organisations are seeing the benefits of having data stored centrally and integrated.As we see a shift in type of organisation, we also see a shift in type of project.

16 Aug 2016 Power BI – Gateways to heaven

Although the Power BI gateways have been around for some time now, they weren't really easy to use. Depending on what you needed to do - refresh your data from the Power BI or use the live connection method - you had to install a different gateway. Next to the annoyance of having to install two separate software packages for your Power BI cloud solution, you would think there is no real issue. Wouldn't it be for the fact that you can't install both packages on the same machine.

27 Sep 2016 Don’t fool mama Natalie!

Let me tell you a true story about mama Natalie and her son Steve. Steve is a 14-year old, clever, young man, one of the cool guys at school. He always keeps his mobile phone at hand. As a matter of fact, he has a black belt in texting. Unfortunately, it seems that Steve’s texting behavior has been a bad influence on his grades at school. Mama Natalia suspects Steve of favoring his phone over his books. But how can she make Steve see the connection?

06 Dec 2016 Power BI on-premise

Although Microsoft always had said that bringing Power BI on-premise was on the road map, no clear time frame could be given. That was the case at least up until recently, when Microsoft announced the Technical Preview of the Power BI on-premise at SQLPass and Ignite.

20 Dec 2016 Power BI – From data to information

We live in a world where an enormous amount of data is available. But having access to the data is not the same as having insight. If we combine this data access with the right tools and a little bit of effort, you might be able to transform your data into information in no time.

03 Jan 2017 Power BI – Ranking with ‘Other’ group

Not so long ago a client asked me to rebuild a report of theirs in Power BI. It contained the top 5 countries ordered by number of visitors and … an Other group at the end.

07 Jan 2019 Update: De Tijdloze Power BI

Doe jij dat ook, op het einde van het jaar luisteren naar een top 100 of 1000? Bijna elke radiozender blikt terug met een muzieklijst van nummers van het voorbije jaar of telt af naar de grootse hit allertijden. Ondertussen hebben we ook de gegevens van de meest recente editie 2018 in ons Power BI rapport geladen.

10 Jan 2017 This was Microsoft BI in 2016

With the latest version of Microsoft SQL Server, we – BI folks – have a lot of new features to play with. Power BI has also made an enormous progress in 2016. Let’s take a look at some of the new, enhanced and/or interesting features of 2016.

07 Feb 2017 Social Science – Get Twitter data in Power BI

Ever wanted to do some analytics on tweets with a certain hashtag (#) or from a certain user (@)? Don’t look any further, there is a great tool called Microsoft Power BI. In this blog post, I’ll be explaining how to get twitter data into your Power BI. Let’s go!

14 Feb 2017 Social Science – Text mining on Twitter data

In my previous blog post I talked about how to get Twitter data into Power BI. This article will discuss how you can apply text mining on that data with some R code, together with some Power BI visuals.

14 Feb 2017 Romantiek met Power BI

Valentijn, je bent er voor of er tegen. Voorstander of niet, wij lieten ons met plezier meeslepen door de zeemzoete sfeer om nog eens wat hits in Power BI te stoppen.

21 Feb 2017 SQL Spot – Part 1

It has been going fast in 2016 for Microsoft BI. If we continue to move on like this, we’re in for a treat in 2017. I want to share some interesting articles, which crossed my path in the past month.

21 Mar 2017 The endless possibilities of Power BI, that’s what makes us happy

We’ve already demonstrated once or twice that with Power BI, you can do much more than just make a simple analysis of your company data. To us, possibilities are truly endless, as long as you do some creative thinking. And today is no different.

30 Oct 2017 Don’t be afraid to visualise complex business processes

In Business Intelligence we extract data from anywhere. Beside the technical structures that define how the data is stored, we also need to comprehend the business processes behind that structure. It’s all in the name, right?

20 Nov 2017 Cortana Intelligence in a Nutshell — Part 1

One of the first things we explain to our future customers, is what is available and what is possible with the Cortana Intelligence Suite. With following story we're discussing each product and we give a real-time usage example.

06 Dec 2017 Latest Power BI update: share your portal with guest users

Power BI's mission is crystal clear: extract crucial intelligence from data so companies can use it to grow or strengthen their business. The latest update to the software further amplifies this creed.

21 Feb 2018 There’s always an insight with Power BI: CONCATENATEX

Not so long ago, I was working with a client who had a specific Power BI request. They wanted to do a lookup of a column in another table, but if there were multiple hits, they wanted to display all the matching rows in the same cell. I came with a solution using ConcentrateX.

02 Mar 2018 World Cup Russia dashboard in Power BI: importing the teams from multiple web pages

While working on our World Cup dashboard my colleague Philippe Van Rillaer and I wanted to import data from tables spread out over multiple Wikipedia pages. With Power BI of course...

27 Jun 2018 World Cup Russia: Discover our Power BI dashboard yourself

You may have seen it pop up throughout our blogs and webinars in the past few months: the World Cup 2018 in Russia! Philippe Van Rillaer and I created a dashboard in Power BI about the historical results of previous World Cups, as well as results of the qualifiers for this year’s World Cup, the current teams that qualified, etc.

28 Nov 2018 How to Automatically add measures to Power BI

Some time ago I wrote a blogpost to retrieve all the measures from your tabular cube or from your open Power BI files. I made a simple addition to this blog, enjoy! And don't forget to watch the how-to video.

09 Jan 2019 Power BI and Python: scraping De Tijdloze 100 website

As you might know, Python is now available as a preview feature in Power BI. I used it to complete the data in our Power BI dashboard of the radio show "The Tijdloze 100". The data was mostly coming from a web-page, but in the latest edition all data was not available for Power BI.

23 Jan 2019 How To videos: Power BI and Python (part I & II)

Python is a great addition to the Power BI family by providing you the ability to perform quick data transformation or plot cool data visualizations. Our Power BI wizard Ken Faes gives you an introduction in setting up Python in Power BI...