I encountered, what I will admit is a pet peeve today, which is why I’m writing this article. I needed contact someone whom I correspond with regularly, but I have no reason to call or be called by them. So, after checking my phone, went to their email thinking this would be a fast and … Continue reading Professional Emails include a signature Block
Management and Measurement You can't manage what you don't measure is an old management adage that has been used for many years and while most attribute it to Peter Drucker, some claim that the quote was first used by Dr. W. Edwards Deming, although it is a bone of contention whether or not the … Continue reading Management principles – You can’t Manage what you don’t Measure
Information Technology Requirements Management Information technology requirement management (IT mаnаgеmеnt) is thе process whеrеbу all rеѕоurсеѕ rеlаtеd to іnfоrmаtіоn technology аrе mаnаgеd according to a оrgаnіzаtіоn'ѕ рrіоrіtіеѕ аnd nееdѕ. Thіѕ includes tangible rеѕоurсеѕ like nеtwоrkіng hаrdwаrе, соmрutеrѕ аnd реорlе, as wеll as іntаngіblе rеѕоurсеѕ like ѕоftwаrе аnd data. The сеntrаl аіm of IT mаnаgеmеnt is … Continue reading Information Technology (IT) Requirements Management (REQM) For Development
Data Modeling Column Data Classification When analyzing individual column data, at its most foundational level, column data can be classified by their fundamental use/characteristics. Granted, when you start rolling up the structure into multiple columns, table structure and table relationship, then other classifications/behaviors, such as keys (primary and foreign), indexes, and distribution come into play. … Continue reading Data Modeling – Column Data Classification
Data Model What is a Common Data Model (CDM)? A Common Data Model (CDM) is a share data structure designed to provide well-formed and standardized data structures within an industry (e.g. medical, Insurance, etc.) or business channel (e.g. Human resource management, Asset Management, etc.), which can be applied to provide organizations a consistent unified view … Continue reading What is a Common Data Model (CDM)?
Database Table Here are a few guidelines for modeling and designing fact tables. Fact Table Effective Practices The table naming convention should identify it as a fact table. For example: Suffix Pattern: <<TableName>>_Fact <<TableName>>_F Prefix Pattern: FACT_<TableName>> F_<TableName>> Must contain a temporal dimension surrogate key (e.g. date dimension) Measures should be nullable – this has an … Continue reading Data Modeling – Fact Table Effective Practices
Database Table I've had these notes laying around for a while, so, I thought I consolidate them here. So, here are few guidelines to ensure the quality of your dimension table structures. Dimension Table Effective Practices The table naming convention should identify it as a dimension table. For example: Suffix Pattern: <<TableName>>_Dim <<TableName>>_D Prefix … Continue reading Data Modeling – Dimension Table Effective Practices