Azure Databricks, Excel Custom Functions Programming, Azure Data Factory

Nilesh Shah Toronto Chapter 4:30p EST, 2 hours

On February 26, Join Toronto Chapter Meet to learn Azure Databricks, Excel Custom Functions Programming, Azure Data Factory.

Price: Free of cost

Requirement: Bring your laptop and an internet card.


Introduction to C# Corner
Azure Databricks
  • Introduction to Spark
  • Why Azure Databricks?
  • Navigating a Databricks workspace
  • Creating a cluster
  • The Notebook development experience 
Excel Custom Functions Programming
  • What are custom functions in Excel
  • Setup & Requirements
  • Streaming Custom Functions
  • Demo 
Azure Data Factory and Azure Logic Apps Typical Samples (P1)
  • File processing and Archiving
  • Unzipping files using ADF, ALA and Python
  • Pipeline Framework
  • Demo
Registration starts at 04:30 PM. So we request you to be there at 04:30 PM to get a seat.
Session details are as follows,
Azure Databricks
Heather Grandy
04:30 PM - 05:10 PM
Excel Custom Functions Programming
Nilesh Shah
05:15 PM - 05:50 PM
Azure Data Factory and Azure Logic Apps Typical Samples (P1)
Nik Shahriar
05:50 PM - 06:30 PM
Queries concerning your registration should be addressed to or call at 0120- 4256016


  • Microsoft MVP | C# Corner MVP | Tech Lead | Blogger, Speaker | TOGAF 9.1
  • Snr Technical Team Lead/Senior BI Consultant, Big Data, IoT Hub, Azure Stream Analytics, Power BI, SSIS, SQL Tabular DM, MCSA: BI Reporting, MCSE: Data Management and Analytics SQL2016, MCSA: SQL 2016 Database Development, MCP, Microsoft Certified Professional (SQL2012), MCPS: Microsoft Certified Professional, MCITP, Database Developer 2008, MCTS SQL 2008 Database Development, MCTS SQL 2008 Implementation and Maintenance, MCTS SQL 2005********Career Objective To obtain a senior level Business Intelligence Designer/Developer/Lead position (SQLServer, Big data, Stream Analytics, IoT Hub, SSIS, Power BI, SSAS, SSRS, Datazen, Tableau, Power Pivot, Power View, etc…).********Experience summary Focused on Big data, Data Warehouse, BI DW design, Business Intelligence Remote team lead and work experience, in Canada, US and EU for BI and ETL design teams. Senior level experience in Transactional DW and BI DW design projects. Coaching, mentoring, Leading, providing BI presentation and BI solutions for, end users, IT teams and management teams********Technical skills Database: SQL Server 2017 down to 7.0, Oracle 9.x, Teradata, Azure Tabular Model, SSAS 2008-2012-2014, SQL Tabular (BISM), Access. BI Tools: SSAS, SSIS, Power Query, PowerPivot, Power View, Power Map, Power BI, Analytic Tools, SSRS, SharePoint, Excel Pivot tables, Datazen Publisher, Tableau. Languages: T-SQL, M Language, DAX, MDX, PowerShell, VB.Net, C#. Other: VS, Cloud Base Technologies: SQL Azure, Power BI Desktop/Design, Power BI Portal/Desktop, O365, Azure Data Factory (ADF), Datazen Publisher, Azure Resource Group, Azure Data Gateway, Data Management Gateway, oAuth, Azure PowerShell.********Certification, Awards, Publication, Contribution MCSA: BI Reporting — Certified 2018 MCSE: Data Management and Analytics — Certified 2018 MCSA: SQL 2016 Database Development - Certified 2018 Power BI forum Contributor at (Click on me for my id, “SNik”) MCP (MS-Certified Professional) SQL 2012, (See attached Microsoft CP Transcript) Co-authors of “SQL MVP Deep Dive 2” 2011 (Support the children of Operation Smile) Microsoft SQL MVP 2010 Award (Microsoft Most Valuable Professional) MCITP (MS-Certified IT Professional), MCTS (MS-Certified Technology Specialist) 4 Star rating at “SQL Server Integration Service (SSIS)” forum online at


  • Microsoft Canada Head Office
  • 1950 Meadowvale Boulevard
  • Mississauga Ontario CANADA
Attendees (2)
View All
Chapter Leader

Nilesh Shah

Microsoft MVP | C# Corner MVP | Tech Lead | Blogger, Speaker | TOGAF 9.1