Tracking S&P 500 Using Power BI
S&P 500 index is an American stock market index consisting of 500 large companies and is considered to be the...
2015-08-17
2,613 reads
Samuel Vanga
Replace Blank Values to NULL in SSIS
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
15,323 reads
Iterate Over Web Pages Using Power Query
Power Query makes it easy to pull data from a web page. As easy as deflating a football. Poof. Gone. However,...
2015-08-10 (first published: 2015-08-05)
3,891 reads
Baltimore Crime Report Using Power BI
As part of my quest for using data to find answers to everyday questions using Power BI – after analyzing baby names...
2015-08-06 (first published: 2015-07-27)
3,168 reads
Community Reactions to Power BI General Availability
Power BI is released to the public on Friday, 07/24. There’re both free and Pro versions. For full details about...
2015-08-03 (first published: 2015-07-26)
1,994 reads
Include File Name in Content Using Power Query
When importing data from a flat file using Power Query, you’d want to combine multiple files and include file name...
2015-07-28 (first published: 2015-07-21)
26,767 reads
Are People’s Food Habits Changing? A Power BI Analysis
A few years ago on road trips I’d happily grab whatever I can find to eat at service stations. That...
2015-07-14 (first published: 2015-07-07)
2,599 reads
Automating SSIS Design Pattern: Load Flat File Into Staging Table
Delimited flat files are commonly used to move data from one system to the other.
In this two part series published...
2015-07-14
777 reads
Automating SSIS Design Pattern - Stage Delimited Flat File
How long does it take to create to 100 staging packages? The answer will shock you!
2015-07-13
9,709 reads
I’m on WOxPod! Podcast
A few weeks ago, while at SQL Saturday Philadelphia, Chris Bell, SQL Server MVP and co-leader of PASS DC user group graciously...
2015-06-29
846 reads
Blogs
Replacing Images in PBIR Format Reports
With the PBIR format of Power BI reports, it’s much easier to make report...
Capturing Ideas for Blogs
By Steve Jones
As we close out the year, I decided to drop this post here and...
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Forums
create multiple output files based on query
I have this script that puts all of the output from query to a...
what if my last resort on extracting excel is at the cell level?
Hi, after i copy in ssis my excel file to a secured folder, its...
dont see a file system task approach to copying excel
Hi , rather than the approach at https://stackoverflow.com/questions/68314594/copy-an-excel-sheet-and-move-to-a-new-location-using-ssis where content rather than file level...
Question of the Day
What is Terraform?
What is Terraform (from Hashicorp) used for in technology?
See possible answers