-
From Medical Jargon to Action Plans: How I Built an AI Blood Work Interpreter
I built a blood work lab result analyzer app, and the process was really fun. Want to share my thoughts and approach, hoping this can be inspiring and help you, my friend, to utilize AI in our day-to-day life. Below is the screen recording of me using the app to analyze some lab results. Opening… Continue reading
-
Manual add new connection to XYZ Tiles – QGIS
There is another way of adding map data by downloading the plugins, i had no luck with it, and this is a manual way to add the new data source to a project. I would like to add the data from OpenStreetMap, so here let’s get started. choose “Open Data Source Manager” right click “XYZ… Continue reading
-
The Grass is greener on which side? – My Lawn Care A/B Testing Story
It started as a typical Monday afternoon, but it quickly turned into a live-action case study in sales experimentation. My husband and I realized our neighborhood was being “pitched” by the same lawn care company, but the math wasn’t adding up. We were looking at Version A: 8 treatments a year, the first one free, and… Continue reading
-
Rapidly Prototype Data Quality Check App with Google AI
We are going to use Google AI Studio to rapidly prototype a data quality check application that business users can interact with. The application takes natural-language prompts from the user to identify incomplete records in provided data, then outputs the results to a predefined structure/format. and provide dq fail count and percentage. The purpose of… Continue reading
-
Infor Syteline ERP– set check box default checked/unchecked
Login to your site, Open the form you would like to modify. Ctrl+E, you will see the Identify your Editing Scope window. Choose a scope, in my case, I want my modification affect everyone. So I chose “Site Default” If there is a warning about the scope, you can… Continue reading
-
TIBCO SpotFire – Better Visualization and Data Blending
When choosing an analytic tool for dashboard, there are 3 key factors are my concerns. First, is it easy to build data models from different data source? Second, Is it able to give a good visualization and easy to be operated? Third, does it come with some formulas/functions to help developers develop dashboard of advanced analysis like… Continue reading
-
infor CRM – Add Property to Bulk Action Update
Bulk Action update is very quick way to edit information in a specific record in CRM entity page. To make the work easier, especially you have to update one field in many records, using this bulk update indeed save a lot of time. But what if the field you need to update, not exists in… Continue reading
-
use SQL Query SUM()OVER() TO Accumulate sales
There are times we just need a quick peek about how things are going. Hence using sql windows function with frame will be a great way for analysts to obtain the report. It’s a very handy function. Below is the sample table I’m going to use, the idea today is to add sales day by… Continue reading
-
The Greening of America
The greening of America is a reflection and prediction about revolution in America, which envisioned by Charles A. Reich. This Book was written in 1970, when the time “green” didn’t exist as a word about the environment, but used as metonymy of the word “growth” or “change”. Reich looked back and foresaw the… Continue reading
-
Tibco SpotFire Cumulative Calculation
Tibco spotfire is a great analytic tool, comparing it with Tableau, how tibco blends data source together is extraordinary, it comes with variety of templets, very convenient to create dashboards and display them in the best visualization, along with automatic create filters from all table entities. I will write another article to comparing this two… Continue reading
