Wednesday, September 25, 2013

Winston Churchill was a Data Analyst

"However beautiful the strategy, you should occasionally look at the results." -Winston Churchill

Tuesday, September 24, 2013

Script I used to populate DimDate from AdventureWorks with current data

WITH mycte AS
    
(
    
SELECT CAST('2012-01-01' AS DATETIME) DateValue
        
UNION ALL
    
SELECT DateValue + 1
        
FROM mycte
        
WHERE DateValue + 1 < '2013-12-31'
    
)INSERT INTO dimdate
    
SELECT CONVERT(VARCHAR, DateValue, 112) AS DateKey
            
, CAST(DateValue AS date) AS FullDateAlternateKey
            
, DATEPART(dw, datevalue) AS DayNumberOfWeek
            
, [dbo].[FormatDateTime] (DateValue, '[dweek]') AS DayNameOfWeek
            
, dbo.FormatDateTime(DateValue, '[d]') AS DayNumberOfMonth
            
, DATEPART(dy, datevalue) AS DayNumberOfYear
            
, DATEPART(ww, datevalue) AS WeekNumberOfYear
            
, dbo.FormatDateTime(DateValue, '[MONTH]') AS MonthName
            
, dbo.FormatDateTime(DateValue, '[M]') AS MonthNumberOfYear
            
, DATEPART(q, datevalue) AS CalendarQuarter
            
, DATEPART(yyyy, datevalue) AS CalendarYear
    
FROM mycte
            
OPTION (MAXRECURSION 0)


I'll include a new script that will populate the other tables with good dates some time later.

Sunday, September 22, 2013

Quote on Business Failure

"I can't give you a surefire formula for success, but there is one for failure: Try to please everybody all the time." Herbert Bayard Swope

Saturday, September 21, 2013

Thomas Edison Believes in Iterations, Too!

"I have not failed. I've just found 10,000 ways that won't work." -Thomas Edison

Friday, September 20, 2013

Hugh Prather speaking to Agilists

"It's simple: if I never try anything, I never learn anything."-Hugh Prather

Quote for Agilists

Salman Rushdie speaking to agilists: "A bit of this and a bit of that is how newness enters the world."

Thursday, September 19, 2013

Quote

"If one FELT successful, there'd be so little incentive to BE successful." Alain de Botton

Wednesday, September 18, 2013

Louis L'amour Speaking to Future Agilists

"Are you where you want to be if it doesn't work?" - Louis L'amour speaking to future agilists.

Tuesday, September 17, 2013

Einstein Quotes on Education

"It is,in fact, nothing short of a miracle that modern methods of instruction have not entirely strangled the curiosity of inquiry" Einstein

Monday, September 16, 2013

Quote from Edmund Burke

"Hypocrisy can afford to be magnificent in its promises; for never intending to go beyond promises, it costs nothing."-Edmund Burke

Sunday, September 15, 2013

Love this Quote from Bertrand Russell

"In all affairs, it's a healthy thing now and then to hang a question mark on the things you have long taken for granted"-Bertrand Russell

Saturday, September 14, 2013

Quote

"Whoever best describes the problem is the one most likely to solve it." -Dan Roam (Back of the Napkin)

Friday, September 13, 2013

Another Quote on Education

"Self-education is, I firmly believe, the only kind of education there is." Isaac Asimov

Thursday, September 12, 2013

Wednesday, September 11, 2013

Business Intelligence Quote

"Praemonitus praemunitus (forewarned is forearmed)" -Even the Roman's depended on business intelligence.