Sam Vanga

Putting Corrections in Perspective using Power BI

• by Samuel Vanga

• Sam Vanga

My enthusiasm for analyzing stock market data using Power BI – even after publishing two posts recently (this and this) – is at...

2015-10-13

516 reads

New Article: Loading Fixed Width Files to Staging Tables

• by Samuel Vanga

• Sam Vanga

My article “SSIS Design Pattern – Staging Fixed Width Flat Files” is published on SQLServerCentral.com. In the article, I provide a...

2015-10-06

632 reads

Calculate Percentage Share in Power BI (DAX)

• by Samuel Vanga

• Sam Vanga

What’s my share? Calculating percent share of the total is a common need. Let’s see how to calculate this in Power BI...

2015-10-06 (first published: 2015-09-29)

18,191 reads

Finding Next Business Day in T-SQL

• by Samuel Vanga

• Sam Vanga

Let’s say you have a table that records transactions along with the date of when the transaction took place. Wait,...

2015-09-22

2,543 reads

How to Create Scatter Chart in Power BI

• by Samuel Vanga

• Sam Vanga

There’s a saying that birds of the same feather flock together. When you throw your data on a scatter chart,...

2015-09-25 (first published: 2015-09-14)

2,768 reads

What is the Difference Between Full Load and Incremental Load

• by Samuel Vanga

• Sam Vanga

When you start working in ETL (Extract, Transform, and Load) or SSIS projects, you’ll be faced with two basic terms:...

2015-09-16 (first published: 2015-09-08)

16,641 reads

How to Create Pareto Chart in Power BI

• by Samuel Vanga

• Sam Vanga

About 80% of the world’s population lives in about 13% of the countries. Okay, this statement is not as knee-jerking...

2015-09-01

6,488 reads

Stock Market Chart in Power BI

• by Samuel Vanga

• Sam Vanga

U.S. stock markets have taken a beating this past week fueled by China markets. Take a look at how China and...

2015-09-02 (first published: 2015-08-24)

3,280 reads

Tracking S&P 500 Using Power BI

• by Samuel Vanga

• Sam Vanga

S&P 500 index is an American stock market index consisting of 500 large companies and is considered to be the...

2015-08-17

1,534 reads

Replace Blank Values to NULL in SSIS

• by Samuel Vanga

• Sam Vanga

Blank values are annoying, anywhere and everywhere. If your source system contains them, here’s how to convert blank values to NULL in...

2015-08-11

10,560 reads