The month of March comes to you with an all-female lineup. This is our stand to have more women be part of and lead our community along with the guys. We have two sessions lined up that covers the following: #Azure #SSIS #BIML #AzureSQLDB #CosmosDB #SQLServer #WIT
SESSION #1: BIML: ETL to the next level
by Samudra Bandaranayake, Engineer – BI/Data Analytics, Ayra Analytics
With Microsoft SQL Server Integration Services (SSIS), you can build powerful and flexible packages to manage your ETL solutions. However, every ETL project has some repetitive tasks. With SSIS out-of-the-box, you are forced to create multiple individual packages which is very time consuming due to the lack of easy code reuse. In a typical BI project, the ETL implementation can easily take up 60% of the project time, so it is beneficial if the development time of similar SSIS packages can be cut down. With BIML (Business Intelligence Markup Language) you can easily generate SSIS packages effectively apply code reuse, templates and patterns. This session will give a brief introduction on how to use BIML to develop Microsoft BI Projects faster, more consistently, and more reliably than you ever thought possible.
About Samudra:
Samudra comes with a Degree in ICT from the University of Rajarata. Samudra has been working with business intelligence for 4+ years; with beginnings in Oracle, her expertise now centers on Microsoft technologies. Her passion lies in data warehousing and business intelligence.
Twitter: www.twitter.com/_samudrab
Linked In: www.linkedin.com/in/samudrabandaranayake
Blog: samudrabandaranayake.wordpress.com/
