Meagan Longoria

Meagan Longoria is a consultant with Denny Cherry & Associates in Denver, CO where she shares her expertise in Microsoft BI and data warehousing through solution envisioning, architecture design, solution development, training, and blogging. She is a speaker at user groups and conferences across the country.

Website: http://DataSavvy.me

All authors

My Preferences for SSIS Design

by Meagan Longoria

Data Savvy

Lately, I have been using SSIS execution frameworks and Biml created by other people to populate data marts and data warehouses. It has taught me a few things and...

2019-08-20 (first published: 2019-08-08)

1,171 reads

Check Out the Updated Violin Plot Power BI Custom Visual

by Meagan Longoria

Data Savvy

I wrote about the violin plot custom visual by Daniel Marsh-Patrick back in February. I thought it was a good visual then, but version 1.3 has recently been released...

2019-08-13 (first published: 2019-08-01)

817 reads

Why We Don’t Truncate Dimensions and Facts During a Data Load

by Meagan Longoria

Data Savvy

Every once in a while, I come across a data warehouse where the data load uses a full truncate and reload pattern to populate a fact or dimension. While...

2019-07-25

815 reads

What You Need to Know About Data Classifications in Azure SQL Data Warehouse

by Meagan Longoria

Data Savvy

Data classifications in Azure SQL DW entered public preview in March 2019. They allow you to label columns in your data warehouse with their information type and sensitivity level....

2019-06-18 (first published: 2019-05-30)

428 reads

Turning a Corporate Color Palette into a Data Visualization Color Palette

by Meagan Longoria

Data Savvy

Last week, I had a conversation on twitter about dealing with corporate color palettes that don’t work well for data visualization. Usually, this happens because corporate palettes are designed...

2019-06-03 (first published: 2019-05-16)

1,418 reads

Storytelling Without Data?

by Meagan Longoria

Data Savvy

There are many great resources out there for data visualization. Some of my favorite data viz people are Storytelling With Data (b|t), Alberto Cairo (b|t), and Andy Kirk (b|t)....

2019-04-23 (first published: 2019-04-11)

517 reads

Power BI Now Has Keyboard Accessible Visual Interactions

by Meagan Longoria

Data Savvy

The March 2019 release of Power BI Desktop has brought us keyboard accessible visual interactions. One of Power BI’s natural...

2019-04-10 (first published: 2019-03-21)

1,883 reads

Power BI: Where Should My Data Live? Webcast

by Meagan Longoria

Data Savvy

When you start a Power BI project, you need to decide how and where you should store the data in your dataset. There are three “traditional” options: Imported Model:...

2019-03-28

41 reads