September 2021 Summaries

With the exponential growth of data, particularly unstructured and semi-structured formats like JSON, businesses face challenges in effectively analyzing this data to gain insights. JSON, a lightweight data interchange format, is widely used by major internet players due to its simplicity and efficiency compared to XML. However, its complex structure poses difficulties for traditional data analysis, often requiring technical expertise to parse and integrate it with structured data. Snowflake addresses these challenges with its patented technology that allows seamless loading and optimization of JSON within a relational database using a VARIANT data type, enabling SQL queries without the traditional schema-on-read process. Sigma complements Snowflake by providing a cloud-native BI tool with a familiar spreadsheet interface, allowing non-technical users to explore and analyze JSON data without writing SQL, thus democratizing data insights across organizations. Together, Snowflake and Sigma empower businesses to unlock the full potential of their semi-structured data, optimizing analytic efficiency and enhancing competitive advantage.

Diagnostic analytics, also known as root cause analysis, is a powerful tool for businesses to identify the origins of issues and implement effective solutions, thereby enhancing organizational agility, minimizing costs, and maximizing profitability. It involves analyzing internal and external data using techniques such as data discovery, drill-down, data mining, and correlation analysis to reveal the multiple factors contributing to trends or problems. Sigma, a cloud-native analytics solution, empowers non-technical users across various business teams to conduct diagnostic analyses quickly and securely, leveraging cloud data platforms like Snowflake, Amazon Redshift, and Google Big Query. Sigma's intuitive interface, which resembles a spreadsheet, enables users to perform in-depth analyses without coding, ensuring data is fresh and analyses remain up-to-date. By providing direct access to live data and supporting collaboration through a combination of spreadsheets, charts, and text, Sigma facilitates rapid, data-driven decision-making necessary in today's fast-paced market environment.

MineralTree, a provider of accounts payable and payments automation solutions, developed MineralTree Analytics to enhance financial processes by offering real-time visibility into key areas like payments and cash flow. The analytics tool, built in collaboration with Sigma, integrates with customers' financial systems to provide comprehensive insights and move away from traditional spreadsheets. Sigma was chosen for its robust security features, user-friendly interface, and scalability, making it an ideal solution for both technical and non-technical users. The development process was swift, taking only two months with a small team, and the feedback has been overwhelmingly positive, with customers appreciating the intuitive dashboards and the tool's ability to align with strategic business priorities. MineralTree plans to continue expanding the role of this analytics solution within its platform.