In this hands-on / bring your own laptop pre-con, Rasmus will show how you can take your ETL to the next level. You will go from “Zero to BIML to BIMLScript” in the duration of the day. That means, that leaving the pre-con, you will never ever again have to go over hundreds of packages to change a datatype or add a column, all you’ll need to do, is to change your meta-data and you are home free.
As our meta-data repository, we will use SQL Servers built-in Master Data Services. You will be given a thorough introduction to this component and learn how to use and administer it.
Besides getting a working knowledge of BIML AND MDS, and become able to use that in your ETL development, you will also get an overview of, and get to work with, the following advanced ETL concepts:
- Early arriving facts
- Slowly Changing Dimensions (SCD) with script task
- Least interdependent structure
- Change Data Capture (CDC)
At the end of the day, this combination will not only make you able to build the best ETL structure possible, but do so meta-driven with BIML.
As this is a bring your own laptop invitation, we will build the solution together, and you will have a working BIML model, that you have built yourselves, and understands at the end of the day. Therefore; after this pre-con, you can go straight to work, and start implementing your new BIML meta-data framework.
||Friday 11th September
||300 – Normal (attendees may require a working knowledge)
||BI and ETL developers who hate repetitive work
||Rasmus Reinholdt Nielsen (blog|twitter)
||Ranging from £100.00 (Super-Early Bird) to £140.00 (Late Bird) + booking fee + VAT
||Cambridge City Hotel, Downing St, Cambridge. England CB2 3DT.
||You should have a working knowledge about SSIS and general ETL concepts to get the most out of the day, but no prior knowledge about BIML is required, we will start from scratch.
||This is a hands-on / bring your laptop pre-con, so attendants are supposed to bring a laptop with SSMS, SSDT-BI / Visual Studio and BIDSHelper to get the most out of it.
Rasmus is the Data Warehouse Architect at UNOPS, the implementation arm of the UN, based in Copenhagen, Denmark. He has worked with Microsoft BI since 2005 both as a developer and architect, building large solutions on every release from SQL Server 2005 and on-wards.
Rasmus is a MSCE in SQL Server on both the Data platform & BI, and a long time speaker at SQLSaturdays, PASS SQLRally Nordic and SQLBits. He also co-organizes SQLSaturday Copenhagen.