Another tool within BI platform to use when you have the huge farm of Analysis Services data warehousing & mining database setup at your end. So the provision of BI within SQL Server 2005 is a complete enterprise-ready and scalable data warehouse platform you can set, with the features and functionality...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
03-13-2008
Filed under: sql server, management, webcast, bi, tools, reporting services, elearning, performancepoint, business intelligence, 2007, training, office
When do you need data partitioning? The data you see in relational database may need such a strategy if the volume is huge, for instance the data to store event-log information having the schema such as: [Id] INT (make this primary key clustered), [Unit_Id] UNIQUEIDENTIFIER, [EventType_Id] UNIQUEIDENTIFIER...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
03-12-2008
Filed under: sql server, performance, indexes, data, backup, bi, database, statistics, partition, monitoring, strategy, data warehouse
So far the SQL Server 2008 Analysis Services new features were included until October CTP, top features that Microsoft would like to include within RTM version: New Aggregation designer - to browse and modify aggregation designs that are now shown grouped by measure group. Simplified and enhanced Aggregation...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
02-25-2008
Filed under: sql server, performance, ssis, bi, ssrs, 2008, new, reporting services, enhancement, samples, business intelligence, integration services
One of the [SSP] forum user asked about what is OLAP, how the process flow occurrs when update happens to a fact table! It sounds like the basic question for Analysis Services user, OLAP - On-Line Analytical Processing for BI - Business Intelligence is useful for a fast and interactive access to aggregated...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
02-11-2008
Filed under: sql server, technet, bi, olap, dimension, table, whitepaper, cube, business intelligence, architecture, fact, what if
Business Intelligence (BI) - is the new term from Microsoft for all Data Warehousing & Data Mining requirement since the SQL Server 2005 version is released. Say many organization face challenges with the Data Explode, this BI offers management and development tools for IT department and Business...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
02-08-2008
Filed under: sql server, management, microsoft, bi, data mining, labs, development, testing, business intelligence, links, operation guide
Got this update from SQLCAT blog on MSDN about new whitepaper on Analysis Services many-to-many dimensions that helps in MDX query performance optimization steps you need to take care. Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex...
Business Intelligence & Application Platform Virtual Conference Thursday, October 4, 2007 - Online Event Learn How IT Can Drive Business Solutions Is your IT organization in lock step with your business leaders? To stay competitive, IT leaders are now required to take a primary role in delivering...
Microsoft released PerformancePoint Server’s LAST Community Technical Preview (CTP) before launch! To date, the CTP program has gathered close to 10,000 members and the product has been enjoying fantastic pre-launch press and analyst coverage. For more information refer to ThePremiers blog. This is much...
If you would like to share your experience in managing Business Intelligence products and applications that are used in business/corporate/enterprise performance management, as a whole it is called OLAP. This survey is to help in identifying the trends and issues in BI market, "The BI Survey"...
I don't mean to say physically, but managing and mastering your data . THE ROLE OF DATA WAREHOUSING IN BI STRATEGIES We know all to well that information is King. But simply managing that data is not enough. During this on-demand program our experts will present an enterprise class data warehouse...