Analytics

Reports In Power BI A Power BI report is nothing but a multi-perspective view of a data set with visualizations that represent different findings and insights from that data set. A report may be a single visualization or pages full of visualizations. Visualizations can be pinned to dashboards and if you select the pinned visualization, it will […]

Introduction Without the right visuals, your Power BI report is redundant. To showcase powerful insights you need to understand when and how to use different visuals so that you can avoid wasting valuable time on building reports that don’t make an impact. We’ll walk through the process we use to decide which visuals to use […]

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

The Different Power BI Licenses There are three kinds of Power BI per-user licenses: Free, Pro, and Premium Per User. Determining which type of license a user needs is going to depend on where content is stored, how they will interact with the content, and if that content needs to utilize any Premium features. Content […]

When making reports in Power BI Desktop (Or any software for that matter ), good performance in terms of loading time plays a key factor in winning the trust of clients and ensuring user adoption for that report. Long loading time creates a poor user experience, so this needs to be fixed. How to Optimize […]

Cognos Analytics with Watson AI Do you wish to have insights of your business data and obtain predictions on future performance based on your data? The new Cognos Watson powered BI solution can help you do it. It can help connecting to data sources, clean the data and provide some stunning Visualizations. The new Cognos […]

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

After writing SQL codes for a few years now, I noticed I used to make mistakes in the order of execution of SQL Queries. So here I am with my new blog on the same topic. Let’s jump in to understand the SQL order of execution & learn practical, correct ways to write SQL Codes. […]

Power BI Buckets or Groups help you to create a range of data, when you are creating visuals in power BI, it aggregates your data into chunks (or groups) based on values found in the underlying data, but there may be times when you want to refine how those chunks are presented. For example, you […]

Getting certified is always a great feeling for an individual and is a way to prove your competency and proficiency in a particular technology. Microsoft provides the pool of trending technologies in demand and is vastly used in many industries. Getting certified in specific technology is a really valuable addition to your profile. Getting Certified […]

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

Dataflows is all about self-service data preparation inside a Power BI. Before Power BI Desktop gives you these awesome tools like power query which lets you do lightweight ETL operations on your data inside a Power BI Desktop. The challenge with this is you tended to bypass the normal ETL processes that your organization may have, […]