A proper database design cannot be thrown together quickly by novices. A practiced and formal approach to gathering data requirements and modeling data is mandatory. This modeling effort requires a ...

At its heart, data modeling is about understanding how data flows through a system. Just as a map can help us understand a city’s layout, data modeling can help us understand the complexities of a ...

Organizations often force the DBA to take on the job of data modeling. That does not mean that DBAs are well-trained in data modeling, nor does it mean that DBAs are best suited to take on this task.

Data modeling refers to the architecture that allows data analysis to use data in decision-making processes. A combined approach is needed to maximize data insights. While the terms data analysis and ...

I started out in Database Design early in my application development career. I still remember being issued with an official IBM stencil for drawing Entity Relationship Diagrams (ERDs). Change ...

If your are wondering how to handle large datasets and complex calculations in your spreadsheets. This is where MS Excel PowerPivot comes into play. PowerPivot is an advanced feature in Excel that ...

Clay Rehm, CCP, PMP, is president of Rehm Technology (www.rehmtech.com), a consulting firm specializing in data integration solutions. Rehm provides hands-on expertise in project management, ...