Author Archives: Lashmi Bai Ravindrapandian

All about Cardinality

As we are aware of the fact and dimension table, it’s important to understand the relationship between the tables. It is where the cardinality comes into the picture. Cardinality is the directionality of a relationship, such as one-to-many, one-to-one, and so on. It describes the directionality between fact and dimension tables. Four Types of Cardinality:Continue reading “All about Cardinality”

Fact vs Dimension Table

The first and foremost concept you need to understand in Power BI is the difference between the Fact and Dimension table. Relationships are defined between tables through primary and foreign keys. Relationships between tables are formed when you have primary and foreign keys in common between different tables. Fact Tables (Foreign Key) Dimension Tables (PrimaryContinue reading “Fact vs Dimension Table”

5 Data Modelling Fundamentals

In this post, let’s understand the 5 important Data modeling fundamentals. They are the most important which one should focus as a beginner. If these are not understood enough, I repeat, it is important to get the basics right. Data and lookup tables & Primary and foreign keys Relantionship Cardinality Filter Flow Evaluation Context CommonContinue reading “5 Data Modelling Fundamentals”

Create Dashboard Index in Jira

Managing multiple dashboards in Jira can quickly become overwhelming. Each project or team might have its own set of key metrics and reports, scattered across various dashboard links. As a Jira user, navigating through these links every time you need specific information can be tedious and time-consuming. Imagine having all your essential dashboard links neatlyContinue reading “Create Dashboard Index in Jira”

PPM Clarity – My Recent Exposure

During the Honeywell days, I have extensively worked in the SAP – Project Systems which gave me exposure to connect the dots in the E2E (End-to-End) project management in terms of scope, schedule, budget, resources, quality, risk, issues, change request, communication, reporting, phase gates etc. The tool had the concept of various T-codes which youContinue reading “PPM Clarity – My Recent Exposure”

Streamline your Jira with Structures

During my time working on a complex project with multiple teams, I discovered the immense value of properly organizing Jira issues to meet our specific needs. It wasn’t just about task tracking; it was about streamlining workflows and ensuring everyone was aligned. Through trial and error, I found that the project portfolio management tool, StructureContinue reading “Streamline your Jira with Structures”

Filter , Sort & Sequence Excel Functions

It’s a tremendous compounding effect when you learn excel formulas everyday. Here’s drafting the explanation about the three major excel functions with examples. You can download the excel from here for reference. 1. Filter Function: Filter function is very handy when you want to filter the specific part of the table data. Lets see bothContinue reading “Filter , Sort & Sequence Excel Functions”

Be Positive But Test Negative.

One of the beautiful & best shayari I came across…..Couldn’t resist to share in my blog. As a excerpt says, “Life can only be understood backwards; but it must be lived forwards”, this is best testimonial. For the Author credit, scroll down 🙂 Never have I seensuch a mess in life. The air is pureContinue reading “Be Positive But Test Negative.”

Effective Delay Management for Jira Tasks

In project management, delays are inevitable. Understanding how to calculate the delay of one task relative to another and forecasting new completion dates is crucial for maintaining project timelines. In this post, we’ll explore a methodical approach to calculate delays and forecast completion dates using Excel. Let’s break down the formula: =IF(E2=””,IF(D2<TODAY(),NETWORKDAYS(D2,TODAY())-1,0),IF(NETWORKDAYS(D2,E2)<0,NETWORKDAYS(D2,E2)+1,NETWORKDAYS(D2,E2)-1)) This formula isContinue reading “Effective Delay Management for Jira Tasks”