grab our rss feed

stevienova.com

Homepage of Steve Novoselac

Entries Tagged ‘BI’

Agile in Business Intelligence? Of Course!

About 3.5 years ago I was introduced to Agile at the Agile 2006 Conference. After that, and implementing it in a software dev environment, I found that it just works. Sprints, Scrums, Stories, Backlog, Velocity, all the pieces fit and work.
Now that I am managing a Business Intelligence group, which when I started wasn’t doing [...]

Comments | 218 views

Microsoft BI: Creating Local OLAP Cubes using XMLA and ascmd.exe

Most people, when using OLAP cubes, are hitting the live version that is located on SQL Server Analysis Services (SSAS). They hit it with Excel, or some other reporting tool, etc. I have blogged previously about offline cubes and how you could possibly use them.
Now, the blog I did before, I talked about creating [...]

Comments | 2,066 views

Blogging in 2009

I have been looking through some of my Google Analytics logs, and I really find it funny. The top 3 posts on my blog really don’t have anything to do with stuff I am really into, but they are more things that I did in my spare time and blogged about.
1) Linux on my Ps3
2) [...]

Comments | 518 views

Microsoft BI Client Tools: Creating PivotTables in Excel 2007 that work in Excel 2003

Recently I blogged about easing the transition to Excel 2007 from Excel 2003, by changing your PivotTable design and options.
This post is going to be about creating PivotTables that connect to OLAP cubes (and PivotTables in general) that will work in either client, or sometimes called “Compatibility Mode“
If you create a PivotTable in Excel 2007 [...]

Comments | 1,147 views

Big Change #3 – New Job

Recently, in May 2008, I took a position with Stratagem. Though the summer I worked for 2 places as a consultant, KHS in Waukesha, and The Dept. Of Regulation and Licensing (DRL) in Madison.
A little history. I was full time for W3i around 2 years, and then went independent for about a year, then as [...]

Comments | 827 views

Business Intelligence and Analysis Services in the “Real World”

A reader sent me an email this weekend:
I wonder if I could as your advice as a BI / Data warehousing specialist.I have been studying Analysis Services recently having read a couple of books Which step me through the process of building the cubes etc but as I don’t come From a DB background one [...]

Comments | 930 views