In this post I attempt to unravel the structure of Tableau Workbook files (TWB & TWBX). I explain some use cases where you might need to dig into the underlying structure of the workbooks. Additionally, I’ll introduce some available tools for modifying the structure. Lastly, I will explain how to retrieve the Tableau Admin Views TWB file.
Continue reading “Unravel Tableau Workbook Structure (TWB/TWBX)”Author: bitipsblog
Lessons from migrating Oracle to Redshift – Data types
This post is a first in a set of posts, which discuss various lessons learned from migrating a BI infrastructure from Oracle to Redshift
This particular post discusses the migration of Oracle data types to Redshift, obstacles, tips and some important function usage differences
Continue reading “Lessons from migrating Oracle to Redshift – Data types”
Dynamic RegExp pattern matching in Redshift
Recently I needed to match regular expressions patterns in Redshift, where both the string and the regular expression were dynamic values provided from table columns. Unfortunately REGEXP_COUNT and other similar functions in Redshift, do not support columns as the regular expression. Therefore I decided to solve this with a UDF.
Continue reading “Dynamic RegExp pattern matching in Redshift”
HTML based emails from Python (ssmtp)
In this post I provide a simple Python code which utilizes ssmtp with MIME in order to send an HTML based email with an embedded image.
Continue reading “HTML based emails from Python (ssmtp)”
Redshift with SAP Data Services
Redshift is a supported source & target for SAP Data Services 4.2 SP8. However, there isn’t much information available about utilizing Redshift with the use of SAP Data Services. Therefore, I decided to summarize my recent observations related to this subject.
Gathering DB Statistics during ETL
Gathering table statistics can have severe performance implications for your ETL & reporting process. In this post I describe why it is important to consider gathering statistics in your ETL process and I provide an example of how this can be achieved.
Utilizing Oracle Basic Compression With Partitions
Oracle basic compression is a free built-in feature, which can be used to reduce data size. This feature is only recommended for use with read-only data due to various limitations. In this blog post, I describe my own solution on how to use Oracle basic compression with a read-write aggregate table.
Continue reading “Utilizing Oracle Basic Compression With Partitions”
Comparing Resources & Performance: Tableau, Qlik Sense & MicroStrategy
In this post, I created a high level comparison of different Desktop reporting software. This comparison focuses on performance and resource usage, rather than focusing on the different reporting features
Continue reading “Comparing Resources & Performance: Tableau, Qlik Sense & MicroStrategy”
UNION your way to a faster & easier Tableau report
In this post I describe why using a UNION can be of great benefit when time is of the essence. Using a UNION can be a handy way to create Tableau reports which are easier to build, faster to load and provide more dynamic capabilities.
Continue reading “UNION your way to a faster & easier Tableau report”
Creating a calendar dimension table & importance of ISO Week
In this post I will describe why you should highly consider to have a calendar dimension table in your reporting layer. I provide my own suggestion on creating the table in Oracle, and lastly I explain why you should pay special attention to ISO week.
Continue reading “Creating a calendar dimension table & importance of ISO Week”
Business Intelligence Tech Tips 