Intro Many times a client wants some sort of customized view of the data they have in PowerBI. The truth is, as powerful as it is PowerBI, like all BI tools, offer limited customizability. However, PowerBI comes with a powerful RESTful interface that we can use to show the underlying data however we wish. This […]
Data + Intelligence
Telehealth’s unique purpose in healthcare
The past two years have proven that telehealth and virtual care are here to stay and will gain strength going forward for patients, providers, and payers. With the ability to provide healthcare to a vast array of patients, the next question is “now what?” How can we improve and customize a better experience for patients, […]
Creating & Invoking Custom Function in Power Query
Microsoft’s Power BI is a data and analytics reporting tool that lets you connect to multiple data sources. Once connected to a data source, raw data sets can be converted to dashboards and presented to the team, customer, anyone at any time. In this blog, we will get introduced to the custom function feature available […]
Navigating from EBS Journal Lines to Originating Transactions
Among the frequent requests when building a Financial Data Warehouse based on Oracle EBS is the desire to drill from a General Ledger period balance through the related Journal Entry lines to the underlying transaction in the source application through the Subledger Accounting linkages. Complicating this challenge is the fact that some of the EBS […]
How to Run Talend job from Command Line
Introduction: We mostly use Talend studio, TAC or TMC to run a Talend job once it is ready. But for all these we need to install Talend Studio and need rights to access TAC and TMC. What if we want to run a talend job outside the studio? We can do that using command prompt. […]
Dynamic Filtering Using Parameters in Power BI
Data is the lifeblood of modern businesses, and we’re generating more of it than ever. For making well-informed business decisions, it is crucial to fetch relevant information from the data and present it in a lucid manner. Microsoft’s Power BI suite is designed to quickly turn your data into useful information. Microsoft Power BI is […]
Data Lineage for BCBS 239 Regulatory Compliance
The purpose of BCBS 239 (Basel Committee on Banking Supervision’s standard number 239) is to ensure that systemically important banks’ risk data aggregation capabilities and internal risk reporting practices give thorough insight into the risks to which they are exposed. BCBS has a total of 14 principles, summarized in the four sections below: I. Overarching governance […]
Perficient Expert Recognized as a 2022 IBM Champion
IBM introduced its IBM Champion program back in 2008 and has continued to recognize innovative thought leaders in the technical community that are helping others derive greater value from IBM software, solutions and services. This year, one of the professionals being honored is Perficient’s Eric Walk a director of knowledge, data and content. What Makes […]
Personalization and Relevant Search with Coveo for Adobe
You need personalization and relevant search. Marketing is no longer about convincing a customer to buy. It’s about helping them buy. And to be seen as an expert, companies need to deliver the information each customer needs. Technology that can seamlessly deliver personalized, targeted content is the Holy Grail. Whether your visitors browse or search, […]
What Rises from the Ashes of 3rd Party Cookies
In 2020, Google broke digital marketing. Okay, broke is a tad dramatic. However, the news to purge 3rd party cookies did leave many digital marketers in shock. Soon after, Apple announced a shift to focus on protecting consumer privacy and eliminating IDFA and Safari’s use of cookies. The end felt near. Yet, the chaos brought […]
[Vlog] Intelligent, Real-Time Clinical Trial Insights
Param Singh: Hello, everyone. My name is Param Singh and I’m the Director of the Clinical Operations Solution Practice here at Perficient Life Sciences. And I want to welcome everyone to today’s discussion on our new partnership with Lokavant. And this discussion today is a way for us to introduce the offering and solution to […]
Coding and Database Best Principles
Today we will dwell into some basics and best practices to follow for any database design as well as for Coding. The key topics that I would like to emphasize today are following Coding Best Practices Data model Design Principles Best Query writing practices. Before I move on to the topics, I would like to […]