Skip to main content

Analytics

Oil Refinery At Twilight

Advanced ESG Reporting Capabilities Are More Essential Than Ever for Oil, Gas, and Utility Companies

Regulations and Policies In November of 2022, the EPA released new regulations to combat the release of air pollutants such as methane, VOCs, and benzene by both existing and new oil and gas operations. Another decisive move in 2023 by EPA enacted new policies to crack down on water pollution from coal plants. In these […]

Portrait Of A Financial Analyst Working On Computer With Multi Monitor Workstation With Real Time Stocks, Commodities And Exchange Market Charts. Businesswoman At Work In Investment Broker Agency.

How to Display Top and Bottom N in a Single Visual Using Slicer Dynamically in Power BI

In Power BI, Top N and Bottom N are often displayed using a visual level filter and two visuals, respectively. As a result, we can only show one item at a time on top or bottom N. But, if the situation asks for slicer selection to be used to dynamically change how top and bottom […]

Data Analytics Graphic

Optimizely Data Platform: The Future of Customer Experience Management

In today’s saturated world of marketing data, the customer remains at the centre of what marketers do. Chief Marketing Officers (CMOs) often face higher expectations from their management and customers regarding personalizing marketing data for optimizing the marketing dollar. Fact Check! According to a Forbes Insights and Epsilon survey, 81% of marketers said they face […]

Data Analyst Working On Business Analytics Dashboard With Charts, Metrics And Kpi To Analyze Performance And Create Insight Reports For Operations Management.

DAX Best approaches in Power BI

This article helps you to accelerate your Power BI reports by improving their back-end code. Effective use of DAX functions: Adding DISTINCT () and VALUES () functions persistently: In DAX, the blank value necessitates special consideration. Power BI assigns a blank value to the column when connecting directly to a query since it is unable […]

Two programmers working on some coding together

Snowflake Best Practices for Data Engineering

We often end up creating a problem while working on data. So, here are few best practices for data engineering using Snowflake: 1. Transform your data incrementally: A common mistake novice data engineers make is writing huge SQL statements that join, aggregate, and process many tables, misunderstanding that this is an efficient way to work. […]

Data Analyst Working On Business Analytics Dashboard With Charts, Metrics And Kpi To Analyze Performance And Create Insight Reports For Operations Management.

How to show multiple measures in single visual from slicer selection in Power BI

Power BI is a Business Intelligence tool used to create Interactive Dashboards which helps the Business users to analyze their data insights. In Power BI, to show calculations measures are built, and it is used to represent the data on dashboard. Slicers in Power BI are the simple forms of filters that play a key role […]

Specialization trophies

Perficient Renews Adobe Analytics Specialization

It’s A New Year It’s the start of 2023 and as a Platinum Adobe Solution Partner with 6 Specializations in: Adobe Analytics, Adobe Commerce, Adobe Experience Manager Run and Operate, Adobe Experience Manager Sites, Adobe Marketo Engage, and Adobe Target, we are here to help you on your Adobe Journey. We are here to deliver […]

Financial Services

Edit Interactions in Power BI: Manage Interactions between Visuals in Power BI

Edit interaction is valuable feature in Power BI which used to manage the interaction between the visuals. Generally, Power BI visuals are interactive that is after selecting any item of visual affects other visual too. So here Edit Interaction helps in controlling the interaction between the visuals. Which helps in making efficient and also it […]

Data Center Corridor Server Room With Abstract Overlay Of Networked Connections By Sdecoret Gettyimages 1197646065 2400x1600 100857776 Orig 1

SQL Best Practices and Performance Tuning

The goal of performance tuning in SQL is to minimize the execution time of the query and reduce the number of resources while processing the query. Whenever we run the query, performance depends on the amount of data and the complexity of the calculations we are working on. So, by reducing the no of calculations […]

SEO Considerations

Filters and Types of Filtering in Power BI

Power BI filters are useful tools for organizing data, visualizing and comparing your data visualizations, and creating reports. They are utilized to sort data according to a chosen condition. Filter Types : Visual Level Filter Page Level Filter Report Level Filter Drill Through Filter On the right side of the dashboard, locate the Filter Pane. […]

Man using tablet to look at charts

Relationship Functions in Power BI

Relationship functions in Power BI allow you to access fields within DAX measures or calculated columns through either physical or virtual relationships between tables. Common Use Cases for Relationship Functions in Power BI Defining calculated columns or measures using fields from related tables. Handling relationships between calendars and multiple date fields (transaction date, stock date, due […]

Scott Graham 5fnmwej4taa Unsplash (1)

QA Test Management using Xray Tool

Xray is the leading Quality Assurance and Test Management Jira plugin, which helps companies in effective and efficient testing. It is the best test management tool that covers the entire testing life cycle: test planning, test specification, test organization, test execution and test reporting. Before diving deep into Xray, we will first see Test Management […]

Load More