Weirdly formatted files, we’ve all had to import them into our reports at some point. Luckily, Power BI has new option that might make our lives easier: import text/CSV by example. We’ll show you how to use it in this blog.
Splitting datasets and reports into separate PBIX files is a very common way of managing Power BI reports. But dividing sets and reports can result in a headache or two. Let our blog be your Power BI painkiller.
Al zolang Kohera bestaat, staat Microsoft als leider in de rechterbovenhoek van Gartner’s Magic Quadrant voor Analytics en BI Platformen. Net daarom hebben we bij Kohera een bewuste keuze gemaakt voor Microsoft Power BI. Het is zowaar de cola van de BI-tools.
Deze eindejaarsperiode is er een waarbij heel wat tradities gesneuveld zijn. Gezellig samenzijn met de hele familie of lekker gaan eten op restaurant zitten er niet in dit jaar. Gelukkig zijn er ook nog zekerheden, zoals De Tijdloze van StuBru, die ook dit jaar voor muzikaal vertier zorgt in de laatste dagen van het jaar. En daarbij hoort natuurlijk ook onze voorspelling.
A client asked if we could provide a simple form of monitoring on a part of a provided solution. For this particular source, our client asked us to send a simple email with record counts to a mailing list. No problem! Let's get to work
Allocating budgets on a different level is not easy to manage in DAX. It was (and still is) a DAX struggle for me. This blog post will guide you through the different steps I took to easily manage the different granularities (and write easy DAX afterwards) by allocating budget on day level using Power Query.
Some of our customers want us to import their data from a standard on-premises or cloud-based (Azure) SQL-database, others want us to import their data from a REST API. If ever, you’ll have to import data from a REST API, you’ll surely encounter some obstacles.
In a previous blogpost, we already explained how to make a date table in Power BI with DAX. Besides the dates you can add extra properties for each date: year, month-names, weekday-names,... But what about hours and minutes? In this blog and video, we'll show you how to create time tables in Power BI.
31 december was het zo ver, we zaten aan de radio gekluisterd om de Tijdloze op de voet te volgen. Op plaats 93 noteerden we onze eerste voltreffer en hoe dichter we bij de top 10 kwamen, hoe beter onze voorspelling . Negen van de tien nummers uit de top 10 hadden we voorspeld en drie hiervan hadden de voorspelde ranking.
Waar we vorige jaren begin januari in actie schoten, staken we nu reeds in december de handen uit de mouwen. Aan de hand van een predictieve analyse doen we een poging om De Tijdloze 2019 te voorspellen, niet enkel de top 3 maar de ganse lijst.
In our latest How To video, our BI wizard Frederik Aerts, integrates the data of his Fitbit into Microsoft Power BI. There are different ways to do it... Enjoy!!
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.
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.
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.
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...
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.
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.
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?
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.
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!
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.
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?
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.
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.
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.
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.
“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
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.
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.
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.
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.
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.
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.
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.
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?