Posts Tagged ‘Business Intelligence’

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

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

Tooltips in Power BI are a simple feature that is often underutilized. One of the easiest ways to impress your audience with Power BI is a tooltip. This simple idea can provide incredible value to the report readers and elevate your work to next level. In this blog, I will take you through the required […]

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

Microsoft has released the feature Export to PDF option from Power BI Desktop. This feature has been available in every update of the Power BI desktop since August 2018. Read to explore this option and how to use it. Now, let’s get started. The following screenshot refers to the sample of my report. How To […]

Have you ever wondered if it would ever be possible to time travel like in the old movies with a time machine? If we could go back in time and see the world, would we? If you asked me, I would have said yes! But not in the way that Hollywood portrays science fiction films. […]

Introduction:  Power BI’s merging and appending operations allow you to join data from multiple tables.  The choice between the merge and append queries depends upon the type of concatenation you want to carry out based on your requirement. When you have one or more columns that you’d like to add to another query, then you […]

Paginated Reports are the same as SSRS, which have come to Power BI with advanced features for better reports. Paginated Reports are well designed & formatted reports which are perfectly sized so we can print and share the reports effectively. We can also load images and charts on these reports. We can create highly formatted […]

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

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