‘data analyses’ Archives
Data Analyst
Data Analyst-OPE0000008Q Description Company Profile: Direct Energy is one of North America's largest energy and energy-related services providers with over 5 million residential and commercial relationships. Direct Energy provides customers with choice and support in managing their energy costs through a portfolio of innovative [...]
Flat File data model
Flat File data model This post discusses our experience of creating a relational database for company which to store all its information Excel files. Excel spread sheets is good for analysis purposes like pivot tables, calculations but very inefficient for data storage purpose. We cannot access data easily and compiling reports for [...]
Sample: Specific Job Skills for data analyst
Database professionals like sql developer, reporting analysts in Crystal Reports, Sql Reporting services and sql programmers can enter into new promising field of healthcare data analysts by following the job descriptions in this field. Following is the sample job description from - The Washington State Hospital Association (WSHA) published on [...]
Data Steward Role & Responsibilities
Data Stewards act as the conduit between IT and the business and accept accountability for data definition, data management process definition, and information quality levels for specific data subject areas. Data stewardship involves managing the enterprise’s data assets in order to improve their reusability, accessibility, and quality. Data [...]
data masking
This post is about data masking a role we read in a job description. Effective data masking requires data to be altered in a way that the actual values cannot be determined or reengineered, functional appearance is maintained, so effective testing is possible. Data can be encrypted and decrypted, relational integrity is maintained, security [...]
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 [...]
Rules and Check constraint
Rules are a backward-compatibility feature that perform some of the same functions as CHECK constraints. CHECK constraints are the preferred, standard way to restrict the values in a column. CHECK constraints are also more concise than rules; there can only be one rule applied to a column, but multiple CHECK constraints can be applied. CHECK [...]
Difference between Index and Primary Key
This post is on very important topic - "Difference between Index and Key" and is explained in very clear and easy terms by Michael J. Hernandez in his book Database Design for Mer Mortals on page 61. We are emphasizing in this post that most of the IT books lacks clarity or makes concepts more complicated resultantly negative impact on the [...]
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 [...]
Changing a Traditional information system to adapt new technologies for effective decision making
This is about an experience of an anonymous writer of this post describing his/her hands on experience in upgrading company’s information to adapt to new technologies for effective decision making and resultantly growth of the company. This post also reveals that how the hands on experience sets the foundations of understanding new [...]
