With over 20 years of experience in automation Sander van der Hoeff knows his way around the ICT business. Since 2000 Sander is specialized in business intelligence and data warehousing using the full SQLServer Stack.

In 2012 Sander founded his own BI-company: Du Sabot.

Nowadays Sander spends his time on several BI- and DWH-projects as an independent professional. Sander combines deep technical knowledge with the capability to explain difficult BI- and DWH-concepts to non-technical people.
Sander van der Hoeff has submitted 4 sessions for SQLBits 2020, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

PowerQuery is often used in combination with PowerBI. But what if the only tool you can use is Excel and data is not in databases. What are the pitfalls in this scenario?
testing databases focus mostly on Stored Procedures. Datawarehouses and reporting solutions uses databases in a much different way. Testing is as important as important but less simple.
Where to start when your SQLServer is under pressure? There are a lot of free tools and scripts available online.These tools will help you decide whether you can fix yourself or you need specialized DBA to solve it.
Bi developpers are using Visual Studio for SSAS, SSRS and SSIS development all the time,but tend to forget to use Visual studio for there database development. For CI/CD you really need a database project in VS

Sessions

Previous Sessions

Pivot tables are very powerfull for analysing data, but a bit difficult to learn. This session will explain all the features to unlock the real power of the PivotTable
Sander_van_der_Hoeff.jpg