business intelligence
LUCRUM Radio Interview
powerpress_play_page(’http://media.danieljohnsonjr.com/LUCRUM-Radio_Daniel-Johnson-Jr.mp3′, ‘powerpress_player_143′);
Podcast: Play in new window
| Download
I recently had the pleasure of being interviewed on LUCRUM Radio with LUCRUM Marketing Manger David E. Bowman. Over some coffee at Winan’s in Vandalia, we talked about my experience in business intelligence and new media, with a bit of marketing mixed in.
David started off by asking about [...]
Special Date Functions in SQL, Part 1
For our internal dashboard work, we’re looking at metrics for the previous month. While I could create a SQL Server stored procedure to pass these dates from a user form, I really want to create a SQL view that will show last month’s information. That way, whenever the view is opened, it always [...]
Business Intelligence and Data Warehousing TeleForum Notes
Today I participated in a NOREX member TeleForum on Business Intelligence (BI) and Data Warehousing (DW). I’m including my notes taken here:
Started off by defining BI and DW. I like the Wikipedia definitions myself. Also discussed what Master Data Management is; i.e., managing data that has become aged and may or may not [...]
Successful online monitoring with Google Alerts and RSS
Are you using Google Alerts and RSS feeds to track your company’s presence on the internet? How about competitors?
Since this blog reflects me personally, I choose to omit specific company names. As the disclaimer says, opinions and thoughts expressed here are my own and not of any employer, past or present.
A few months [...]
Finding Tables for Employee Census Report
This is one of the posts where I describe the more technical aspects of a project I’ve been working on. The contents here are meant mainly to trigger my own memory when needed in the future.
The HR department has requested a census report so that the company can shop around for benefits with other [...]
