business intelligence
LUCRUM Radio Interview
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 how I got involved in social [...]
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 shows data [...]
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 be [...]
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 [...]
Reorganizing clients in Darwin provides opportunity for SQL Server clean-up
This is a post where I share more of the technical aspects of my job as a ‘conscientious programmer/analyst’. The company I work for is reorganizing clients into new databases in the Darwin business system (a customized version of Microsft Great Plains Dynamics), and the business sees this as a great opportunity to clean up [...]
05 Nov 2007 – Utterz from the road
Three topics discussed: Effects of Daylight Savings Time ending one week later this year, especially on the commute home. New Media Cincinnati: http://www.newmediacincinnati.com or http://danieljohnsonjr.com/2007/11/new-media-cincinnati-meetup-november.html Dashboard-types of reporting I’ve been doing to provide a good pulse on the company. I love doing this kind of marketing-type of analysis. Hear all my Utterz: http://www.utterz.com/~h-danieljohnsonjr/list.php —–Check out [...]
Keeping upper management knowledgeable and salespeople paid
This is another post where I share technical details about a project I have been working on. SITUATION Sales executives within the company receive monthly commission checks based on active client employee counts and gross payroll, for clients that they have brought on. In addition, upper management needs to see high-level numbers such as active [...]
