‘Data mart’ Archives
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
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 ?
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
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
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
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 [...]
DataMart Reporting for University of Nebraska Lincon (UNL)
DataMart is a data warehouse containing University of Nebraska Lincoln student information. This information is stored on a network server that can be accessed from the user's desktop using Excel or Access. Using the desktop software, reporting is greatly simplified and data is available for further analysis. The DataMart replaces the SMART [...]
