‘Data Mining’ Archives
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 [...]
