In the age of data-driven decision-making, organizations require powerful tools to transform raw data into actionable insights. Microsoft’s Power BI has become a go-to solution for businesses looking to leverage data visualization and business intelligence capabilities. With continuous updates and improvements, Power BI offers a plethora of essential features to …
Read More »Recent Posts
Revolutionize Your Data Analytics with Power BI’s May 2023 Update: What to Expect?
2023: New Features and Enhancements In May 2023, Microsoft announced a series of updates and new features to its Power BI platform, aiming to improve user experience, accessibility, and performance. As a skilled blog writer, I will provide you with a comprehensive summary of these updates, covering all areas from …
Read More »Top 5 ETL Tools of 2023: Which Ones Should Your Business Be Using?
As data continues to become a more valuable asset for businesses, the need for effective and efficient Extract, Transform, and Load (ETL) tools has only increased. With a wide variety of ETL tools on the market, it can be difficult to determine which one is the best fit for your …
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 »Power BI Premium Embedded vs PRO vs FREE
At the moment, Microsoft has three versions of Power BI you can use. The Power BI Free, Power BI Pro and Power BI Premium. The Power BI Premium is a replacement of the Power BI Embedded version. This article will highlight the differences between the three versions of Power BI.
Read More »Free e-book: Introducing Microsoft Power BI
Get started quickly with Microsoft Power BI! Experts Alberto Ferrari and Marco Russo will help you bring your data to life, transforming your company’s data into rich visuals for you to collect and organize, allowing you to focus on what matters most to you. Stay in the know, spot trends …
Read More »SQL 2016 Database Mail not working
I was struggling with my SQL Server 2016 database mail after installing the Free Developer edition of Sql Server 2016. My server contains Microsoft Windows Server 2012 and I enabled the SMTP server. The SMTP server (local) was working fine but database mail refuses to work!
Read More »Postcodetabel van Nederlands + SQL Script
Inleiding De Nederlandse Postcodetabel bevat informatie over alle postcodes die in Nederland bekend zijn. Dit is erg handig als je meer informatie wilt over een bepaalde postcode zoals een geografische locatie of de plaats die bij een postcode hoort. We laten in dit artikel zien wat je met deze postcodes …
Read More »Power BI Publish to the web
See how easy it is to add your reports to your public websites and blogs with Power BI Publish to web. Now you can craft your data story and tell it online in minutes. Here’s how!
Read More »Setup sp_send_dbmail attachment included!
I need to setup a weekly report for one of my customers. The report can be manually run by executing a T-SQL statement and copy the result to Excel. After copying, it’s emailed to the client. By using sp_send_dbmail attachment options, you can automate this process.
Read More »Gratis E-Book SQL Server 2016
De tweede preview van Microsoft SQL Server 2016 “Mission-Critical Applications, Deeper Insights, Hyperscale Cloud” is te downloaden.
Read More »Data Warehouse – Waarom heb je er een nodig?
Het woord “Data Warehouse” klinkt behoorlijk spannend! Het doet vermoeden dat het een ingewikkeld gebeuren is, een soort pakhuis of verzameling met data. Eigenlijk is een data warehouse een database net als alle andere “gewone databases”. Men noemt het een “warehouse” omdat je er meer in bewaart dan in een …
Read More »Linked Server – Why and how use them!
A linked server is used to connect to another (remote) database or file (Xls, CVX) using SQL Server Management Studio (SSMS) and discover the data or objects. You can write SQL queries from your SSMS directly on a database on another machine. In Oracle they call it DBLinks (Database Links).
Read More »Cool ASCII big text generator
I found this cool ascii text generator website today. You can use it to generate cool banners to use in your documentation or code comments.
Read More »Calculate Age in SQL Server
In my daily work, I need to calculate and report the age of people very often. There are a couple of ways to calculate the age and will give you the right result. I do not recommend a SQL Function to to this. SQL Functions are performing very slow, especially …
Read More »-
Klantgegevens verrijken met de postcodetabel
In een vorig artikel bespraken we kort wat je met de postcodetabel van Nederland kunt doen. Een …
Read More » -
SQL Server Optimize Insert Performance In 5 Steps
-
SQL 2016 Database Mail not working
-
Postcodetabel van Nederlands + SQL Script
-
Gratis E-Book SQL Server 2016
-
T-TSQL – Create 4 week Moving Total
This article will offer you a way to calculate a 4 week moving total in …
Read More » -
Create a KPI box with an image / text overlap in SSRS
-
SSRS – Subscriptions in pending status
-
Prevent Divide by Zero in SSRS
-
How to Refresh Reporting Services Cache?
-
Microsoft Azure, Amazon AWS, and Google Cloud: The Titans of the Cloud
The cloud computing landscape has never been more competitive. Among the leading contenders in the …
Read More » -
Introducing Data Factory in Microsoft Fabric
-
Understanding Lakehouse, Warehouse, and Datamart: The Differences Between the Three Fabric Objects
-
The Correspondence Between Excel Formulas and DAX Formulas: Why Financial Analysts Should Learn DAX
-
The Future of Business Intelligence: Trends and Innovations in 2023