Most Active Speaker

Angela Henry

Angela Henry

Data mover and shaper. Data Platform MVP

High Point, North Carolina, United States

Angela is a Senior Architect, living in High Point, NC and loves what she does. She's worked with all versions of SQL Server & worn all the hats that come with dealing with SQL Server throughout the years: developer, administrator, data architect and BI developer. She has her MSCE in Data and Analytics (f.k.a., Business Intelligence), is a Data Platform MVP, and a Microsoft Certified Trainer (MCT). She is the former chapter leader for the PASS Triad SQL User Group in Greensboro, NC. In her spare time you can probably find her in or at the pool, she's an avid US Masters Swimmer, Coach and Instructor.

Awards

Area of Expertise

  • Information & Communications Technology

Topics

  • SQL Server Integration Services
  • SQL Server Data Tools
  • T-SQL
  • SQL
  • SQL Server Reporting Services
  • Microsoft SQL Server
  • SQL Server Analysis Services
  • Microsoft Power BI
  • Dimensional modeling
  • Microsoft Purview
  • Data Platform
  • Analytics and Big Data
  • Azure SQL Database
  • Azure Data Platform
  • Data Visualization
  • Data Warehousing
  • Data Engineering
  • Databases
  • Data Analytics
  • Data Management
  • Microsoft Data Platform
  • Database
  • Azure Data Lake

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.

Make Your Power BI Reports Pop

Want to make your Power BI reports pop? In this demo heavy session we will go over several features you can add to your Power BI reports to make them stand out in a crowd.

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 and when folks hear the word “Governance” they groan, either out loud or to themselves, and think of red tape, bottlenecks, and mandates from IT that make their daily work lives more complicated. What we really need to do as IT professionals is to change that mindset. Governance should be thought of as supplying trustworthy, useful data that is easily available to those who need it.

In this session we'll cover the "must haves" for starting your Power BI governance journey to provide trustworthy and useful data that is easily available and discoverable.

We will discuss how to start small and achieve big success.

This is a 45-60 minute session

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.

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.

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

Music City Tech 2018

May 2018 Nashville, Tennessee, United States

SQL Saturday Richmond

Data Types Do Matter, Intro to Integration Services (SSIS)

March 2018 Richmond, Virginia, United States

SQL Saturday Iceland

Data Types Do Matter

March 2018 Reykjavík, Iceland

SQL Saturday Cleveland

What is Power BI?, Intro to Integration Services (SSIS)

February 2018 Cleveland, Ohio, United States

Triad SQL UG

Data Types Do Matter

January 2018 Greensboro, North Carolina, United States

Charlotte BI UG

What is Power BI?

November 2017 Charlotte, North Carolina, United States

SQL Saturday Denver

Intro to Integration Services (SSIS)

September 2017 Denver, Colorado, United States

PASS WIT Virtual UG

What is Power BI?

August 2017

SQL Saturday Atlanta

What is Power BI?

July 2017 Atlanta, Georgia, United States

Angela Henry

Data mover and shaper. Data Platform MVP

High Point, North Carolina, United States