Learn more about structured data and how its standardized form allows for easy access and efficient processing.
Structured data is quantitative data, meaning it includes data that you can measure or count. It is organized, typically formatted into tables, and easily searchable. This makes structured data ideal for performing analysis and combining with other data sets for storage in a relational database.
Within a relational database, you can manage structured data using Structured Query Language (SQL). SQL allows you to perform a variety of tasks with structured data, including inputting new data, modifying or deleting data, and querying to retrieve data. Sources of structured data include customer relationship and enterprise resource planning systems, online forms, web server logs, medical devices, and point-of-sale software.
Thanks to its highly organized nature, structured data is favorable for inputting, querying, and manipulating through machine learning algorithms. While structured data lacks flexibility and has its limits in terms of usability in comparison to unstructured data, more tools exist for analyzing structured data that don’t require advanced expertise.
Structured data has a number of different uses. Running structured data through customer relationship management (CRM) software enables you to develop analytic insights to customer behavior trends and patterns to drive informed decision-making. When used in accounting, departments have the ability to use structured data to record and process financial transactions or maintain payroll processes.
Structured data has predefined types, allowing for storage in tables with relationships between rows and columns. For example, this is commonly seen in an Excel file. Here are some other examples of structured data:
Customer names and email addresses
Product directories
Phone numbers
Dates and times
Transaction information
Inventory control
Semi-structured is a type of structured data that features characteristics of both structured and unstructured data. Semi-structured data has some of the same quantitative properties as structured data, but it also encompasses qualitative properties, which involve descriptive or categorical attributes. This makes semi-structured data more difficult to analyze; however, it offers greater flexibility in the type of information it contains. Examples of semi-structured data include the contents of an email, JSON and CSV documents, and NoSQL databases.
If you’re ready to start a career in data analytics, consider earning a Google Data Analytics Professional Certificate on Coursera. With this program, you have the opportunity to earn an employer-recognized certificate and develop job-ready skills in a number of areas, such as SQL, data cleaning and visualization, R programming, and more.
Editorial Team
Coursera’s editorial team is comprised of highly experienced professional editors, writers, and fact...
This content has been made available for informational purposes only. Learners are advised to conduct additional research to ensure that courses and other credentials pursued meet their personal, professional, and financial goals.
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies enable the website to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.