SQLBlog Nederland Business Intelligence & Datawarehousing
Introduction Microsoft Power BI is a suite of business analytics tools that enables organizations to analyze data and share insights. Through its comprehensive dashboards, interactive reports, and compelling visualizations, businesses can transform raw data into meaningful information to drive strategic decisions. Industry leaders across various sectors are harnessing the power …
Read More »From Excel to Power BI: Transitioning to Advanced Analytics
From Excel to Power BI: Transitioning to Advanced Analytics Over the past few decades, Excel has firmly established itself as a cornerstone of data management, manipulation, and visualization. However, in the evolving world of data analytics, tools like Microsoft Power BI have emerged as powerful alternatives, offering advanced functionalities that …
Read More »Making Sense of Time: An Introduction to SQL Server’s DateTime Functions
Making Sense of Time: An Introduction to SQL Server’s DateTime Functions When it comes to managing and manipulating data, there’s no doubt that SQL Server is one of the most popular choices. One of the reasons for its popularity is the rich set of functions it provides for a variety …
Read More »Postcodetabellen in Databases en Power BI: Koppeling van Geografische Informatie voor Bedrijfsprestaties
In de wereld van gegevensanalyse en business intelligence is het essentieel om niet alleen cijfers en statistieken te begrijpen, maar ook de geografische context van die gegevens. Hier komt de postcodetabel in beeld. Een postcodetabel is een krachtige manier om geografische informatie, zoals postcodes, te koppelen aan andere bedrijfsprestaties, en …
Read More »Actieve bold buttons maken in Power BI
Wanneer je met buttons werkt in Power BI om bijvoorbeeld met bookmarks te werken is het handig om te zien welke “view” actief is in je rapport. Het lijkt een beetje op het principe van een web navigatie. Door de actieve bookmark op de button zichtbaar te maken wordt het …
Read More »Assign Power BI Pro license to External (Guest) user
Power BI Pro licentie kopen en koppelen aan een gebruiker.Korte handleiding hoe je een power bi pro licentie kunt kopen en koppelen aan een externe gebruiker. Stap 1:Deel het powerbi rapport alvast met de externe gebruiker. Nu wordt het account ook bekend in de azure directory. De link zou ik …
Read More »DAX Set column to Zero based on Username()
Klantgegevens verrijken met de postcodetabel
In een vorig artikel bespraken we kort wat je met de postcodetabel van Nederland kunt doen. Een postcodetabel kun je gebruiken om automatisch gegevens op je website in te vullen. Klantgegevens verrijken behoort ook tot de mogelijkheden. In dit artikel geven we voorbeelden vanuit Microsoft SQL Server 2016 hoe je klantgegevens kunt …
Read More »The 5 best examples Of Big Data in real life
One thing that is definitely taking the world by storm is Big Data. It is considered highly imperative for big to small industries and businesses. Companies have started to embrace the fact that big data is of utmost significance to them. WHAT IS BIG DATA AND WHAT ARE ITS BENEFITS? …
Read More »Top 3 of the Best ETL tools in the Market in 2017
It’s pretty hard to say “best etl tools” or “single best etl tools” to recommend. ETL-tools are very often closely related to the ERP or database product in use at an organization. As an IT professional, you just use what is provided at the company you are working for. This …
Read More »Power BI Update September 2017
Power BI Update September 2017 The new Microsoft Power BI Desktop version has been released. This month brings another collection of new and useful updates, from reporting to data connectivity. The following updates are new to Power BI Desktop this month: Report View: Drillthrough to another report page Ribbon chart …
Read More »How much does Microsoft Power BI cost?
How much does Microsoft Power BI cost? Microsoft Power BI offers three enterprise pricing plans to choose from, one of which can be acquired for free (1 GB data capacity limit). Power BI – Free The Free service is for personal use, according to Microsoft. It has capabilities similar to …
Read More »SQL Server Optimize Insert Performance In 5 Steps
SQL Server Optimize Insert Performance In 5 Steps. What are the possible reasons of the slow table insert? What are ways to identify this bottleneck without the execution plan? DROP ALL triggers and constraints on the table DROP ALL indexes (except the ones that are needed by the insert) Prevent page …
Read More »SSIS Maximum insert commit size
The default value of the Maximum insert commit size is 2147483647, the largest value a 4 byte INT will hold. This value is default set in SQL 2012+ but you need to set it manually in versions lower then 2012. In most cases you will leave this setting alone. The value of 0 indicates that all …
Read More »Cannot truncate table because it is being referenced by a FOREIGN KEY constraint
Using Microsoft SQL Server, you cannot truncate or drop a table with a foreign key constraint. For example, when you have a client table and a country table. When the client table has a foreign key constraint to the country table, you cannot truncate the country table in this situation …
Read More »