Hands On - ASP.NET Razor Pages

June 14, 2018

SLDF Meetup June 2018

You will be introduced to ASP.NET Core Razor Pages with demos. Razor Pages is a new aspect of ASP.NET Core MVC that makes coding page-focused scenarios easier and more productive.

ASP.NET Core 2.1: ActionResult<T> and HttpClientFactory

June 14, 2018

Sri Lanka Developer Forum Monthly Meetup - June, 2018

In this session, let's go through some couple of nice features introduced with ASP.NET Core 2.1 such as ActionResult<T> and HttpClientFactory.

Building a data warehouse using Microsoft SQL Server

June 08, 2018

Standard workshop with hands-on - Organized by CICRA

This is a 3-day workshop that focuses on traditional data warehousing with hands-on. This initially discusses building a logical data warehouse, physical on-premise data warehouse and ETL using Microsoft SQL Server. Then it discusses Analysis Services, focusing on Tabular Model creation.

Building a data warehouse using Microsoft Azure Services

24 May 2018, 25 May 2018, 30 May 2018, 31 May 2018

Organized for MAS Holdings

This is a 4-day workshop that focuses on traditional data warehousing and modern data warehousing hands-on. This initially discusses building a logical on-premise data warehouse, physical data warehouse and ETL using Microsoft SQL Server. Then it discusses modern data warehousing using Azure SQL Data Warehouse, Data Lake Store and Analytics, Data Factory and Analysis Services with hands-on.

Azure Data Lake Analytics: Leveraging the Modern Data Warehouse

May 26, 2018

SQLSaturday 712 - South Island NZ

What you feared has come upon you: You’ve been happily building business intelligence solutions the traditional way for years; Finally, the big data curse has caught up with you. Your organization wants to exploit their big data along with their day-to-day transactional data. You are now tasked with storing all this in one place and working your analytics magic on it. You start wondering how and w....See More

Analyzing Data with Power BI - 20778B

08 Apr 2018, 22 Apr 2018, 13 May 2018

Analyzing Data with Power BI - Organized by CICRA

This is a 3-day workshop on Microsoft Power BI, based on 20778B Microsoft official curriculum. Power BI as a BI Client tool, data loading and transformation, direct query and live connection, visualization, administration, security, developer API and Power BI mobile app were discussed.

Analyzing Data using Microsoft Power BI - Sri Lanka

10 May 2017, 11 May 2017

Standard workshop with hands-on

This is a 2-day workshop organized for Quantum Clothing Lanka (Pvt) Ltd, Sri Lanka on Power BI. This workshop focused on modern BI and discussed Power BI related items such as shaping and combining data, modeling data, visualization, and Power BI service.

Doing Machine Learning with Azure ML Studio - Indonesia

07 May 2018, 08 May 2018

Azure Partner Practice Enablement: Azure Machine Learning

This is a two-day PPE workshop organized by Microsoft. This focuses on Azure Machine Learning along with Machine Learning concepts, supervised and unsupervised models, demonstration and hands-on with regression, classification and clustering techniques.

Azure Data Services - Indonesia

03 May 2018, 04 May 2018

Azure Partner Practice Enablement: Azure Data Services

This is a two-day workshop organized as a PPE workshop by Microsoft. This workshop discusses Azure SQL Database, Azure SQL Data Warehouse, Azure Search, Azure Data Lake Analytics and Azure Cosmos DB along with demonstrations and hands-on.

Build planet scale serverless apps with Azure Cosmos DB & Azure Function Apps

April 21, 2018

Global Azure Bootcamp - 2018

This session mainly focuses on how to create a Azure Function App on top of Azure Cosmos DB Collection, And it's going to describe how to subscribe to a change in Cosmos DB collection and trigger necessary actions inside the Function App

Serverless Computing with Azure Functions

April 21, 2018

Global Azure Bootcamp 2018 - Colombo

Serverless Computing is a concept of completely taking away your concerns about maintaining servers, infrastructure, and operating systems. It acts in an event-driven manner, resources are allocated as soon as they’re required. In this session, let's go through Azure Functions, which is one of the features in Serverless Computing in Azure. There let’s see what Azure Functions really is and it’s ....See More

Azure Stack – Everything you need to know

April 21, 2018

Global Azure Bootcamp - 2018

Microsoft Azure Stack is the extended arm of bringing Azure capabilities to your datacenter. Learn what Azure Stack is, what challenges it solves, how you deploy, manage and operate a Azure Stack in your datacenter. Learn about the features and services you will get by offering Azure Stack to your customers and how you can build a true Hybrid Cloud experience. In this presentation Susantha Silva (....See More

Move Your On-Prem Data to a Lake in the Clouds

April 21, 2018

Global Azure Bootcamp 2018-Colombo

With the boom in data; the volume and its complexity, the trend is to move data to the cloud. Where and How do we do this? Azure gives you the answer. In this session, I will give you an introduction to Azure Data Lake and Azure Data Factory, and why they are good for the type of problem we are talking about. You will learn how large datasets can be stored on the cloud, and how you could transport....See More

Application Insights and Jupyter Notebook(Opensource) combo to analyze large scale data

April 21, 2018

Global Azure Bootcamp - 2018

Learn how to quickly instrument an existing .NET Core application. Monitor the metrics of your application and be warned when it doesn’t behave. Track application dependencies and performances. All of this, in less time it takes to cook dinner. During the session we will walk through the power of appinsights and see few demos with the usage of application insights and how effectively we can vis....See More

Your First PHP Application at Azure

April 21, 2018

Global Azure Bootcamp - 2018

Lets build a PHP application from ground up and deploy it to Azure with a MySQL database as the data storage. Yep we don't just stop there, lets have a look on Azure SDK for PHP and usage of Azure Table Service with PHP.

Move Your On-Prem Data to a Lake in the Clouds

April 21, 2018

Global Azure Bootcamp - 2018

With the boom in data; the volume and its complexity, the trend is to move data to the cloud. Where and How do we do this? Azure gives you the answer. In this session, I will give you an introduction to Azure Data Lake and Azure Data Factory, and why they are good for the type of problem we are talking about. You will learn how large datasets can be stored on the cloud, and how you could transport....See More

Blockchain Development on Azure

April 21, 2018

Global Azure Bootcamp 2018

This session will focus on creating Blockchain on Azure and deploy your own cryptocurrency. Then making a transaction from a client application.

Azure Site Recovery and Backup (IaaS)

April 21, 2018

Global Azure Bootcamp - 2018

The session will focus how you can protect critical data with Azure Site Recovery and Azure Backup for IaaS. Utilizing Azure Backup, you can enabling business continuity and protect server data against loss and corruption by facilitating scalable, secure backup to offsite cloud storage in Azure. In Azure Site Recovery (ASR), users have a powerful Azure-based service that provides disaster recover....See More

Azure for Machine Learning & Deep Learning

April 21, 2018

Global Azure Bootcamp - 2018

A session on Usability of Azure cloud in Machine Learning & Deep Learning based deployments.

Micro-services with Azure

April 21, 2018

Global Azure Bootcamp - 2018

Factoring an application into component parts is nothing new. Object orientation, software abstractions, and componentization is a familiar paradigm. Today, this factorization is mainly based on technology layers, with a tiered approach, consisting of back-end store, middle-tier business logic, and a front-end user interface (UI). But over the last few years, building distributed applications that....See More

SharePoint and Azure better together - how your SharePoint setup can benefit from Azure capabilities

April 21, 2018

Global Azure Bootcamp - 2018

Not every organization will move completely cloud due to obviously fair reasons. Despite the nature of your SharePoint deployment, Microsoft Azure can be a home or bridge to your IT infrastructure success. In this session we will find out how Azure can help to achieve the fundamental bench marks of any SharePoint deployment.

Modernize and Secure Your Digital Workspace

April 21, 2018

Global Azure Bootcamp 2018

The session discussed about features available in Azure that an organization can used to protect corporate data from unauthorized access, data breaches, etc.

Nothing to DevOps

April 19, 2018

April Meetup 2018 - MVPs in Action

We will discover, “Why DevOps matters?”, and see some quick demos on getting CI/CD pipelines implemented within matter of minutes targeting few different platforms to prove Any Language, Any Platform capability of Visual Studio family of tools.

JumpStart to Azure Functions

April 19, 2018

Sri Lanka Developer Forum Monthly Meetup - April, 2018

Azure Functions, which is one of the features in Azure’s Serverless Computing stack is a trending topic in the world of technology. In this session, let’s learn what Azure Functions really is and how we can create and work with Azure Functions using function editor in the Azure portal and of course our favorite tool, Microsoft Visual Studio.

Doing Machine Learning with Azure ML Studio - Thailand

March 29, 2018

Azure Partner Practice Enablement: Azure Machine Learning

This is a two-day PPE workshop organized by Microsoft. This focuses on Azure Machine Learning along with Machine Learning concepts, supervised and unsupervised models, demonstration and hands-on with regression, classification and clustering techniques.

Why DevOps Matters?

March 29, 2018

Creative Tech Talks

DevOps is it just a another buzzword just that will fade away in time? Do we really need to adopt? What changes require for you to become a DevOps organization would be discussed in the aspect of Software Development, Testing and Business Operations. Let's understand how to do the right things in the right way using right tools.

Azure Data Services - Thailand

March 26, 2018

Standard workshop with demos and hands-on (PPE Workshop)

This is a two-day workshop organized as a PPE workshop by Microsoft. This workshop discusses Azure SQL Database, Azure SQL Data Warehouse, Azure Search, Azure Data Lake Analytics and Azure Cosmos DB along with demonstrations and hands-on.

Architecting Modern Web Applications with ASP.NET Core and Microsoft Azure.

March 22, 2018

Sri Lanka Developer Forum Meetup - March 2018

Lets have a look on how to architect a modern ASP.NET Core web application on Microsoft Azure. A full 2 hour session with examples.

Data Community Meetup: Women in Data Evening - Mar 2018

March 21, 2018

Data Community Meetup

Database as a service (DBaaS) is offered via a variety of relational and NoSQL databases. When you migrate a traditional database to the cloud, would you choose relational or NoSQL? 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 im....See More

Doing Machine Learning with Azure ML Studio - Philippine

March 21, 2018

Azure Partner Practice Enablement: Azure Machine Learning

This is a two-day PPE workshop organized by Microsoft. This focuses on Azure Machine Learning along with Machine Learning concepts, supervised and unsupervised models, demonstration and hands-on with regression, classification and clustering techniques.

Azure Data Services - Philippine

19 Mar 2018, 20 Mar 2018

Standard workshop with demos and hands-on (PPE Workshop)

This is a two-day workshop organized as a PPE workshop by Microsoft. This workshop discusses Azure SQL Database, Azure SQL Data Warehouse, Azure Search, Azure Data Lake Analytics and Azure Cosmos DB along with demonstrations and hands-on.

Azure Data Services - Sri Lanka

14 Mar 2018, 15 Mar 2018

Standard workshop with demos and hands-on (PPE Workshop)

This is a two-day workshop organized as a PPE workshop by Microsoft. This workshop discusses Azure SQL Database, Azure SQL Data Warehouse, Azure Search, Azure Data Lake Analytics and Azure Cosmos DB along with demonstrations and hands-on.

BI's a Journey, Not a Destination

March 10, 2018

DataCamp 2018

With analytics becoming a buzzword in the recent past, everyone seems to want it in their businesses. Known as business intelligence for a long time, it helps an organization’s various decision makers take better business decisions using the insights that is provided. However, the path to a successful business intelligence implementation was always hounded by failure – The main reason being that B....See More

Get Your Feet Wet with Machine Learning - DataCamp 2018 - Singapore

March 10, 2018

Data Camp 20-18 - Singapore

This 1 hour session is to learn what Machine Learning (ML) is, some history about it, and all the important key terms that go with it. We will then move to a demo driven learning of ML using Azure Machine Learning (Azure ML); what it is, an introduction to and a simple classification/regression demo, so that in the end you, will know how to get started with ML.

Create a document store on Azure Cosmos DB - Singapore

March 10, 2018

Data Camp - Singapore

This session will be doing in Data Camp Singapore. It focuses on Azure Cosmos DB and its main features including data partitioning, global distribution, fail over regions, scaling, pricing details and query performance. It shows how you can implement a shopping cart application as a hybrid solution with the use of Azure Document API

Making unstructured data analysis-ready using Data Lake Analytics - Singapore

March 10, 2018

Data Camp - Singapore

This session focuses on Azure Data Lake Analytics, prepared for DataCamp 2018 - Singapore. This sessions discusses Data Lake Analytics, its internal work, difference between Hadoop and ADLA and, how it can be used for processing text-heavy row-oriented unstructured files and images, along with demos.

Doing Machine Learning with Azure ML Studio - Singapore

08 Mar 2018, 09 Mar 2018

Standard workshop with demos and hands-on (PPE Workshop)

This is a two-day PPE workshop organized by Microsoft. This focuses on Azure Machine Learning along with Machine Learning concepts, supervised and unsupervised models, demonstration and hands-on with regression, classification and clustering techniques.

Azure Data Services - Singapore

01 Mar 2018, 02 Mar 2018

Standard workshop with demos and hands-on (PPE Workshop)

This is a two-day workshop organized as a PPE workshop by Microsoft. This workshop discusses Azure SQL Database, Azure SQL Data Warehouse, Azure Search, Azure Data Lake Analytics and Azure Cosmos DB along with demonstrations and hands-on.

Developing modern cloud applications using Microsoft Azure

February 22, 2018

CICRA Campus Tech Talks

This is a developer focused event. Will be looking at how to develop a cloud ready ASP.NET / ASP.NET Core application and deploy successfully to the Azure.

Get Your Feet Wet with Machine Learning

February 21, 2018

Sri Lanka Data Community Meetup - Feb 2018

This 1 hour session is to learn what Machine Learning (ML) is, some history about it, and all the important key terms that go with it. We will then move to a demo driven learning of ML using Azure Machine Learning (Azure ML); what it is, an introduction to and a simple classification/regression demo, so that in the end you, will know how to get started with ML.

Application Development with Azure

February 21, 2018

Tech Talk by voice club at Embla Software Innovations

In the presentation i am going to introduce App Services and SQL DB services to the software developers / engineers at Embla Software Innovations. Mainly i will demonstrating creating services / hosting an application on Azure and looking on application performance through insights. Lastly, introduction to cognitive services and how we can integrate services with application

Executing commands on IoT Device and Introduction to Cognitive Services

February 21, 2018

Microsoft Imagine Cup Awareness & Workshop

This session more on hands on development with communication between devices and IoT Hub. I will be demonstrating the connecting devices and execute commands in the device from remotely. Lastly, i will be introducing cognitive services to demonstrate that how many innovations we can do using Microsoft Services.

My first PHP Application in Azure.

February 08, 2018

Sri Lanka Developer Forum

In this session you will learn how to setup PHP, MySQL, Apache and Visual Studio Code in Ubuntu. And then develop your first PHP application using Visual Studio Code and test it under Ubuntu. Finally deploy your application as a Azure App Service using Visual Studio Code for Ubuntu.

Azure Services & Customer Needs

February 01, 2018

Microsoft Sales Academy - Sri Lanka

This session is for Microsoft Sales Partners to give them a better understanding about what are the Azure Services available and how these servers can be accommodate to solve customer needs / requirements . In this session main focus will be into Azure App Services, SQL DB Services, Insights, IoT & Cognitive Services.

Engineering Big Data using Microsoft Azure

01 Feb 2018, 02 Feb 2018, 03 Feb 2018

Organized By: dinesQL (Pvt) Ltd

Standard workshop with demos and hands-on

This three-day workshop discusses big data, related concepts and implementations using Microsoft Azure platform. Implementing Hadoop and HBase using HDInsight and processing data with Hive, Handling event streams with Stream Analytics, managing and processing data using Data Lake Analytics, maintaining and processing data with Azure Data Warehouse and automating data flow with Azure Data Factory a....See More

Cloud Computing with Azure

January 24, 2018

Openday on Cloud, IoT & Career guidance - Hosted by ESOFT Metro Campus

This session basically for freshers into Information Technology. In this session we covered the areas such as cloud computing, what is Azure, Internet Of Things & Cognitive Services.

Cloud Data Warehousing with Azure SQL Data Warehouse - Malaysia

January 13, 2018

SQLSaturday - Malaysia

This session is scheduled to SQLSaturday Malaysia and focuses on Cloud Data Warehousing - Azure SQL Data Warehouse and areas such as MPP architecture, data distribution, loading and accessing will be discussed.

Let's make a complex data set simple using Azure Cosmos DB - Malaysia

January 13, 2018

SQLSaturday - Malaysia

This session is done in SQLSaturday - Malaysia. It focuses on Azure Cosmos DB and its main features including data partitioning, global distribution, fail over regions, scaling, pricing details and query performance. It demonstrates how to design a document store with relationships and how to play with its queries to gain maximum performance

Azure Data Lake Analytics: Leveraging the Modern Data Warehouse

January 13, 2018

SQLSaturday #702

What you feared has come upon you: You’ve been happily building business intelligence solutions the traditional way for years; Finally, the big data curse has caught up with you. Your organization wants to exploit their big data along with their day-to-day transactional data. You are now tasked with storing all this in one place and working your analytics magic on it. You start wondering how and w....See More


Azure Data Lake: Data Warehousing of the Future

December 20, 2017

Data Community Meetup

The new age of data brings new problems. Apart from the need to store your organization's transactional data, you now need to store all sorts of other data that your organization collects. This big data along with your transactional data needs to be stored and processed appropriately for business intelligence needs. This cannot be done the way you were used to. But what if you don't have enough ha....See More

Introduction to Azure Data Lake Analytics - Sri Lanka

December 20, 2017

Data Community Meetup: Azure Data Lake Evening - Dec 2017

This session is prepared for Sri Lanka Data Community (SLDC) and completely based on ADLA. Here is an abstraction from detailed published: "........Allowing to store petabytes of data, get them processed while automatically parallelizing for the scale we need and use a simple language called U-SQL, make data warehousing and data processing much more simpler but powerful than what we have been used....See More

Designing and Implementing Big Data Analytics Solutions (70-475) - Vietnam

04 Dec 2017, 05 Dec 2017, 06 Dec 2017, 07 Dec 2017, 08 Dec 2017

Organized By: TechoFocus

Data camp - Vietnam - Organized by Techofocus

This workshop focuses on implementing big data solutions using various technologies including Microsoft Azure platform. This is a 40 hours workshop that includes demonstrations and hands-on. Big data concepts, Hadoop, Hive, HBase, Storm, Azure SQL and DW databases, HDInsight, Data Lake, Data Lake Analytics, Event Hub, IoT Hub, Stream Analytics and Data Factory are discussed with hands-on.

Analyzing data with Microsoft Power BI - Sri Lanka

22 Nov 2017, 23 Nov 2017, 24 Nov 2017

Standard workshop with demos and hands-on

This 24 hours instructor-led workshop provides participants the knowledge and skills to do BI all by themselves using Microsoft Power BI. Participants will learn about self-service business intelligence and how to get data from multiple data sources, create a data model, create interactive reports and dashboards and publish them for sharing.

Implementing a SQL Data Warehouse (20-767) - Singapore

06 Nov 2017, 07 Nov 2017, 08 Nov 2017, 09 Nov 2017, 10 Nov 2017

Organized By: TechnoFocus

Implementing a SQL data warehouse | Singapore | Bootcamp - Organized by Techofocus

This 40 hours instructor-led workshop, based on MS 20-767 course provides participants the knowledge and skills to implement a data warehouse using Microsoft Business Intelligence Product Suite. Participants will learn how to do the requirement gathering for DW/BI, build a relational data warehouse, implement an ETL solution and some additional services like DQS and MDS.

Analyzing data with Microsoft Power BI - Batch II

27 Sep 2017, 28 Sep 2017, 29 Sep 2017

Organized By: dinesQL (Pvt) Ltd.

Standard workshop with hands-on

This 24 hours instructor-led workshop provides participants the knowledge and skills to do BI all by themselves using Microsoft Power BI. Participants will learn about self-service business intelligence and how to get data from multiple data sources, create a data model, create interactive reports and dashboards and publish them for sharing. For more info: https://www.rateevent.com/banners/dinesQL....See More

Implementing a SQL Data Warehouse - Sri Lanka

03 Sep 2017, 10 Sep 2017, 17 Sep 2017

Organized By: dinesQL (Pvt) Ltd.

Standard workshop with hands-on and demos

This 24 hours instructor-led workshop provides participants the knowledge and skills to implement a data warehouse using Microsoft Business Intelligence Product Suite. Participants will learn how to do the requirement gathering for DW/BI, build a relational data warehouse, implement an ETL solution and build models.

Cloud Data Warehousing - Singapore

August 26, 2017

Organized By: Singapore UG

SQLSaturday Singapore - 2017

This session is focused on Cloud Data Warehousing - Azure SQL Data Warehouse and areas such as MPP architecture, data distribution, loading and accessing will be discussed.

Implementing a SQL Data Warehouse - Singapore

August 25, 2017

Organized By: Singapore UG

SQLSaturday Singapore - 2017

This 8 hours instructor-led workshop provides participants the knowledge and skills to implement a data warehouse using Microsoft Business Intelligence Product Suite. Participants will learn how to do the requirement gathering for DW/BI, build a relational data warehouse, implement an ETL solution and build models.

Cloud Data Warehousing

August 12, 2017

Organized By: SLDC

SQLSaturday 639 - Sri Lanka - 2017

This session is focused on Cloud Data Warehousing - Azure SQL Data Warehouse

SQL Server Performance Tuning Made Easy

August 11, 2017

Organized By: SLDC

SQLSaturday 639 - Sri Lanka - 2017 - Pre-Con

SQL Server Performance Tuning is still a mystery to many. Quite often even an experienced SQL Server DBA, often gets confused as to how to figure out where to start with this entire process. In this module we are going to learn about how to get started with SQL Server Performance Tuning. We will go over some very important scripts which will help us to get started with the SQL Server Performance T....See More

Analytics and Power BI with R

August 11, 2017

Organized By: SLDC

SQLSaturday 639 - Sri Lanka - 2017 - Pre-Con

You keep hearing about machine learning and R quite often. R has become one of the languages for data analysis and machine learning; which makes the need for learning it all the more important. Moreover, Microsoft introduced R Server as a comprehensive platform for using machine learning and R functionality within data analysis tools such as SQL Server 2016 and Power BI. In this one day workshop, ....See More

Advanced Power BI Modeling and DAX

August 11, 2017

Organized By: SLDC

SQLSaturday 639 - Sri Lanka - 2017 - Pre-Con

This course is module 3 of the Power BI from Rookie to Rock Star course. In this module, you will learn DAX from zero to hero. You will learn how to design the best model in Power BI with relationships, considering formatting and data types. You will learn about DAX which is the data modeling expression language in Power BI (and also in SSAS Tabular and PowerPivot). You will learn from Simple DAX ....See More

Analyzing data with Microsoft Power BI - [Sri Lanka]

19 Jul 2017, 20 Jul 2017

Standard workshop with hands-on

This 16 hours instructor-led workshop provides participants the knowledge and skills to do BI all by themselves using Microsoft Power BI. Participants will learn about self-service business intelligence and how to get data from multiple data sources, create a data model, create interactive reports and dashboards and publish them for sharing. For more info: http://www.ratespeaker.net/dineshpriya....See More

Power BI - A Look at Security

June 27, 2017

Sri Lankan Data Community Meetup - Jun 2017

Power BI has caught on very well as a visualization tool, a BI tool and in a lot of cases as a BI solution itself. It can connect to a plethora of sources, helps data analysts build their own data models. With all this comes the requirement to secure the data, and provide access to different levels of users. Join this session as we take a look at methods of securing and providing access on Power B....See More

Microsoft Power BI - 20778A - Workshop III

May 30, 2017

Standard workshop with Hands-On and Demos

16 hours workshop on Microsoft Power BI based on 20778A MOC. This workshop discusses Self-Service BI, Power BI Desktop and Online Service, Connecting to multiple sources (both online and local), Transformation and managing/maintaining Power BI Online Service, etc. with demos and hands-on.

Microsoft Power BI - 20778A - Workshop II

May 09, 2017

Standard workshop with Hands-On and Demos

16 hours workshop on Microsoft Power BI based on 20778A MOC. This workshop discusses Self-Service BI, Power BI Desktop and Online Service, Connecting to multiple sources (both online and local), Transformation and managing/maintaining Power BI Online Service, etc. with demos and hands-on.

Microsoft Power BI - 20778A - Workshop I

April 27, 2017

Standard workshop with Hands-On and Demos

24 hours workshop on Microsoft Power BI based on 20778A MOC. This workshop discusses Self-Service BI, Power BI Desktop and Online Service, Connecting to multiple sources (both online and local), Transformation and managing/maintaining Power BI Online Service.

Processing Unstructured Data - The Microsoft Way - UVA

April 01, 2017

UWU Big Data Workshop

Guest lecture on Big Data for students at Uva Wellassa University (http://www.uwu.ac.lk/ ), This session focuses on concepts related to Big Data, Hadoop, Hadoop Sub-Project: Hive and how to use them using Microsoft Azure. This workshop is organized as a special Big Data meetup.

VS 2017 DevOps with VSTS

March 30, 2017

VS 2017 Community Launch

Explore VS 2017 capability of enabling continuous delivery with VS Team Services to push docker enabled .NET Core web applications to Azure container registry etc. Continuous delivery extensions for VS 2017 enable automating creation of builds & deployment pipelines and monitoring continuous integration builds via VS.

Microsoft Power BI - SriLankan Airlines Ltd

March 28, 2017

Standard workshop with Hands-On and Demos

16 hours workshop on Microsoft Power BI. This workshop was organized for IT professionals in SriLankan Airlines Ltd (http://www.srilankan.com/ ) and discussed about Modern Business Intelligence, Self-Service BI and how to use Power BI for implementing a BI solution. Many area related Power BI such as Online Service, Desktop tool, Connection with multiple sources, DAX, Social media data analysis an....See More

Developing Databases

March 22, 2017

Guest Lecture

2 hours Guest Lecture on database development for students in General Sir John Kotelawala Defence University (KDU) (http://www.kdu.ac.lk/ ), Sri Lanka. This session focuses on types of databases, modern way of implementing them on both on-premises and cloud, consideration on security and data warehousing.

Administering SQL Server Environments - IFS - Sri Lanka

March 20, 2017

Standard workshop with Hands-On and Demos

40 hours workshop on SQL Server Administration for IFS (http://www.ifsworld.com/lk/ ) team. This workshop focuses on installing and administering SQL Server instances, creating and maintaining databases, automating administration tasks, performance tuning and Azure SQL Databases. Specific items are discussed in details with demos and hands-on.

Developing SQL Server Databases

March 19, 2017

Standard workshop with Hands-On and Demos

40 hours workshop organized for professional from multiple companies in Sri Lanka. Developing both disk and memory-optimized tables, objects such as stored procedures and functions, and handling XML, Spatial data, concurrency and many more are discussed with hands-on.

Building a Data Warehouse and Business Intelligence Solution

March 18, 2017

Standard workshop with Hands-On and Demos

24 hours workshop organized for VirtusaPolaris (http://www.virtusapolaris.com/ ) DWBI team. This workshop discusses requirement gather processing related to BI implementation, making a bus matrix, logical and physical DW (both relational and OLAP) using Microsoft SQL Server 2016 using modern technologies and finally how to consume it using Power BI and SSRS.

Processing unstructured data

March 11, 2017

DataCamp 2017 - Singapore

Session on Business Intelligence and Big Data for DataCamp 2017, Singapore. This session focuses on processing unstructured data using Microsoft technologies such as Integration Services and Azure HDInsight. Introduction on implementations of traditional DW/BI, modern DW/BI and Big Data processing with Hadoop/Hive with the support of Azure HDInsight and SSIS are discussed along with demos.

Silent Secrets of Security

March 11, 2017

DataCamp 2017 - Singapore

Topic Title: Silenced Secrets of Security In this session, we will discuss some silent salient concepts of SQL Server Security which have been less spoken about. 1) Service Accounts 2) SSPI Handshake 3) ACLs We will explore Service Accounts and how progressively they have been improved from previous versions (SQL Server 2000) to the most recent SQL Server 2016. How SQL Server utilizes ....See More

Business Intelligence

March 09, 2017

Guest Lecture - UCSC Year 3 Students

Guest lecture on business intelligence for third year students of the University of Colombo School of Computing. This lecture introduces the students to business intelligence and data analytics, takes them through what one needs in order to do BI and Analytics. This is then followed by a demo on self-service business intelligence using Microsoft Power BI, in order to showcase to the students how e....See More

Business Intelligence

March 09, 2017

Guest Lecture - UCSC Year 3 Students

Guest lecture on business intelligence for third year students of the University of Colombo School of Computing. This lecture introduces the students to business intelligence and data analytics, takes them through what one needs in order to do BI and Analytics. This is then followed by a demo on self-service business intelligence using Microsoft Power BI, in order to showcase to the students how e....See More

Business Intelligence

March 06, 2017

Guest Lecture - SLIIT Year 3 Semester 1 SE-Weekday Batch

Guest lecture on business intelligence for the software engineering degree of the year 3 semester 1 weekday batch of SLIIT, Malabe. This lecture introduces the students to business intelligence and data analytics. It walks the students through the history, concepts and new concepts in business intelligence. This is then followed by a demo on self-service business intelligence using Microsoft Pow....See More

Business Intelligence

March 05, 2017

Guest Lecture: SLIIT Year 3 Semester 1 SE-Weekend Batch

Guest lecture on business intelligence for the software engineering degree of the year 3 semester 1 weekend batch of SLIIT, Malabe. This lecture introduces the students to business intelligence and data analytics. It walks the students through the history, concepts and new concepts in business intelligence. This is then followed by a demo on self-service business intelligence using Microsoft Pow....See More

Introduction to SQL Server 2016

February 22, 2017

Standard workshop

This 8 hours workshop was organized for Proavos (http://www.proavos.com/) for discussing key components of SQL Server 2016. Database design, TSQL, Table design, Stored Procedures, In-Memory OLTP tables and some of 2016 new features were explored in details along with best practices and key considerations.

R in SQL Server 2016

February 21, 2017

SQL Server Sri Lanka User Group

R, the popular statistical programming language is used for statistical computing and analysis, data mining and machine learning, while being a great tool for graphics and data visualization. R is now available within SQL Server 2016, making it accessible for more flexible data analysis, making sharing data insights much easier, and overcoming memory (RAM) limitations. Join this session to learn h....See More

Getting Ready for Azure SQL Database

January 31, 2017

SQL Server Sri Lanka User Group [SS SSLUG]

This session is organized for SS SLUG in Sri Lanka which is monthly meet up on Microsoft SQL Server. [Session Details]. Everyone says that it is high time to move our databases to cloud but should we? Can we just move it and continue the business as we used to? It is always better to make sure that the cloud-database satisfies all our business requirements before moving it from on-premises to cl....See More

BI is a Journey, Not a Destination

January 31, 2017

SS SLUG January 2017 Meetup

This session is from the SS SLUG January 2017 Meetup Too many times have we started business intelligence as one big project, spanning months and months, and finally going on to years; and by the time you know it, you are over budget, people have moved on, and you don't want your medieval solution any more. Rather, a business intelligence solution needs to be looked at as a journey. Join Go....See More

Processing data using Apache Hive

January 24, 2017

Colombo Big Data Meetup

This speech is organized by Colombo Big Data Meetup ( https://www.meetup.com/lkbigdata ) and it is focused on Apache Hive. Speech Details: Previously-ignored-data has suddenly become the most important part of the business and it needs to be processed just as the way we process standard, relational data. Yes, it is called as BigData, unstructured data or semi-structured data. Being a database ....See More

Data Warehousing / Business Intelligence with Microsoft SQL Server 2016

January 06, 2017

This 4-hours session was done to Totalamber (http://www.totalamber.com ) on DW/BI. The session was focused on concepts related to data warehousing, logical design based on Kimbal's concepts and physical design using Microsoft SQL Server 2016..

SQL Server Administrations

December 16, 2016

Standard SQL Server Training

This 4-days training was done based on Database Administration with SQL Server 2014. Database creation, administration, backup & restore strategies and maintenance were discussed in details with hands-on.

Administering SQL Server 2016

December 12, 2016

Standard Microsoft SQL Server Administration Course

This 3-days workshop was organized to MIT ( https://www.millenniumit.com ), Sri Lanka, focusing on administration of Microsoft SQL Server 2016 Converting key areas related to Administration.

Developing SQL Data Models with SQL Server 2016

November 03, 2016

Standard Microsoft SQL Server Data Model Course

This was a 3-days workshop organized for participants from two companies: MIT ( https://www.millenniumit.com ) and IFS ( http://www.ifsworld.com/lk/ ) Sri Lanka. Concepts related to Data Modeling, Creating Models with Power BI and Analysis Services were discussed with Hands-On.

Implementing a SQL Server Data Warehouse

October 25, 2016

Microsoft Data Warehousing Course

This is a 5-days workshop organized based on Microsoft Data Warehousing curriculum for MIT ( https://www.millenniumit.com ) and IFS ( http://www.ifsworld.com/lk/ ). Data Warehousing concepts, logical design using Kimabl's concepts, Physical design with Microsoft SQL Server 2016 and ETLing using Microsoft SQL Server Integration Services were discussed with Hands-On.

Developing SQL Server Database

October 17, 2016

Standard Workshop

This 4-days workshop was organized for MIT ( https://www.millenniumit.com ) Sri Lanka on Microsoft SQL Server 2016. This course was focused on Microsoft SQL Server 2016, discussing areas like Database development, Objects such as Tables, SPs, Function development, Rowstore and Columnstore indexing and many more, with hands-on.