Keynote
Stephen Wynkoop
Demo: Capture perfmon counters to binary logs and at the same time capture SQL Profiler. Then you can load both into profiler and see both at the same time. Great for troubleshooting what might be causing a problem or what is happening at a particular point in time.
Historical only (not real-time)
When things go Wrong
- What changed?
- What were you doing?
- What were you seeing?
- Answer: NOTHING.
Add all the counters you need. Don’t be skimpy. Start broad and then narrow down. If you don’t record it, you can’t see it.
Intro to SSAS 2008
Marc Beacom
You can import an existing cube into BIDS which will essentially create a copy of the project that was used to create the cube. (Probably only to a certain extent)
PerformancePoint Services 101
Craig Utley
- Craig Utley, Mentor with Solid Quality Mentors
- Consultant specializing in development with Microsoft technologies and data warehousing
- Published author of books, whitepapers, articles, and courseware
- Operator of LearnMicrosoftBI.com
Performance Point Services
Monitoring, Analytics and Planning
Planning being removed in the next version
- Monitoring: Scorecards and dashboards.
- Analytics: Drill up, drill down, slicing, dicing, etc…
Performance Point ships only with MOSS. With MOSS 2010, 64-bit only, no 32-bit.
KPI Sources are usually cubes but can be other sources including SQL Server, Excel and other sources.
No Pie Charts until next version.
Financial analytics with SQL Server Analysis Services
Donald Farmer
Need to listen to the Scottish Starbucks analogy again. It was a great analogy but want to be sure I didn’t miss something.
Financial Calculations
- Currency Conversions
- Time Intelligence
- Account Intelligence
Resources
http://www.microsoft.com/sqlserver/2008/en/us/analysis-services.aspx
http://sqlblog.com/blogs/mosha/default.aspx
http://www.sqlserveranalysisservices.com/default.htm
http://sqlcat.com/Default.aspx
Full SpectrumBusiness Intelligence
Donald Farmer
These slides are masterful is telling the verbal story Donald is presenting. I am putting up a few of the key slides that will server as good reference to me.
Thanks Donald!
Data quality is “fitness for purpose”. IT cannot tell you is a record is good.
Popularity: 2% [?]
