Speaker Profile


Dinesh Priyankara Sri Lanka

Founder/Principal Architect, (MVP, MCT) - dinesQL (Pvt) Ltd.

Number of Speeches : 62

Dinesh Priyankara - Dinesh is an experienced professional and database enthusiast with skills in database management systems and business intelligence, especially on the Microsoft SQL Server product suite. Possessing over 16 years of experience on data related technologies, he does training, consulting, and is a top contributor to the local SQL Server community. In recognition of his contributions and expertise he has demonstrated, he was awarded the Microsoft Most Valuable Professional (MVP) award for SQL Server for 12 consecutive years since 2006. Dinesh is the Founder/Principal Architect of dinesQL (Pvt) Ltd (http://dinesql.com). In his spare time he runs a blog at http://dinesql.blogspot.com with a follower base of over 100,000 from around the world and is a co-organizer of SQL Server Sri Lanka User Group (http://www.meetup.com/ssslug/).


Dinesh Priyankara


Current Rate 4.5

Based on 467 ratings.


Recommendations 0

  Recommend Dinesh

All Speeches

Stepping into Data Science - Batch II

29 Jan 2019, 30 Jan 2019

Standard workshop with hands-on - Organized by dinesQL Pvt Ltd

This 16- hour instructor-led workshop focuses on Data Science and provides participants the knowledge and skills for understanding Data Science, Statistics, Data Science methodologies and how to create, validate and deploy Machine Learning Models using Python and Azure Machine Learning Studio.

Stepping into Data Science

04 Dec 2018, 05 Dec 2018

Standard workshop with hands-on

This 16- hour instructor-led workshop focuses on Data Science and provides participants the knowledge and skills for understanding Data Science, Data Science methodologies and how to create, validate and deploy Machine Learning Models using Python and Azure Machine Learning Studio.

Analyzing Data with Power BI - 20778B

27 Oct 2018, 10 Nov 2018, 17 Nov 2018

Standard workshop with hands-on

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.

Developing a SQL Server Database - Airport Aviation, Sri Lanka

November 16, 2018

Standard workshop with hands-on

This is a 3-day workshop on Microsoft SQL Server, how to use it for database development, adding advance table structures such as columnstore, memory-optimized, temporal, partitioning tables and administration.

Analyzing Data with Power BI - 20778B

19 Oct 2018, 25 Oct 2018, 26 Oct 2018, 29 Oct 2018

Standard workshop with hands-on

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.

Business Intelligence Systems - University of Colombo

October 17, 2018

Standard workshop with hands-on

This 8-hour course focuses on concepts of Business Intelligence solutions discussing theories, logical and physical design, OLAP data warehouses and visualization.

Azure Data Services - Sri Lanka

September 14, 2018

Standard workshop with hands-on

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

Administering a SQL Database Infrastructure - 20764C

22 Aug 2018, 23 Aug 2018, 04 Sep 2018, 05 Sep 2018, 06 Sep 2018

Standard workshop with hands-on - Organized by CICRA

This 5-day workshop focused on administration of SQL Server and it was based on 20764C Microsoft official curriculum. Many areas related to SQL Server administrations were discussed using 15 modules and every module had demonstrations and hands-on.

Azure Data Services - Bangladesh

26 Aug 2018, 27 Aug 2018, 28 Aug 2018

Standard workshop with hands-on

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

Azure Data Services - Thailand

26 Mar 2018, 27 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, and Azure Cosmos DB along with demonstrations and hands-on.

Accelerating and modernizing data integration with Azure Data Factory - Singapore

August 18, 2018

SQLSaturday - Singapore

Integration Services (aka SSIS) has been serving us for years for building enterprise data integration solutions, not only for data warehousing but for all types of data integrations between heterogenous data sources. SSIS is not retiring but it is high time to check out its new neighbor; Azure Data Factory, fully managed ETL service in the cloud. This session focuses on Azure Data Factory for imp....See More

Making Unstructured Data Analysis-Ready using Azure Data Lake Analytics - India

August 10, 2018

Data Platform Summit 2019

This session focuses on Azure Data Lake Analytics and discusses how to process unstructured data such as text and images, making them ready for analysis.

Analyzing Data with Power BI - 20778B

02 Aug 2018, 03 Aug 2018, 04 Aug 2018

Standard workshop with hands-on

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.

Processing Unstructured Data using Azure Data Lake Analytics

July 20, 2018

Microsoft Student Champs Meetup

This session is organized for Microsoft Student Champs meetup and focuses on Azure Data Lake Analytics. Unstructured data, Azure Data Lake, Azure Data Lake Analytics and USQL are discussed with demonstrations.

Business Intelligence and Management Support Systems

July 09, 2018

Software Engineering Honors Degree Program, Faculty of Science, University of Kelaniya

This is a 40-hour course designed for Software Engineering Honors Degree Program, Faculty of Science, University of Kelaniya. This discusses important of DWBI systems, how to do the requirement gathering, creating logical DW, creating physical DW, implementing ETL solutions and OLAP data warehouses.

Building a cloud data warehouse using Microsoft Azure Services

21 Jun 2018, 22 Jun 2018, 28 Jun 2018, 29 Jun 2018

Standard workshop with hands-on

This 4-day workshop discusses Azure Services such as Azure SQL Data Warehouse, Data Factory, Data Lake Store and Data Lake Analytics for building a complete cloud data warehouse. Hands-on includes, building a data warehouse using Azure SQL DW and ETLing with Azure Data Lake and Azure Data Factory.

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.

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.

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.

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.

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.

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.

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.

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.

Engineering Big Data using Microsoft Azure

01 Feb 2018, 02 Feb 2018, 03 Feb 2018

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 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.

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

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

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

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

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

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

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

SQLSaturday 639 - Sri Lanka - 2017

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

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

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.

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.

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.

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

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.