You cannot find a dataset without the field “Date”. It can be created date, approved date, ordered date etc. All the data revolves around time. So it is important to create calendar table first as part of your dataset in Power BI. You can use individual Date and Time functions in Power BI or useContinue reading “Create Calendar Table in 6 easy steps”
Author Archives: Lashmi Bai Ravindrapandian
OKR vs KPI – Outcome vs Output
I recently got acquainted on the word OKR – Objectives & Key Results. My thirst for the learning made to dig drive to understand what is all about OKR and its comparison to KPI – Key Performance Index. KPIs are typically the Outputs whereas the OKR will showcase the outcomes because of the KPI. OutcomesContinue reading “OKR vs KPI – Outcome vs Output”
Functionality of Smartsheet
Let’s see about the features and functionality in this post. Don’t forget to checkout my other posts on Smartsheet here. There are 7 major elements in Smartsheet and lets see one by one in detail. 1. Grid—Has no predefined columns except for default columns—it’s a clean slate. Use this when you want to start fromContinue reading “Functionality of Smartsheet”
Are you aware of Different Views in Smartsheet
The most significant feature in the Smartsheet is the ability to view the sheets of Rows and Columns (Grid view) in three different forms – Cards , Gantt & Calendar view. Let’s see in detail. This post gives the overall features and functionality in each views. Don’t forget to checkout my other posts on SmartsheetContinue reading “Are you aware of Different Views in Smartsheet”
Basic Features of Smartsheet
Before understanding the key elements and functionality of the Smartsheet, its very important to know the key features of the sheet. Before scrolling down, don’t forget to checkout my other posts on Smartsheet here. As the name says, all the information is organized in rows and columns (of course sheet !) in the Smartsheet. Let’sContinue reading “Basic Features of Smartsheet”
Introduction to SMARTSHEET
My recent acquaintance about SMARTSHEET. In order to broaden my horizon in the latest project management related tools, I started to subscribe for a free trial on Smartsheet and got the hands-on self-training. Let me share about the tool in layman terms. Don’t forget to checkout my other posts on Smartsheet here. What is Smartsheet?Continue reading “Introduction to SMARTSHEET”
JQL using Filter Function
Understanding the Filter Function: The filter function in JQL allows you to reference and reuse saved filters. A saved filter is a predefined JQL query that in you or your team have created and saved for future use. By using the filter function, you can incorporate these saved filters into new JQL queries, making yourContinue reading “JQL using Filter Function”
All about Jira Rich Filters
I recently learned about rich filters in Jira, and they’ve been incredibly useful for managing our projects more effectively. These filters allow us to create highly customized searches using JQL (Jira Query Language), which is great for tailoring views to our specific project needs. For instance, we can filter issues by project, issue type, status,Continue reading “All about Jira Rich Filters”
Row-level security (RLS) with Power BI Desktop
With Power BI Desktop, row-level security (RLS) may be utilized to limit data access for certain users. You can set filters within roles to restrict data access at the row level. Members of a workspace who have access to datasets in the workspace in the Power BI service will not have any impact by RLSContinue reading “Row-level security (RLS) with Power BI Desktop”
Agile – Major Scrum Metrics
As the saying goes ” Anything that cannot be measured, cannot be managed well”. Though there are wide range of metrics being measured during Agile Project Management, listed few down which I feel is important to track in any projects. It’s important to have your KPI’s be – Specific Measurable Attainable Relevant Time bound MetricsContinue reading “Agile – Major Scrum Metrics”
LR Virtual Classroom 