Cloud Dataset Benefits and Use Cases
How to create a Cloud Dataset?
Create imports using a Cloud Dataset
Cloud Datasets is a feature that allows you to create sets of data in your spreadsheet(s) using Coefficient and then store them in the cloud. Think of a dataset as your master sheet, you can access and pull data from at any time. These data sets can be scheduled to refresh, and you can customize them as needed. Share your Cloud Dataset(s) with your team for collaboration and group projects. How cool is that! ☁️
Spreadsheets expand constantly with new and updated data for any business. The size limitations in Google Sheets can make that a challenge sometimes. By using Cloud Datasets with Coefficient, your data is stored on cloud servers, which alleviates the size limitations and spreadsheet load lag.
<aside> 💡 Cloud Datasets with Coefficient currently can handle up to 100K rows per import! (Our team is planning to increase soon - so stay tuned!)
</aside>
Leveraging Cloud Datasets allows you to establish and maintain a primary dataset, which serves as the foundation or single source that once updated funnel the updates to other imports. You can then effortlessly generate various data subsets by applying various parameters such as filters and sorting. This approach eliminates the necessity for extensive formula usage, including functions like VLOOKUPS, which can otherwise add unnecessary complexity to your spreadsheet. 🏋🏽
Similar to a Coefficient import, your Cloud Dataset can be scheduled to refresh on a cadence you can choose (Hourly, Daily, or Weekly). Any updates or changes made to the source sheet (master) will be reflected in your Cloud Dataset after the refresh is complete.
With Cloud Datasets, you can easily share data with team members, enabling them to access and reference it as required. This is particularly valuable for team members who may not possess advanced SQL query skills but require data access for reporting and analysis purposes. They can utilize the query you've created or shared as a foundation and adapt their own copy from the 'master' dataset to tailor the data to their specific requirements. This not only streamlines the process but also enhances overall team efficiency!! Owners/Creators of a Cloud Dataset can also have more control over who has access which mitigates accidental changes that can happen in a regular spreadsheet. 😵💫