My current list of presentations is below. If you are interested in a topic but do not see it, let me know and I’ll work on creating a session for you.
What to know where I’m presenting next? Check out my Community Activities page.
What is Power BI?
You’ve heard all the buzz about Power BI, but you have no idea what it is or how it works. This session explains what Power BI is, who can use it and why you would want to. It’s an introductory session that gives you the information you need to determine if Power BI is right for you and your organization.
Level: Beginner/Intro
Target Audience: Anyone who is interested in learning more about what Power BI is and if it’s right for you. For people with both technical and non-technical backgrounds.
Intro to Integration Services (SSIS)?
This session is a very basic introduction to Integration Services (SSIS). We’ll cover the basics; what it’s used for and the various parts and pieces to get you started creating your own projects in no time. We’ll talk about packages, connections and project parameters and their respective tasks/properties. We’ll also cover some basic performance tuning to make your packages run faster.
Level: Beginner/Intro
Target Audience: Anyone who is interested in learning more about what Integration Services is and if it’s right for you. For people with both technical and non-technical backgrounds. Perfect for the DBA who wants to start learning about the world of BI.
Data Types Do Matter
They’re just numbers, right? A date’s a date. It’s just string data, who cares? I can’t tell you how many times I’ve heard these phrases. This session will help you understand why choosing the correct data type for your data is so important. It affects data quality, storage and performance. It can even produce incorrect query results.
Level: Intermediate
Target Audience: DBAs and Developers
Profiling Your Data
Have you ever started a warehouse or ETL project and realized that the data wasn’t as “clean” as you were told? If only you had profiled your data before you started then you wouldn’t have to rework design elements, change code or redesign your database. In this session we will talk about what data profiling is, why you should do it and how you can do it with tools that are already included in the SQL Server BI stack.
Level: Intermediate
Target Audience: DBAs, Developers & Analysts
Getting Started With Dimensional Modeling
You want to analyze your data, but you are not sure where to start. If you are using any of the Microsoft BI stack of products, then you will need to start by modeling your data. In this session we will talk about what data modeling is, explain why we should do it, and finally show you how to do it with a very simple example.
Level: Beginner
Target Audience: Developers & Analysts
Understanding DAX – It’s All About the Context
How many times have you created a Power BI report and gotten an unexpected or inconsistent result, then spent an absurd amount of time trying to figure where the result came from? This happens with almost everyone when they start writing DAX. The key to understanding DAX is context, evaluation context. This session won’t provide the magic bullet to becoming a master at DAX, but will help you understand evaluation context, so the next time you create a measure, the result will be not only consistent, but expected.
Level: Beginner
Target Audience: BI Developers & Analysts
Demo File: Download from GitHub (Understanding DAX Demo.zip)
Can Microsoft Purview Answer All Your Data Governance Needs
Your company has amassed more data than it can possibly use, yet no one can find the data they need. Your company also deals with sensitive data, but you have no idea what your exposure is should a breach occur. This session will introduce you to Azure Purview and what problems it was designed to solve for. We’ll walk through all the major features of Purview, including Data Map, Data Catalog, Workflows, Policies, and Insights to see if Azure Purview can answer all your data governance needs.
Level: Intermediate
Target Audience: Anybody who deals with data governance
Identifying and Preventing Unauthorized Power BI Gateways
Power BI has taken off at your company, but now you have who knows how many on-premises data gateways in your organization. If you need to easily identify all your on-premises data gateways or prevent gateways from being installed, then you don’t want to miss this quick tip session.
Level: Intermediate
Target Audience: Anybody who deals with data governance, Power BI Administrators
Getting Started With Governance For Your Power BI Estate
Is your company thinking about implementing Power BI or have they already implemented Power BI and your estate looks like the wild, wild West? Governance is a huge topic, but when you start with small steps, it is achievable, and you can have success. In this session we’ll cover the “must haves” for Power BI governance and tell you how to start small and achieve big success.
Level: Intermediate
Target Audience: Anybody who deals with data governance, Power BI Administrators, Data professionals
Power BI Data Wrangling – Choosing the Best Feature for the Job
The Power BI ecosystem has grown so much since it was released in 2015, and new data wrangling features are being added all the time. How do you know which feature to use and when? Some features are better than others for certain types of solutions. In this session, we will cover the major options of Power BI data wrangling, including datasets, datamarts, and dataflows, and discuss which problem(s) they solve for and when it makes sense to use them.
Level: Intro to Intermediate, Basic knowledge of Power BI recommended
Target Audience: Anybody who has to build Power BI artifacts, Power BI Administrators, Data professionals
Make Your Power BI Reports Pop
Are you ready to take your Power BI reports to the next level and make them truly shine? Join us for an immersive and dynamic session where we’ll unveil a plethora of captivating features designed to elevate your reports to new heights of brilliance! Through a series of captivating demonstrations, we’ll showcase a rich tapestry of techniques guaranteed to make your Power BI reports stand out amidst the sea of data.
Prepare to embark on a journey through the enchanting world of Power BI customization as we unveil a treasure trove of features and functionalities that will transform your reports into captivating works of art. From dazzling visualizations to interactive elements, we’ll explore some little known features that will make your Power BI reports pop.
Don’t miss this opportunity to unlock the full potential of Power BI and unleash your creativity like never before. Join us and discover how to infuse your reports with a touch of magic that will leave your audience spellbound and craving for more!
Level: Intro to Intermediate, Basic knowledge of Power BI recommended
Target Audience: Anybody who has to build Power BI reports, Data professionals
Intro to Azure Data Catalog (retired)
Your company has amassed more data than it can possibly use, yet no one can find the data they need. This is more common than you think. With Azure Data Catalog, anyone can find the data they are looking for, no matter the data source. This session will introduce you to Azure Data Catalog, what it is, how you can use it and why everyone should be using it.
Level: Beginner
Target Audience: DBAs, Developers & Analysts, IT Managers/Executives
SQLSwimmer 