Skip to main content

Posts Tagged ‘Business Intelligence’

Currency And Exchange Stock Chart For Finance And Economy Display

Unlocking Insights with Alteryx: A Comprehensive Overview of the Data Analytics Platform

Alteryx: A Comprehensive Overview Alteryx is a leading data analytics platform that helps businesses and organizations of all sizes to turn raw data into actionable insights. This comprehensive platform includes data preparation, blending, and analytics capabilities, along with tools for data governance, collaboration, and automation. Alteryx has gained popularity in recent years due to its […]

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

Shot of a group of businesspeople applauding in an office

What is EEO Reporting, and How Does it Work in Oracle HCM?

Are you a part of the Human Resources team, which is tasked with reporting on Equal Employment Opportunity? Are you an Oracle Human Capital Management consultant tasked with configuring the environment setup of this report? The goal of this blog is twofold: demystify EEO reporting by defining the various reports, and outline EEO-1 reporting setups […]

Working In Office.

Advanced Time Intelligence Functions in Power BI (Series -1)

DAX provides a whole host of powerful time intelligence functions, allowing you to do things like build custom calendars, define dynamic date ranges, and compare performance over specific periods. Common Use Cases: Creating custom calendar tables with DAX instead of using the default auto-generated versions. Writing measures to calculate period-over-period, moving average, or running total […]

Istock 903569480 (5)

How to Get the Dataset to Practice Power BI

Microsoft Power BI is business intelligence Tool . Microsoft Power BI is a Leader in analytics and business intelligence platforms. This Blog  will walk you through different websites to get sample data for power bi to practice Go to the Microsoft documentation, link as below. https://learn.microsoft.com/en-us/power-bi/create-reports/sample-datasets You can access the dataset or actual source itself […]

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

Working In Office.

Show Last N Month Data using single Date Slicer & What if Parameter in Power BI

Have you ever had a scenario where you need to Display the last 6 month or 4 month or N months of data just by selecting a single date dimension in slicer, sounds difficult“? Let’s me show you step by step how to display last N months of data just by selecting single date dimension […]

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

SQL Magic Series – Minus Sign in ORDER BY

We are beginning a new series on SQL – A Magic Series. We will see few of many, yet effective tricks & solutions to make SQL easy in daily use. Let’s begin!! So, the Question we are dealing here is: What does the SQL minus sign (-) mean in ORDER BY -emp_no DESC; ? Before answering that, let’s see, how ORDER […]

Designer team drawing website ux app development application for mobile phone.

JIRA – Views, Dashboards, JIRA Connect

This blog, last, in our series on Atlassian Optimizing JIRA will cover creating Views & Dashboards and Connecting JIRA with other applications to make it best for you. (Read previous post here on Optimizing JIRA by Adjusting Personal Settings). Jira gives you many ways to see your work : boards, backlogs, roadmaps, etc. In this blog, […]

Woman working with graphs and coding on holographic screen

Dashboards in JIRA

Dashboard is a customized screen to give you a high-level snapshot of everything happening in Jira. Dashboards in Jira are made up of small configurable blocks called gadgets (Introduction, Projects, Assigned to Me, and Activity Stream). We can create multiple dashboards for different projects OR one single dashboard that spans all the work we’re involved with. How […]

Featuredimage

Creating Column Slicer using Field Parameters

Slicer in Power BI is a form of filter that play vital role in designing customized charts, tables and reports on Power BI Desktop. With a slicer, users could choose the type of data they would like to see on the report, and it would reflect immediately. Moreover, Power BI has released a new feature […]

Load More