SkyDesk Reports is an on-demand reporting and business intelligence solution that helps you get new insights on your business information through its powerful and flexible online business intelligence engine. You get powerful reports in minutes, with no IT help.
SkyDesk Reports offers the following important capabilities:
Follow this link for a detailed discussion on Who should use SkyDesk Reports?
You can read about the difference between Spreadsheet and SkyDesk Reports in our solutions page Comparison with Excel Reporting.
SkyDesk Reports supports a wide variety of report creation options, which includes:
Yes, SkyDesk Reports does support dashboard creation. SkyDesk Reports provides an easy to use drag and drop interface for creating custom dashboards in minutes. Using the dashboard you can display a collection of reports in a single page, providing a quick at-a-glance view of your Key Business Information for easy analysis & visualization. For more details, refer here.
SkyDesk Reports is an Online Reporting and Business Intelligence service. The features offered by SkyDesk Reports specialize on providing in-depth, powerful and flexible reporting and analytical capabilities. It contains an in-built analytical database grid inside, which is optimized for reporting and analytical querying than just serving as a real-time online transactional database. The following links will be a useful read:
Click here to check the system requirement for SkyDesk Reports.
SkyDesk Reports is best viewed in 1024 * 768 screen resolution and above.
SkyDesk Reports user interface is available in the following two languages.
The SkyDesk Reports User interface language selection is based on the user's browser locale setting. In case you have a different language setting in your browser, you can go to your profile page in SkyDesk Accounts and change it. You may have to wait for 10 minutes, or log out and log in again, for the language change to take effect in the user interface.
In SkyDesk we give utmost importance to ensure our customers' data is both SAFE and SECURE. We have very stringent processes and systems in place to ensure the same. To know more about this, we recommend you to go through the following policy documents:
SkyDesk Terms of Service: http://www.skydesk.jp/en/legal/terms/
In case you have any further questions or concerns, please write to us at firstname.lastname@example.org.
You can view our Security and Privacy policies from the links given below:
You can find more details about the various pricing plans offered by visiting here
Yes, SkyDesk Reports does offers an Always Free Plan ($0) targeted at small end reporting requirements. It supports 2 users, 5 reporting databases and 10,000 rows in your account. You can find more details about the various plans SkyDesk Reports offers, by visiting Price
The priced plans allow you to store more data (more number of rows) and share the views in SkyDesk Reports with more number of users based on your plan. Also, it offers a wide range of value added features, which include:
Anyone to whom at least one view in the SkyDesk Reports account is privately shared is considered a User in the SkyDesk Reports pricing model. These private users are required to have an account in SkyDesk Reports and they need to login with their user name and password to access the views shared to them in that corresponding SkyDesk Reports account. Users are identified by their unique email address, to which the views in SkyDesk Reports account is shared.
Account Administrator is also considered as a User. When you subscribe a plan with 5 users, then you an privately share the data/reports in your account with 4 other persons for collaboration. Now your SkyDesk Reports account is said to have 5 users (Admin + 4 users).
By adding new users to your account, you could easily collaborate with them. The Administrator has the complete control over shared users accessing the views. Admin can grant permission to perform operations such as add, modify and delete data, create new reports and share views within a group, apart from just viewing the shared reports. Shared users will be able to perform only the operation that the admin has granted.
An Account Administrator is the one who subscribes to the SkyDesk Reports account. The Admin has authority to perform all possible operations available. This includes:
The number of rows (records) is the sum of all rows stored across all your database in your SkyDesk Reports account. i.e., when you have 2 databases with 3 tables in each of them. And each table contains 10,000 rows. Then the total number of rows in your SkyDesk Reports account is calculated as 60,000 (10,000 rows * 6 tables).
Note: Rows that are stored in SkyDesk Reports Tables (across all your databases) alone will be counted. Data in any other object in SkyDesk Reports such as query table and tabular view will not be counted.
Please contact to SkyDesk Sales. We'll get back to you with a price quote.
You can find more details about the various pricing plans at https://www.skydesk.jp/en/suites/sales/reports/plans.html
You can create a SkyDesk Reports account in less than sixty seconds by just filling up the Sign Up form.
You can change your account setting by following the steps given below:
For more details about your account settings, refer to the document @ https://www.skydesk.jp/en/apps/accounts/help/accountsettings.html.
You can change your password by following the steps given below:
Yes, SkyDesk Reports allows you to add multiple Email ID's to your account. Note that only one email id will be considered as Primary to your account and all other mail ids added will be considered as secondary mail id's.
To add a secondary email id:
Yes, you can change your primary email id and set one of your secondary email id as primary.
To change primary email id:
You can get more details about your account setup in the following link. https://www.skydesk.jp/en/apps/accounts/help/accountsettings.html
You can import tabular data from the following file formats:
You can also copy-paste data from all the above file formats as well as from spreadsheets (Microsoft Office Excel, Open Office Calc and StarOffice) files to import the data into SkyDesk Reports. For more details, refer to Import Data section.
Currently, SkyDesk Reports allows you to import files (CSV, TSV, XLS, HTML) with maximum 500,000 rows or a file size limit of 50 MB at a time when you use the SkyDesk Reports web user interface. It will restrict it based on whichever condition is met first. If you wish to upload more than 500,000 rows or a file more than 50 MB at a time, you can use the CSV Upload tool, as it would be more efficient to handle such loads.
By default a table in SkyDesk Reports allows you to have up to 500,000 rows. This is applicable only when you are using the Free Editions of SkyDesk Reports and not for paid editions.
If you find these limits are constraining to your application needs, mail us your requirements to email@example.com, we will definitely help you.
If you have large amount of data (greater than 50 MB or 500,000 rows) to be uploaded into SkyDesk Reports, loading them using the Web Graphical Interface of SkyDesk Reports, might not be the best way. As the upload happens over the Internet, slow or unreliable network connection might cause failures or interrupt the large data upload. In these cases, we recommend the following mechanism:
You could also Zip the file and upload from the Web User Interface, as long as the Zipped file content size is less 50MB and containing not more than 500,000 rows. CSV Upload tool does not have this restriction. But the overall limitation of having a maximum 500,000 rows in a table still applies, when you are in the Free Editions of SkyDesk Reports. Please refer #2 for more details on import data size restrictions.
You can upload/push data files from in-house and hosted applications into SkyDesk Reports. For details, refer to the solution page How to upload/push data from in-house applications.
You can upload data from local databases like Oracle, SQL Server, MySQL, DB2, PostgreSQL, MS Access etc., to SkyDesk Reports. For details, refer to the following sections:
You can periodically upload/push/import data into SkyDesk Reports through any of the following supported means:
Yes, SkyDesk Reports supports relational modeling of your reporting database. The following are the important capabilities that are currently available:
Click here to know more on SkyDesk Reports Relational Modeling Capabilities.
Yes, you can join data tables and easily create reports in SkyDesk Reports. There are two way to join tables. They are by Auto join and by Query tables.
You can auto join tables using lookup columns and then create reports over these tables. For more details on this refer to the following links:
Using Query tables you can join data from multiple tables in a database using JOIN construct in SQL SELECT query. You can save the results from the query into a new table for creating reports over the same. For more details, refer to the following link:
Yes, SkyDesk Reports supports full-fledged SQL based querying of your database. It understands SQL SELECT Queries written in any of the well-known database dialects including Oracle, Microsoft SQL Server, IBM DB2, Sybase, MySQL, PostgreSQL, Informix and ANSI SQL.
You can use SQLs from any of the below methods:
SkyDesk Reports supports SQL written in a wide variety of popular database dialects. It currently supports Oracle, SQL Server, IBM DB2, Sybase, MySQL, PostgreSQL, Informix and ANSI SQL database dialects.
Yes, you can easily share your data tables, reports and dashboards created in SkyDesk Reports with other users. Use the Share option within SkyDesk Reports to share your tables, reports, dashboards or entire reporting database to others users. You just need to provide the email address (Users should have a SkyDesk Reports account registered with this email address. If they do not have an account at the time of sharing they need to create one using the email id to which it is shared) and set the necessary permission (Read or Read-Write etc.) for the views being shared.
To learn more, refer to Sharing and collaboration section.
You can also make a reporting database public for anyone to access it in a Read-only mode (no permission for editing) or set the necessary permissions (Read Access, Export Data and View Underlying Data) to the views being shared. Refer to the topic Making Views/Database Public to know how to make your data and reports public.
Note: While making a database public please choose whether to list the database under SkyDesk Public Databases list. If this is done, anyone can view your reporting database. Hence exercise caution.
Yes, you can embed tables and reports created in SkyDesk Reports in your website, web application or blog. Follow the steps below to achieve the same:
To learn more, refer to Embedding Views in Web Pages, Web Applications and Blogs section in SkyDesk Reports.
Yes, you can allow other users to edit (add, modify & delete data) the data in your database. Follow the instruction below to do the same:
Your data table is now accessible to the shared users for editing. For more details about granting permissions for your user, refer to Granting Permissions to Users section.
Yes, you can allow others to create reports in your database by sharing the data table over which you want them to create reports. You can do this as follows:
Your data table is now accessible to the shared users. And they can create reports over the shared table. For more details about sharing, refer to the Sharing and Collaboration section.
Yes, you can allow other users to upload data in your database. Follow the steps given below to do this:
Your data table is now accessible to the shared users. And they can upload data into your database, by logging into their SkyDesk Reports account. For more details refer to Granting Permission to users section in Sharing Views to a User topic.
Yes, you can generate a standalone URL (permalink) for the reports created in SkyDesk Reports. Follow the steps given below to do this:
For more details on this, refer to Creating URLs to Views section.
Yes, you can export your reports & dashboards created in SkyDesk Reports into various file formats. SkyDesk Reports supports exporting into the following formats.
Yes, you can email the reports & dashboards created in SkyDesk Reports as attachments to your users. You can also schedule the emails to be sent automatically at specified time intervals. You can setup this as follows:
You can email multiple reports together.
Yes, SkyDesk Reports is integrated with SkyDesk CRM. The SkyDesk Reports Advanced Analytics Add-on for SkyDesk CRM enables you to analyze your SkyDesk CRM data and create insightful reports & dashboards easily. It brings all the powerful analytical & reporting capabilities of SkyDesk Reports into SkyDesk CRM. For more details, refer to Advanced Analytics for SkyDesk CRM.
Yes, SkyDesk Reports is integrated with SkyDesk Creator. Two type of integration are supported. They are:
Currently, SkyDesk Reports is integrated with Google Drive (Google Spreadsheets). You can easily import data from your Google spreadsheets into SkyDesk Reports, for analysis and reporting. You can read more about this in the following document:
Currently, we do not offer a direct integration with Google Adwords that pulls the data from that service automatically. This is something that we are already working and should be made available in the very near future.
Meanwhile you could still use SkyDesk Reports for analyzing your data in Google Adwords, by manually exporting the data from Google Adwords and importing into SkyDesk Reports. Refer to the solution page Google Adwords Reporting and Analysis for more details.
Yes, SkyDesk Reports offers extensive APIs to integrate any external application with SkyDesk Reports. The API's offered are HTTP based, which can be used in any programming language. Also language wrappers are provided for Java and Python.
SkyDesk Reports offers APIs to perform the following actions:
For more details, refer to Supported Actions section in the API documentation @ https://www.skydesk.jp/en/apps/reports/help/api/index.html
Yes, SkyDesk Reports supports comprehensive HTTP based Web APIs using which application developers can add, update and query/fetch data in the reporting databases created in SkyDesk Reports. Using these APIs users could push/pull data from SkyDesk Reports from/to their own applications enabling easy integration. This would effectively enable SkyDesk Reports to be a convenient reporting database framework for your applications.
SkyDesk Reports also support SkyDesk CloudSQL API technology, which enables users to interact with their business data stored in SkyDesk Reports through familiar SQL language. Users can access the data in SkyDesk Reports using CloudSQL from both other cloud applications as well as from traditional in-premises software.
View API docs @ https://www.skydesk.jp/en/apps/reports/help/api/index.html
SkyDesk CloudSQL docs @ https://www.skydesk.jp/reports/help/api/SkyDesk-reports-cloud-sql.html
SkyDesk Reports offers APIs to perform the following actions:
For more details, refer to Supported Actions section in the API documentation @ https://www.skydesk.jp/en/apps/reports/help/api/index.html.
Currently, SkyDesk Reports supports the following programming language libraries to enable developers to easily use SkyDesk Reports API in the corresponding programming language:
For more details, refer to Client Libraries section.
Yes, SkyDesk Reports supports API for sharing. To know more details about share API, refer to Sharing section in the API documentation @ https://www.skydesk.jp/en/apps/reports/help/api/index.html.
Yes, SkyDesk Reports supports only Logo re-branding and we are not supporting Complete re-branding (white labeling).
Logo Re-branding enables you to customize the SkyDesk Reports product logo that is displayed within the SkyDesk Reports service. This support is available only in paid plans of SkyDesk Reports. Using this feature you can replace the SkyDesk Reports product logo displayed in the service and also change the powered by logo displayed as footer of the reports when you export them (as PDF or images) or embed them in other web pages.
Follow the steps given below to change the logos :
Take a tour for a quick understanding of the product. Also refer to the following links, to know more on the features of SkyDesk Reports:
Help Document: https://www.skydesk.jp/en/apps/reports/help/overview.html
We will announce about new features in SkyDesk Reports regularly in our What's New page.
The key difference between SkyDesk Reports and SkyDesk Creator is in-depth reporting and analytics vs online custom database application creation.
SkyDesk Reports enables you to easily create powerful and sophisticated reports with your data by creating online reporting applications. It enables you to slice & dice your data for in-depth visualization and business intelligence. SkyDesk Creator enables you to quickly create a powerful online database application to collect data and trigger work flows through forms and scripting.
SkyDesk Reports could act as a convenient back-end reporting/analytical database for your application needs. You can get data into SkyDesk Reports through manual data entry or bulk load data from files or upload data stored in your local databases (like MS Access, Oracle, SQL Server, MySQL, DB2, PostgreSQL & MS Access) or schedule for periodic upload of data or push data from your application through Web API (HTTP based) for reporting and analysis. Here the crucial difference is that, while SkyDesk Creator offers a hosted programming environment (with a DB backing), SkyDesk Reports offers a powerful reporting layer (backed by an analytical database) for your application data.
SkyDesk Reports also supports full-fledged relational modeling (similar to relational/analytical databases) for powerful reporting. It currently supports relational modeling functionalities through Lookup columns. With lookup columns you can relate one table with another. It also offers cascade-on-delete functionality whereby when a row in the parent table is deleted, it will automatically delete all the related rows in the child table(s). Click to know more on SkyDesk Reports Relational Modeling Capabilities.
The other key difference is that SkyDesk Reports embraces SQL, and supports all major dialects of it. This enables users to do sophisticated querying on the data for creating powerful reports. We will flesh out this functionality even further in future updates.
Please read the FAQ #2 before you read further. If you require a quick application development environment, with forms, scripting, workflows and basic reporting, opt for SkyDesk Creator. If you require a powerful online reporting and analytics service with an inbuilt analytical database support, opt for SkyDesk Reports. SkyDesk Reports also supports Web based APIs using which you can build your own forms and push/update/pull data into SkyDesk Reports from any of your applications.
In case you require any clarifications or assistance in this regard, please feel free to contact us at
skydesk-support at fujixerox dot co dot jp