Data Community Meetup: Women in Data Evening - Mar 2018

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/

---

SESSION #2: Databases: On-premise to the Cloud
by Dilini Serasinghe, Senior Technical Lead, TIQRI
and Hansamali Gamage, Senior Software Engineer, TIQRI

These days, everything from A to Z is accelerated towards the cloud. So are traditional databases. Database as a service (DBaaS) is offered via a variety of relational and NoSQL databases. Their applications, however are among the hot topics in the tech world. When you migrate a traditional database to the cloud, would you choose relational or NoSQL? Join this session as Dilini and Hansamali explore how a single data set can be perceived from both Relational (Azure SQL Database) and NoSQL (Azure Cosmos DB) viewpoints and see the considerations and processes for choosing the database type, migrating and implementing a database on Azure.

About Dilini
Dilini is a Senior Tech Lead at Tiqri. She is backed by 14+ years of experience working in.NET technology stack. A data science research enthusiast and have published her work at international conferences.
LinkedIn: www.linkedin.com/in/dilini-serasinghe-aab2162b
Twitter: twitter.com/dilinisera
Blog: www.medium.com/@dilini

About Hansamali
Hansamali is an MVP in Visual Studio and Development Technologies. She has 5+ years of experience in. NET, ASP.NET, .NET Core and Azure services. She is a frequent speaker at various local and global events and an active writer on Microsoft Tech Net forum.
LinkedIn: www.linkedin.com/in/hansamali-gamage-37777a50
Twitter: www.twitter.com/hansamaligamage
Blog: hansamaligamage.blogspot.com