What is Azure Purview and Why Do I Need It?

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, what problems it was designed to solve for, and show you how to create a Purview Account in your Azure tenant.

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.

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.

What is Power BI?

You’ve heard all the buzz about Power BI, but you have no idea what it is and 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.

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.

Intro to Azure Data Catalog

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.

Getting Started With Data 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.

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 (100)
Duration: 60-75 minutes

Zero To Dashboard

Your boss has heard all the buzz about Power BI and wants you to start using it to make the business users happy and reduce the demands on IT staff. In this single day workshop, we review the capabilities of the Power BI suite of tools and help you realize the following objectives using demos and hands-on labs:

Objectives:

1. Understand the Power BI ecosystem and what it can and can't do for you.

2. Understand the importance of Data Cleansing.

3. Understand the importance of Data Modeling.

4. Understand data visualization principles.

5. Understand the implications of Power BI as it relates to governance.

5. Create a meaningful dashboard based on the previous objectives.

Pre-requisites

1. Bring your own laptop

2. Microsoft Power BI Desktop: you should have downloaded and installed Power BI Desktop from https://go.microsoft.com/fwlink/?LinkId=521662.

3. Microsoft Power BI Desktop requires Internet Explorer 10 or greater.

4. Signup for Power BI: Go to http://aka.ms/pbidiadtraining and sign up for Power BI. If you cannot sign up for Power BI, let the instructor know.