Asset Types
Why are Asset Types important?
Asset Types are the backbone of ReadyWorks. They define how data is organized and presented within the platform. By properly setting up Asset Types, you ensure that the data is structured in a way that reflects your organization's needs.
Assets vs. Lists:
- Assets: Represent primary items (e.g., Computers, Users) and appear prominently in the navigation menu.
- Lists: Serve as lookup tables or control lists (e.g., Locations, Models) and help maintain data consistency.
Example:
If you're managing printers, creating a "Printer" Asset Type allows you to store all relevant printer data in one place. You might also create a "Printer Model" list to standardize model names.
ETL Module (Extract, Transform, Load)
Why use the ETL Module?
The ETL Module is essential for bringing data from external systems into ReadyWorks. It ensures that data is extracted accurately, transformed as needed, and loaded into the platform for use.
- Connectors: Pre-built integrations that know how to communicate with external systems.
- Jobs: Specific tasks within connectors that define what data to extract.
- Staging Tables: Temporary storage where the raw data is held before mapping.
Data Flow Insight:
Data moves from the external system into ReadyWorks through Connectors and is stored in Staging Tables. Understanding the structure of this data is crucial for the next step—Data Mapping.
Data Mapping
Why is Data Mapping crucial?
Data Mapping is where you transform and organize the raw data into meaningful information that fits your Asset Types. This step is vital because it allows you to clean, combine, and structure data before it becomes part of your main dataset.
- SQL Queries: Used to manipulate and combine data from staging tables.
- Mapping to Asset Types: Assigns the transformed data to the correct fields in your Asset Types.
Data Flow Insight:
Data from the Staging Tables is transformed through SQL queries and mapped to the Asset Types. This is where raw data becomes structured, actionable information.
Reports and Dashboards
Why build Reports and Dashboards?
Reports and Dashboards help you visualize and analyze the data within your Asset Types. They provide insights that can drive decision-making and reveal trends or issues that need attention.
- Report Builder: A tool to create custom reports using data from Asset Types.
- Visualization: Charts, graphs, and tables that present data in an understandable format.
Data Flow Insight:
Data within Asset Types is used to generate reports and dashboards, providing the end-users with meaningful insights derived from the data flow starting from the external sources.