Practical Data Warehousing with Microsoft Fabric

Duration

5 days

Location

Tessenderlo

Language

Dutch or English

Difficulty

Advanced


Hey you, are you responsible for implementing a BI solution that is future proof and allows for indefinite scaling ? Do you recognize the qualities of Power BI as a state of the art reporting tool but feel limited by Power Query’s data transformation capabilities ? Do you want to upgrade from a reporting environment to an integrated data analytics platform and leverage your Sql and Power BI skills in the process ? Then stop looking, we got you covered !


What is it?

In our new training “Practical Data Warehousing with Microsoft Fabric” you will learn how to implement a practical and professional Data Warehouse solution from A to Z. We do this by following the Kimball dimensional data modeling principles for BI solutions. As our tool we use Fabric, a fully integrated technical environment which offers a comprehensive suite of services, including data integration, data engineering, data lake, data integration and data visualisation all in one place without the hassle of wiring everything together in a secure manner.


You will get better at:
  • Kimball dimensional data modeling principles for BI solutions
  • Designing low-code pipelines that streamline your data traffic
  • Writing SQL code in stored procedures for managing staged data transformations
  • Setting up fact and dimension tables that are released as datasets for self service analytics
  • Seamlessly plugging in Power BI on these datasets for creating insightful dashboards
  • Understanding the delta lake technology that underpins the Fabric suite and the benefits of OneLake

Must have:

Basic SQL knowledge (select, from, where, join types, group by, having, union, update, insert, delete …)


Nice to have:
The course is easier to follow if you already
  • have some basic Power BI knowledge,
  • are familiar with BI concepts,
  • have worked with data services in Azure like Data Factory, Data Lake, Synapse Analytics.

Price:

€600/day
Ask for more details: academy@credon.eu


Practical:

On location:

> Credon provides sandwiches for lunch.
> Industrieweg 116, 3980 Tessenderlo
> Start at 9h and are finished around 17h.
> 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

Register here

Choose your start date.
*Multi-day workshops kick off on the chosen start date.

18/06/2024 09:00

22/06/2024 17:00
09/09/2024 09:00

13/09/2024 17:00
12/11/2024 09:00

16/11/2024 17:00

Billing Details

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

+32 13 35 37 10

Or fill in the form to contact us.

Steven Van Gansberghe

BI Trainer for 1 year

What do you love about BI?
Helping customers to create new insights in their own data and making their life easier.

 

What do you love about teaching?
Seeing people take off as they learned something new.

 

Gille Buyle

BI Trainer for 1 year

What do you love about BI?
The ability to create order among the chaos that a data environment can be.

What do you love about teaching?
Teaching allows me to share my knowledge and improve my own.

Elias Vandendriessche

BI Trainer for 1 year

What do you love about BI?
To build a dashboard with meaningful insights for your end-user to enjoy.

What do you love about teaching?
I love to see the appreciation/expression on the attendees faces and it keeps my knowledge up-to-data.

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.