Speaker Profile


Dinesh Priyankara Sri Lanka

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

Number of Speeches : 84

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


Recommendations 0

  Recommend Dinesh

All Speeches

Analyzing Data with Power BI - 20778B - 2019 - Batch IV - Sri Lanka

31 May 2019, 07 Jun 2019, 14 Jun 2019

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.

Analyzing Data with Power BI for Aiten Spence - Sri Lanka

27 May 2019, 29 May 2019, 30 May 2019, 31 May 2019

Standard workshop with hands-on

This is a 4-day workshop on Microsoft Power BI, organized byTechOne Global for Aitken Spence, Sri Lanka, 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.

Stepping into Data Science - Batch V

12 Jun 2019, 13 Jun 2019

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, Statistics, 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 - Jan-2019 - Batch IV-2019 - Sri Lanka

April 11, 2019

Standard Workshop with hands-on

This is a 3-day workshop on Microsoft Power BI, organized by CICRA Campus, Sri Lanka, 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.

Stepping into Data Science - IV - Softlogic Life - 2-day workshop

April 09, 2019

Standard Workshop

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.

[Dubai Ignite] Accelerating and modernizing data integration with Azure Data Factory - Microsoft Ignite Tour

March 28, 2019

Microsoft Ignite | The Tour Dubai

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. Let me show you how we can use Azure Data Factory ....See More

Implementing a modern data warehouse - 3-day workshop on Azure

March 26, 2019

Standard workshop with hands-on

This 3-day workshop focused on implementing a modern data warehousing using Azure services such as Azure SQL Data Warehouse, Azure Data Factory, Azure Data Lake Store Gen 2 and Azure Databricks. Concepts, design and patterns were discussed along with hands-on.

[Bangladesh] Data Warehousing and Data Science workshop

March 18, 2019

Standard workshop with hands-on

This 3-day workshop focused on data warehousing using Microsoft platform. Requirement gathering, Bus Matrix, physical DW design, SQL Server DB, Azure SQL, Azure SQL DW and Power BI are discussed in details with hands-on.

[Myanmar] Data Warehousing and Data Science workshop

March 06, 2019

Standard workshop with hands-on

This 3-day workshop focused on data warehousing using Microsoft platform. Requirement gathering, Bus Matrix, physical DW design, SQL Server DB, Azure SQL, Azure SQL DW and Power BI are discussed in details with hands-on.

[Singapore Data Camp 2019] Another way of making data ready: Azure Databricks

March 02, 2019

Data Camp 2019 - Singapore

This session focuses on modern and efficient data processing that is processing data using Azure Databricks. This talks about Spark, Databricks and integration of Databricks with Azure. Finally demo will be done, showing how CDR records can be processed using a notebook written with Scala.

[Workshop] Processing Big Data using Azure Databricks - Singapore

March 01, 2019

Data Camp 2019 - Singapore

This one day workshop discusses Azure Databricks, architecture of it, characteristics of it and usage of it. In addition to that, hands-on are prepared for configuring Azure Databricks, Azure Data Lake Gen2 and processing data using Databricks with notebooks configured for Scala and SQL.

Stepping into Data Science - Batch III

26 Feb 2019, 27 Feb 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.

Another way of making data ready: Azure Databricks

February 20, 2019

Sri Lankan Data Community (SLDC) - February 2019

This session focuses on modern and efficient data processing that is processing data using Azure Databricks. This talks about Spark, Databricks and integration of Databricks with Azure. Finally demo will be done, showing how CDR records can be processed using a notebook written with Scala.

Performance Tuning and Optimizing Microsoft SQL Server Databases - Sri Lanka

06 Feb 2019, 07 Feb 2019

Standard workshop with hands-on

This two-day workshop focuses on performance tuning and optimizing Microsoft SQL Server databases. This workshop discusses database and table design considerations, indexing strategies and maintenance, statistics, locks and blocks, isolation levels and memory-optimized tables.

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.

Analyzing Data with Power BI - 20778B - Jan-2019 - Batch III - Sri Lanka

22 Jan 2019, 23 Jan 2019, 24 Jan 2019

Standard workshop with hands-on

This is a 3-day workshop on Microsoft Power BI, organized by CICRA Campus, Sri Lanka, 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 with Power BI - 20778B - Jan-2019 - Batch II - Sri Lanka

05 Jan 2019, 12 Jan 2019, 19 Jan 2019

Standard workshop with hands-on

This is a 3-day workshop on Microsoft Power BI, organized by CICRA Campus, Sri Lanka, 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.

Microsoft Power BI: Enterprise Reporting - Microsoft Ignite | The Tour Singapore

January 16, 2019

Microsoft Ignite | The Tour Singapore

Power BI Premium enables you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights. This demo-heavy session dives into exciting, new, and upcoming features including aggregations for big data, incremental refresh, connectivity and programmability, and tooling for large models.

Accelerating and modernizing data integration with Azure Data Factory - Microsoft Ignite Tour - Singapore

January 16, 2019

Microsoft Ignite | The Tour 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. Let me show you how we can use Azure Data Factory ....See More

Data Warehousing Course (40 hrs) - MSc in Business Analytics - IIT - University of Westminster

January 09, 2019

MSc in Business Analytics program - IIT

This 40 hours course designed for students in Informatics Institute of Technology, for MSc in Business Analytics - University of Westminster, focuses on data warehousing. This course discusses requirement gathering process, logical design based on Kimball's concepts, physical design and implementation using Microsoft platform.

Analyzing Data with Power BI - 20778B - Jan-2019 - Batch I - Sri Lanka

02 Jan 2019, 03 Jan 2019, 08 Jan 2019

Standard workshop with hands-on

This is a 3-day workshop on Microsoft Power BI, organized by CICRA Campus, Sri Lanka, 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.

Azure Database for MySQL and PostgreSQL workshop - Malaysia

17 Dec 2018, 18 Dec 2018, 19 Dec 2018

Standard workshop with hands-on - Organized by TechnoFocus

This 3-day workshop focus on Azure Database for MySQL and PostgreSQL, discussing how to create instances, capabilities added on these two services, automatic backup, replicas and various migration techniques with hands-on.

Stepping into Data Science - Batch I - Sri Lanka

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.

Business Intelligence and Decision Support System Module (2016/2017) - University of Kelaniya - Sri Lanka

December 01, 2018

Bachelor of Science Honours in Software Engineering Degree

This 40-hour module is designed for undergraduates in University of Kelaniya, Sri Lanka. Module focuses on Business Intelligence, technologies used, multidimensional databases, BI interfaces and applications.

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.

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.

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.

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.