Ashish Jaiman's Blog

Microsoft SQL Server 2005 Analysis Services (SSAS) provides three tools for deploying an Analysis Services database onto an Analysis Services server in the production environment: · Using an XML Script Use SQL Server Management Studio to generate an...

SQL 2005 is an integrated platform to create Data Warehousing applications, data mining tools are consolidated into two working environments in SQL 2005. Business Intelligence Development Studio and SQL Server Management Studio SQL 2005 has a number...

PivotTables are designed to help users make sense of large amounts of data by providing an easy way to quickly reorient the data and build a summarized report. Main improvements in the Pivot table interface which makes the user productive are A...

SharePoint server deliver centralized access to information. SharePoint portal server makes it easy to create live, interactive business intelligence (BI) portals that assemble and display business-critical information from disparate sources, using integrated...

Close integration of Windows SharePoint Services with Microsoft Office Client(s) for authoring, publishing, organizing, and finding information helps users get up to speed quickly. Integration with Office Client applications m ake it easy for users to...

The ability of SSIS to integrate different technologies manipulates data, like “fuzzy logic” based data cleansing components. Support for complex data routing in SSIS allows anomalous data to not only be identified, but also be automatically corrected...

§ Provide a single workspace to coordinate schedules, organize documents, discussions within the organization and over the extranet. § Easily author and manage documents, with check out, versioning capabilities and recycle bin facility. § Blogs...

SSRS 2005 has many improvements over SSRS 2000. Specifically in the following four areas 1. Core Product Improvements a. Direct Client Printing b. End user Sort c. Multi valued parameters d. Custom Report Items 2. Integration a. Analysis...

The new visualization feature of Excel 2007 provides users several methods of graphically representing numerical data, making it easier for them to understand relationships and trends. User can add data bars to the columns of data, allowing them to visually...

Excel Services gives users a way to deal with challenges related to sharing and versioning of spreadsheets. Using Excel services, a spreadsheet author is able to save their spreadsheet to a SharePoint document library and give other users browser-based...

WSSV3 is a web site provisioning engine which helps the enterprise to create secure web sites for both intranet and extranet environment enabling collaboration and information sharing. Windows SharePoint services are technology to improve efficiency...