‘Sql Reporting Services’ Archives
OLAP Vrs OLTP
Online-Line analytic Processing is optimized for questions like for example What sales people generate revenues or make sales more than $45,000 during the Christmas and there sales orders were not returned during first 45 days of making sales. Olap is highly summarized and aggregated data. In Olap Data is stored and accessed from [...]
Business Intelligence defination for Business Managers
Business Intelligence Solutions are built on top of the rest of the infomration platform to provide consolidated, reconciled information typically for management consumption. Business Intelligence is subject often very closely tied with data warehousing and focused on the exploitation of data for the benifit of Business(reporting, decision support [...]
SQL Reporting Services 2008 Nice features
Some good features in SQL Reporting Services we would like to write here; 1- Enable business users to create their own reports and explore corporate data by using Microsoft Report Builder 2.0, an intuitive and familiar Microsoft Office-optimized authoring environment. Report Builder 2.0 enables users to go directly against relevant data sources [...]
Canned / readymade reports
Few words about Datamart.org services; Many times our clients have bought softwares for businesses like Healthcare, Accounting application or any business. Sooner or later there reporting needs surpassed the information provided by canned reports. Software vendors usually charged premium price for modifying or creating custom reports. We [...]
Data Mart Schema
Analyses and understanding of the reporting needs, in depth research on their business questions and how do they want that data presented are the basis for the design of the data mart schema. For more info on Stars, Snow Flakes, Fact Tables Schema for multidimensional Databases- visit http://datamart.org/?p=23
Business Intelligence and MS Sql Server 2008
Microsoft Sql Server 2008 Provides tools to support all Aspect of Business Intelligence; Integration Services – Enables us to create automated processes for data cleansing and import into Data Ware house and Data marts. Online Analytical processing (OLAP) features i.e Key performance indicators (KPIs), Multidimensional expressions [...]
Data mart and Historical Data
For example an employee who has been rotated in different departments with different benefits and salary. A data mart allows the company to record the move, and reflects the change in the database. Without record of employee history or this slowly changing dimension, It would be very hard to performance analyses of employee. Over time, [...]
Deploying Enterprize Reports on Sql Server Reporting Services
January 11th, 2009 No comments On my recent project I was assigned to prepare a report for Online Ticket Status count by different departments. Report was very simple it involved presenting a data from Company’s Sql Server 2005 database server. With little help from documentation I easily deployed the report on Sever where employees can easily [...]
