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.