Presentations

I greatly enjoy doing presentations on a variety of topics, such as Big Data, Data Warehousing, Business Intelligence, SQL Server, and personal development.  If you would like me to do a presentation, just ask!  Below are descriptions of presentations I have done before, along with other possible topics:

Technical

Building an Effective Data Warehouse Architecture

You’re a DBA, and your boss asks you to determine if a data warehouse would help the company.  So many questions pop into your head: Why use a data warehouse?  What’s the best methodology to use when creating a data warehouse?  Should I use a normalized or dimensional approach?  What’s the difference between the Kimball and Inmon methodologies?  What’s the difference between a data warehouse and a data mart?  Is there any hardware I can purchase that is optimized for a data warehouse?  What if I have a ton of data?  Join this session for the answers to all these questions.  You’ll leave with information that will amaze your boss and lead to a big raise… – or at least lead you down the correct path to adding business value to your organization!  Level 100

11/14/2012, South Florida PASS
2/27/2013, PASS DBA Virtual Chapter (recording)
4/12/2013, PASS Business Analytics Conference (slides)
4/13/2013, PASS SQL Saturday Chicago (slides)
6/13/2013, Pragmatic Works (slides) (recording)
7/31/2013, 24 Hours of PASS: Summit Preview (slides) (recording)
9/3/2013, PASS DBA Fundamentals VC (slides) (recording)
9/10/2013, Houston PASS (slides)
10/17/2013, PASS Summit 2013 (slides)
5/8/2014, PASS Business Analytics Conference (slides)
9/27/14, SQL Saturday Boston BI Edition (slides)
2/10/15, PASS Rhode Island User Group (slides)
6/6/15, PASS SQL Saturday Philadelphia, PA (slides)

Building a Big Data Solution (Building an Effective Data Warehouse Architecture with Hadoop, the cloud and MPP)

As a follow-on to the presentation “Building an Effective Data Warehouse Architecture”, this vendor-free presentation will explain exactly what Big Data is and its benefits, including use cases.  We will discuss how Hadoop, the cloud and massively parallel processing (MPP) is changing the way data warehouses are being built.  We will talk about hybrid architectures that combine on-premise data with data in the cloud as well as relational data and non-relational (unstructured) data.  We will look at the benefits of MPP over SMP and how to integrate data from Internet of Things (IoT) devices.  You will learn what a modern data warehouse should look like and how the role of a Data Lake and Hadoop fit in.  The Big Data boom brings new challenges to those of you who define the architectures to create and consume business-critical data.  You will need guidance on the best solution for your data warehouse going forward.  This presentation will help to give you that guidance!  Level 200

2/24/15, Pragmatic Works (slides) (recording)
10/17/15, SQL Saturday Boston BI Edition

Finding business value in Big Data (What exactly is Big Data and why should I care?)

I often hear from clients: “We don’t know much about Big Data – can you tell us what it is and how it can help our business?”  Yes!  The first step is this vendor-free presentation, where I start with a business level discussion, not a technical one.  Big Data is an opportunity to re-imagine our world, to track new signals that were once impossible, to change the way we experience our communities, our places of work and our personal lives.  I will help you to identify the business value opportunity from Big Data and how to operationalize it.  Yes, we will cover the buzz words: modern data warehouse, Hadoop, cloud, MPP, Internet of Things, and Data Lake, but I will show use cases to better understand them.  In the end, I will give you the ammo to go to your manager and say “We need Big Data an here is why!”  Because if you are not utilizing Big Data to help you make better business decisions, you can bet your competitors are. Level 100

8/26/14, Tableau Users Group (slides)
3/21/15, PASS SQL Saturday Richmond, VA (slides)
5/16/15, PASS SQL Saturday Rochester, NY (slides)
5/26/15, Big Data Virtual Chapter (slides)

How does Microsoft solve Big Data?

So you got a handle on what Big Data is and how you can use it to find business value in your data.  Now you need an understanding of the Microsoft products that can be used to create a Big Data solution.  Microsoft has many pieces of the puzzle and in this presentation I will show how they fit together.  How does Microsoft enhance and add value to Big Data?  From collecting data, transforming it, storing it, to visualizing it, I will show you Microsoft’s solutions for every step of the way.  Level 100

5/16/15, PASS SQL Saturday Rochester, NY (slides)

Modern Data Warehousing with the Microsoft Analytics Platform System

The traditional data warehouse has served us well for many years, but new trends are causing it to break in four different ways: data growth, fast query expectations from users, non-relational/unstructured data, and cloud-born data.  How can you prevent this from happening?  Enter the modern data warehouse, which is able to handle and excel with these new trends.  It handles all types of data (Hadoop), provides a way to easily interface with all these types of data (PolyBase), and can handle “Big Data” and provide fast queries.  Is there one appliance that can support this modern data warehouse?  Yes!  It is the Analytics Platform System (APS) from Microsoft (formally called the Parallel Data Warehouse or PDW), which is a Massively Parallel Processing (MPP) appliance.  In this session I will dig into the details of the modern data warehouse and APS.  I will give an overview of the APS hardware and software architecture, identify what makes APS different, and demonstrate the increased performance.  In addition I will discuss how Hadoop, HDInsight, and PolyBase fit into this new modern data warehouse.  Level 100

5/3/14, PASS SQL Saturday Dallas (slides)
5/22/14, Pragmatic Works (slides) (recording)
8/12/14, Central New Jersey SQL User Group (slides)
9/30/14, Beyond Tech-Ed, Rochester, NY (slides)
10/7/14, Beyond Tech-Ed, Hartford, CT (slides)
10/9/14, Beyond Tech-Ed, Cambridge, MA (slides)
4/1/15, APS roundtable with Pragmatic Works, Cambridge, MA (slides)
Presented to dozens of Fortune 500 companies over the last year

Introducing Azure SQL Data Warehouse

The new Microsoft Azure SQL Data Warehouse (SQL DW) is an elastic data warehouse-as-a-service and is a Massively Parallel Processing (MPP) solution for “big data” with true enterprise class features.  The SQL DW service is built for data warehouse workloads from a few hundred gigabytes to petabytes of data with truly unique features like disaggregated compute and storage allowing for customers to be able to utilize the service to match their needs.  In this presentation, we take an in-depth look at implementing a SQL DW, elastic scale (grow, shrink, and pause), and hybrid data clouds with Hadoop integration via Polybase allowing for a true SQL experience across structured and unstructured data.

(slides)

Azure Stream Analytics

Azure Stream Analytics (ASA) is an Azure Service that enables real-time insights over streaming data from devices, sensors, infrastructure, and applications.  In this presentation, we provide introduction to the service, common use cases, example customer scenarios, business benefits, and demo how to get started.  We will quickly build a simple real time analytic application that uses an IoT device to ingest data (Event Hubs), process and analyze data (Stream Analytics) and visualize data (PowerBI).

(slides)

Cortana Analytics Suite

Cortana Analytics Suite is a fully managed big data and advanced analytics suite that transforms your data into intelligent action.  It is comprised of data storage, information management, machine learning, and business intelligence software in a single convenient monthly subscription.  This presentation will cover all the products involved, how they work together, and use cases.

(slides)

What exactly is Business Intelligence?

BI is the “Gathering of data from multiple sources to present it in a way that allows executives to make better business decisions”. I will describe in more detail exactly what BI is, what encompasses the Microsoft BI stack, why it is so popular, and why a BI career pays so much. I will review specific examples from previous projects of mine that show the benefits of BI and its huge return-on-investment. I’ll go into detail on the components of a BI solution, and I will discuss key concepts for successfully implementing BI in your organization.

4/13/2013, PASS SQL Saturday Chicago (slides)

Best Practices to Deliver BI Solutions

If your company is planning to build a data warehouse or BI solution, you need to be aware that BI projects have high failure rates. Gartner says between 70% to 80% of corporate business intelligence projects fail. And with “Big Data” adding more complexity you can expect even more failures. However, the major causes of these failures are well known and can be avoided by implementing a set of best practices.

I have worked on dozens of end-to-end BI projects and have seen my share of successes and failures. I will talk about the reasons BI projects fail and share best practices and lessons learned so your BI project will fall into the “successful” category.

8/6/2013, Pragmatic Works (slides) (recording)
5/10/14, PASS SQL Saturday Houston (slides)
9/27/14, SQL Saturday Boston BI Edition (slides)
10/4/14, SQL Saturday Charlotte BI Edition (slides)

Why a Company Should Consider DW/BI

What is a data warehouse and why should a company use one? What is business intelligence and why should a company use it? I’ll answer those questions, as well as discuss BI concepts, the types of BI solutions and the BI lifecycle. And end with a discussion about the Microsoft BI stack.

Client presentation (slides)

Power BI for Office 365

A demonstration-heavy presentation of Power BI for Office 365, showing you how all the various tools and technologies work together: Power Query, Power Pivot, Power View, Power Map, Power BI sites, Data Management, Power BI Admin center, Power BI for mobile, and Power BI Q&A.

With so many tools it can be hard to understand not only the purpose of each tool, but how you can develop a solution that uses the features of each tool.  This presentation will help to make this more clear and also show you the “power” in Power BI.  It really is a game changer.

Client presentation (video) (slides)

Introduction to Microsoft’s Master Data Services (MDS)

Companies struggle with consolidating the same set of data from multiple systems to accurately report on critical business information.  For example, having customer lists in multiple systems that often have the same customer in more than one list, sometimes with a different spelling.  Master Data Services is bundled with SQL Server 2012 to help resolve many of the Master Data Management issues that companies are faced with when integrating data.  In this session, James will show an overview of Master Data Services 2012, including the out of the box Web UI, the highly developed Excel Add-in, and how to get started with loading MDS with your data.

12/20/2012, PASS Data Architecture Virtual Chapter (recording)
2/12/2013, Houston PASS (slides)

Overview of Microsoft Appliances

Learn how SQL Server can scale to HUNDREDS of terabytes for BI/DW solutions.  This session will focus on Fast Track Solutions and Appliances, Reference Architectures, and Parallel Data Warehousing (PDW).  Included will be performance numbers and lessons learned on the very first production PDW deployment in the world and how a successful BI solution was built on top of it using SSAS.

Learn about all the different appliances and how they can save you a tremendous amount of time and money instead of building on your own: HP Business Decision Appliance (BDA), HP Business Data Warehouse appliance (BDW), HP Enterprise Data Warehouse Appliance (EDW), and HP Database Consolidation Appliance (DBC).

If you are involved in the decision-making in your company for purchasing one or more servers to be used for SQL Server, this session will make you aware there are options outside of the usual ordering a server and internally installing the hardware, OS, and SQL Server.

3/13/2012, Houston PASS
4/21/2012, Houston SQL Saturday
4/11/2013, PASS Business Analytics Conference (slides)

Top BI enhancements for SQL Server 2012

SQL Server 2012 has an abundance of new features and enhancements, with business intelligence (BI) being one area given a lot of attention. Microsoft understands the importance of BI and continues to make things easier and more powerful for BI developers and end users. In this session I will cover the most important of these new features, broken out into the logical areas seen in a full end-to-end development of a BI solution: data integration, data management & warehousing, and end-user reporting.

3/12/2013, Houston PASS (slides)

End-User Microsoft BI tools – Clearing up the confusion

Excel, SSRS, Report Builder, PowerPivot, PerformancePoint, Power View. Which one should I use? I will discuss the pros and cons of each and give demos of all the tools so you know the best tool for each situation.

Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there are many different possible presentation layers (client tools) that serve different user communities with varying usage profiles. There is a lot of confusion on what is the best tool to use. This presentation will hopefully clear up the confusion and give you some guidance on the best tool for each situation.

Client presentation (slides)

Methods for Populating a Data Warehouse Each Day

Designing and creating the process to extract the data from the source system is usually the most time-consuming task in the ETL process if not the entire data warehousing process. Source systems are usually very complex, with tables and fields in the databases that are difficult to understand and poorly documented. This makes determining the data which needs to be extracted a challenge. And usually the data needs to be extracted on a daily basis to supply all changed data to the data warehouse in order to keep it up-to-date. Moreover, the source systems usually cannot be modified, or its performance or availability adjusted, to accommodate the needs of the data warehouse extraction process. The focus of this session will be the technical considerations of having different kinds of sources and extraction methods. We will discuss the most common techniques used for extracting data from source databases and the ways to determine the data that has changed since the last extraction.

Transitioning from self-service BI to corporate BI

Self-service BI is all the rage as many power users are using PowerPivot to build their own reports.  But what happens if those users want to make those reports available to everyone?  How do you make those reports available to the enterprise?

Self-service allows power users to build PowerPivot reports, proof-of-concept reports, and ad-hoc queries.  This session will discuss these benefits, then talk about how to take those reports to the next level, which is team/workgroup BI via PowerPivot for Excel and PowerPivot for SharePoint, and the next level after that: corporate/organizational BI via SSAS.

Master Data Management (MDM) Hub Architectures

There are three basic styles of architecture used for Master Data Management hubs: the registry, the repository, and the hybrid approach.  I will provide details of all three so you can make the most informed decision when creating your MDM hub.

The Master Data Management (MDM) hub is a database with the software to manage the master data that is stored in the database and keep it synchronized with the transactional systems that use the master data.  There are three basic styles of architecture used for Master Data Management hubs: the registry, the repository, and the hybrid approach.  There are also a few other popular variations.  I will provide details on all these styles as well as present real-world examples so when you come away from the session you have a solid understanding of all the styles and then have the confidence to determine the right architecture for your company.

Professional Development

Enhancing your career: Building your personal brand

In three years I went from a complete unknown to a popular blogger, speaker at PASS Summit, and a SQL Server MVP.  Along the way I saw my yearly income triple.  Is it because I know some secret?  Is it because I am a genius?  No!  It is just about laying out your career path, setting goals, and doing the work.  It’s about building your personal brand and stepping out of your comfort zone.  It’s about overcoming your fear of taking risks.  If you can do those things, you will be rewarded.  I will discuss how you too can go from unknown to well-known.  I will talk about building your community presence by blogging, presenting, writing articles and books, twitter, LinkedIn, certifications, interviewing, networking, and consulting and contracting.  Your first step to enhancing your career will be to attend this session!

5/10/14, PASS SQL Saturday Houston (slides)
5/30/15, PASS SQL Saturday New York City, NY (slides)

How to Make a LOT More Money as a Consultant

James will show you the ropes on how to double your income by going from a salaried permanent employee to an independent consultant. James will discuss: Differences between perm, consulting, contracting; Understanding how placement/consulting companies work; Salary vs W2 vs 1099; Using social media (blogging, twitter, LinkedIn) and job boards; Certifications; Most in-demand skills; Developing the needed technical and communication skills; Interviewing and resume tips; How to negotiate; Networking yourself; and the additional risks and higher expectations that go with being a consultant.

1/10/2012, Houston PASS (slides)

Become a BI Independent Consultant!

If you are bold enough, you can enter the world of independent consulting and watch your income soar! BI is hot and with a little effort you can step out of your “comfort zone” and enjoy the benefits of being your own boss. James will show you the ropes on how to double or even triple your income by going from a salaried permanent employee to an independent consultant. James will discuss: Differences between perm, consulting, contracting; Understanding how placement/consulting companies work; Salary vs W2 vs 1099; Using social media (blogging, twitter, LinkedIn) and job boards; Certifications; Most in-demand skills; Developing the needed technical and communication skills; Interviewing and resume tips; How to negotiate; Networking yourself; and the additional risks and higher expectations that go with being a consultant.

What is it like to work at Microsoft?

James has worked at Microsoft for the past year. Before that, he was an independent consultant as well as having worked as a permanent employee and contractor and numerous companies. What is different about Microsoft? What is it like to see how things work “behind the curtain”? How does it compare to what he anticipated it to be like? Come join this session to find out more working for Microsoft: benefits, compensation, training, career advancement, work-life balance, travel, types of jobs, etc. We will leave plenty of time to ask questions!

4/18/15, PASS SQL Saturday, Boston MA (slides)

Transitioning to a BI role

Business Intelligence is an extremely hot career.  If you are a DBA or have another IT position, how can you transition to a BI role?  I will describe what exactly BI is, what encompasses the Microsoft BI stack, why it is so popular, and why a BI career pays so much. Then I will delve into the steps to take to become a BI expert and how I made the transition, going from a salaried DBA to a high-in-demand and high-income BI consultant.  If I can go from a complete unknown to building a personal brand that allowed me to present at the PASS Business Analytics conference in just two years, so can you!

2/13/2013, PASS Professional Development Chapter (recording) (slides)
10/19/2013, PASS SQL Saturday Charlotte (slides)
10/17/15, SQL Saturday Boston BI Edition

Other topics:

Technical

  • Hadoop: cutting through the hype to find out how it can help you can how it cannot
  • SQL Server Analysis Service (SSAS): The perfect source for BI
  • SQL Server Analysis Service (SSAS): Comparing the new tabular model vs the Multidimensional model
  • What are the new BI-related features in Excel 2013?
  • Microsoft Certified Solutions Expert (MCSE): Business Intelligence: New certifications for SQL Server 2012
  • Fast track data warehouse reference configuration
  • Introduction to Data Quality Services 2012
  • The new BI enhancements in PerformancePoint and SharePoint 2013
  • The new enhancements in SSIS 2012
  • BI in the cloud – SQL Azure Reporting, SSRS, SSIS
  • Why You Need a Data Warehouse
  • Using Amazon Web Services (AWS) for your data warehouse
  • The future of BI

Professional Development

  • How to use LinkedIn to enhance your career
  • How to nail that Interview: Tips and tricks, PLUS The art of negotiation: How to negotiate your salary/pay rate
  • How to find a contract/perm job: Networking yourself so the jobs find you by building up your personal brand
  • Blogging: All you need to know to start blogging and reap the benefits
  • Consulting vs contracting vs perm: Pros and cons of each
  • Step out of your comfort zone: keys to a high-paying career

2 Responses to Presentations

  1. Pingback: Want me to do a presentation? - SQL Server - SQL Server - Toad World

  2. Dhananjay says:

    Thank you so much James….. hope you recognized me… I have seen most of training from you (Pragmatics Work) , those was really fantastic and awesome …. I have been working completely in MSBI/MSSQL technology last 10 yrs and hearing that Power Bi,Power Pivot/query etc is also good in market now , so I am confused that which one is in best demand in coming future for best career path.

    Is it good to continue MSBI/Power etc with MS technology or can take risk and learn and switch to BIGDATA and Hadoop. As I know Hadoop required good Java and DBA/Networking etc knowledge in high expert level , please guide me .

    Thanks
    Dhananjay
    91 9963004441

Leave a Reply

Your email address will not be published. Required fields are marked *