dashboard
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 [...]
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 my other blogs:Journey Inside [...]
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 clients, [...]
