Mastering the Art of Unpivoting Data in DataWORQ
In this comprehensive guide, you’ll learn how to convert your pivoted data back to an unpivoted format using DataWORQ’s Unpivot node. Designed for those who want to explore the full range of DataWORQ’s data manipulation capabilities, this article explains how to effectively select and combine columns for Extended Planning & Analysis (xP&A). Using an example…
A Step-by-Step Guide to Data Pivoting in DataWORQ
Learn how to master the art of data pivoting in DataWORQ with this step-by-step tutorial. Aimed at business users looking to streamline Extended Planning & Analysis (xP&A), this article guides you from the point of pulling an unpivoted dataset from Excel to transforming it into a neatly pivoted dataset. We explain how to utilize the…
How to Leverage Pivot Tables in DataWORQ for Better Data Management
Discover the power of Pivot Tables within DataWORQ with our comprehensive guide. Ideal for professionals involved in Extended Planning & Analysis (xP&A), this article demystifies how to effectively navigate between pivoted and unpivoted datasets. Using real-world examples based on flower species data, we break down the benefits of each dataset format for your planning system.…
The Ultimate Solution for Streamlined Data Collection and Planning
Maximize Business Efficiency with ReportWORQ ReportWORQ revolutionizes the way businesses manage data collection and planning. With its user-friendly interface and robust capabilities, it’s designed to simplify data collection from internal and external sources, saving you hours of manual labor. • Eliminate the hassle of manually copying templates and transposing data. ReportWORQ automates these tasks so…
Streamlining Business Reporting with ReportWORQ: A Comprehensive Walkthrough
ReportWORQ offers an integrated solution for automating PowerPoint presentations and Excel-based reporting, saving your team valuable time and reducing the risk of manual errors. This article provides a detailed step-by-step guide on how to leverage ReportWORQ for generating dynamic briefing books, personalized P&L statements, and much more. Sections Included: Introduction to ReportWORQ What sets it…
Create Dynamic Email Dashboards with ReportWORQ: Personalized Financial Reporting Across 50 States without Attachments
ReportWORQ’s rich and dynamic email dashboards help Finance drive data adoption by enabling business users with clear and timely data, while also helping IT improve the security and availability of sensitive data. Watch as we demonstrate how to use ReportWORQ variables to generate personalized email dashboards, complete with conditional formatting, snippets from reports, and visuals.…
Gather data from an API using the Script source node
The following article outlines how Euclid Studio can be used to request data from an API and process it so it can be used in the system. This requires some knowledge of Python coding that is used within the Script source node and how APIs function. APIs usually have associated documentation that describes how to…
Euclid Studio: Call a Flow from a REST Client
In this video you will learn how to call a Euclid Studio Flow from a REST Client. This example leverages the Euclid Studio REST API.
Euclid Studio: Rename and Remove Fields
This video shows you how to Rename and Remove fields from a Euclid Studio Flow. This approach applies to any data in a segment on the Euclid Studio canvas. For example, you can Rename and Remove fields from data that started as a Flat File or from a Database Table.
Euclid Studio: Call a TI Process from a Flow
This video will show you how you can execute a Planning Analytics Turbo Integrator process from a Euclid Studio Flow. This approach uses the Planning Analytics REST API.
Euclid Studio: Call a Flow from Planning Analytics
This video will show you how to use Planning Analytics to call a Euclid Studio Flow. This approach uses the included EuclidStudio.jar file and a QueBIT Standard Turbo Integrator Process to simplify your REST command.
Euclid Studio: Creating and Saving a Flow
This video walks you through the process of creating and saving a Euclid Studio Flow. Flows are files Euclid Studio uses to solve your business problems.
Euclid Studio: Create a Database Connection
In this video you will learn how to setup a JDBC Database Connection for use in Euclid Studio. Setting up these connections will allow you consume and deliver data for that Database
Euclid Studio: Connect and Configure Nodes
This video instructs you how to connect and configure Euclid Studio Nodes. Orchestration of these Nodes is done using the canvas and Node connections.
Euclid Studio: Combine Many Sources Into One
In this video you will learn how to combine many data sources in Euclid Studio. This approach can combine data from various sources such as Flat Files and Databases. Even if the data isn’t in the same shape you can use Euclid Studio to shape the data and seamlessly combine it in a single…
Euclid Studio: Navigating the Business Rules Node
Using the Business Rules Node in Euclid Studio is an extremely effective way of managing business rules, giving you total control over their scope and impact. It’s important to understand the tool’s options and settings before adjusting or implementing new rules. In this example, we’ll go through the basic options and settings of the node.…
Get Started with Snowflake
Snowflake is a cloud computing–based data cloud company based in Bozeman, Montana founded in July 2012. Snowflake offers a cloud-based data storage and analytics service, generally termed “data-as-a-service”. Its key features include options for Security, Governance, and Data Protection, Standard and Extended SQL Support, Various built-in Tools and Interfaces, easy Connectivity, Data Import and Export,…
What is MariaDB?
MariaDB, created by the original developers of MySQL, is an open source relational database management system that is a compatible, literal “drop-in” replacement for the widely used MySQL database technology. MariaDB offers more and better storage engines which are designed to efficiently manage data files, the data, and the index caches. NoSQL support, provided by Cassandra, allows you to run…
Taming the Many Tabbed Excel Workbook
Have you ever opened an Excel workbook and been surprised by the number of sheets it contains? Perhaps you are looking for something, or don’t know where to begin? This article shares a great trick in Excel if you need to see at-a-glance what all the tabs are in a workbook. You can build your…
Azure Query Performance Insight
Query Performance Insight proposes to provide “intelligent” query analysis for single and pooled (databases in a pool are on a single server and share a set number of resources ) databases. It identifies those queries that consume the most resources as well as the longer-running queries. This helps find which queries to optimize to improve…
Exploring the Azure Data Factory
Since I’ve worked with SQL Server Integration Services (SSIS) off and on for a while, I have been anxious to explore Azure Data Factory (or ADF) to see what the differences are and how it stacks up. While SSIS may be a familiar ETL tool for on-premises work, Azure Data Factory (defined as a “platform…
Discovering Custom Maps in Power BI Desktop
The objective of this exercise is to explore the use of Microsoft Power BI Desktop (version 2.98.1) to create a map visualization, so, let’s start by answering the question: what is a map visualization? Map visualizations are used to analyze and display geographically related data and present it in the form of a map. This…
Creating a Simple Azure App Service Web App
The Azure App Service is a Platform as a Service (or PaaS) offering from Microsoft. It’s a component that provides resources for deploying web applications and for making deployed web applications accessible by HTTP clients. You can use it to host web applications, REST API’s and backend services for mobile applications in almost any programming language…
Exploring Azure Cosmos DB
Azure Cosmos DB is a fully managed NoSQL database designed for modern app development. Microsoft states that “…any web, mobile, gaming, and IoT application that needs to handle massive amounts of data, reads, and writes at a global scale with near-real response times for a variety of data will benefit from Cosmos DB…”. In this post I want to demonstrate…
Creating a Docker Application
Create a project To create a Docker application, you need an application and a (Docker) image file. In this example we’ll use a very simple Python script as the application, so we have to create 2 files: A “py” file (the python script that will contain the code to be executed) A ‘Dockerfile’ file (the…
PostgreSQL and JSONB
Forensic Files is a documentary-style, true crime series which reveals how forensic science is used to solve violent crimes, mysterious accidents, and even outbreaks of illness. Being a fan and most likely having watched all of the episodes in the series (more than once!) I was inspired to build a database to be used as…
Doing Development with PostgreSQL and Docker
In this post I want to demonstrate how to create and start a Docker container using a Postgres image to run a PostgreSQL database server in a Docker container so that I can do some development in my local environment. Docker Assuming Docker is running, the first step is to create a container running PostgreSQL.…
Running MariaDB in a Docker Container
In this article a MariaDB server image is created and run in a Docker container. A DBeaver connection to the container is established. Next, bash commands are used to execute MySQL statements to perform various database tasks such as create a new MariaDB database, create a table, create a CSV data file and load the…
PostgreSQL and Planning Analytics
Regardless of whether you are working with IBM Planning Analytics Workspace on cloud or Planning Analytics Workspace Local, an ODBC data source can be established so that you can use it as a process data source and therefore integrate your PA model with your organizations existing infrastructure. In this article I want to demonstrate how…
A SQL Server Integrated Services SSIS Exercise
SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions. You can use Integration Services to perform a variety of tasks such as maintaining data hubs that serve Planning Analytics or other enterprise applications. The following outlines the process of creating and deploying a working SSIS package that takes…
Exploring PostgreSQL with pgAdmin
PostgreSQL is a powerful, open-source object-relational database system with 30+ years of active development that has earned it a formidable reputation for reliability, feature robustness, and performance. In this post I want to show how you can get started quickly with PostgreSQL by creating a sample database and running some simple queries against it using…
Azure Key Vaults and SQL Encryption
I started a “few posts ago” exploring the topic of SQL Server encryption, beginning with Symmetric Encryption and then looking at the “Always Encrypted” feature. In the second post, I configured Always Encrypted on a column in a SQL table and stored the encryption key in the Windows certificate store on the client machine. In…
Always Encrypting Sensitive SQL Data
In an earlier post I spent some time exploring symmetric encryption in SQL Server. In this article I wanted to address another kind of security offered in SQL Server: “Always Encrypted”. Always Encrypted is a security feature which was introduced in an earlier version of SQL Server and is designed to ensure that data stored…
Exploring Symmetric Encryption in SQL
There is a very helpful article describing how to encrypt a column of data in a relational database by using symmetric encryption (sometimes known as column-level encryption, or cell-level encryption) using Transact-SQL found here: https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/encrypt-a-column-of-data?view=sql-server-ver15. After reading the article, I felt like working-through the provided examples myself in order to dig a bit deeper into…
Exploring the SQL Cartesian Join
Joins are an interesting and critical part of understanding and using the SQL language. One of the most curious is the Cartesian join. Simply put, cartesian joins generate a “cartesian product”, which is defined as “…the product of two sets: the product of set X and set Y (is) the set that contains all ordered…
Managing Timeouts in ControlWORQ
This article covers settings that can be changed to adjust different timeouts in your ControlWORQ installation. ControlWORQ has timeout settings which can be added or modified to adjust how long a connection remains open or how long an operation (like intercompany eliminations) runs before timing out. ControlWORQ timeouts work in tandem with Planning Analytics (PA)-based…
Supported Excel and TM1 worksheet functions by WebWORQ
Excel and TM1 worksheet expressions supported by WebWORQ include: Cell references, e.g. =B$22, =Sheet5!$K$6. Expressions built up of combinations of the following subset of predefined Excel functions and operators: Operators: +, -, *, &, =, <, >, >=, <=, <> Logical Functions: TRUE, FALSE, NOT, AND, OR, IF TM1 Functions: DBR, DBS, DBSS, DBRW, DBRA, DFRST, DIMNM,…
Expansions stop working after updating sheet names in WebWORQ
Expansions stop working after updating sheet names Issue: Updated sheet names to include -, expansions stopped working on the web Resolution: Change the – to _ and republish sheet Open WebWORQ Excel file where the expansion is not working Review Sheet names If sheet name contains a – , rename the sheet to contain _…