Sign in
|
Help
Sign In
Home
Blogs
Forums
Wikis
Groups
Blogs
Tags
Analysis Services Tuning MDX SQL Server 2008
BI
BI Events
BI Exams
BI Methodology
Business Intelligence
CBIP
Conferences
cube
Cumulative packages
Data Mining
Donald farmer
Excel
Excel 2010
Excel Source
For Each Loop
Foreach Loop
Kimball
SharePoint
sql 2008
SQL Server
SSAS
SSIS
StepByStep
TDWI
View more
Blogs
RSS Syndication
Opml
Blogs on this Site
Sort By:
Most Recent
|
Most Viewed
|
Most Commented
StepByStep - SSIS Using Package Configurations
Dear friends, Today I’ll add to the community a new type of post, a StepByStep post, based on the support that I usually provide to users from MSDN Forums and Experts-Exchange… some real examples and real scenarios from real world. I'm...
Posted to
BI Blog
by
PedroCGD
on 05-13-2009
Filed under:
Package Configurations
,
SSIS
,
StepByStep
BI Certifications - CBIP/TDWI Certifications done!
I started writing this post on the return trip to Portugal. It was a very enriching and experience trip, which I reached one more objective I had in mind for more than two years. I passed the four exams and got the specialization in Business Analytics...
Posted to
BI Blog
by
PedroCGD
on 11-13-2009
Filed under:
CBIP
,
TDWI
,
Certifications
,
BI Exams
Excel 2007/2010 Pivot Tables: Getting detailed/granular table reports from OLAP… in seconds!
Well, I’ve been delaying & postponing this post. Being the main reason having some assurance that this could have some actual value :). Really, I’m not sure, but anyway, here it goes! A few weeks (actually I think I now can say months…...
Posted to
Rui Quintino BI
by
Rui Quintino
on 07-25-2010
Filed under:
Performance
,
Excel
,
Analysis Services
,
Pivot Tables
,
MDX
,
OLAP
BI Resort - Apresentação
Este é o meu primeiro artigo nesta comunidade BI sendo um pouco uma introdução, e como tal, gostaria antes de mais, desejar que seja um ponto de encontro para todos os estudantes, professores e profissionais na área de BI,...
Posted to
BI Blog
by
PedroCGD
on 05-10-2009
Filed under:
BI Resort
DevDays DAT302, Tuning & understanding MDX Query Performance in SQL Server 2008 Analysis Services
A little bit late I know , but now in english,. Thanks for the "heads up" Pedro. Anyway, here it is, all the materials I've used on the DevDays session.Notes of interest: Report/Dashboard that shows the mdx trace log, properly organized...
Posted to
Rui Quintino BI
by
Rui Quintino
on 08-07-2009
Filed under:
Analysis Services Tuning MDX SQL Server 2008
BI SSAS - What is an OLAP cube?
I was answering some questions at Experts-Exchange website and found an interesting question with an even more interesting, simple and objective answer wrote by Josh. I did not resist to share with you… could be very intuitive for the beginners…...
Posted to
BI Blog
by
PedroCGD
on 06-04-2009
Filed under:
SSAS
,
cube
Predictable Changes with Multiple Version Overlays
There is a technique in Kimball's "Data Warehouse toolkit 2nd" book that is suggested for Predictable Changes with Multiple Version Overlays situations. It was a bit intangible for me what Kimball means for that solution, but I could understand...
Posted to
BI Solutions
by
Amin
on 11-13-2009
Filed under:
SCD Type 2
,
SCD
,
Kimball
The Olap Report: Commentary on Project Gemini
Nigel Pedse of the The Olap Report has posted a commentary on Project Gemini: http://www.olapreport.com/Comment_Gemini.htm He also has posted a preview review of Gemini (available to subscribers).
Posted to
João Bilhim
by
joaobi
on 04-08-2009
Filed under:
Business Intelligence
,
SQL Server
Webcasts on SQL Server 2008 relational data warehousing
Joe Longtin has several interesting webcasts on the relational DW features in SQL Server 2008. Check it out at: http://channel9.msdn.com/posts/Joe+Longtin/
Posted to
João Bilhim
by
joaobi
on 07-06-2009
Filed under:
Business Intelligence
,
SQL Server
SQL Server 2008 Star Join Paper
A paper about star joins in relational Datawarehousing scenarios with SQL Server 2008 called "Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries" has been recently added to the MSDN Library: http://msdn.microsoft...
Posted to
João Bilhim
by
joaobi
on 09-09-2009
Filed under:
Business Intelligence
,
SQL Server
SQL Server 2008 Integration Services Metadata Toolkit
The SQL Server Metadata Toolkit has been updated to SQL Server 2008. You cane get it at: http://sqlmetadata.codeplex.com/
Posted to
João Bilhim
by
joaobi
on 12-11-2009
Filed under:
Business Intelligence
,
SQL Server
Office 2010 Beta Developer Training Kit
The Office 2010 Beta Developer Training Kit features, among other interesting content, a "Developing BI Applications" set if videos, presentations and labs. Thhe kit is available at: http://www.microsoft.com/downloads/details.aspx?displaylang...
Posted to
João Bilhim
by
joaobi
on 12-16-2009
Filed under:
Business Intelligence
,
SQL Server
All you need to know about Microsoft Business Intelligence
The recordings from Rafal Lukawiecki BI session in Sweden are live on Channel 9: Session 1
Posted to
João Bilhim
by
joaobi
on 01-07-2010
Filed under:
Business Intelligence
,
SQL Server
PowerPivot for Excel CTP3 Fixed
The refresh for the November CTP of PowerPivot that fixes the expiration issue is online at www.powerpivot.com
Posted to
João Bilhim
by
joaobi
on 04-07-2010
Filed under:
Business Intelligence
,
SQL Server
Donald Farmer @Portugal | 16 April 2010
If you would like the unique opportunity to get to know better PowerPivot and interact with Donald Farmer ( http://www.beyeblogs.com/donaldfarmer/ ), don't hesitate and register for the community event: www.biresort.net
Posted to
João Bilhim
by
joaobi
on 04-07-2010
Filed under:
Business Intelligence
,
SQL Server
1
2
3
Next >