Data Modeling for Business Analyst

Business or System analyst is good to have minimum programming knowledge

or some tech key elements such as database concepts, SQL or Code Analysis, which helps to communicate with Dev folks during Analysis/Design/Development phase.

 What is Databases and Data Structures: Database is the collection of data in a  well arranged manner, like table & Data Structure is the way of arranging information in a database so that it becomes easy to access information whenever needed, like how it is stored.

Data Modeling: Data modeling helps to define and analyze data requirements, it is often first step in database design & how data items relate to each other. There are three levels of Data modeling as follows: Conceptual model, Logical Models and Physical Models respectively:

Though we are not responsible to creating the database tables, however we might be responsible for designing these models…as you see these models increases the complexity in a respective way, so always recommended to first start with the conceptual data model to understand high level different entities in our data and how they relate to one another, then move on to the logical data model so we understand the details of our data without worrying about how they will actually implemented, and finally the physical data model so we know exactly how to implement our data model in the database.

Tools to design Data Modeling: Out of many, very commonly used tools Toad Data Modeler, ERwin Data Modeler

Last modified on Monday, 10 April 2017 19:58
Share this article

Contact info

About us

Newsletter

Join the network: We are Business Folks, analyzing IT projects.
Top
We use cookies to improve our website. By continuing to use this website, you are giving consent to cookies being used. More details…