BI for the BA – Live Blog 11:42 a.m.

Entity relationship diagrams ERDs show the relationship between classes of data, or data entities.  Unified Modelling Language (UML) is a common language to use to show the relationships between classes or entities.  Concepts of one-to-one, one-to-many or many-to-many is used here. Data models are good concept sources for having discussions with stakeholders. Data dictionary, not often used, can be developed to document the definition of…

BI for BA – Live Blog 10:47 a.m.

Dimensional modelling Tolerates redundancy to assist query speed across multiple tables Uses cubes rather than table concept Few tables; fact table concept is used; measures are connected to dimensional tables Uses OLAP (online analytical processing) – an environment where information is queried.  There are no updates, deletes or inserts in a data warehouse or data mart. OLTP is online transactional processing (this is the most…

BI for the BA – Live Blog 10:02 a.m.

Discussion focusses on workload where there are multiple systems that will feed a data warehouse.  A question came out as to how to tie the data sources together?  One aspect is the concept of mapping source information together using unique identifiers that can be created by a data modeller, or BA doing the data model in the staging environment where extraction and transformation occurs prior…

BI for the BA – Live Blog 9:44 a.m.

Cultural issues make post challenges to a BA working on a data project.  “We have always done it this way” is a common response to change. BA techniques to handle this type of response: Focus on the objective Listen attentively Ask “what did we miss” on past projects or activities that led to this type of response now. Ask questions about the culture or get…

BI for the BA – Live Blog 9:24 a.m.

Data warehouse is the target of extracted, transformed and loaded. ETL is one of the most time consuming aspects of business analysis work.  There could be many sources of information from which to extract information.  Transformation puts some quality on the information that is extracted.  Loading of transformed data is done in the data warehouse. ETL is a good method for standardizing data, putting quality…

BI for the BA workshop – live blog 9:14

Participant engagement right off the bat for the prioritization exercise for the case study goals and objectives of the sample organization, TBIXC. We need to know not only what the goals are but also what the top level priorities are for an organization.  From a data model perspective, we might use the approach of talking with key stakeholders about what current information they have to…