For a data dictionary or data mapping, Microsoft Excel is a common choice.You can also create and save up to 5 diagrams for free. Gliffy is my favorite because it’s simple and easy to use. Alternatively, if you don’t have access to Visio, there are many web-based diagramming tools offering similar functionality to Visio.(Microsoft also offers a 60-day full-featured free trial of Visio, making it easy to practice using it even if your organization doesn’t have a license.) It’s a full-featured software tool that many organizations already have. For creating ERDs, Visio is a common choice.Here are 3 tools commonly used by business analysts to complete conceptual and logical data modeling.
So, yes, we do need to create the models from scratch…manually. When we are updating existing data models or communicating the requirements for creating new database designs, we don’t have automated tools to generate these specifications. We define the difference between physical, logical, and conceptual data modeling there and draw a line in the sand regarding what type of data modeling is typically done by business analysts.) Business Analysts Use Tools Like Visio and Excel If you haven’t already checked out this article on how to data model without getting too technical, be sure to do so. (Luckily, as a business analyst, you won’t be creating these models, although you may need to review them to understand the current state. They simply show us what exists today, in all its wonderful and gory detail. These models do not represent meaningful abstractions designed to help business stakeholders make decisions about data requirements. This also happens to be one reason they are so difficult to read from a business perspective. Most often, they are generated output direct from the database software itself. The good news is that no one is manually creating these models. Most database models we see are physical-level models representing the actual database structure. (By the way, if you are looking to learn more about data modeling, be sure to check out our Free Data Modeling Training.) Database Tools Can Generate Complicated-Looking Models In this article, we’ll discuss the types of tools used to generate different types of data models, and then specifically look at how you can use tools you are most likely familiar with to do data modeling. Are you ready to get started with data modeling, but wondering what software tools you’ll need? Have you seen some of the more complicated-looking models and wonder how you can create these with your business analysis tool set?
0 kommentar(er)
