Joyce Norris-Montanari, CBIP-CDMP, is president of DBTech Solutions, Inc. Joyce advises clients on all aspects of architectural integration, business intelligence and data management. Joyce advises clients about technology, including tools like ETL, profiling, database, quality and metadata. Joyce speaks frequently at data warehouse conferences and is a contributor to several trade publications. She co-authored Data Warehousing and E-Business (Wiley & Sons) with William H. Inmon and others. Joyce has managed and implemented data integrations, data warehouses and operational data stores in industries like education, pharmaceutical, restaurants, telecommunications, government, health care, financial, oil and gas, insurance, research and development and retail. She can be reached at jmontanari@earthlink.net.
Design of the data warehouse for staging, the lowest level of granularity (history), and the data marts has to be tuned based on how these levels are used. Let’s evaluate some characteristics about each level. STAGING – Staging areas are used as a place to land data for propagation and integration
I work with some fabulous people! They are team players, motivated and ready to take on the world. These are the Millennial Generation or Generation Y. These people were born in the technology age and expect data to be at their fingertips, which gives information technology (IT) a bit of heartburn when it comes
How do we, as IT (information technology), interact with the business? This is where I see companies failing quite a bit lately. We just can’t seem to create a good way of communicating with the business people. The business people don’t quite understand IT processes, and we (IT) don’t understand why they
The obvious answer to this is: SOMEWHERE! When I have clients who don’t know where to start on their data governance initiatives, I like to assess what data governance practices or disciplines my clients are now implementing. For example, what if they really don’t have a good way to audit and manage the
Do you have a vision for master data for the next two years? Five years? Ten years? Do you have a "workable" strategy (you know, a strategy that will work for your company)? Master data should be the backbone of any organization, and part of any data strategy. It should feed business intelligence with important
Joyce Norris-Montanari on tuning queries for reasonable response time.
Joyce Norris-Montanari addresses the issue of whether a data modeler needs to know databases.
Joyce Norris-Montanari on data normalization -- third normal form or performance and usage.
Joyce Norris-Montanari on what NULL really means.
Joyce Norris-Montanari explains why you should listen to more seasoned ways of doing things.
