‘Business Intelligence’ Archives
Changing a Traditional information system to adapt new technologies for effective decision making
This is about an experience of an anonymous writer of this post describing his/her hands on experience in upgrading company’s information to adapt to new technologies for effective decision making and resultantly growth of the company. This post also reveals that how the hands on experience sets the foundations of understanding new [...]
Change in business rule and its impact on Data model.
This post explains the extension in data model resulting from change in business rule. A Prime Group is a steel rolling mills and Export Company having its offices in Dubai and Pakistan. This project was to create /upgrade database and creating Crystal Reports to facilitate changes in business rules and expansion in manufacturing [...]
Fastly changing dimensions
This post is about fast changing dimension, for example A customer dimension may have large number of attributes and many rows. It happens sometimes in the "customers" are health insurance policy claimants, and other times they are owners of motor vehicles. We found a usefull material on Fast change management of Complex dimensions written by [...]
Practicality of Floor function in SQL Server
We are writing this post to share our experience of usefulness of Floor function. We use the floor function in calculating product manufactured and raw material wastage in the process. The problem was to calculate how many units of a product can be manufactured from certain weight of a raw material. We were getting answer like 8.67 products [...]
sql server 2008 adventureworks – cannote deploy Cube
This post is response to problems in deploying Adventureworks 2008 cube. I faced connectivity issues to Analysis services on deploying Cube, when I only have the SQL Server 2008 Express edition. It is not clear what exactly can be achieved with SQL Server 2008 Express edition only. So I downloaded the Sql Server 2008 evaluation edition and [...]
Pivot Table with Excel 2007 with data from Sql Server
This post is about using pivot table with excel 2007 with invoice payments received data from sql server. In this case company’s payment mechanism was changed from full 1 payments to breakup in 4 to 5 payments. We created a new table named payments received and linked it to the Invoices table. Whenever payment for certain invoice received it [...]
MDX query Builder in Sql Reporting services 2008
I would like to share my hands on experience of Query builder in SQL Reporting Services 2008. We created a report in Sql Reporting Services 2008 utilizing Analysis Services Database. We can create MDX queries by drag and drop Dimension and measures in their respective areas. MDX code will be automatically generated and can be viewed by pressing [...]
data ware house by linking data marts
This post is about building data ware house by linking data marts and some precautions. Be aware that building data ware house by linking data marts can be very troublesome because of possible significant difference in the structure and design of existing data marts. Different parts of an organization may use different data s and [...]
Case Study: Building an Analytical Data Mart for Credit Cards at the Bank of Montreal
Bank of Montreal embarked upon building a data mart for its credit card portfolio at a time when many banks and solution providers were focusing upon "enterprise-wide" solutions. However, the challenges facing the bank’s card portfolio were not inconsiderable, and the bank was forced to choose between quickly saving the card portfolio and slowly [...]
Experiance of installing SQL server 2008 Express and Evaluation edition
I would like to share my experiance of installing SQL server 2008 Express and Evaluation edition. To day I installed the Sql Server 2008 express and Sql Server 2008 Evaluation edition on Windsows XP. The following steps are must for installing SQL Server 2008. 1- Windows XP SP2 and SP 32- Step 1: Download and install Microsoft .Net Framework [...]
