Latest Posts
-
Designing AI Infrastructure for the Modern Enterprise
Enterprises are increasingly prioritising AI infrastructure, particularly generative AI, as essential for integrating AI frameworks into business workflows. The demand for specialised infrastructure is driven by the need for scalability, cost efficiency, and reliability, especially… Read more
-
Avoiding Data Quality Failures: Enterprise Challenges and Best Practices
Data quality is crucial for businesses, as poor data quality can lead to significant financial losses and hinder decision-making. It encompasses dimensions such as accuracy, completeness, uniqueness, consistency, timeliness, and validity. Enterprises often struggle with… Read more
-
Building Enterprise Data Lineage & Provenance
Data lineage is crucial for data management and governance, tracking data from its origin to destination. It ensures quality control and compliance, benefiting data engineers and owners. Unlike data provenance, which focuses on the origin… Read more
Archive Posts
-
Lets start this new year with a small introduction to Microsoft SQL Server Business Intelligence or MSBI. In short it’s another “very” popular BI tool like Pentaho BI Suite build by Microsoft. MSBI provides you with a complete suite to work around your BI needs/requirements. This tools provides you with easy plugins to develop your…
-
The blog details steps for loading data from Amazon S3 to Redshift using PDI. The process includes creating a table in the Redshift cluster, executing a COPY command to read and load data from S3 in parallel, and ensuring the COPY command ignores the header of CSV files to prevent errors.
-
Loading large volumes of data into Amazon Redshift using Pentaho may initially present performance issues due to Redshift treating each data row as a separate query. A more efficient strategy involves loading the data into an AWS S3 bucket first, then copying the data from the bucket to Redshift via a single query.
-
The use of data by people and business around the world is on a rise. Almost everyone involved into work are now-a-days looking for a analytics solution and to take business decisions based on the insights generated from data. As a results a number of DW/BI solutions are born in the market. The BI tools…
-
The older website: anotherresshu has been renamed and linked to Tech-Spaghetti (the current website); enabling me to streamline the content and reach more audience. This blog post was from the archives. Thank you for all your support all these years, Wow.. its been 1 year since i have been authoring anotherReeshu. I would love to…
A Tech Spaghetti Blog Newsletter made just for you
Latest blog posts and insights on data, analytics, cloud, pentaho, artificial intelligence and more straight to your inbox.
Subscribe
Join hundreds of happy subscribers!
Tech Spaghetti 