Skip to main content

Analytics

Business background with arrays of data in virtual space

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

tiethnic colleagues sitting at desk looking at laptop computer in office. stock photo

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

Woman working with code and data

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

Cover Photo 3

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

Power BI: Import vs Direct Query

Background Core of any BI tools is to acquire business data from multiple sources and then to co-relate it for quality reports & dashboards. Information Technology is being dominantly used for business processes from last 20 years. Volume of data has grown a lot. Businesses have shifted to enterprise database platforms like SQL Server, Oracle, […]

Doctor And Patient

8 Capabilities for Agile M&A in Healthcare Organizations

As the numbers of mergers and acquisitions continue to rise, the majority still fail to realize their intended value. Following best-practices and using third party support can help increase your chances of success. Perficient’s wide variety of tools and assets in the following eight capability categories help complement and drive the overall success of a […]

Viva Insights Logo

Viva Insights: Empower Hybrid Work Employee Experiences with Data-Driven Insights

Viva Insights In the ever-changing landscape of work, having data-driven intelligence is paramount for individuals, managers, and leaders. Viva Insights takes signals from across M365, Exchange, and teams and uses them to identify trends. From those trends, MS applies a ton of workplace insights gleaned from academic and hands-on research to derive from that data […]

Azure Databricks

Azure Databricks – Capacity Planning for optimum Spark Cluster

Overview: Today the terminology “Data Analytics” becomes a buzz across all industries & enterprises. Every organization strongly believes Data Analytics greatly helps to get insight & accelerate the business strategies in order to grow & lead in their fast and ever-changing markets. Azure Databricks: Azure Databricks is a data analytics platform optimized for the Microsoft […]

IBM Cloud Pak for Data- Data Science MLOPS

IBM Cloud Pak for Data- Data Science MLOPS: I have been Learning, exploring and working on IBM MLOPS for Data Science and wanted to share my learning and experience here about IBM’s Cloud services and how they are integrated under one umbrella named IBM Cloud Pak for Data. First, let’s understand what IBM Cloud Pak […]

On The Spot Updates Using Smart Technology

COGNOS IS BACK!

Setup: This article is for those of you who like me, have lamented and long suffered the downturn that Cognos endured beginning with the introduction of Cognos 11.0.2 in May 2016. To set the stage, I led the first global implementation of Cognos 10 in 2010.  I was a Cognos evangelist.  I appeared with then […]

Incorta Analytics

Analytics with Incorta using 3rd Party Tools

Incorta provides a comprehensive platform for data Acquisition, Data Enrichment, and Data Visualization. It can be a one-stop for all your data needs, but it can also be combined with other BI Visualization tools to enhance the experience even further. Incorta provides a Postgres connection to connect other 3rd party Visualization tools like Power BI, […]

Load More