Saturday July 22nd 2017

Categories

Insider

Archives

‘Training & Consulting in Crystal Reports’ Archives

How to categorize transnational data by phases if the information about phase is not stored in transactions table ?

How to categorize transnational data by phases if the information about phase is not stored in transactions table ?

How to aggregate transnational data by phases if the information about phase is not stored in transactions table. Recently I encountered a scenario where I have to aggregate the information about Account holders spending transnational history by different phases, let's say there were 3 phases in which these transactions were falling. Transaction [...]

BI Demo

BI Demo

What are Dimensions and Measures?

What are Dimensions and Measures?

This video explained very well the concepts of dimensional model.

Star Schema – Fact table a closer look

Star Schema – Fact table a closer look

In this post we are writing more on factt table in star schema because we believe that clear concept of fact table and its creation is critical to understand the difference between OLTP Relational Database’s logical model and then its de-normalization to create Star schema, which have fact table in the centre. We found some useful writings [...]

Process From OLTP datamodel to Olap DataModel

Process From OLTP datamodel to Olap DataModel

This present s an example showing the process to denormalization for dataware house or data mart Star schema. We researched on this topic in various books and even Microsoft examples they only give sample, but we think it is more important to know how oltp data model is converted in Star schema or olap. We used Microsoft’s Northwind data [...]

Best tool for Dynamic Website – CMS

Best tool for Dynamic Website – CMS

So far we have tried many dynmic web softwares which are also known Content Management System. They run on top of database or inother words all the information is saved in database. we used ASP classic and SQL Server 2000 database and had our hand wet with vb scripting, it was in the late 90s and early 2000. then microsoft used asp.net. Then we [...]

As BI Consultant and Data Analyst – Gateway Laptop Rocks – HP-Toshiba Sucks

As BI Consultant and Data Analyst – Gateway Laptop Rocks – HP-Toshiba Sucks

We would like to share our experiance of using Laptops from Gatway, HP and Toshiba. As a database and BI consultant Laptop is like my tool to write, present and design just like a pen is to an author. Over the years of experiance in using laptops for my professional career I found Gateway the best, whereas HP and Toshiba I would sad to say Sucks. [...]

key not valid for use in specified state in SSAS 2008

key not valid for use in specified state in SSAS 2008

I recently faced this issue which deploying a Sql Server Analysis Project 2008, however was able to resolve by doing the following; I did, go to services, change the SSAS service to use the local / admin account. this error will then vanish.

Quality Control

Quality Control

Quality Control - (a) Planned systematic activities necessary to ensure that media conforms to established technical requirements. (b) All actions that are taken to ensure development of products that meet performance requirements and adhere to standards and procedures. (c) Policy, procedures and systematic actions established in an enterprise for [...]

Data Quality Strategy – SQL Server Technical Article

Data Quality Strategy – SQL Server Technical Article

This post ic about Data quality which always done in every organization it is presented here in more formal words: Primary goal of a data integration solution is to assemble data from one or more data sources. As you bring data together, you are likely to find a broad range of data quality issues that require attention. For example, you may [...]

 Page 1 of 3  1  2  3 »