Advertisement Β· 728 Γ— 90

Posts by Mandhri Abeysooriya

Preview
Why Your Single-Cell Data Is not telling You the Truth Yesterday I ran three normalisation methods head-to-head on the Tung et al. 2017 iPSC scRNA-seq dataset (3 individuals, 864 cells). I…

Why Your Single-Cell Data Is not telling You the Truth.
Yesterday I ran three normalisation methods head-to-head on the Tung et al. 2017 iPSC scRNA-seq dataset (3 individuals, 864 cells).
The question is: Which method are YOU using?

medium.com/@mandhri.abe...

9 months ago 0 0 0 0

The right tool for the right job is not just good practice, rather it is essential for scalable data operations.
#DataArchitecture #ResearchData #Analytics #DatabaseDesign #ClinicalResearch #REDCap #HealthcareInformatics #ClinicalData

9 months ago 0 0 0 0

The approach that actually work would be to implement a hybrid approach:
1/ Capture data in OLTP systems (like RedCap)
2/ Transform and load into OLAP environments
3/Analyse using purpose-built analytical tools (eg R, Python)

9 months ago 0 0 1 0
Post image

This is not a REDCap problem. It is an architecture problem. Forcing transaction-focused databases (OLTP) to perform analytical tasks (OLAP).

If your reports take more than five minutes, and your project is mid to large-scale, you are probably hitting the same OLTP vs OLAP wall.

9 months ago 0 0 1 0

This one mistake costs research teams 40 hours per month!
The team was spending 40+ hours monthly waiting for "simple" reports to run. The problem was using REDCap for complex analytics.

9 months ago 0 0 1 0

i like looking at clouds and see different patterns. Loving the new vibe....

1 year ago 0 0 0 0
Preview
Streamlining R Markdown Rendering and Error Logging in R Working with multiple R Markdown (.Rmd) files can be a routine task for data scientists and analysts. However, rendering each file…


Bypassing Boredom: How I Automated R Markdown Rendering to Outsmart Error Surprises!

#Bioinformatics #Rmarkdown #Automatingpipelines #datascience #genomics

medium.com/@mandhri.abe...

1 year ago 0 0 0 0
Preview
Oops! I Forgot the Cells: Updating Model Matrices with Cell Type Proportions Across 60+ Blood… Automatically Updating Cell Type Proportions in Model Matrices Across A Large Number Of Files

I love automating workflowsβ€”it's not just efficient and less error-prone; it feels like playing a game.

So, essentially, I'm gaming even when I'm working!

medium.com/@mandhri.abe...

1 year ago 1 0 0 0
Advertisement