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

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

589 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

458 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,302 reads

Using a Variable to Populate the Query in a Lookup in SSIS

by Meagan Longoria

Data Savvy

I encountered a situation on my last SSIS project in which I needed to be able to populate the query in lookup...

2015-12-29

836 reads

Type 6 or Hybrid Type 2 Slowly Changing Dimension with Biml

by Meagan Longoria

Data Savvy

In my previous post, I provided the design pattern and Biml for a pure Type 2 Slowly Changing Dimension (SCD). When...

2015-12-27

610 reads

Demystifying the Type 2 Slowly Changing Dimension with Biml

by Meagan Longoria

Data Savvy

Most data warehouses have at least a couple of Type 2 Slowly Changing Dimensions. We use them to keep history...

2015-12-21

934 reads

Blogs

Why Database AI Agents need Layers?

Third part in my Ai series with databases. When building AI solutions within the...

Un-Migrating From the Cloud: T-SQL Tuesday #199

This month we have a very interesting invitation from Koen Verbeeck. He has hosted...

T-SQL Tuesday #199: Back to the on-prem

By Koen Verbeeck

It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...

Read the latest Blogs

Forums

BCA KCU PANAKKUKANG Telp/WA:0817844112

phone/Wa, Cs. 0817844112 Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi...

BCA KCU MAKASSAR Telp/WA:0817844112

By layanan_Bca88

phone/Wa, Cs. 0817844112 Jl. Ahmad Yani No.31, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan...

BCA KCU AMBON Telp/WA:0817844112

phone/Wa, Cs. 0817844112 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku...

Visit the forum

Question of the Day

Converting Money

Does this run successfully on a SQL Server 2022, US English default installation?

DECLARE @YenAmount MONEY;
SET @YenAmount = ¥1500; 

SELECT @YenAmount AS RawValue;

See possible answers