Analytics

Istock 903569480 (5)

ETL & SQL : The Dynamic Data Duo

Data is the lifeline of any modern organization. At any point, every day, you work on molding data points into information to derive profits. Therefore, having the right building blocks is a crucial part of running a good business. This is where the dynamic duo of ETL and SQL comes into play. While you may […]

Application security assessment

Unexpected MDX assumptions and error handling for subsets in TM1/Planning Analytics

I had a bug in a TM1 application recently that was very difficult to track down, and it was because I didn’t understand the different ways that TM1 might respond to vague or incorrect MDX expressions.  MDX makes some unexpected assumptions. Take the following simplified example cube: Let’s say that I have an active form […]

abstract circuit networking blockchain concept background

Views in Denodo

Denodo Virtual DataPort tool can import data coming from different systems and with different structures or formats. To Retrieve Data from the source, views are created in Denodo. I will be using an Oracle 11g data source to fetch the data here and Denodo Web Design studio to create views. “To know more about connecting […]

Woman working with code and data

Connecting Data Sources with Denodo

What is the use of Denodo? It allows business users to examine the particular data mistreatment associated with an intuitive interface through the Denodo Platform.   Data sources supported by the Denodo Platform Denodo Platform supports many different data sources like Amazon Redshift, Apache Derby, Apache Spark SQL, Greenplum, Hadoop, Hive, Microsoft SQL Server, Netezza, […]

2

Empowering IoT with AI

Have you ever wondered how wonderful it would be if things like switching on lights, opening the doors, email replies, etc. which we require in day-to-day life become automated? Life would become easier, and humans will be able to take out time for themselves. Well, this is now possible thanks to AI and IoT. So, […]

Application security assessment

Analyzing TM1 logs and data from the command line using Find

The Find Command I come from a systems background in Windows and Linux, maintaining operations and writing programs in C.  Since I bring that perspective to my TM1 work, I’m more comfortable with command line tools than some of my other teammates, so I thought I would share some tips. As an example, let’s look […]

Group of web developers working in an office.

Feature of Snowflake: Zero Copy Cloning

                                                                      Feature of Snowflake: Zero-Copy Cloning Zero Copy Cloning in Snowflake: Snowflakes have some advanced feature like Time Travel, zero-copy cloning […]

Traditional Software Engineering, Cmmi And Its Problems

EXPLORE TIME TRAVEL IN SNOWFLAKE

Have you ever wondered if it would ever be possible to time travel like in the old movies with a time machine? If we could go back in time and see the world, would we? If you asked me, I would have said yes! But not in the way that Hollywood portrays science fiction films. […]

Picture

An Introduction to Data Virtualization

End users of large data banks must be protected from knowing how the data is organized in the machine – the internal representation. Generally, most application programs should remain unaffected when the internal representation of data is changed or even when some aspects of the external model are changed. The guiding principle of Data Virtualization […]

Group of web developers working in an office.

HOW TO IMPLEMENT BASIC ETL TEST SCENARIOS (PART 1)

In this blog, we will see what the basic test scenarios for ETL testing are. However, before we go to the ETL test scenarios, let me first tell you what ETL is and how it works, along with the process involved with it. WHAT IS ETL? ETL stands for Extract-Transform-Load, and it is a process […]

tiethnic colleagues sitting at desk looking at laptop computer in office. stock photo

How to Convert Blank Values to Null in Flat File Source in SSIS Package

SQL Server Integration Services(SSIS): SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading. In […]

Image of laptop computer with Google Analytics open. It sits on a white table.

Introduction to Google Analytics – A Guide for Beginners

A guide towards an entry to Google Analytics with Naeem Sheikh. What is Google Analytics? Google Analytics is a web analytics service offered by Google that will help in tracking website traffic and generate an easy understandable report to analyze the performance of your website. It is basically divided into five major report i.e. Realtime […]

Load More