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 !
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.
- 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
Basic SQL knowledge (select, from, where, join types, group by, having, union, update, insert, delete …)
- 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.
€600/day
Ask for more details: academy@credon.eu
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.