Practical Data Warehousing with SQL Server

Duration

3 days

Location

Online, Tessenderlo or Aartselaar

Language

Dutch or English

Difficulty

Advanced


Hey you! Are you responsible for implementing a BI solution where SQL Server acts as a centralized data provider? Are you looking for hands-on tips about BI data models and their typical repository structure? Do you feel limited by Power Query? And are you looking for a more powerful ETL tool? Then stop looking, we got you covered!


What is it?

In our new SQL Server Data Warehouse Training you will learn how to implement a practical and professional Data Warehouse solution from A to Z. We do this by using the Kimball data modeling principles for BI solutions.


You will get better at:
  • Kimball data modeling principles for BI solutions
  • Setting up Fact and Dimension tables as a starting point for your Visual BI Solution
  • The T-SQL language and Stored Procedures to set up (ETL) dataflows. (You’ll discover that you don’t need to be a T-SQL expert to build a professional Data Warehouse.)
  • Plugging the developed data model into an insightful dashboard during a Power BI primer leveraging the learned modeling techniques

What you must have:
  • A basic SQL knowledge (Select, Where, Group by, Join types, Union, …)
    Nice to have:
  • The course is easier to follow if you already have some basic Power BI knowledge, or have are familiar with another BI tool.

Do you fit our brief? Then let’s get going!


Price

€600/day + 1 hour free follow-up with your trainer!

Ask for more details: academy@credon.eu


Teacher

This workshop will be given by Gerrit Van Even. Our technical expert when it comes to data and BI. He’s been immersing himself in the SQL language and is a true data warehouse superhero.


Practical
  • Workshops start at 9h and are finished around 17h.
  • Credon provides sandwiches for lunch.
  • Dijkstraat 6, 2630 Aartselaar or Industrieweg 116, 3980 Tessenderlo
  • Participants have to bring their own laptop.

Workshops take place at a minimum of three subscribers.


Contact

Questions about this Workshop?

Contact us at: +32 13 35 37 10 or academy@credon.eu

Request more information

This workshop is on demand. Submit this form for more information.

Billing Details

Register

For those who want to get their hands dirty and dig through their data gold.

Learn from the best in the field

World-class BI workshops

Let's Chat!

+32 13 35 37 10
Or fill in the form to contact us
Submit

Kris Adant

BI Trainer for 12 years

What do you love about BI?
BI makes people happy. In our job, we see a quick and direct positive impact on what we’ve created at all levels of the company. Putting a smile on people’ faces when they realise that the new BI system solves a frustration is what makes me happy.

What do you love about teaching?
Seeing people get enthusiastic from understanding something new. I also learn a lot from the people who follow the course. In this way, both the student and the teacher stays up to data.

Jeroen Beunckens

BI Trainer for 2 years

What do you love about BI?
To give people the ability to trust their data and therefore take well-informed decisions. 

What do you love about teaching?
Teaching a person a new  skill! The skill to create your own visualisations and gain insights, you never knew you had. 

Gerrit Van Even

BI Trainer for 4 years

What do you love about BI?
Ever since I was a child, I’ve had something with lists. I made neat overviews of my comic strip collection, my music collection, etc. I then combined these to find out which other comics would suit my preferences. My child’s brain was already triggered by data. And not much has changed since then; only more available data and better tools to do something useful with it.

What do you love about teaching?
Explaining complex thought patterns in an understandable way is like kneading a multitude of data streams into an accessible story that leads to insights. Witnessing the Aha-erlebnis of the students is simply priceless!

Sajjad Malik

BI Trainer for 9 years

What do you love about BI?
Using technology to generate insights that allow me to make factual decisions. I love finally being able to read data.

What do you love about teaching?
Being able to spread the “good word” of data literacy. I love seeing people’s reactions when they, finally, figure out how powerful analytics truly are.