Unpivot Data

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…

Pivot Data

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…

Dataset Review

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…

streamline business reporting

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…

Personalize Financial Reports

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.…

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.

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 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: 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: 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.…

Euclid Studio: Connecting to a database via JDBC

When using an ETL and modeling tool like Euclid Studio, it’s extremely likely that you’ll want to access your relational databases. The following steps will walk you through configuring a JDBC connection within a Euclid Studio flow. Once you’ve logged into Euclid Studio and created/opened your flow, hover over the ‘Server’ menu at the top…

Euclid Studio: Running a Flow

When creating a flow in Euclid Studio, you may want to run a single node to perform a single operation or run an entire flow of nodes. This article will review the options you have to run processes within the context of the Euclid Studio application. Before we get into the how, it’s important to…

Euclid Studio: Introduction to Nodes

This video introduces you to the Euclid Studio canvas where you can interact with Nodes. Nodes are used to capture your business logic. Each Node has a specific purpose, and many Nodes can be used in combination to achieve your desired outcome.

Euclid Studio: Derive a New Column

This video teaches you how to Derive a new column in Euclid Studio. You can use information provided in your dataset to drive the creation of a new column. This is approach enables you to use a consistent strategy to derive more meaning from your data.

Euclid Studio: Clean a Column in a Text File

This video walks you through an example of how you can perform Text Cleansing in Euclid Studio. You will learn how to clean up text in various columns of your data pipeline.

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…

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…

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.…

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…

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…

SQL Server IMAGE and VARBINARY Data Types

The IMAGE data type in SQL Server has been used to store the image files. Recently, Microsoft began suggesting using VARBINARY(MAX) instead of IMAGE for storing a large amount of data in a single column since IMAGE will be retired in a future version of MS SQL Server. Illustration As always, I think the best way to understand something is…

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…

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 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…

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…

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…

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 _…

Can't find what you're looking for?