23rd February 2023

How Data Analytics Support Can Help Your Business Stay Ahead of the Curve

How Data Analytics Support Can Help Your Business Stay Ahead of the Curve

Read More
Understanding SQL Query Execution: A Data Engineer’s Guide.

Understanding SQL Query Execution: A Data Engineer's Guide.

As data engineers, we work with SQL daily, but how many of us truly understand the inner workings of a SQL query? Knowing the order of execution can significantly improve the way you write SQL queries. Let’s dive into the process with a practical example. Example Query1: Step 1: Gather the DataOperation: FROM & JOIN […]

Read More
Optimizing SAP Data Warehouses with DBT: A Comprehensive Guide to Enhanced Analytics
6th November 2024

Optimizing SAP Data Warehouses with DBT: A Comprehensive Guide to Enhanced Analytics

In today’s data-driven world, businesses rely heavily on analytics to make informed decisions, optimize processes, and stay competitive. As the volume and complexity of data increase, ensuring efficient data transformation and management becomes critical. This is where the combination of SAP Data Warehouses and DBT (Data Build Tool) offers an innovative approach to improving analytics […]

Read More
Cloud-Based Supply Chain Dashboards: Key Benefits and Trends for 2025
6th November 2024

Cloud-Based Supply Chain Dashboards: Key Benefits and Trends for 2025

In an increasingly interconnected and competitive global economy, supply chain management is more critical than ever. Businesses must ensure efficiency, agility, and resilience in their supply chains to remain competitive, and cloud-based supply chain dashboards are becoming essential in achieving these objectives. By providing real-time visibility, fostering collaboration, and enabling data-driven decisions, cloud-based dashboards are […]

Read More
How to Ensure Data Quality and Governance in Your Enterprise Data Lake
6th November 2024

How to Ensure Data Quality and Governance in Your Enterprise Data Lake

In today’s data-driven world, enterprises are continually collecting massive volumes of data from multiple sources to drive decision-making, enhance customer experiences, and stay competitive. An Enterprise Data Lake serves as a central repository for all this raw data, allowing organizations to store data of all types, structured or unstructured, at any scale. However, without Data […]

Read More
6th November 2024

Harnessing Data Management Services to unlock Business Value

In today’s rapidly evolving business landscape, data has emerged as one of the most valuable assets for any organization. Whether it’s for making strategic decisions, optimizing operations, or identifying new business opportunities, the effective management of data is critical. Data Management Services play a crucial role in ensuring that businesses can extract maximum value from […]

Read More
Migrating to SAP BTP – Best Practices for a smooth Transition to the Cloud
30th October 2024

Migrating to SAP BTP - Best Practices for a smooth Transition to the Cloud

The modern business landscape is increasingly driven by digital transformation, and cloud adoption is at the heart of this shift. SAP Business Technology Platform (SAP BTP) offers organizations a robust cloud-based platform that accelerates innovation, improves operational efficiency, and delivers the scalability needed to thrive in today’s competitive environment. As businesses transition from legacy systems […]

Read More
The Role of AI and Machine Learning in Enhancing xP&A Capabilities
30th October 2024

The Role of AI and Machine Learning in Enhancing xP&A Capabilities

In the fast-evolving world of business, data-driven decision-making has become essential for staying competitive and agile. Traditional financial planning processes no longer suffice in an era where organizations must anticipate market trends, optimize resources, and respond to rapidly changing conditions. This is where Extended Planning and Analysis (xP&A) comes into play, providing a more comprehensive, […]

Read More
How AI is Shaping the Future of Financial Planning & Analysis
30th October 2024

How AI is Shaping the Future of Financial Planning & Analysis

In the ever-evolving world of finance, Financial Planning and Analysis (FP&A) has long been the cornerstone of business decision-making. With the increasing complexity of markets and the exponential growth of data, traditional methods of financial forecasting, reporting, and analysis are proving insufficient. Enter artificial intelligence (AI), a technology that is fundamentally transforming the way FP&A […]

Read More
Overcoming Key Challenges in SAP BW to Snowflake Migration
26th October 2024

Overcoming Key Challenges in SAP BW to Snowflake Migration

In the era of cloud-first strategies, many organizations are looking to modernize their data landscapes by moving from traditional on-premises solutions like SAP BW (Business Warehouse) to cloud-native platforms like Snowflake. SAP BW to Snowflake migration promises numerous advantages, including improved performance, scalability, and advanced features that empower businesses to gain better insights from their […]

Read More
25th October 2024

Self-Service BI vs. Traditional BI: Which is Right for Your Business?

In today’s rapidly evolving business landscape, data is a powerful asset that drives decision-making and shapes strategies. As businesses aim to become more data-driven, Business Intelligence (BI) tools have become indispensable. Business Intelligence refers to the processes, technologies, and tools used to collect, analyze, and present data to inform business decisions. Two distinct models of […]

Read More
Cloud DevOps Consulting and Implementation Services on Azure
25th October 2024

Cloud DevOps Consulting and Implementation Services on Azure

In today’s fast-paced digital landscape, organizations are increasingly turning to Cloud DevOps to streamline their development and operations processes. With the right DevOps Consulting Services, companies can enhance collaboration, improve software delivery times, and ensure the quality of their applications. Among the various cloud platforms available, Microsoft Azure stands out as a leading choice for […]

Read More
Streamlining Data Consumption in Power BI with SAP Datasphere
25th October 2024

Streamlining Data Consumption in Power BI with SAP Datasphere

In today’s data-driven business environment, the ability to efficiently consume and analyze data is paramount for organizations aiming to make informed decisions. SAP DataSphere and Power BI are two powerful tools that, when integrated, can significantly enhance data analytics capabilities. This blog will explore the importance of efficient data consumption in business intelligence, provide an […]

Read More
Latest Innovations in SAP Analytics Cloud: A Deep Dive into SAC Updates
25th October 2024

Latest Innovations in SAP Analytics Cloud: A Deep Dive into SAC Updates

In the world of data analytics, staying ahead of the curve is crucial for organizations aiming to leverage insights for competitive advantage. SAP Analytics Cloud (SAC) has emerged as a leading solution that combines business intelligence, augmented analytics, and enterprise planning in a single cloud-based platform. As technology evolves, so does SAC, with continual innovations […]

Read More
Zero-ETL: An Innovative Approach to Data Integration
6th Sep 2024

Zero-ETL: An Innovative Approach to Data Integration

The modern business world is demanding fast deployment of data insights. Companies need efficient methods to transition from data collection to analytics, AI, and machine learning. Conventional ETL (extract, transform, load) frameworks often fail to meet the technical demands of big data and real-time analysis. To tackle these challenges, a new data management approach known […]

Read More
19th July 2024

5 Ways Azure Purview Can Revolutionize Your Data Governance Strategy

Effective data governance is more critical than ever in today’s data-driven world. Organizations are inundated with data from various sources, and managing this data efficiently while ensuring compliance with regulatory standards is a significant challenge. Traditional data governance methods often need to catch up due to their inability to scale and adapt to the ever-evolving […]

Read More
A Five-Step Guide to Develop Your Robust Data Strategy Roadmap
19th July 2024

A Five-Step Guide to Develop Your Robust Data Strategy Roadmap

In today’s data-driven world, a well-defined data strategy roadmap is essential for organizations aiming to leverage their data assets for improved decision-making and enhanced ROI. A data strategy roadmap serves as a structured plan that aligns data initiatives with business goals, ensuring that data is effectively managed, analyzed, and utilized. This blog will outline a […]

Read More
Top Data Migration Tools to Use in 2024
19th July 2024

Top Data Migration Tools to Use in 2024

Data migration transfers data between storage systems, formats, or computer systems. In the digital landscape, data migration is essential for organizations undergoing cloud adoption, business transformation, or striving to meet data compliance requirements. As businesses increasingly rely on data to drive operations and decision-making, the need for efficient and reliable data migration services has never […]

Read More
All About the Dynamic Duo of Next Generation Analytics – SAP DataSphere and SAP Analytics Cloud
10th July 2024

All About the Dynamic Duo of Next Generation Analytics - SAP DataSphere and SAP Analytics Cloud

Analytics tools have become indispensable in helping organizations make sense of vast data, providing insights that drive strategic actions. Among the leading solutions in the analytics landscape are SAP DataSphere and SAP Analytics Cloud. When used together, these tools offer a powerful combination for next-generation analytics, enabling businesses to manage, analyze, and visualize data seamlessly. […]

Read More
A Comprehensive Guide to Building an Enterprise Data Lake on AWS Cloud
10th July 2024

A Comprehensive Guide to Building an Enterprise Data Lake on AWS Cloud

In today’s data-driven world, enterprises are constantly seeking ways to harness the power of their data to gain insights and drive decision-making. One such approach is building an enterprise data lake. An enterprise data lake is a centralized repository that allows organizations to store all their structured and unstructured data at any scale. Building this […]

Read More
10th July 2024

The Dominant Power of Advanced Analytics Consulting in Transforming CX Management

Amidst today’s rapid business landscape, the quest for delivering exceptional customer experiences (CX) reigns supreme. CX management, a comprehensive journey that extends beyond mere customer service, is a key focus. Advanced analytics consulting emerges as a significant change, empowering businesses with a potent instrument to elevate CX management. By leveraging data and sophisticated analytical methods, […]

Read More
Mastering Security and Compliance for Synapse Data Warehouse
4th June 2024

Mastering Security and Compliance for Synapse Data Warehouse

Synapse Data Warehouse is the cornerstone of modern data management, giving companies unparalleled ability to analyze large amounts of data and gain insights. In today’s data-driven world, the importance of security and compliance cannot be underestimated. Please don’t overdo it. This blog explores security and compliance’s critical role in securely managing data in Synapse Data […]

Read More
The Power of Data Management Services in Digital Transformation
4th June 2024

The Power of Data Management Services in Digital Transformation

Digital transformation fundamentally changes customer value delivery by integrating digital technology into all aspects of a business. These changes include technological advances and cultural shifts that require organizations to constantly challenge, test, and adapt to the status quo. Effective data governance, a key element of digital transformation, drives insight and decision-making.  Data management services are […]

Read More
Fort Knox Your Data Security with SAP Datasphere Technology
4th June 2024

Fort Knox Your Data Security with SAP Datasphere Technology

Data security has become a top priority for businesses and organizations in today’s digital age. With data’s increasing volume and complexity, protecting sensitive information from unauthorized access and breaches is essential to maintaining trust and integrity. SAP Datasphere Technology emerges as a robust solution designed to strengthen your data security measures and protect your valuable […]

Read More
Seamless Transition and Enhanced Support: TekLink’s Success Story
14th March 2024

Seamless Transition and Enhanced Support: TekLink's Success Story

In the dynamic world of technology, businesses constantly seek ways to optimize their operations and enhance efficiency. One critical aspect is the seamless transition of IT responsibilities, ensuring uninterrupted support and continued improvements. In a recent collaboration, the TekLink Team successfully replaced an onsite Architect with an offshore resource for a client, offering robust support […]

Read More
7th March 2024

Mastering SAP BW to Snowflake Migration: Best Practices and Key Considerations

The ever-expanding data landscape within modern enterprises demands a resilient data infrastructure that facilitates efficient analysis and informed decision-making. In response to the growing complexity, businesses are increasingly exploring alternatives to traditional data warehouse solutions, with Snowflake, a cloud-based data warehouse, emerging as a compelling migration target. This exploration delves into the crucial aspects of […]

Read More
Empowering FP&A by mastering SAP Analytics Cloud Integration
20th February 2024

Empowering FP&A by mastering SAP Analytics Cloud Integration

In the ever-evolving business landscape, the role of Financial Planning & Analysis (FP&A) has become increasingly crucial. This blog aims to delve deeper into the transformative journey of FP&A, examining the pivotal role that technology, specifically SAP Analytics Cloud, plays in reshaping its processes. Integrating advanced analytics and data-driven decision-making becomes paramount as organizations navigate […]

Read More
Tips and Tricks for Effective Data Visualization in Azure Power BI
8th February 2024

Tips and Tricks for Effective Data Visualization in Azure Power BI

In today’s data-driven world, extracting actionable insights from vast datasets is no longer a luxury but a necessity. Azure Power BI emerges as a powerful ally in this quest, empowering organizations to unlock the hidden potential within their data. Yet, the true magic lies not just in the analysis but in how effectively that analysis […]

Read More
Strategic Growth with SAP’s RISE Methodology
29th January 2024

Unveiling strategic growth with SAP’s RISE Methodology implementation

The foundation of this implementation was the strategic utilization of SAP’s RISE Methodology, a structured approach encompassing Realize, Innovate, Sustain, and Enhance. This methodology, offered as a managed cloud service by SAP, was pivotal in migrating critical ERP data, processes, and capabilities to the cloud. The Realize phase focused on understanding the existing landscape, Innovate […]

Read More
RelativePath/Query Option in Power BI
11th January 2024

RelativePath/Query Option in Power BI

This blog post will provide a comprehensive guide or content to relative queries in Power BI. We will cover the following topics: What is a RelativePath/query? RelativePath & Query are two powerful options that can be used to construct URLs for web service calls in Power BI. They are both records that can be used […]

Read More
21st December 2023

Thriving in Dynamic Markets with the BI Advantage

In today’s fast-paced and ever-evolving business landscape, the ability to make informed decisions is not just advantageous; it is imperative for staying competitive and thriving in today’s dynamic markets. This comprehensive exploration delves deeper into the transformative trajectory of Business Intelligence (BI), tracing its roots from essential reporting tools to its current status as an […]

Read More
SAP’s Strategic Direction for Analytics (BusinessObjects BI 2025)
13th December 2023

SAP’s Strategic Direction for Analytics (BusinessObjects BI 2025)

SAP Introducing BusinessObjects BI 2025 SAP continues to develop BusinessObjects and will continue to invest in the interactivity between Analytical Cloud and BusinessObjects. SAP BusinessObjects BI 2025 will be enhanced to improve core workflows, i.e., report creation, access to information, and integration with ever more complex landscapes. Integrating Bl, planning, and predictive in one native […]

Read More
In the Clouds: Azure’s Data Engineering Revolution (August 2023)
5th December 2023

In the Clouds: Azure's Data Engineering Revolution (August 2023)

In the dynamic world of data engineering, staying up-to-date with the latest updates is essential to maintain efficiency and leverage the most advanced tools available. Microsoft Azure, a leading cloud platform, continuously introduces new features and enhancements directly impacting data engineering workflows. This blog will explore the most significant updates in Azure up to August […]

Read More
SAP Analytics Cloud Revolutionizes predictive capabilities
14th November 2023

Predictive Power Unleashed – SAP Analytics Cloud Revolutionizes Decisions

In the complex world of business analytics, SAP Analytics Cloud stands out as a robust tool, offering organizations valuable insights. This blog explores the significance of predictive forecasting within SAP Analytics Cloud, examining its features, benefits, real-world applications, implementation tips, and future trends. Predictive forecasting, departing from traditional statistics, involves using historical data, machine learning […]

Read More
Data Visualization’s Role in Optimizing Supply Chains
23rd October 2023

Data Visualization's Role in Optimizing Supply Chains

Supply Chain KPI Dashboards are crucial in modern supply chain management, offering real-time insights and data-driven decision-making capabilities. In this blog, we’ll explore the significance of data visualization within these dashboards and how it transforms supply chain performance. Supply chains are the backbone of businesses, ensuring the seamless flow of goods and services. Any disruption […]

Read More
20th October 2023

Using Microsoft Product Charticulator to Create Custom Power BI Visuals

Charticulator is a Microsoft product that allows the user to create custom visualizations to be used in Power BI. Charticulator guide: https://charticulator.com/docs/getting-started.html. In this blog we will walk through a use-case scenario for Charticulator and how to integrate that custom visual into Power BI. The requirements from the client state that they want a bar […]

Read More
Migrating Data Warehouse to a Data Lakehouse
16th October 2023

Migrating Data Warehouse to a Data Lakehouse

What is Data Lakehouse? A Data Lakehouse combines the flexibility of data lakes with the structured processing and analytics capabilities of data warehouses. It allows you to store, manage, and analyze data efficiently. Why Migrate to a Data Lakehouse? Data is vital for modern businesses, but traditional data warehouses face challenges as data grows. The […]

Read More
Data Masking Policies in Snowflake
13th October 2023

Data Masking Policies in Snowflake

Data security has established itself as an unwavering foundation within the technological framework of modern applications. Snowflake came with a new feature – “dynamic data masking” – an essential tool that allows it to address the never-ending issue of sensitive data protection. Dynamic Data Masking will protect/control the column data and make it visible to […]

Read More
Streamlining Azure Purview Asset Classification with Automation
4th October 2023

Streamlining Azure Purview Asset Classification with Automation

The Team was working on a data governance requirement. It required the Team to classify the assets as a “Dimension Table” or a “Transaction Table” based on the asset name. They were using Azure Purview as the data governance tool. However, it was a hectic task to follow the same steps and extremely monotonous to […]

Read More
Date Range for Paginated Report Parameter using Calendar Format
28th September 2023

Date Range for Paginated Report Parameter using Calendar Format

We have Power BI Report Builder to create paginated reports from Power BI Datasets and other popular data sources.  We also have the Power BI Service, where we can publish paginated reports to Premium-backed workspaces and export them to PDF and Microsoft Excel formats. Now, let’s look at the date filtering problem we faced. Date […]

Read More
27th September 2023

Unlocking Growth with the Complete BI Strategy Blueprint

In today’s fast-paced and data-centric business world, the significance of Business Intelligence (BI) cannot be overstated. BI is the driving force behind informed decisions, actionable insights, and maintaining a competitive edge. This blog explores the pivotal role of BI and how a well-crafted BI strategy can be your compass to navigate the complexities of modern […]

Read More
Enhance Analytics with SQL Window Framing – A Guide
24th August 2023

Enhance Analytics with SQL Window Framing - A Guide

Window Framing Window framing is a concept of accessing a range of data while executing window functions. Window frame comes into the picture whenever you do calculations using window functions. It enables you to decide the range of data to perform the window function calculation in a particular partition. Window Frame A set of rows […]

Read More
Tooling Up for Data Science Implementation Excellence
22nd August 2023

Tooling Up for Data Science Implementation Excellence

In the contemporary landscape, data science is revolutionizing industries by converting insights into actionable strategies. Appropriately choosing tools and technologies is paramount to achieving a fruitful data science implementation –translating insights into real-world solutions. This article delves into the fundamental considerations for making these selections, ensuring a seamless journey from gathering data to deploying models. […]

Read More
Using Direct Query for Power BI Datasets
8th August 2023

Using Direct Query for Power BI Datasets

What is DirectQuery for Power BI datasets? With DirectQuery for Power BI datasets and Analysis Services, you can use DirectQuery to connect to Power BI datasets. Report authors who want to combine the data from their enterprise semantic model with other data they own, such as an Excel spreadsheet, or want to personalize or enrich […]

Read More
Automating Asset Grouping in Azure Purview
27th July 2023

Automating Asset Grouping in Azure Purview

The Team was working on a data governance requirement. It required the Team to group the same type of assets into a logical collection. They were using Azure Purview as the data governance tool. However, it was a tedious task to achieve this manually. Therefore, there was a need to automate it. This blog deals […]

Read More
24th July 2023

The Power of Data Analytics in AMS Support: Leveraging Insights for Success

Today’s businesses rely heavily on applications to streamline processes, enhance productivity, and gain a competitive edge. As applications become more complex, ensuring seamless performance and availability is vital for sustained success. This is where Application Management Services (AMS) come into play. AMS providers offer comprehensive support to monitor, maintain, and optimize critical business applications. In […]

Read More
TekLink Enables Seamless BPC Upgrade and Migration
19th July 2023

TekLink Enables Seamless Upgrade and Migration for a Multinational Food Products Company

Companies must continuously adapt their technology systems to stay competitive in the dynamic business world. This blog showcases a successful project undertaken by TekLink, for a multinational food products company renowned as the world’s one of the largest cereal companies. This project addressed critical business challenges while ensuring a smooth upgrade and migration process. The […]

Read More
A Comprehensive Approach to SAP Cloud Security
18th May 2023

A Comprehensive Approach to SAP Cloud Security

A Comprehensive Approach to SAP Cloud Security

Read More
Benefits of DevOps in CI/CD Implementation
12th May 2023

Breaking Down the Benefits of DevOps Consulting Services in CI/CD Implementation

DevOps is a methodology and cultural approach to software development that emphasizes collaboration, integration, and communication between development and operations teams. By promoting shared responsibility and cooperation throughout the software development lifecycle, DevOps aims to bridge the gap between these two domains. This approach adopts automation, streamlined processes, and tools to enable efficient software application […]

Read More
Advanced Techniques for Automating Data Integration with Anaplan Connect
18th April 2023

Advanced Techniques for Automating Data Integration with Anaplan Connect

Understanding Data Integration and Automation Data Integration is gathering data from different sources into a centralized source for better data analysis and decision-making. Data Automation is the use of technology to automate data-related tasks and workflows to improve the efficiency and productivity of an organization. These are important activities that an organization must consider implementing […]

Read More
13th April 2023

How to Monitor Power BI Refresh Dataset Performance and Ensure Data Accuracy

An Introduction to PowerBI In today’s data-driven world, making informed decisions based on data has become a crucial element of success for businesses and individuals alike. Power BI is a powerful analytics tool that helps users analyze and transform data into actionable insights. In the following passage, we will explore how Power BI can help […]

Read More
How Data Analytics Support Can Help Your Business Stay Ahead of the Curve
23rd February 2023

How Data Analytics Support Can Help Your Business Stay Ahead of the Curve

How Data Analytics Support Can Help Your Business Stay Ahead of the Curve

Read More
Improving your planning and reporting process with BI services
17th February 2023

Improving your planning and reporting process with BI services

Before discussing the nuances of Business Intelligence, we focus on why companies need help to have a good reporting process. These are just some reasons to introduce you to the issues that companies might face. Understanding Business Intelligence: Business Intelligence (BI) refers to organizations’ tools, systems, and practices to analyze and present data to make […]

Read More
Resolving John Snow Labs(JSL) Library Error in Databricks
7th February 2023

Resolving John Snow Labs(JSL) Library Error in Databricks to seamlessly make insightful decisions driving the business objectives.

Why is it essential to resolve a JSL Library Error? Resolving errors in the John Snow Labs (JSL) Library in Databricks is critical for seamless and efficient data analysis and processing. It helps achieve business objectives, such as making data-driven decisions, identifying trends and patterns, and ultimately making informed business decisions. To resolve errors in […]

Read More
Understanding SAP BPC and the steps to its implementation
31st January 2023

Understanding SAP BPC and the steps to its implementation

Understanding SAP BPC and the steps to its implementation

Read More
27th January 2023

How SAP Data Warehouse Cloud connects Business and IT

SAP Datasphere (Previously SAP DWC) is a cloud-based data warehousing solution that connects business and IT by providing a unified data integration, modeling, and analytics platform. It allows business users to access and analyze data in real time while providing IT with the tools to manage and govern data. One of the key features of […]

Read More
Dynamic Conditional Formatting based on given targets in Power BI Matrix
7th December 2022

Dynamic Conditional Formatting based on given targets in Power BI Matrix

** Conditional formatting of measures values in matrix based on given targets for given values (these values are rows in matrix) The business users used Weighted Forecast Accuracy – WFA (A Percentage Measure) metric for various business divisions. They wanted to understand each division’s targets better to achieve 100% of the forecast. We worked on […]

Read More
Resolving Error in Azure Function with Extension Bundle
24th November 2022

Resolving the error in Azure Function with Extension Bundle

In one of our Azure projects, during the development phase, while writing the files into Azure blob storage in Visual Studio Code, we faced the below error: The root cause of the error: “Error fetching version information for extension bundle Microsoft.Azure.Functions.ExtensionBundle Unable to find or download”. Solution: “Extension Bundles” can add a pre-defined compatible set […]

Read More
Resolving the ECONNREFUSED Error with VS Code
1st November 2022

Resolving the ECONNREFUSED Error with VS Code while running an Azure Function

We were working on a project requiring us to extract data from an API and land it over a data lake storage account container. So, we created an Azure Function App using Visual Studio (VS) code. We set up an environment for the variable using the SETX command locally. While debugging the code, we got […]

Read More
Correcting the column name definitions in Theobald Bex Query
5th July 2022

Correcting the column name definitions in Theobald Bex Query

Spaces and other special characters in the column names in Theobald Bex Query Extract cause errors in Azure Synapse Analytics during loading into a data warehouse. We worked on a requirement where Theobald job extracted Bex Query Result into a Parquet* file and placed it in the Azure Data Lake Gen2 Container. From Azure Data […]

Read More
22nd June 2022

Using Calculation Groups in AAS and PowerBI

Calculation groups can significantly reduce the number of redundant measures by grouping common measure expressions as calculation items. Calculation groups are supported in tabular models at the 1500 and higher compatibility levels. These are most commonly used in time intelligence measures and to reduce the redundant complex codes. It can significantly reduce the number of […]

Read More
Collecting failed records from ADF Pipeline and storing in Azure Datalake
9th June, 2022

Collecting failed records from Azure Data Factory Pipeline and storing in Azure Datalake Storage

We had approximately 130 customer accounts to extract data through the ADF pipeline to be loaded into the Datawarehouse. We ran into an issue of failed or successful loading of customer accounts into the storage account in ADLS. We used the “forEach” activity for all the customer accounts when the activity fails/succeeds. We required the […]

Read More
Customize ARM Template of ADF with IRE
6th June 2022

Customize the ARM Template of Azure Data Factory (ADF) that has Integration Run Time (IRE)

We worked on a Sales Analytics application built to pull the data from SAP and land it over to SQL Server. While working on it, we migrated to Azure Data Factory from one subscription model to another for a POC. We used ARM templates for this purpose. During deployment, there were issues because the same […]

Read More
Triggering Power BI Dataset Refresh from Azure Data Factory (ADF)
30th May 2022

Triggering Power BI Dataset Refresh from Azure Data Factory (ADF)

This blog explains how to trigger Power BI dataset refreshes using an Azure Data Factory Web Activity. Background: The business requirement was to develop a solution to trigger Power BI dataset refresh from ADF after completing the ETL pipeline. We were implementing the incremental data load process for which the ETL pipeline was designed to […]

Read More
Getting the correct totals in Power BI for calculated measures grouped by a set of fields
24th May, 2022

Getting the correct totals in PowerBI for calculated measures grouped by a set of fields

Totals in Power BI are calculated horizontally instead of vertical sum for the calculated measure grouped by a specific set of fields We worked on a requirement to get the Vendor Responsibility for the warranty claimed by customers. The data set was as follows: Vendor Material Customer Sales Warranty Vendor Responsibility % Vendor Responsibility (Warranty*Vendor […]

Read More
February 07, 2022

Machine Learning with Industrial Production: Data Modeling

In the second of two posts covering a recent Machine Learning project at an industrial company. The first post covers the dataset, preprocessing, and features used to analyze the data. With these data assumptions, we can now hope to better understand the algorithms attempted in the project’s next phases.   We won’t cover any specific findings or outcomes […]

Read More
Machine Learning with Industrial Production – Data Preprocessing
February 01, 2022

Machine Learning with Industrial Production - Data Preprocessing

As the hardware required to collect, synthesize, and analyze data becomes cheaper, the opportunity to apply Machine Learning solutions to complex environments grows. The area that is ripe for disruption in the industrial production processes, by leveraging constant streams of data that record measurements from different sections of the production process. However, the promise of […]

Read More
Configuring the Dropdown feature in Analytic Designer
June 08, 2021

Configuring the Dropdown feature in Analytic Designer: SAP Analytics Cloud

With SAP focusing on cloud-based analytics, SAP Analytics Cloud (SAC) is becoming one of the most sort after tools in the SAP BI space. SAC is more of a self-service solution on the cloud, hence, there was a constant business need for a professionally authored dash-boarding tool on the cloud. SAP now has a solution […]

Read More
Configuring the CheckBox feature in Analytics Designer
June 01, 2021

Configuring the CheckBox feature in Analytic Designer: SAP Analytics Cloud

With SAP focusing on cloud-based analytics, SAP Analytics Cloud (SAC) is becoming one of the most sort after tools in the SAP BI Space. SAC is more of a self-service solution on the cloud, hence, there was a constant business need for a professionally authored dash-boarding tool on the cloud. SAP now has a solution […]

Read More
Generate Measures in SSAS Tabular Model