Search7 Results

DataLaVista™ is a lightweight, client-side reporting and dashboard toolkit that brings the full power of SQL directly to your browser, allowing you to build high-performance visualizations without the need for expensive server-side licenses or complex backend infrastructure. While engineered to dominate SharePoint List items with pure JavaScript widgets, DataLaVista™ is a framework-agnostic survivor that terminates data silos across REST services, JSON, Excel, and CSV files.

This article explains what time time dimensions are, why they matter for health research and business data analysis, and how they solve the common but frustrating problem of analyzing time-series data that sits at variable time scales. Ready-to-use code AI assistant prompts to generate these tables is freely available in the EFDC AI Prompt Database on GitHub, with support for multiple platforms including Power BI / Power Query (M), Python, R, SQL, JavaScript, Lua, PowerShell, and Bash.

Your AI assistant can generate a working prototype in minutes — but trusting it without testing is a recipe for disaster. These 10 practical tips for writing code with generative AI come from Automators Anonymous at the University of Michigan, where members build clinical, research, and operational tools using Power Automate, Power BI, Power Apps, JavaScript, SQL, SharePoint, and AI. From prompt engineering to data validation, this is the survival guide we wish we had when we started.

How to capture GitHub repository usage for analysis and visualizations, using PowerShell.

This article introduces MiNap, an application developed to serve as a prototype for sleep medicine research data collection. The article shares an overview of the problem in hand, the designed solution and its future potential in the medical research domain.

Architecture and backend implementation of MiNap, a sleep diary app for smartwatches. Written by Anika Raisa Chowdhury and Max Liu.

This article discusses an approach to solve the multi-valued field join problem in SharePoint JDBC using Custom SQL with UNION clauses.