by Sakthi Vijay Balu | Feb 11, 2019 | Azure
Overview Data Extraction, Transformation and Loading (ETL) is fundamental for the success of enterprise data solutions. The process must be reliable and efficient with the ability to scale with the enterprise. There are numerous tools offered by Microsoft for the...
by Sakthi Vijay Balu | Nov 21, 2018 | Azure, Power BI
How easy is it to move data from a plethora of sources into a single large repository and use it as a data source? The above mentioned, plus the choice of data formatting, column remapping, inclusion/exclusion of fields and a whole new way of maintaining consistency...
by Sakthi Vijay Balu | Nov 12, 2018 | Power BI
How many times has someone built a Power BI report and finally had the source of the data changed to a new location? Well, this blog walks everyone through a set of steps to assist transitioning of the query without breaking the Report’s charts. Situation: Source...
by Sakthi Vijay Balu | Aug 13, 2018 | Azure
Ever tried accessing data on Azure SQL Database from a Python IDE? This article will walk you through the steps required to reach the data in Azure SQL Database tables. Before beginning, let us set up the pre-requisites needed for the process. Below are the software...
by Sakthi Vijay Balu | Aug 7, 2018 | SAP HANA
Dealing with a customer who is hesitant to provide access to their HANA tables? Well, request the necessary data in the HANA system as Views, because the data within a View would be a subset of the larger table and it would be straight up easier for any referencing...