Analytics

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

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

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

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, […]

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, […]

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

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

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

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

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

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

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