Delivering effective customer experiences requires an omnichannel mindset. Customers want brands to understand their needs and help them on their journey, no matter what part of the organization they are interacting with. Your website or mobile app visitors do not think in terms of channels, product lines, or business units, they just think about their […]
Data + Intelligence
Data Visualization – How to Pick the Right Chart? – Part 2
So Many BI Charts, but which one to choose and when? This blog series will help you understand each chart’s uses and properties. This is the second blog in a series about data visualization. Read the first blog in the series here. 10. Area Chart An area chart is essentially a line chart — good […]
Top 5 take-aways from Databricks Data – AI Summit 2022
The Data and AI Summit 2022 had enormous announcements for the Databricks Lakehouse platform. Among these, there were several exhilarating enhancements to Databricks Workflows, the fully managed orchestration service that is deeply integrated with the Databricks Lakehouse Platform and Delta Live tables too. With these new efficacies, Workflows enables data engineers, data scientists and analysts […]
Handling ever changing source schema issues using Python and Snowflake
The problem statement: An organization having a lot of FMCG products, conducts campaigns in various cities across India. The main aim of this campaign is to promote the products and collect feedback from the customers both existing and prospective ones. The data is collected in excel files and loaded to a centralized location in the […]
Tableau – Table Pagination
Pagination is a great way to improve the user experience and minimize the footprints that tables occupy within Tableau dashboards. In cases, where we need to show multiple records or our tables are too long to display it in single view, pagination comes to rescue. By implementing this technique, users will be able to “turn […]
Data Visualization – How to Pick the Right Chart? – Part 1
So Many BI Charts, but which one to choose and when? This blog series will help you understand each chart’s uses and its properties. To determine how to pick the right chart for your data visualization needs, first, you must answer a few questions: How many variables do you want to show in a single […]
How to implement incremental loading in Snowflake using Stream and Merge
Snowflake is Cloud hosted relational database used to create Datawarehouse on demand. Data in the data warehouse can be loaded as full load or incremental load. The full load is a process of deleting whole existing data and reloading it again. Full loads are time and resource-consuming tasks compared to incremental loads that only load […]
IBM Cloud Pak for Data- Multicloud Data Integration and Data Governance
IBM Cloud Pak for Data- Multicloud Data Integration and Data Governance: As we all know, IBM Cloud Pak for Data is a cloud-native solution that enables you to put your data to work quickly and efficiently. Let’s understand below features of IBM Cloud Pak for Data. I’ll also be discussing what practical experience I have […]
Drill Down Feature in Power BI
What is Drill Down in Power BI? In Power BI, Drill Down is nothing but the next level of hierarchical insights of the data. For example, when you want to see a year-wise sales summary, you may want to look into the “Monthly” summary, “Quarterly Summary,” and day-wise summary. So, this is where the drill-down […]
A MDM Success Story: Streamlining Claims Processing and Payments With Reliable, Centralized Data
Does this sound familiar: you’re running multiple point-of-care systems, each with redundant data points collected. But what happens when there are small variations in how data is captured and processed across these systems? As a healthcare provider client of ours discovered, inconsistent data can reduce revenue realization. It caused claims to be improperly matched and […]
Power BI – Dynamic Columns in a Table
In advance Power Bi scenarios , All of us have created dynamic slicers using measures. the dynamic slicers works on factual values because we use Measures in there. But what if we want the same slicer to represent Dimensions dynamically? Well, here is the step by step solution for the same. Without using single DAX […]
Navigating from EBS Journal Lines to Originating Transactions – Part II
In our last post we discussed the linkages between Journal Entries and the source transactions in Accounts Payable, Accounts Receivable, and Fixed Assets. This post continues the discussion with the linkages for the Purchasing, Project Accounting, and Cost Management applications. As noted in the prior posting, since most organizations employ summary posting of Journal entries, […]