business analyst

SlashDB and Data Analysis

SlashDB and Data Analysis

An increasingly popular trend in IT and business intelligence is data analysis. At SlashDB, we celebrate this trend as it contributes to the rising awareness of data’s amazing capabilities. Data analysis tools allow for the construction of predictive models that enable businesses to anticipate the needs of their customers – changing customer service into a proactive rather than reactive element.

Recent advances have made data analysis tools both more affordable and more precise in their predictions. To help predictive models reach their full potential, new data analysis tools are adding API technology to help interpret and organize complex un-structured and real-time data, as well as to support in-house development of data analysis apps.

Pairing Data Analysis and APIs

Pairing data analysis tools with APIs enables more efficient and in-depth data collection. APIs not only help extract more specific data than ever before, they also help expose real-time data for more precise and up-to-date predictive models – predicting trends and modifications ahead of the competition.

Combining data analysis tools with APIs helps businesses create more detailed and consumer-specific predictive
models and applications. These predictive models and apps help businesses to fully gauge the desires and needs of their customers – enabling proactive customer support and, in turn, higher customer satisfaction.

Data analysis tools paired with APIs are helping businesses achieve higher revenue than ever before by speeding up and simplifying data collection. This is a trend that businesses simply cannot afford to miss out on. The best way to get the most out of your data analysis tools, and keep up with the competition, is to adopt an API add-on to streamline data extraction.

Case in Point – SlashDB in Real Life

The theories behind adopting API technology in order to increase the effectiveness of data analysis tools are informative – and well-considered – but real life examples are sometimes even better at illustrating a point. For instance, SlashDB powers APIs for Aruba Tourism Authority. Our API helps them collect valuable data and gives them heightened insight into prospective travelers’ specific interests in the island’s activities. Aruba Tourism Authority uses an attractive web application and digital content on arubashortcuts.com as a platform for gathering important data from prospective visitors.

beachfront-dinner

SlashDB captures the data from their website and seamlessly integrates it into Google Spreadsheets where it is analyzed in real time. By pairing an API with data analysis tools, Aruba Tourism Authority is able to capture and analyze data that will help them attract more visitors and increase revenue. This is an excellent example of the effectiveness and efficiency that APIs bring to data extraction and analysis.

aruba-report

SlashDB: Your Data Analysis API Solution

Adding an API add-on like SlashDB to your data analysis set-up can help you extract important data from predictive models, enabling you to meet and exceed customer expectations across multiple channels.aruba_island

At SlashDB, we focus on creating APIs with both high accessibility and heightened searchability. That’s why our API  add-on relies on a “what you see is what you get” set-up. This kind of set-up increases the speed and efficiency of data extraction. Our technology enables you to access your data through multiple platforms and creates a unique hyperlink for each individual piece of data.

Important Reasons Why You Should Pair SlashDB with Your Data Analysis Tools

  • SlashDB makes databases easily accessible from any analysis tool including (but not limited to): R Studio, Jupyter Notebook, Qlikview, Tableau, and Excel.
  • SlashDB makes working with databases as simple as working with plain files – with the added bonus that the data retains its integrity and authorizations while staying up-to-date.
  • SlashDB allows users to access and retrieve data with ease, relying on their intuition to extract the data they need rather than relying on complicated search queries.
  • With SlashDB, the content in your data analysis software or database becomes accessible through authorized web and mobile applications.SlashDB logo

SlashDB is committed to creating APIs that are highly accessible, searchable, and adaptable to other business and software tools. SlashDB’s API add-on can help streamline your business, allowing for increased profit margins and higher customer satisfaction. Contact us at SlashDB and we’ll work with you to find the best API add-on configuration for your business needs.

SlashDB API for Data Science vs. Tools Like Oracle BI

SlashDB API for Data Science vs. Tools Like Oracle BI

We are often asked how SlashDB compares to Oracle BI or other business intelligence software.

Well, the main difference is that SlashDB provides unobstructed access to data for reading and writing, while those tools can only display data already nicely formatted for end users.

In addition to that SlashDB works both internally and does not require you to send data to a third party storage to make it available on the Internet. Oracle BI generally only works on the inside, and cloud-based SaaS products generally require you to upload your data to their storage in a format that fits their systems.

SlashDB is an instant web API shell over traditional databases. Unlike data warehouses and ETL, it does not copy the data form their source systems so the data is always up to date. Oracle BI requires setting up complicated ETL processes, which only run periodically and create copies of data.

Transparency of Research Matters

SlashDB is an excellent gateway to data for downstream analytics systems and self-service reporting in Excel, R, Python and more.

Fragment of the Research DocumentOur friends at PyStreet have recently conducted a survey on Python developers salary. The response data resides in an MS SQL Server database, but they wanted to publish the results online. They also wanted to demonstrate Python’s capability in data analysis.

Using SlashDB they made the database publicly accessible for reading via HTTP.

Then using IPhython Notebook and pandas data analysis library they produced a fully transparent research document, which was later shared online.

The notebook can not only be viewed, but also downloaded and modified.

Both the raw data and their transformations can be scrutinized and/or modified. For example, certain data points were removed from the study, but one can change those criteria or skip that step entirely. BI tools typically do not offer that degree of transparency.

SlashDB is industry independent. At last, your data scientists and business analysts will be empowered to leverage investments made in database systems. Use it with sales records, marketing campaign data, financial data or any other key performance indicator data to derive insights that matter.

SlashDB ver. 0.7 Released, Improved UX and Admin Functions

SlashDB version 0.7 has just come out. This time, improvements focus on three things: user experience,  robust system administrator functionality and enhanced authorization mechanisms. Try the new SlashDB and you will appreciate the benefits of data accessibility from anywhere.

Here’s what’s new in 0.7:

For data scientists, business analysts

SlashDB has this dual personality. It is the API developer’s best tool to incorporate databases into his/her web or mobile apps but the equally important aspect of the system addresses the needs of data scientists, business analysts and rapid application developers.  Using SlashDB they get straightforward access to relevant data in its unobstructed form. Thanks to our latest GUI enhancements the web interface is now even more user friendly. New, responsive design allows for comfortable browsing through data on mobile devices while automatically generated, drill-down, filtering and sorting links help casual user discover the data and system’s functionality on the fly. As before you can use your favorite data analysis tools such as Excel, Matlab, SAS, R etc. to work with live data referenced by /db URLs.

For system administrators

Previously most settings would require editing configuration files on the server. We still have that option but since version 0.7 nearly all settings can be made in the web GUI or via a REST API. New authorization schemes now allow even greater flexibility in creating user segments with distinct permissions to data and system functions. Special users “admin” and “public” have been added. The former has full permissions to all system functions. The latter can be configured to offer limited access without requiring a login.

For CTO/CIO and software architects

Using SlashDB as a mobile enterprise application backend or to build an API is a sensible choice. Not only can you instantly leverage prior investments in databases but also remain in full control of your solution. That is because unlike SaaS offerings SlashDB can work in your data center or in your private cloud. See also this blog post.

User Experience in ver. 0.7

User Experience in ver. 0.7