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