Wednesday June 21st 2017

Categories

Insider

Archives

‘Data mart’ Archives

Case Study of an Auto Insurance Company for the Data warehouse

Case Study of an Auto Insurance Company for the Data warehouse

This case study is an assignment I submitted and hence sharing with readers. ABC Auto Insurance is under immense pressure from competitors due to reduce Auto Insurance prices and high risk underwriting. ABC Company has huge data resources from business operation, however, it is difficult to get required information in timely manner. ABC Company [...]

Requirements for Marketing Database analyst

Requirements for Marketing Database analyst

Now a days computer related jobs like Data analyst which used to require the Computer science degrees now emphasize more on Business Education, which clearly shows that Business graduates should equip themselves with Information Technology and hence more opportunities in IT field in addition to traditional business related jobs. Following is an [...]

Types of Data Profiles

Types of Data Profiles

Data profiles computed by data profiling analytical techniques include: * Distinct lengths of string values in a column and the percentage of rows in the table that each length represents. Example: Profile of a column of US State codes, which should be two characters, shows values longer than 2 characters. * Percentage of null [...]

What is composite key ?

What is composite key ?

In SQL, a composite key is a combination of more than one column to identify a unique row in a table. For example in invoice table each row is uniquely identified. Here Invoice no and Product ID forms the composite Key.  Each Invoice have different products / one product should not be entered twice in same invoice. Invoice [...]

System testing

System testing

This post is about system testing, which we saw on a recruiting website, stating write something about system testing experiance, this job was for data analyst role. Frequently we have done critical tasks but we do not know what name we should give to them when preparing resumes because recruiting sites / job interviews are not straight forward. [...]

Creating Data Mart by Consolidating Multi-Source Enterprise Operational Data

Creating Data Mart by Consolidating Multi-Source Enterprise Operational Data

We have included a very practical Paper on Data Mart by J. D. D. Daniel, K. N. Goh, and S. M. Yusop. Abstract - Trends in business intelligence, e-commerce and remote access make it necessary and practical to store data in different ways on multiple systems with different operating systems. As business evolve and grow, they require efficient [...]

IBM Cognos solutions for business analytics

IBM Cognos solutions for business analytics

Because midsize businesses are the engines of a Smarter Planet™, IBM has designed a business analytics solution for organizations like yours. The IBM Cognos Express solution helps C-level executives and other business users create reports, analyze data and identify trends quickly—with no special training or IT involvement—using [...]

Crystal 2008 and data warehouse

Crystal Reports 2008 is a reporting tool which can access and present data from Relational Databases and OLAP follwing are the supported OLAP databases: Hyperion Essbase Seagate Holos and Seagate INFO/Crystal Info IBM DB2 OLAP Server Informix MetaCube Microsoft SQL Server 2007 and above OLEDB for OLAP Sources(Oor other "Open OLAP [...]

Data Source Views

With Data Source views or DSVs you can limit the number of visible tables by including only those that are relevant to analysis. DSVs allows to create a logical data model upon which you can build Unified data Model. It can contain tables rom one or more sources. Spending time on creating DSVs save a time later on.

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

 Page 1 of 8  1  2  3  4  5 » ...  Last »