Posts Tagged ‘analytics’

Microsoft Power BI is a suite of business intelligence (BI), reporting, and data visualization products and services for individuals and teams. It converts data from different sources to build interactive Dashboard and Business Intelligence reports. Gartner has recognized Microsoft as a Magic Quadrant Leader in analytics and business intelligence platforms. In this Blog, I will walk […]

Robotic Process Automation (RPA) is the method through which a software bot automates repetitive, high-volume, rule-based, and trigger-driven processes using a combination of automation, computer vision, and machine learning.  Organizations should assess their readiness to employ RPA technologies by looking at their data management procedures and architecture before implementing them. For RPA to succeed, high-quality […]

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

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

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

Data Functions in TIBCO Spotfire Data Functions in TIBCO Spotfire allow people to create scripts based on their custom logic for transforming data, adding features to a visualization, establishing connections to the database, and so on. It maps the input to the output, specifying what field/value to use and which variable to assign it to. […]

So, you find yourself in a need of upgrade of your existing Sitecore platform and don’t know what to start with or how to approach it? This series of blog posts will cover the whole process from zero to hero, or in upgrade terms – from planning to going live. It comes in the form […]

Usage metrics help you understand the impact of your dashboards and reports. When you run either dashboard usage metrics or report usage metrics, you discover how those dashboards and reports are being used throughout your organization, who’s using them, and for what purpose. Usage metrics reports are read-only. However, you can copy a usage metrics […]

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

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

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

What is Bravo for Power BI? Bravo studio is a design before, no code tool which allows you to turn your app designs and prototypes into real publishable mobile apps (both iOS and Android). You can use Bravo to build even complex apps by connecting your design to external tools via APIs. In this blog, […]