Insider

Archives

‘Data mart’ Archives

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

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

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

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

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

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

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

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.

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