BI Architect Bill Pearson continues his discussion of Partition planning for Analysis Services, this time focusing on the settings and properties involved from a SQL Server Management Studio perspective.  Read more...

This, the first in a series of three articles, describes the history of information workers and discusses their characteristics. The next article will describe how to leverage the latest BI technologies, and the final article will address how to improve information consumability.  Read more...

This paper discusses the integration of SAP NetWeaver BI ® with Microsoft ® SQL Server ® 2008 Reporting Services (SSRS). The paper provides an overview of using the Reporting Services SAP Netweaver BI data provider and related query designer, to build high quality reports against SAP NetWeaver BI sources. For Reporting Services users who are new to working with SAP NetWeaver BI, this paper will help you connect and build datasets. For users already familiar with SAP NetWeaver, the paper will show how some of that system’s notable features can be leveraged in Reporting Services reports. It also presents some tips and tricks that can help you make the most of the integration between the two products.  Read more...

When developing Reporting Services reports that use Analysis Services as a data source you may find that it is difficult...  Read more...

In this article, we'll see how you can use the Foreach loop and the Expression Language to create multiple, dynamic outputs through object reuse.  Read more...

Join BI Architect Bill Pearson as he continues to explore attribute discretization, as a part of an extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.  Read more...

August 2009 Business Intelligence: Planning Your First Microsoft BI Solution Even BI novices can learn what goes into creating a BI solution, from planning and designing a data mart to preparing data. An Adventure Works example illustrates the first steps a company can take to ensure that its BI solution supports the strategic decisions it needs to make. Stacia Misner Business Intelligence: Building a Data Foundation for a BI Solution See how you can design and build a data mart that uses SQL Server 2008 Integration Services to perform the extract, transform and load (ETL) processes for the Adventure Works BI solution introduced in "Planning Your First Microsoft BI Solution." Derek Comingore  Read more...

Even BI novices can learn what goes into creating a BI solution, from planning and designing a data mart to preparing data. An Adventure Works example illustrates the first steps a company can take to ensure that its BI solution supports the strategic decisions it needs to make. Stacia Misner  Read more...

When an enterprise first encounters master data management, it often doesn’t have a clear understanding of how MDM will affect the architecture of its business transaction systems or business intelligence systems. This article describes master data patterns in legacy system architectures, a general MDM architecture and some ways the new MDM layer affects the master data patterns in the legacy layers.  Read more...

Join BI Architect Bill Pearson as he continues his overview of Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution. In this article, we begin a hands-on overview of the use of the Automatic discretization method.  Read more...

Fast analysis, better insight and rapid deployment with minimal IT involvement: these are among the benefits of in-memory analytics, but different products are appropriate for different environments. Read our in-depth report on in-memory technologies.  Read more...

One of the main features of Oracle Business Intelligence Publisher (BIP) is its ability to connect to pretty much every major RDBMS on the market. Steve Callan shares the little documented steps of how to establish a connection to SQL Server.  Read more...

How can you do more with less? Follow this data warehousing/BI strengthening regimen to cut cost, avoid expenditures and bulk up the bottom line.  Read more...

Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.  Read more...

Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.  Read more...

Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.  Read more...

Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.  Read more...

These days more and more systems gather data all the time, but are we using that data? Steve Jones comments on the glut of information and some of the problems that creates.  Read more...

These days more and more systems gather data all the time, but are we using that data? Steve Jones comments on the glut of information and some of the problems that creates.  Read more...

These days more and more systems gather data all the time, but are we using that data? Steve Jones comments on the glut of information and some of the problems that creates.  Read more...