A dataset is a systematically organized and formatted collection of data, typically curated for the purpose of analysis or machine learning. It encompasses diverse types of information, ranging from numerical data and text to images and audio. Widely utilized across scientific research, business, and government institutions, datasets serve as foundational elements for informed decision-making.
Datasets are capable of being stored in various formats, including CSV, JSON, and Excel, facilitating accessibility and analysis. The implementation of universal data connectivity, achieved through standards-based drivers, serves to insulate users utilizing SQL interfaces.
The effectiveness of a dataset relies on its meticulous organization and structure, ensuring seamless accessibility and analysis for users.
Lumenore Connect empowers users to establish connections for extracting data from various sources, including local files, databases, or live connections. With over 80 connectors available, users can seamlessly link their data to create both the schema and the dashboard.
The initial stage of dashboard creation involves the user generating or adding a dataset through a designated connector. Upon the creation or addition of a dataset, it is stored as a local dataset for further utilization.
Steps for creating a dataset:
Step 1: Sign in using your credentials, access “Lumenore Connect” either from the homepage or the Self-Service page and choose “Connect Your Data”.
Step 2: Click on “connect”.
On the Lumenore Dataset Connector screen, you can select from a range of connectors to establish connections with your data source depending on your requirements.
Step 3: Select “Browse File” or import the file from cloud storage.
Step 4: Upon successful file upload, a message will appear. Proceed by clicking “Next”.
Step 5 : Click the check box(es) to select tables and columns, then click on “Preview”.
Step 6 : The table preview is displayed, allowing the user to filter or clean the data as needed. Subsequently, click on “Save”.
Step 7: Input the dataset name and, if desired, provide a description. Afterward, click “OK“.
Step 8 : The dialogue box confirming the successful upload of the dataset will appear. Click on “Create Schema”, to apply joins and process further; otherwise simply click “OK“.
After uploading the dataset, you have the flexibility to edit and manage it. Utilizing the uploaded dataset, users can create schema, modify tables, columns, attributes, or measures as needed.