The Data Administration Newsletter

JULY 5, 2022

Bounded Contexts / Ubiquitous Language My new book, Data Model Storytelling,[i] contains a section describing some of the most significant challenges data modelers and other Data professionals face. Like most of its predecessors, including Agile development and […].

Data Modelling 102

Data Modelling Agile Data Architecture Data Management 102

The Data Administration Newsletter

JUNE 1, 2021

One of the ideas we promote is elegance in the core data model in a Data-Centric enterprise. Look at most application-centric data models: you would think they would be simpler than the enterprise model, after all, they are a small subset of it. This is harder than it sounds.

Data Modelling 98

Data Modelling Data Architecture Big Data Data Management 98

The Data Administration Newsletter

AUGUST 2, 2022

Canonical Data Models and Overlapping Connections In the previous article, I introduced and explained the approach to application development called ‘Domain-Driven Development’ (or DDD), explained some of the Data Management concerns with this approach, and described how a well-constructed data model can add value to a DDD project by helping to create (..)

Data Modelling 59

Data Modelling Data Management Data Architecture 59

Sisense

SEPTEMBER 3, 2020

People with this data job title work with information security software to prevent data breaches and assist business operations by organizing volumes of data. Database specialists may be charged with looking after other data repositories used by the organization, such as data stores, marts, warehouses, and lakes.

Chief Data Officer 97

Chief Data Officer Finance Data Modelling Visualization 97

The Data Administration Newsletter

FEBRUARY 17, 2021

“…quite simply, the better and more accessible the data is, the better the decisions you will make.” – “When Bad Data Happens to Good Companies,” (environmentalleader.com) The Business Impact of an organization’s Bad Data can cost up to 25% of the company’s Revenue (Ovum Research) Bad Data Costs the US healthcare $314 Billion. (IT

Data Management 59

Data Management Healthcare Data Quality Data Modelling 59

Astera

APRIL 24, 2024

It helps establish policies, assign roles and responsibilities, and maintain data quality and security in compliance with relevant regulatory standards. The framework, therefore, provides detailed documentation about the organization’s data architecture, which is necessary to govern its data assets.

Data Governance 52

Data Governance Government Data Architecture Data Quality 52

The Data Administration Newsletter

AUGUST 16, 2022

In the first article, I introduced and explained the approach to application development called Domain-Driven Development (or DDD), explained some of the Data Management concerns with this approach, and described how a well-constructed data model can add value to a DDD project by helping to create the Ubiquitous Language that defines the Bounded Context (..)

Data Modelling 59

Data Modelling Data Management Master Data Management Data Architecture 59

The Data Administration Newsletter

APRIL 4, 2023

Why would Technics Publications publish a book outside its specialty of data management? First, Graham is a world-renowned data modeler and the author of Data Modeling for Quality, and therefore many of his examples are in the field of data management. Second, and more […]

Data Modelling 52

Data Modelling Data Management Data Architecture 52

The Data Administration Newsletter

SEPTEMBER 21, 2022

Data Mesh and Data as a Product In the first article, I introduced and explained the approach to application development called Domain-Driven Development (or DDD), explained some of the Data Management concerns with this approach, and described how a well-constructed data model can add value to a DDD project by helping to create the Ubiquitous […]. (..)

Data Modelling 52

Data Modelling Data Management Data Governance Data Architecture 52

Tableau

SEPTEMBER 23, 2021

This also helps IT with impact analysis and change management, to understand who and which assets are affected downstream when changes are made to a table. While not exhaustive, here are additional capabilities to consider as part of your data management and governance solution: Data preparation. Data modeling.

Data Governance 101

Data Governance Government Data Quality Change Management 101

Tableau

SEPTEMBER 23, 2021

This also helps IT with impact analysis and change management, to understand who and which assets are affected downstream when changes are made to a table. While not exhaustive, here are additional capabilities to consider as part of your data management and governance solution: Data preparation. Data modeling.

Data Governance 97

Data Governance Government Data Quality Change Management 97

Astera

AUGUST 13, 2024

After modernizing and transferring the data, users access features such as interactive visualization, advanced analytics, machine learning, and mobile access through user-friendly interfaces and dashboards. What is Data-First Modernization? It aligns data with the requirements of modern data systems and applications.

Data Governance 52

Data Governance Data Architecture Data Quality Real-time Data 52

Astera

NOVEMBER 30, 2023

With rising data volumes, dynamic modeling requirements, and the need for improved operational efficiency, enterprises must equip themselves with smart solutions for efficient data management and analysis. This is where Data Vault 2.0 It supersedes Data Vault 1.0, What is Data Vault 2.0? Data Vault 2.0

Data Warehouse 52

Data Warehouse Big Data Healthcare Data Governance 52

Astera

FEBRUARY 14, 2024

Data Vault 101: Your Guide to Adaptable and Scalable Data Warehousing As businesses deal with larger and more diverse volumes of data, managing that data has become increasingly difficult. It has some key differences in terms of data loading, data modeling, and data agility.

Data Warehouse 52

Data Warehouse Data Modelling Agile Data Quality 52

Domo

OCTOBER 22, 2021

Using a data fabric solution, you can essentially stitch together various data tools to include a consistent set of capabilities and functionality. Ideally, CIOs and data practitioners get the full functionality of a unified BI architecture without having to move any data out of a cloud data warehouse (CDW).

Data Warehouse 52

Data Warehouse Embedded Analytics Government Digital Transformation 52

Astera

MAY 31, 2024

It involves visualizing the data using plots and charts to identify patterns, trends, and relationships between variables. Summary statistics are also calculated to provide a quantitative description of the data. Model Building: This step uses machine learning algorithms to create predictive models. Get Started Now!

Data Analytics 52

Data Analytics Data Analytics Data Warehouse Healthcare 52

The Data Administration Newsletter

APRIL 18, 2023

The foundation of a business’s digital transformation is effective data management. Master data management services allow you to effectively utilise the new currency of data and effectively collaborate between different functional verticals, departments, and stakeholders for better productivity, efficiency, and […]

Digital Transformation 52

Digital Transformation Digital Master Data Management Data Management 52

Astera

FEBRUARY 14, 2024

Data Mapping: Create a mapping between source and target data fields in Salesforce. Specify how data will be transformed and mapped during the migration process. Ensure alignment with Salesforce data models and consider any necessary data cleansing or enrichment.

IBM Support 52

IBM Support IBM Maintenance IBM cost Data Quality 52

The Data Administration Newsletter

AUGUST 3, 2021

Rigidly adhering to a standard, any standard, without being reasonable and using your ability to think through changing situations and circumstances is itself a bad standard. I guess I should quickly define what I mean by a “database standard” for those who are not aware.

Documentation 116

Documentation Data Quality Data Modelling Data Architecture 116

Astera

JANUARY 23, 2024

Businesses need scalable, agile, and accurate data to derive business intelligence (BI) and make informed decisions. Their data architecture should be able to handle growing data volumes and user demands, deliver insights swiftly and iteratively. The combination of data vault and information marts solves this problem.

Agile 52

Agile Data Warehouse Data Quality Government 52

Astera

DECEMBER 21, 2022

Moving data warehouses to the cloud relieve businesses from worrying about insufficient storage and lowers their overhead and maintenance costs. A cloud DWH is critical for businesses that need to make quick, data-driven decisions. What are the Benefits of Cloud Data Warehouses Compared to On-premise Solutions?

Data Warehouse 52

Data Warehouse Supply Chain Business Intelligence Business Intelligence 52

The Data Administration Newsletter

JUNE 21, 2022

Twenty-five years ago today, I published the first issue of The Data Administration Newsletter. It only took a few months to recognize that there was an audience for an “online” publication focused on data administration. […].

Master Data Management 78

Master Data Management Data Quality Data Modelling Data Governance 78

Astera

OCTOBER 27, 2023

The “cloud” part means that instead of managing physical servers and infrastructure, everything happens in the cloud environment—offsite servers take care of the heavy lifting, and you can access your data and analytics tools over the internet without the need for downloading or setting up any software or applications. We've got both!

Data Warehouse 52

Data Warehouse Data Quality Big Data Predictive Analytics 52

The Data Administration Newsletter

OCTOBER 18, 2022

“First thing we do, let’s banish all of the CIOs.” Shakespeare was much harder on lawyers. But the reality is, IT is a mess. Yes, it is. Judged by any performance measure we would apply to other groups within any enterprise, it is. I am reminded of old black and white movies: the […].

Data Modelling 52

Data Modelling Data Architecture Data Management 52

The Data Administration Newsletter

MAY 31, 2022

In my September 2020 Data is Risky Business column for TDAN.com, I wrote about the strategy lessons for data that we can learn from the writings of a 16thcentury Japanese swordsman. To summarize: – We need to study different disciplines to understand how they relate to each other.

Data Modelling 52

Data Modelling Data Architecture Data Management 52

The Data Administration Newsletter

APRIL 19, 2022

I know very few people who specialize in one area of IT/business architecture yet have practical knowledge of how all of the areas fit together. Roger has expertise in business process management, but has deep and vast knowledge of all facets of an organization’s business architecture. Roger Burlton is one of those people.

Business Architecture 52

Business Architecture Business Process Management Data Modelling Data Architecture 52

The Data Administration Newsletter

DECEMBER 4, 2024

The Irish satirist Jonathan Swift wrote “Gulliver’s Travels” almost 300 years ago, but the story of Lemuel Gulliver’s journey to Lilliput and beyond has resonance for data leaders today. There are important lessons to learn from the little people of Lilliput and the challenges encountered by the eponymous Gulliver.

Data Governance 52

Data Governance Data Architecture Data Modelling Government 52

Astera

JANUARY 12, 2024

Data volume continues to soar, growing at an annual rate of 19.2%. This means organizations must look for ways to efficiently manage and leverage this wealth of information for valuable insights. Enterprises should evaluate their requirements to select the right data warehouse framework and gain a competitive advantage.

Data Architecture 52

Data Architecture Data Warehouse Data Quality Government 52

Insight Software

MAY 1, 2023

Advanced Analytics Provide the unique benefit of advanced (and often proprietary) statistical models in your app. Data Environment First off, the solutions you consider should be compatible with your current data architecture. Strategic Objective Enjoy the ultimate flexibility in data sourcing through APIs or plug-ins.

Embedded Analytics 52

Embedded Analytics IBM Support IBM Maintenance IBM cost 52