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

BYO Time Zone Conversion With SSAS DMVs

by Meagan Longoria

Data Savvy

This is just a quick note (since I apparently forgot and was puzzled for a moment) that the MDSCHEMA_CUBES DMV...

2016-09-21

485 reads

DAX Date Dimension and Fun with Date Math

by Meagan Longoria

Data Savvy

I was working on a SSAS Tabular 2016 solution for a project for which I had no data (an empty...

2016-09-03

646 reads

Create a Date Dimension in Azure SQL Data Warehouse

by Meagan Longoria

Data Savvy

Most data warehouses and data marts require a date dimension or calendar table. Those of us that have been building...

2016-08-11 (first published: 2016-08-06)

2,448 reads

PolyBase Is A Picky Eater – Remove Carriage Returns Before Ingesting Text

by Meagan Longoria

Data Savvy

Update: As Gerhard points out in the comments, switching to ORC files solves this issue nicely. It’s not human readable,...

2016-08-09 (first published: 2016-08-01)

2,140 reads

Using Context To Traverse Hierarchies In DAX

by Meagan Longoria

Data Savvy

My friend and coworker Melissa Coates (aka @sqlchick) messaged me the other day to see if I could help with a...

2016-07-28

797 reads

BimlScript – Get to Know Your Control Nuggets

by Meagan Longoria

Data Savvy

This is post #2 of my BimlScript – Get to Know Your Code Nuggets series. To learn about text nuggets, see my...

2016-07-01

466 reads

BimlScript – Get to Know Your Code Nuggets

by Meagan Longoria

Data Savvy

In BimlScript, we embed nuggets of C# or VB code into our Biml (XML) in order to replace variables and...

2016-06-30

942 reads

Colorblind Awareness and Power BI KPIs

by Meagan Longoria

Data Savvy

Update: The ability to change the color of a KPI was delivered in August 2016!
Color blindness, or color vision deficiency (CVD)...

2016-04-23

588 reads

Trekking through the DAX Jungle In Search of Lost Customers

by Meagan Longoria

Data Savvy

I like to think I’m proficient at writing DAX and building SSAS tabular models. I enjoy a good challenge and...

2016-03-01

457 reads

Creating a Matrix in Power BI With Multiple Values on Rows

by Meagan Longoria

Data Savvy

This week I was asked to create a matrix in a Power BI report that looks like this:
Matrix with Values on...

2016-01-09

1,300 reads

Blogs

T-SQL Tuesday #196 – Two risky career decisions I made

By DataOnWheels

The T-SQL Tuesday topic this month comes James Serra. What career risks have you...

T-SQL Tuesday #192: What career risks have you taken?

By Mala Mahadevan

This T-SQL Tuesday is hosted by the one and only James Serra – literally...

T-SQL Tuesday #196: Taking Risks

This month we have a new host, James Serra. I’ve been trying to find...

Read the latest Blogs

Forums

OPENQUERY Flexibility

By Steve Jones - SSC Editor

Comments posted to this topic are about the item OPENQUERY Flexibility

A Full Shutdown

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Full Shutdown

Going Native with Fabric Spark Pools: The Fabric Modern Data Platform

Comments posted to this topic are about the item Going Native with Fabric Spark...

Visit the forum

Question of the Day

OPENQUERY Flexibility

Which of these are valid OPENQUERY() uses?

See possible answers