Sunday January 21st 2018




‘Data Mining’ Archives

Difference between DMX and MDX

Difference between DMX and MDX

DMX stands for Data Mining Extensions. The DMX is similar to SQL language and contains statements for data defination and data manipulation. the data defination language includes statements for model creation and data manipulation language contains statements for training the model which includes inserting data into the model and retrieving [...]

Heterogeneous Databases and Legacy Databases

As we are driven by the goal making information technology understandable by business decision makers and end-users, therefore when ever we find any simple word made unnecessarily technical term, we made best efforts to make them original / understandable. So Legacy database is a group of heterogeneous data bases that combines different kind of [...]

Data Governance and Metadata

The Metadata literally means information about data. Metadata specifies how a company is going to store and interpret data. Metadata also specifies how data rolls up to become the metrices and KPI's that organizations use to drive every day business decisions. It is critical that the way these items are calculated is consistent throughout an [...]

Micro strategy 9 enables departmental BI

This information is from Microstrategy 9 Press release 2009. The main spirit of this specific topic is Setting up new departmental BI Environment quickly, with little or no IT Support. I found that an ideal solution as in my experience a lot of time is wasted during the process of understanding business end users needs and perception by pure [...]

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 [...]

Crosstab report of quarterly debits by years

This is similar query with only 1 difference i.e accountid. It show same results by accountid grouping. It will help to analyze quarterly expenses by different accounts during 2004 and 2005. select accountid, datepart(year, transactiondate) ‘year’, sum(case datepart(quarter, transactiondate) when 1 then debit else 0 end)q1, sum(case [...]

Data Mining Overview

May 30th, 2008 No comments Data Mining can be called as knowledge discovery consist of following steps; Data Cleaning Data cleaning mean removing inconsistent data, verify that data is correct and according certain rules. for example column grades may have A,B,C. Data Selection; Relevant data is extracted from database. i.e If we are [...]