tag:blogger.com,1999:blog-358926822024-02-07T23:06:08.622-05:00Deep Data Mining BlogThis blog is mostly focused on the technical aspect of data mining.Unknownnoreply@blogger.comBlogger288125tag:blogger.com,1999:blog-35892682.post-13575287437062039742023-11-14T07:14:00.001-05:002023-11-14T07:14:03.810-05:00Live webinar "Costly Mistakes in Determining Safety Stocks and a New Approach" Don't miss the live webinar "Costly Mistakes in Determining Safety Stocks and a New Approach" taking place tomorrow at 9:00am Eastern. </br></br>
In this interactive webinar, we'll demonstrate why not considering profit margin when setting service levels and safety stocks can be a costly mistake.</br></br>
We'll show you firsthand how a new method that accounts for gross margin can better optimize your inventory to maximize profits. Have your own data ready! All we need is a few SKUs' average daily demand, standard deviation of demand, lead time, and gross margin. We'll apply this method to your data live to start increasing your bottom line.</br></br>
Feel free to reach out with any questions before the webinar. Register now to reserve your spot for this free webinar tomorrow November 15 at 9am Eastern: https://lnkd.in/e8-ZDR2J </br></br>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEqDq_K7P26UBmtyierMztlu9_uK5QPeNDAUMsw08RcRVNYJ4Y9XbT59i1mnBIALDd9svBqU8_IRV2zEVMEemJGFQnsBh5kMXBSGlccLvLnMmKXmeLVLsgOC2DOkMtwp-tWjZrvRfgmuZVMgby7BGoaBh1MYC_lPLGRlBHatMgpo9Oa6AHEe7fan5GbeY/s939/Screen%20Shot%202023-11-14%20at%207.06.09%20AM.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="400" data-original-height="622" data-original-width="939" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEqDq_K7P26UBmtyierMztlu9_uK5QPeNDAUMsw08RcRVNYJ4Y9XbT59i1mnBIALDd9svBqU8_IRV2zEVMEemJGFQnsBh5kMXBSGlccLvLnMmKXmeLVLsgOC2DOkMtwp-tWjZrvRfgmuZVMgby7BGoaBh1MYC_lPLGRlBHatMgpo9Oa6AHEe7fan5GbeY/s400/Screen%20Shot%202023-11-14%20at%207.06.09%20AM.png"/></a></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-47062403507100833932023-11-06T15:59:00.001-05:002023-11-06T15:59:07.915-05:00Optimize Your Inventory Live: An Interactive Webinar
Join our live, interactive session on Wednesday, November 8 at 9am Eastern where we'll optimize real inventory data right before your eyes.</br></br>
Bring your own data for products you want to optimize. We'll input the numbers into our system during the webinar including:</br>
- Daily demand (in Units)</br>
- Demand variability (i.e., standard deviation of daily demand)</br>
- Lead time (in Days)</br>
- Margin - calculated as (sale price - purchase price)/purchase price</br>
To give you an idea, the presenter Dr. Jay Zhou will demo the algorithm using data for one of his SKUs:</br>
- Daily demand: 100 units</br>
- Demand variability: 35</br>
- Lead time: 21 days</br>
- Margin: 45%</br></br>
You'll see our optimization algorithm at work as we determine live on the webinar:</br>
- Service level targets</br>
- Safety stock requirements</br>
- Ideal re-order quantities</br></br>
This is a truly hands-on session where you'll get to optimize your own inventory with real recommendations you can implement immediately.</br>
Seats are limited, register now to reserve your spot and prepare your data! https://lnkd.in/ekfqzxXX
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNTKK91eVzeTPhr-EVmAUbPpi7R6oiQhhgfTfjXvaUs5yyAH4NoTjgjHfOBPqqeuYgZnLbb1TV2cfXwcv3mPhL8uGKK9GyiTg2m5V-VHI3ghEKfDqonJWsWmV4LyaAc6WD2rWPNleVu8-KLCW9IlLOFbUVpRGEsdSm1TwgyLz-_IOTV2vYFCXu/s2372/Screen%20Shot%202023-11-06%20at%207.36.45%20AM.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="400" data-original-height="1612" data-original-width="2372" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNTKK91eVzeTPhr-EVmAUbPpi7R6oiQhhgfTfjXvaUs5yyAH4NoTjgjHfOBPqqeuYgZnLbb1TV2cfXwcv3mPhL8uGKK9GyiTg2m5V-VHI3ghEKfDqonJWsWmV4LyaAc6WD2rWPNleVu8-KLCW9IlLOFbUVpRGEsdSm1TwgyLz-_IOTV2vYFCXu/s400/Screen%20Shot%202023-11-06%20at%207.36.45%20AM.png"/></a></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-58042843114174346672023-10-31T07:06:00.004-04:002023-10-31T07:06:51.557-04:00Upcoming Webinar: How to Boost Your Bottom Line: Achieving Greater Profits with Automated Inventory OptimizationIntuition tells us that an inventory item with 65% gross margin, everything else being the same, should have a higher service level/safety stock than one with 10% for the sake of maximizing profit. However, traditional methods fail to quantify exactly how much the service levels/safety stocks should differ between these items. This causes companies millions of dollars in lost profits every year.</br></br>
Our proprietary Safety Stock Price Model, developed by Dr. Jay Zhou, solves this issue. The model accurately calculates the ideal service levels and safety stocks based on your products' gross margins. For the above example, it prescribes service levels of 99% vs 92% and safety stocks of 282 vs 170 units for the 65% vs 10% margin items (see the picture below). By optimizing service levels and safety stock in this way, your company's profit is maximized - exactly what you and your executives want!</br></br>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSGrmHuwGkc93GeSPvO7qd-vzc2DOkoyhhVuaMJRfSWl7wz_6mbQdO4b177yMAp8lt0P0Fw1sqgr_mBFyDpB9FmWKa7wMEHOTczUqQ8JWj8x9dja8l0U8Y6rOSlcp3VRreIMyDxLi2InTxp9Q5vClELco4PFjQ4Q2oU_aHuueIEJ7Tb3JUyYXUCPsMtyo/s1564/Screen%20Shot%202023-10-31%20at%206.28.30%20AM.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="400" data-original-height="532" data-original-width="1564" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSGrmHuwGkc93GeSPvO7qd-vzc2DOkoyhhVuaMJRfSWl7wz_6mbQdO4b177yMAp8lt0P0Fw1sqgr_mBFyDpB9FmWKa7wMEHOTczUqQ8JWj8x9dja8l0U8Y6rOSlcp3VRreIMyDxLi2InTxp9Q5vClELco4PFjQ4Q2oU_aHuueIEJ7Tb3JUyYXUCPsMtyo/s400/Screen%20Shot%202023-10-31%20at%206.28.30%20AM.png"/></a></div>
Join our free webinar tomorrow at 9am ET to learn how our algorithm can boost your bottom line through smarter inventory optimization. Dr. Zhou will explain why traditional methods fall short and how our patented approach is the true path to greater profits.
Register now <a href="https://app.livestorm.co/zsanalytics-llc/how-to-boost-your-bottom-line-achieving-greater-profits-with-automated-inventory-optimization?type=detailed"> here </a> for "How to Boost Your Bottom Line: Achieving Greater Profits with Automated Inventory Optimization" on Wednesday, November 1st at 9am ET Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-76849950318714489872023-10-27T09:55:00.002-04:002023-10-27T09:58:33.632-04:00Upcoming Webinar on How to Boost Your Bottom Line: Achieving Greater Profits with Automated Inventory OptimizationUpcoming Webinar on How to Boost Your Bottom Line: Achieving Greater Profits with Automated Inventory Optimization
-Why Traditional Methods Fall Short and How Our Algorithm is the True Path to Financial Success</br>
Will be delivered by Dr. Jay Zhou on Wednesday, November 1st 2023 - 9:00 PM (EDT). Please register <a href="https://app.livestorm.co/zsanalytics-llc/how-to-boost-your-bottom-line-achieving-greater-profits-with-automated-inventory-optimization?type=detailed"> here.</a>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizXIq8fjneMmeIJnBdCEYswbgyAG63iPbac-IUCeiQrJiB6F-GZUW5qPlaBun1i3j8PcrbQbTqYV3MN8RaQIo5MDRtBTsqnsGiR5RA2jhq_jGRR1J1dd76jrKUJaQJqjmCXARsrKqF7rx8zOqwmI2_DysGCgOw-KR_SgEkrnDIp-NaRJ7DvlND/s851/Screen%20Shot%202023-10-27%20at%209.41.40%20AM.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="400" data-original-height="612" data-original-width="851" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizXIq8fjneMmeIJnBdCEYswbgyAG63iPbac-IUCeiQrJiB6F-GZUW5qPlaBun1i3j8PcrbQbTqYV3MN8RaQIo5MDRtBTsqnsGiR5RA2jhq_jGRR1J1dd76jrKUJaQJqjmCXARsrKqF7rx8zOqwmI2_DysGCgOw-KR_SgEkrnDIp-NaRJ7DvlND/s400/Screen%20Shot%202023-10-27%20at%209.41.40%20AM.png"/></a></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-11480703296536403182023-10-20T11:17:00.002-04:002023-10-20T11:17:37.135-04:00Speeding Up Bulk Data Loads in Oracle with HintsBulk loading volumes of data from staging tables into production tables is a common task, but a slow and tedious process using basic INSERT statements in Oracle. But using query hints can dramatically improve load times, as I recently discovered how dramatical it could be.</br></br>
In our ETL process, we needed to load order data from a staging table to the main orders table. Our initial INSERT statement looked like: </br>
<pre>
INSERT INTO Orders (order_id, customer_id, order_date, total_amount)
SELECT order_id, customer_id, order_date, total_amount
FROM Staging_Orders;
</pre>
This took many hours to millions of rows. But then we came across hint syntax that lets you fine-tune SQL behavior. </br>
Adding a parallel and direct-path hint like:</br>
<pre>
INSERT /*+ APPEND PARALLEL(4) */ INTO Orders (order_id, customer_id, order_date, total_amount)
SELECT order_id, customer_id, order_date, total_amount
FROM Staging_Orders;
</pre>
In the above SQL statement, the /*+ APPEND */ hint instructs Oracle to perform a Direct Path Insert for faster data loading. and the PARALLEL(4) hint instructs Oracle to use parallel processing with four parallel execution servers (you can adjust the number as needed based on your system's resources). </br></br>
The results were mind-blowing - loading finished in under 10 minutes! For big data loads, enabling direct-path INSERT with parallelism cuts the time from hours to minutes.</br></br>
I hope this example gives you some ideas on optimizing bulk data operations in Oracle through hints. Let me know if you have any other tips for supercharged ETL performance!
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-15155174051427938522023-03-16T00:47:00.002-04:002023-03-16T08:24:23.748-04:00Leveraging Oracle's Compress and Partition Features for Efficient Data ManagementRecently, one of my clients loaded a substantial amount of data into an Oracle database table, which consumed an excessive amount of disk space and resulted in sluggish query performance. To address these issues, I suggested implementing Oracle's compress and partition table features. By applying these techniques, we successfully saved disk space and improved query performance.</br>
In this example, we will create a table that combines both compression and partitioning with an interval. The table will store a sales transaction dataset, which includes columns for transaction ID, product ID, date, and revenue. We will use range partitioning with an interval of 1 month and enable Advanced Row Compression for the table.
Creating the table with compression and interval partitioning:
<pre>
CREATE TABLE sales_transactions
(
transaction_id NUMBER,
product_id NUMBER,
transaction_date DATE,
revenue NUMBER
)
PARTITION BY RANGE (transaction_date) INTERVAL (NUMTOYMINTERVAL(1, 'MONTH'))
(
PARTITION sales_transactions_initial VALUES LESS THAN (TO_DATE('2023-01-01', 'YYYY-MM-DD'))
)
COMPRESS FOR OLTP;
</pre>
In this example, we have created a range-partitioned table with an interval of 1 month. The PARTITION BY RANGE clause specifies that we are partitioning the table based on the transaction_date column. The INTERVAL clause defines a 1-month interval for partition creation using the NUMTOYMINTERVAL function.
The table also has an initial partition, sales_transactions_initial, that holds data for dates before '2023-01-01'. Lastly, we have added the COMPRESS FOR OLTP clause to enable Advanced Row Compression for the table.
Inserting data into the table:
<pre>
INSERT INTO sales_transactions (transaction_id, product_id, transaction_date, revenue)
VALUES (1, 101, TO_DATE('2022-12-15', 'YYYY-MM-DD'), 1000);
INSERT INTO sales_transactions (transaction_id, product_id, transaction_date, revenue)
VALUES (2, 102, TO_DATE('2023-01-05', 'YYYY-MM-DD'), 1500);
INSERT INTO sales_transactions (transaction_id, product_id, transaction_date, revenue)
VALUES (3, 103, TO_DATE('2023-01-20', 'YYYY-MM-DD'), 2000);
INSERT INTO sales_transactions (transaction_id, product_id, transaction_date, revenue)
VALUES (4, 104, TO_DATE('2023-02-15', 'YYYY-MM-DD'), 2500);
</pre>
Querying the table:
<pre>
SELECT * FROM sales_transactions
WHERE transaction_date >= TO_DATE('2023-01-01', 'YYYY-MM-DD')
AND transaction_date < TO_DATE('2023-02-01', 'YYYY-MM-DD');
</pre>
This query retrieves sales transactions for January 2023. Oracle will use partition pruning to read only the relevant partition(s) for the specified date range, improving query performance.
By combining compression and interval partitioning, you can optimize storage space, manage large tables efficiently, and enhance query performance in your Oracle database.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-18196973586235577252022-06-15T00:12:00.003-04:002022-06-15T00:13:37.643-04:00Convincing an Intern to Perform Data Science Tasks Using SQLAn intern has joined my client's company to work on a data science task. I will be helping her along the way. She is familiar with Python and R programming languages and has accomplished a number of projects with these tools. However, I have successfully convinced her that it is a good idea to learn database query language SQL and use it to perform most data work. The following are the four reasons that I mentioned:<div><ol style="text-align: left;"><li>Unlike in academic environment, business data are mostly stored in relational databases. It is economical and secure to perform data analytics/data science jobs within databases using SQL.</li><li>SQL language is standard. SQL scripts, with minor or no change, can run on any relational databases such as Snowflake, Oracle, SQL Server, MySQL, Postgresql, etc.</li><li>Most of the data analytics/data science processes can be implemented in SQL and deployed in databases.</li><li>SQL was developed over 50 years ago. It is still widely used and will continue to be so for many years to come. Not many programming language survived such a long period of time. It is a good investment to learn SQL.</li></ol><div><br /></div><div><br /></div></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-13392876350524712332021-12-30T00:39:00.001-05:002021-12-30T00:39:24.607-05:00Upcoming Webinar: Optimize Inventory Safety Stock - A Fundamental Principle and ToolMany factors involved with an inventory affect the bottom line of a business including the purchase price, selling price, bank interest rate, warehouse space cost, utility cost, cost of the item being damaged, stolen and becoming obsolete, etc. It is a consensus among planners that balancing these factors and setting safety stock levels to improve the overall profitability is by no means an easy task.<br><br>
In the webinar, Dr.Jay Zhou will introduce a much-need guiding principle that pinpoints the optimal safety stock level to maximize the profitability. It is a powerful and quantitative principle yet a straightforward one that can be easily understood by everybody. The benefits of the approach are many-faceted: fully measurable financial outcomes, improved planning productivity, etc.<br><br>
Dr. Zhou will show how it actually works by using PeakProfit, a software tool from Friesian Analytics that implements the principle, and finding the optimal safety stocks for stock items convincingly and elegantly in a live demo.<br><br>
The webinar is designed for all inventory professionals and managers regardless of if they have 2 months or 20 years of working experience. Please register for the webinar scheduled on Thursday, January 13th 2022 - 11:00 AM (EST) <a href="https://app.livestorm.co/dr-jay-zhou/optimize-inventory-safety-stock-a-fundamental-principle-and-tool?type=detailed">here</a><br><br>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhI6kE8Wt-cLwxwpnQ0I9y-NzDjOK9fjZSq4xdNGdPPZEO1Dj-90Oh8Xtgcz2RAY5KOB4GqBrOd2iz8h-4RqSIZmosW9N1zapmfyq-6oYrnN_AHnIDxZiWCQ9edONUR1M-AMLkfwxDmzqsuXgXzxDtl3JlnYZTiNR-Hmf2rvR79oxOp-DBBAA=s2340" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="320" data-original-height="1628" data-original-width="2340" src="https://blogger.googleusercontent.com/img/a/AVvXsEhI6kE8Wt-cLwxwpnQ0I9y-NzDjOK9fjZSq4xdNGdPPZEO1Dj-90Oh8Xtgcz2RAY5KOB4GqBrOd2iz8h-4RqSIZmosW9N1zapmfyq-6oYrnN_AHnIDxZiWCQ9edONUR1M-AMLkfwxDmzqsuXgXzxDtl3JlnYZTiNR-Hmf2rvR79oxOp-DBBAA=s320"/></a></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-60674153973657768112021-12-24T10:57:00.006-05:002021-12-24T11:03:53.635-05:00Upcoming Webinar - Optimize Inventory Safety Stock - A Fundamental Principle and ToolWithout a clear and quantified guiding principle, planners find themselves having a hard time determining inventory safety stock levels. Often, it becomes an “art”, which involves manual judgement and spreadsheets, rather than a science. It is not uncommon to see that a company’s safety stock levels stay the same for years despite the business conditions have changed drastically. As a result, a company’s bottomline is negatively impacted.<br><br>
In the webinar, Dr.Jay Zhou will introduce a much-need guiding principle that pinpoints the optimal safety stock level to maximize the profitability. It is a powerful and quantitative principle yet a straightforward one that can be easily understood by everybody. The benefits of the approach are many-faceted: fully measurable financial outcomes, improved planning productivity, etc.<br><br>
Dr. Zhou will show how it actually works by using PeakProfit, a software tool from Friesian Analytics that implements the principle, and finding the optimal safety stocks for stock items convincingly and elegantly in a live demo.<br><br>
The webinar is designed for all inventory professionals and managers regardless of if they have 2 months or 20 years of working experience. Please register for the webinar scheduled on Thursday, January 13th 2022 - 11:00 AM (EST) <a href="https://app.livestorm.co/dr-jay-zhou/optimize-inventory-safety-stock-a-fundamental-principle-and-tool?type=detailed">here</a><br><br>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgkSgExSymQR-XLcqv9pqOQ1KALuAOFBjOVweh05mlDD0HXYRz6xZqPn82kXgbQTivjCduJYhPGyLsghMMZdDE3TO5UUA0V42FW_L1uvWfMRAyzQFO_l_8ttfv9vBVygzAfrRnS0-HNVSdB668YOIxjEMlMY0JLE6jk0FrRFVT5OhScvI4JTA=s2598" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="320" data-original-height="1612" data-original-width="2598" src="https://blogger.googleusercontent.com/img/a/AVvXsEgkSgExSymQR-XLcqv9pqOQ1KALuAOFBjOVweh05mlDD0HXYRz6xZqPn82kXgbQTivjCduJYhPGyLsghMMZdDE3TO5UUA0V42FW_L1uvWfMRAyzQFO_l_8ttfv9vBVygzAfrRnS0-HNVSdB668YOIxjEMlMY0JLE6jk0FrRFVT5OhScvI4JTA=s320"/></a></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-71225832833368793942021-12-19T23:42:00.004-05:002021-12-24T11:03:11.813-05:00Upcoming Webinar: Optimize Inventory Safety Stock - A Fundamental Principle and Tool<br><br>
Many planners take a trial-and-error approach based on experience or guesswork to set inventory safety stock levels. In the webinar, Dr.Jay Zhou will introduce a fundamental principle that pinpoints the optimal safety stock level to maximize the profitability. It is a powerful and quantitative principle yet a straightforward one that can be easily understood by everybody. The benefits of the approach are many-faceted: fully measurable financial outcomes, improved planning productivity, etc. Following the introduction of the principle, Dr. Zhou will show how it actually works by using PeakProfit, a software tool from Friesian Analytics that implements the principle.<br><br>
The webinar is designed for all inventory professionals and managers regardless of if they have 2 months or 20 years of working experience. Please register for the webinar scheduled on Thursday, January 13th 2022 - 11:00 AM (EST) <a href="https://app.livestorm.co/dr-jay-zhou/optimize-inventory-safety-stock-a-fundamental-principle-and-tool?type=detailed"> here </a> .
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgXoHMb-CFaX5C8li_soThBAdmpsEQbEt714ipfINPPGJ1g82XZtOIaCn91DGgwuhvoYdFznCvg7JvIBsZJZ1iZzkk-w2nKVxiAB-ntEHa0jRCIOR-4zLVjrfrs01qmtl-jKGqyYBWu1je68MRHf7niV7miKyzRewQP4IrBYug4_m_INFOrSg=s2488" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="320" data-original-height="1666" data-original-width="2488" src="https://blogger.googleusercontent.com/img/a/AVvXsEgXoHMb-CFaX5C8li_soThBAdmpsEQbEt714ipfINPPGJ1g82XZtOIaCn91DGgwuhvoYdFznCvg7JvIBsZJZ1iZzkk-w2nKVxiAB-ntEHa0jRCIOR-4zLVjrfrs01qmtl-jKGqyYBWu1je68MRHf7niV7miKyzRewQP4IrBYug4_m_INFOrSg=s320"/></a></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-31291890512304689942021-11-28T22:02:00.003-05:002021-11-28T22:08:07.835-05:00We are hiring data engineers.We are looking for multiple contractors for a six-month project, Data Engineers, who may work remotely. The role
will help us build and maintain a Snowflake data warehouse that captures
historical and ongoing business data. The data in the warehouse need to be
cleaned, transformed, and merged to generate a holistic view of the business,
which will serve as the foundation for downstream value-added in-depth analytics
and machine learning.<br><br>
<b>Responsibilities</b><br>
Build Snowflake data pipeline/ETL jobs to ingest data from text files,
relational and non-SQL databases. <br>
Perform ongoing maintenance and administration
of the Snowflake warehouse. <br>
Design and implement Snowflake schemas including
tables, views, and materialized views. <br>
Understand the data from a business perspective and write SQL
scripts based on business logic. <br>
Manage data sharing and data access for
business users. <br>
Optimize data storage and warehouse query
performance.<br><br>
<b>Qualifications and Experience</b><br>
Experience with Snowflake warehouse, data pipeline, Apache Airflow, and ETL
tools in an enterprise environment. <br>
Strong experience working with large data
sets from multiple sources. Performed tasks including data cleansing, data
merge, and aggregation. <br>
Strong SQL and Python programming skills. Knowledge in R
programming is a plus. <br>
Experience MySQL, MongoDB, Amazon AWS
services (S3, SQS, Lamba, etc.). <br>
Experience with business intelligence tool is a plus.<br>
Experience with machine learning is a plus. <br>
<br><br>
To apply for the position, please send your
resume to us at <a href="mailto:jobs@sqlytics.com ">jobs@sqlytics.com</a>.
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-88709180362444228742021-09-24T00:09:00.001-04:002021-09-24T00:09:16.960-04:00An Antique Neural Network for Image ClassificationQuite accidentally I found the picture below showing my research work in 1994 when I trained a neural network to identify the land use types from a satellite image. The neural network had a structure of 3 input neurons, corresponding to the blue, green, and red bands of a Landsat TM image, 14 hidden neurons, and 7 output neurons, representing seven land use types including the cornfields, wheat fields, water bodies, impervious surfaces, etc. The number of training data points is 65. <br><br>
I coded everything from scratch including the algorithm and the user interface using C++. There were no prebuilt packages to use, no internet to search the information, and no such thing as asking questions on social media. The computer used had a 486 CPU, a 32-megabyte memory, and a hard drive with less than 500-megabyte storage. <br><br>
How things have changed in 27 years! With a deep learning neural network, such as a convolutional neural network, many layers of neurons serving different purposes can be stacked together to form a complex structure and collectively perform recognitive tasks that were unthinkable in the past. And all these can be done with a few lines of Python scripts and the execution is often done in a cloud computing environment with virtually unlimited computation and storage resources. The progress is astonishing. <br><br>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0Uh-toQZxk-6kd4GKTTAplYsu8x4RnS_ex3m6XPhwOXfCdgWcMoo3I7UTwOtKLLEK2cc6Ao3Dg54HdoIfNuF1BU1vNg7w-1RpxvVoHkLq3V-khIrI7QnAjbrdUgLQsRzMP6J-/s2590/NN_image_classification.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="600" data-original-height="1214" data-original-width="2590" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0Uh-toQZxk-6kd4GKTTAplYsu8x4RnS_ex3m6XPhwOXfCdgWcMoo3I7UTwOtKLLEK2cc6Ao3Dg54HdoIfNuF1BU1vNg7w-1RpxvVoHkLq3V-khIrI7QnAjbrdUgLQsRzMP6J-/s600/NN_image_classification.png"/></a></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-22014080001511463342021-09-22T08:33:00.007-04:002021-09-22T12:38:03.607-04:00Online Course: Oracle SQL for Random Sampling<html>
<style type="text/css">
pre{border: 2px solid #666; padding: 10px; background-color: lightgray;}
pre.code {border: 2px solid #666; padding: 10px; background-color: lightyellow;}
pre.out {border: 2px solid #666; padding: 10px; background-color: lightgray;}
div.code {color:blue}
</style>
<p>
Since many companies store their critical business data in Oracle databases, it is advantageous to perform random sampling within the same environment using SQL without data movement. For example, it is time-consuming to pull a large data set out of a database and do random sampling using Python on a laptop computer. In addition, the data are prone to various security issues once they are not protected by the database.<br><br>
A Competition-winning data scientist and long-time Oracle SQL practitioner Dr. Jay Zhou creates an online course and shares his expertise in performing random sampling using Oracle SQL. Students will learn practical skills that can be applied immediately in their work. There were hundreds of people from 85 countries who took the course.<br>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwJT0S60AEPmrK0wD2z1DLcwmFrOoELUJW1gLYf1Zqdy9-2mOPYOxP5eypTHMJ26hB2QX_eYaCxJMD6DFkUa0DcUIZm7uoZKFCAkrP_kVGwPYg39S3n-cxmy2LZYsqW1KBLXGR/s1866/Screen+Shot+2021-09-22+at+12.23.02+AM.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="600" data-original-height="1270" data-original-width="1866" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwJT0S60AEPmrK0wD2z1DLcwmFrOoELUJW1gLYf1Zqdy9-2mOPYOxP5eypTHMJ26hB2QX_eYaCxJMD6DFkUa0DcUIZm7uoZKFCAkrP_kVGwPYg39S3n-cxmy2LZYsqW1KBLXGR/s600/Screen+Shot+2021-09-22+at+12.23.02+AM.png"/></a></div>
The course begins with a description of scenarios where random sampling is necessary. A number of useful Oracle SQL random functions are introduced. The course uses examples and presents SQL scripts to perform the following common tasks.
<ul>
<li>How to quickly view random samples of the data. There are multiple ways to do this task.</li>
<li>How to select a precise number of samples randomly.</li>
<li>How to split data randomly. This is a necessary task when we build a machine learning model and need to produce three data sets, i.e., training, testing, and validation sets.</li>
<li>How to select random samples by groups. For example, we want to randomly select 100 students, 50 of them female and 50 male, from a school.</li>
</ul>
<h4>Are there any course requirements or prerequisites?</h4>
Very basic Oracle SQL knowledge<br>
<h4>Who this course is for?</h4>
SQL developers, data analysts, data scientists, statisticians<br>
</p>
</ul> <h4><a href="https://www.udemy.com/course/oracle-sql-for-random-sampling/learn/lecture/14223194#overview">Please take the course here.</a></h4>
<a href="https://www.udemy.com/course/oracle-sql-for-random-sampling/learn/lecture/14223194#overview">
<div class="separator" style="clear: both; text-align: center"><img alt="" border="0" width="400" data-original-height="135" data-original-width="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYwXvPrO0uhj7a-3tzjjjiL8cwI1GWJhfXM2f5VL3iUTdArTPCxmujWY-MyJ_kW3aN8OeRE1hax7EVEqx8ZqJVu29orG95b5SoP1-0ti3I86i3GfXp2XFD-6fngTMJYVTjuWXd/s400/2301068_e9ac_3.jpeg"/></div></a></html>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-68914044702340402832021-09-18T06:27:00.001-04:002021-09-18T06:30:40.339-04:00Taking Operational Efficiency to the Next Level: Leverage the 95-5 Rule of Automation<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJQpgXeRw2FtR7LpINsOOqqGYQiV8z_D9bfvrpgjl7VlKsN4aFJGC0jVdaQs2zDByIhLLOpaE5QAKqVmYDX5BulF48b06a3W76q43xpU2ruBqHm-tdwkmizq9cW-AGS1cy4-X8/s2048/rule-9505.jpeg" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="400" data-original-height="1365" data-original-width="2048" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJQpgXeRw2FtR7LpINsOOqqGYQiV8z_D9bfvrpgjl7VlKsN4aFJGC0jVdaQs2zDByIhLLOpaE5QAKqVmYDX5BulF48b06a3W76q43xpU2ruBqHm-tdwkmizq9cW-AGS1cy4-X8/s400/rule-9505.jpeg"/></a></div>
Through an odyssey of over two decades helping clients in various industries solve hard problems, I have gained a deep appreciation of a pattern that can be leveraged to dramatically improve the quality and efficiency of the work and, ultimately, the return on investment of businesses.<br><br>
Whether it is inventory planning, or financial fraudulent transaction detection, or finding costly insurance claims, it generally holds true that 95% of the work can be resolved by automated algorithms. The remaining 5% needs to be done by domain experts using their expertise, intuition, and creativity. I call it the 95-5 rule of automation.<br><br>
The 95-5 rule is not simply a division of the labor between machines and human experts flatly in that proportion. There is a structural and temporal implication in it. Algorithms are first applied to a raw problem, which involves a large number of cases and big data and is hard or inefficient to solve manually. This step produces as an output a simpler problem where the work is greatly reduced, by 95% generally. Human experts then work on this reduced problem and make their judgment calls to reach the final decision.<br><br>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzmDqdRCTPzLViJd9bvHGRsWeEdhTafvKa0TK0XofkZL9u5m6V1Np9mME8t21fzrjSuv7Vxd1nvjyAILaUM2GnryxDXzFXsHd7GbEW_NbGVoOUY93BOg9esWHBgab_KPI6cub4/s2048/rule-do-2.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="400" data-original-height="1066" data-original-width="2048" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzmDqdRCTPzLViJd9bvHGRsWeEdhTafvKa0TK0XofkZL9u5m6V1Np9mME8t21fzrjSuv7Vxd1nvjyAILaUM2GnryxDXzFXsHd7GbEW_NbGVoOUY93BOg9esWHBgab_KPI6cub4/s400/rule-do-2.png"/></a></div>
Take as an example our solution to a worker compensation insurance claim problem. A company receives about 200 worker injury claims daily. Our algorithm highlights 10 (5% of the total) of them as potentially costly using a machine learning model based on factors including age, cause of injury, and injury body parts. Using these 10 cases as a starting point, analysts review them carefully and take proper action. The solution has resulted in a 40% reduction in claim loss.<br><br>
To recap, in the real world the 95-5 rule of automation works this way: applying algorithms to a raw problem to reduce the work by 95% and subsequently having human experts take on the reduced problem.<br><br>
Here are the benefits as reported by our clients that have adopted solutions based on the 95-5 rule of automation.<br><br>
<ul>
<li>Improved outcomes. For example, a bank sees its fraud loss reduced by 70%. Another bank finds the bad debt rate dropping by 50%.
<li>Increased efficiency. In a K12 education company, content tagging is 100 times more efficient than a manual process.
<li>More jobs. A group in a bank hires more analysts because the operation there drives a good return on investment.
<li>Improved employees' morale. This is because they work on the reduced problem where the same amount of effort generates more fruitful outcomes. ( I did not realize this point until I saw a report produced by an independent department from a client company.)
</ul> <br>
When the rule is applied to inventory planning, our advanced optimization algorithm generates a set of recommended safety stocks for all items which serves as the foundation for planners to make further improvements. <br><br>
One lesson that we have learned is that, unless it is an exceptionally simple circumstance, domain experts should not work with the raw problem directly. Unfortunately, the violation of this principle is happening every day resulting in ineffective, inefficient, and unscalable operations and a stressful workforce. The whole situation is avoidable.<br><br>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUKRSPte5P4Ul_1Jq82OfDex4doJSSfNluibtKlPa2W06i5seqHJv0nEfHP2q6o2lJRGD6kaUQGq1RsioNxOh9b_e6e1vR_tsU6IMH_SkfuW7wiuj4Uo93b3m4t1CKVuZvxDzx/s1847/Rule-not-do.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="400" data-original-height="1050" data-original-width="1847" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUKRSPte5P4Ul_1Jq82OfDex4doJSSfNluibtKlPa2W06i5seqHJv0nEfHP2q6o2lJRGD6kaUQGq1RsioNxOh9b_e6e1vR_tsU6IMH_SkfuW7wiuj4Uo93b3m4t1CKVuZvxDzx/s400/Rule-not-do.png"/></a></div>
The 95-5 rule of automation has worked for us remarkably. I hope you make the most of it in your organization and take operational efficiency to the next level.<br><br>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-57894417695560584362021-08-14T05:12:00.004-04:002021-08-14T05:13:30.659-04:00Webinar Video: Holistic Safety Stock Optimization - Putting the Horse Before the Cart
<html>
<style type="text/css">
pre{border: 2px solid #666; padding: 10px; background-color: lightgray;}
pre.code {border: 2px solid #666; padding: 10px; background-color: lightyellow;}
pre.out {border: 2px solid #666; padding: 10px; background-color: lightgray;}
div.code {color:blue}
</style>
<p>
The recorded video of the webinar "Holistic Safety Stock Optimization - Putting the Horse Before the Cart" delivered by Dr. Jay Zhou on August 12. <br><br>
<iframe width="560" height="315" src="https://www.youtube.com/embed/videoseries?list=PLvDu3gGS3a_8AMM4gKWGYWSqKK4xAqXN8" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe><br><br>
A significant amount of money can be saved without impacting the overall demand satisfaction by optimizing the inventory holistically. With the right approach, we can comfortably construct an inventory with less money while providing higher overall demand satisfaction.
</p>
</html>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-62350670348290595642021-08-04T11:34:00.004-04:002021-08-04T11:40:21.868-04:00Webinar Invitation: Holistic Inventory Optimization<html>
<style type="text/css">
pre{border: 2px solid #666; padding: 10px; background-color: lightgray;}
pre.code {border: 2px solid #666; padding: 10px; background-color: lightyellow;}
pre.out {border: 2px solid #666; padding: 10px; background-color: lightgray;}
div.code {color:blue}
</style>
<p>
If you are responsible for a large inventory, I would like to invite you to attend my webinar <a href="https://lnkd.in/d43MEjP"> "Holistic Safety Stock Optimization - Putting the Horse Before the Cart"</a> on Thursday at 2:30 pm, August 12, 2021. Please register <a href="https://lnkd.in/d43MEjP"> here.</a>. <br><br>
I have written an <a href="https://www.linkedin.com/pulse/holistic-inventory-optimization-friesian-analytics/"> article </a>) describing the challenge facing companies with large inventory. Tens or hundreds of millions of dollars or more, in addition to their stock prices or market valuation, are at stake depending on the company’s inventory sizes. C-level executives and senior managers want answers to the following critical questions which are both sides of the same coin. <br>
<ul>
<li>How to spend a fixed budget on safety stocks so that the average demand satisfaction for the whole inventory is the highest? </li>
<li>How to achieve the desired average demand satisfaction for the whole inventory with the lowest budget of total safety stocks? </li>
</ul>
In the webinar, I will demonstrate a powerful solution developed by Friesian Analytics. The total inventory value can be reduced significantly without affecting the overall demand satisfaction. The horse (budget) should pull the cart (inventory), not the other way around as it is done by many companies. I look forward to seeing you at the webinar! Thank you.
<br><br>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqJREewDT-dGc3TRPASliulIMIAG14FrUgwI2vFJCfl79MzG8sg0xGQDx8xCktxxWHbfhPEgnkcLHBelzNj2jkTEVNiHja5De1xeULyWrbtknY8Mb96VQ_8H2fr7YViyT6cMlA/s1412/Screen+Shot+2021-08-04+at+10.12.32+AM.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="400" data-original-height="781" data-original-width="1412" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqJREewDT-dGc3TRPASliulIMIAG14FrUgwI2vFJCfl79MzG8sg0xGQDx8xCktxxWHbfhPEgnkcLHBelzNj2jkTEVNiHja5De1xeULyWrbtknY8Mb96VQ_8H2fr7YViyT6cMlA/s400/Screen+Shot+2021-08-04+at+10.12.32+AM.png"/></a></div>
</p>
</html>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-38270941434538203722021-07-26T14:21:00.006-04:002021-07-26T14:27:07.176-04:00Holistic Inventory Optimization<html>
<style type="text/css">
pre{border: 2px solid #666; padding: 10px; background-color: lightgray;}
pre.code {border: 2px solid #666; padding: 10px; background-color: lightyellow;}
pre.out {border: 2px solid #666; padding: 10px; background-color: lightgray;}
div.code {color:blue}
</style>
<p>
The following was first published by me as a <a href="https://www.linkedin.com/feed/update/urn:li:ugcPost:6825440095366213632?updateEntityUrn=urn%3Ali%3Afs_feedUpdate%3A%28*%2Curn%3Ali%3AugcPost%3A6825440095366213632%29">LinkedIn article.</a><br><br>
Tens of millions or hundreds of millions of dollars or more, in addition to stock prices or market valuation, are at stake depending on the company’s inventory sizes. C-level executives want answers to the following critical questions which are both sides of the same coin. <br><br>
<ul>
<li>How to spend a fixed budget on safety stocks so that the average demand satisfaction for the whole inventory is the highest? </li>
<li>How to achieve the desired average demand satisfaction for the whole inventory with the lowest budget of total safety stocks? </li>
</ul>
To illustrate the point, consider the following simple inventory with 10 stock items. Factors determining the total value of safety stocks including lead time, unit price, demand standard deviation, and demand satisfaction (DS). Among these factors, DS for the individual stock items is the only one that we can adjust readily.
<br><br>
<h3>Figure 1. Common Approach - Setting the Same DS to Each Item</h3>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZw-IFq12ryAII5RRV1FQlYdVKVLxcfAz772baZkTfEGkXIuOlJYomZhEI9M1SM6gKvBylwebNzoWQtM5giGockP7LCMLymeVuCWAeH2f2cTXnJgpldX-XsSRHupEQAGlNkpA6/s915/Screen+Shot+2021-07-26+at+6.17.53+AM.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="400" data-original-height="285" data-original-width="915" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZw-IFq12ryAII5RRV1FQlYdVKVLxcfAz772baZkTfEGkXIuOlJYomZhEI9M1SM6gKvBylwebNzoWQtM5giGockP7LCMLymeVuCWAeH2f2cTXnJgpldX-XsSRHupEQAGlNkpA6/s400/Screen+Shot+2021-07-26+at+6.17.53+AM.png"/></a></div>
A common approach is to simply set the DS for all parts to a single number. Some managers adopt ABC analysis to divide stock items into several groups based on their values and assign the DS to each group. When we set DS to 91% for all items as shown in Figure 1, the average DS is 91% and the total value of safety stock is $129,985. <br><br>
However, we can do much better. By setting the DS for each item more intelligently, we can keep the average DS of 91% and reduce the total safety stock by about 16% (Figure 2). Or by assigning a different set of DSs, we can maintain the same total safety stock budget and increase the average DS from 91% to 93% (Figure 3). <br><br>
<h3>Figure 2. How to Keep the Average DS of 91% and Reduce the Total Safety Stock by About 16%?</h3>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-y508giJSsMQKsdXQmsLRE0iXEcVBaFnvvpbMOtPRzGI3974hmPOtX-l2K0D0MC2KprUI0AghyifxizLKana-QaWtRTqbn80kyO2rBjrfz9hIT0uP4qaohCpi4rJpaGl-9YQn/s988/Screen+Shot+2021-07-26+at+9.50.09+AM.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="400" data-original-height="328" data-original-width="988" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-y508giJSsMQKsdXQmsLRE0iXEcVBaFnvvpbMOtPRzGI3974hmPOtX-l2K0D0MC2KprUI0AghyifxizLKana-QaWtRTqbn80kyO2rBjrfz9hIT0uP4qaohCpi4rJpaGl-9YQn/s400/Screen+Shot+2021-07-26+at+9.50.09+AM.png"/></a></div>
<h3>Figure 3. How to Keep the Same Total Safety Stock Budget and Increase the Average DS From 91% to 93%?</h3>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNi99zvbinfahGGzAYgMe40gsCfesW23VfuNq99BY_310xhlpywDZbSnBZ5iUaBCWUwBU-pokahEdAqZsA7vklvImI9ammhyB3_aHS1ePEjAMoWzwYLPdFlpIQJAfzxHA3pFla/s983/Screen+Shot+2021-07-26+at+9.49.58+AM.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="400" data-original-height="326" data-original-width="983" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNi99zvbinfahGGzAYgMe40gsCfesW23VfuNq99BY_310xhlpywDZbSnBZ5iUaBCWUwBU-pokahEdAqZsA7vklvImI9ammhyB3_aHS1ePEjAMoWzwYLPdFlpIQJAfzxHA3pFla/s400/Screen+Shot+2021-07-26+at+9.49.58+AM.png"/></a></div>
Interested readers may do an exercise. <a href="https://1drv.ms/x/s!AgrNCVAL-EQxgfkW6f142Id-w1Kqig?e=rCf72y">Here is a downloadable spreadsheet file that embeds the formula to calculate DS.</a> One simply fills in whatever DS she/he desires for each item. The average DS and total safety stock will be calculated for you. <br><br>
If you can produce the results as shown in Figures 2 and 3 or better, congratulations! If not, I would invite you to attend my webinar <a href="https://jiangzhou.my.webex.com/jiangzhou.my/j.php?RGID=raf28fd25165cb60e379460020b551eec">"Holistic Safety Stock Optimization - Putting the Horse Before the Cart" on Thursday, August 12, 2021 </a> <br><br>
Even if you are able to solve the 10-item problem by trial-and-error, in the real world many businesses have far more stock items than 10, I would still encourage you to attend the event.<br><br>
</p>
</html>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-75287880640628268142021-07-22T06:57:00.007-04:002021-07-22T06:57:58.808-04:00Upcoming Webinar: Holistic Safety Stock Optimization - Putting the Horse Before the Cart<html>
<style type="text/css">
pre{border: 2px solid #666; padding: 10px; background-color: lightgray;}
pre.code {border: 2px solid #666; padding: 10px; background-color: lightyellow;}
pre.out {border: 2px solid #666; padding: 10px; background-color: lightgray;}
div.code {color:blue}
</style>
<p>I will give a 45-minute webinar on Thursday, August 12, 2021, at 2:30 PM Eastern Time. If you are responsible for a large quantity of inventory, I would encourage you to attend the event. <a href="https://jiangzhou.my.webex.com/jiangzhou.my/j.php?RGID=raf28fd25165cb60e379460020b551eec"> Please register here.</a> </br></br>
The following is a summary of the webinar. </br></br>
The CFO of a company wants to know, given a fixed budget, how to determine the safety stocks of all inventory items to achieve the highest overall demand satisfaction. In the webinar, Dr. Jay Zhou will show that the above goal can only be achieved by optimizing safety stocks holistically. He will demonstrate a powerful solution developed by Friesian Analytics (https://friesiancorp.com). The horse (budget) should pull the cart (inventory), not the other way around as it is done by many companies.
</p>
</html><div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNIEAM0Hd1qu2O4kTk3BKzCFebrdHZkgXdVv91vkcOTwBFdQyt1KHYwh9YCzPPrtBo79QF9gCeCtIsUw9LM4h1BsVwfqt3utm4oPwgiw2fChH2b2xJeb8A6vpIwWf31VmRE1Vc/s600/FA_budget_ss4.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="400" data-original-height="315" data-original-width="600" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNIEAM0Hd1qu2O4kTk3BKzCFebrdHZkgXdVv91vkcOTwBFdQyt1KHYwh9YCzPPrtBo79QF9gCeCtIsUw9LM4h1BsVwfqt3utm4oPwgiw2fChH2b2xJeb8A6vpIwWf31VmRE1Vc/s400/FA_budget_ss4.png"/></a></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-41849427142261406962021-07-02T06:25:00.006-04:002021-07-02T06:33:35.084-04:00Free Online Calculating Inventory Safety Stock Calculator<html>
<style type="text/css">
pre{border: 2px solid #666; padding: 10px; background-color: lightgray;}
pre.code {border: 2px solid #666; padding: 10px; background-color: lightyellow;}
pre.out {border: 2px solid #666; padding: 10px; background-color: lightgray;}
div.code {color:blue}
</style>
<p>I made a youtube video at https://lnkd.in/d3hECWU to introduce a free online tool for calculating inventory safety stock. A spreadsheet file that implements the calculator is downloadable. <a href="https://safetystockcalc.com/calculator.html">Here is the link to the calculator.</a> Enjoy!
<iframe width="560" height="315" src="https://www.youtube.com/embed/3TorHaZZRcc" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
</p>
</html>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-55955275632199086402021-05-28T09:47:00.001-04:002021-05-28T09:47:51.870-04:00Oracle Function Returns Two Values<html>
<style type="text/css">
pre{border: 2px solid #666; padding: 10px; background-color: lightgray;}
pre.code {border: 2px solid #666; padding: 10px; background-color: lightyellow;}
pre.out {border: 2px solid #666; padding: 10px; background-color: lightgray;}
div.code {color:blue}
</style>
<p>There is a table in a schema that contains three columns, p, low and hi. In the table, p is the primary key. I want to develop a function to return low and hi based on an input variable p. First I create a type.</p>
<pre>
create or replace type t_low_hi as object ( low number, hi number);
</pre>
<p> Then I create a function that finds low and hi based on p, constructs a type object and returns it. </p>
<pre>
create or replace function f_prob (p_p number)
return t_low_hi is
p_Low number;
p_Hi number;
Str_sql varchar2(2000);
begin
Str_sql := 'Select low, hi from t_lookup where p=:1';
Execute immediate str_sql into p_low, p_hi using p_p;
return t_low_hi(p_low, p_hi);
end;
/
</pre>
<p>I call the function and retrieve low and hi for p with a value of 0.99.</p>
<pre>
select x.v.low , x.v.hi from (select f_prob(0.99) v from dual) x;
</pre>
</pre>
</html>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-44960137333725297872021-01-12T22:39:00.003-05:002021-01-13T07:50:49.041-05:00Updated Online Chinese Document Analytics Tool<html>
<style type="text/css">
pre{border: 2px solid #666; padding: 10px; background-color: lightgray;}
pre.code {border: 2px solid #666; padding: 10px; background-color: lightyellow;}
pre.out {border: 2px solid #666; padding: 10px; background-color: lightgray;}
div.code {color:blue}
</style>
<p>We have updated our free online tool for analyzing Chinese documents: <a href="https://aistrike.us/text-analysis.html">https://aistrike.us/text-analysis.html</a> A user fills in a textbox with the content and click Submit button. The tool identifies words, displays a word cloud picture and calculates a sentiment index for each sentence. Enjoy! </p>
<p>Identifying words in a sentence is necessary. Chinese words in a sentence are next to each other without spaces separating them, e.g. Chinesewordsinasentencearenexttoeachotherwithoutspacesseparatingthem. And yes, the division of words could be ambiguous. For example, "结婚和尚未结婚的" could mean "married and unmarried" ("结婚 | 和 | 尚未结婚的") or "married, monk, unmarried" ("结婚 | 和尚 | 未结婚的") .
</p>
<html><div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDYknecafhB5QtYtOicofic3KMp1R-7lf3jyWdD1M3fVyvhZhd1KZTyv0TLJTuzFOBuFzgENdr1q7ties7vUkDR5VdrX_E4tp_JeavYoTDb6znsS6TwkbD0V5TYFfDvFSqnFqD/s1173/Screen+Shot+2021-01-12+at+9.58.32+PM.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="320" data-original-height="872" data-original-width="1173" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDYknecafhB5QtYtOicofic3KMp1R-7lf3jyWdD1M3fVyvhZhd1KZTyv0TLJTuzFOBuFzgENdr1q7ties7vUkDR5VdrX_E4tp_JeavYoTDb6znsS6TwkbD0V5TYFfDvFSqnFqD/s320/Screen+Shot+2021-01-12+at+9.58.32+PM.png"/></a></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-9179063260027883872020-12-29T01:08:00.015-05:002020-12-29T11:39:25.071-05:00Inventory Optimization - Calculate Safety Stock<html>
<head>
<style type="text/css">
h1,h2,h3,h4 {
text-align: center;
}
pre{border: 2px solid #666; padding: 10px; background-color: lightgray;}
pre.code {border: 2px solid #666; padding: 10px; background-color: lightyellow;}
pre.out {border: 2px solid #666; padding: 10px; background-color: lightgray;}
div.code {color:blue}
</style>
</head>
<p>
Safety stock provides a "cushion" in inventory to address the uncertainty in a customer's demand. It is important to maintain the "right" amount of safety stock. If it is too low, we may not be able to fulfill a customers' orders in a timely fashion. On the other hand, safety stock that is too high incurs significant financial and/or logistics burden to the business.<br/><br/>
The calculation of safety stock is based on a number of factors include historical customer demands, product lead time and fill rate (a.k.a., demand satisfaction). The team at <a href="https://safetystockcalc.com">safetystockcalc.com</a> builds a <a href="https://safetystockcalc.com">website and describe a popular approach to calculate safety stock using an example</a>. On the website, you may also find two free tools that are useful, <a href="https://safetystockcalc.com/calculator.html">an online calculator</a> and a downloadable spreadsheet with all the formulas. Enjoy!<br/>
</p>
<h4> <a href="https://safetystockcalc.com/calculator.html">Online Safety Stock Calculator</a> Screenshot</h4>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgd65ws6Ya-HQXKaCpSDaJYUY8kKRpRbcOygnDETNpyR1-e6wX6CyFghqix6GupiTCH04dEqojajs0W0lgHogy-dRTFSerrmzhNqy14ZBJlzOOgZuQSvRezxFXXXmCkoB7VKaVP/s1456/Screen+Shot+2020-12-29+at+1.12.22+AM.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="320" data-original-height="655" data-original-width="1456" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgd65ws6Ya-HQXKaCpSDaJYUY8kKRpRbcOygnDETNpyR1-e6wX6CyFghqix6GupiTCH04dEqojajs0W0lgHogy-dRTFSerrmzhNqy14ZBJlzOOgZuQSvRezxFXXXmCkoB7VKaVP/s320/Screen+Shot+2020-12-29+at+1.12.22+AM.png"/></a></div>
<h4><a href="https://safetystockcalc.com">Spreadsheet Safety Stock Calculator</a> Screenshot</h4>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitl8ClY2C9m4tA0VGqyO2YqNwZyz5rnvKInjloWg_x5fptmuRZPUwdXC4vRb3DjOc5FPuAjFcQwCRet_kOEHemO5L-COrNfNXxT15H1KWeGI804l7vU4Gn-aJ9arBilrxk2G6m/s1059/Screen+Shot+2020-12-28+at+12.27.20+AM.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="320" data-original-height="710" data-original-width="1059" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitl8ClY2C9m4tA0VGqyO2YqNwZyz5rnvKInjloWg_x5fptmuRZPUwdXC4vRb3DjOc5FPuAjFcQwCRet_kOEHemO5L-COrNfNXxT15H1KWeGI804l7vU4Gn-aJ9arBilrxk2G6m/s320/Screen+Shot+2020-12-28+at+12.27.20+AM.png"/></a></div>
</html>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-88363942300533705852020-11-30T23:41:00.004-05:002020-12-03T11:33:15.906-05:00An Online Tool for Analyzing Chinese Text<html>
<style type="text/css">
pre{border: 2px solid #666; padding: 10px; background-color: lightgray;}
pre.code {border: 2px solid #666; padding: 10px; background-color: lightyellow;}
pre.out {border: 2px solid #666; padding: 10px; background-color: lightgray;}
div.code {color:blue}
</style>
<p>
We have developed a free online tool for analyzing Chinese document. The URL of the tool is located at <a href="https://wcloud.aistrike.us"> here.</a> </br>
A user fills in the textbox with the content and click Submit button. The tool identifies words, calculates frequencies for those words and display a word cloud picture.
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-_7vFHFmr0Bienu2cFj29ereHdf1rzE7kyXYGyrwD5LNHMHL22NeT1f4wf6FAETcAmhAbFTIwTj-nCuqEVnn6AxMkxIFh64uaaqJmj8tCvKS4K5t9PpJL5JQsPfz3bFF-fPjx/s1824/Screen+Shot+2020-11-30+at+11.34.23+PM.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="600" data-original-height="1066" data-original-width="1824" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-_7vFHFmr0Bienu2cFj29ereHdf1rzE7kyXYGyrwD5LNHMHL22NeT1f4wf6FAETcAmhAbFTIwTj-nCuqEVnn6AxMkxIFh64uaaqJmj8tCvKS4K5t9PpJL5JQsPfz3bFF-fPjx/s400/Screen+Shot+2020-11-30+at+11.34.23+PM.png"/></a></div>. Enjoy!
</p>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-67642373316797461792020-04-20T23:59:00.000-04:002020-04-21T00:09:28.832-04:00Real COVID-19 Death Rate<html>
<style type="text/css">
pre{border: 2px solid #666; padding: 10px; background-color: lightgray;}
pre.code {border: 2px solid #666; padding: 10px; background-color: lightyellow;}
pre.out {border: 2px solid #666; padding: 10px; background-color: lightgray;}
div.code {color:blue}
</style>
<p>
In my last post, we did research on COVID-19 death rate based on the ratio between the number of deaths and the number of confirmed cases. However, this method is inherently flawed. Some infected people did not show up at a hospital or a testing station to get tested. As a result, the death rate is exaggerated. </br></br>
Blood antibody tests on randomly sampled residents in Santa Clara, California in early April shows that the number of people infected is 55 to 85 times more than confirmed cases (https://www.cnn.com/2020/04/17/health/santa-clara-coronavirus-infections-study/index.html). Thus, the real death rate for people who infected with coronavirus is between 0.1% and 0.17% which are similar to that of flu. </br> </br> We use the following charts to illustrate two ways of calculating death rates.</br> </br>
COVID-19 Death Rate (Flawed) = Number of Deaths/ Number of Confirmed Cases
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiez5wvf6AG6Kw5D0chdVdH-ZcQaT2Vq8AmVFkM1-k4E5-MAtFLOCcM500YzVHwYm91FkE3dgjyJyk-mObPyadW6eatWAhnI-QSfrO_edsIujUjZqZw3DHABzBqh7l1VPTmkJtm/s1600/confirmed.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiez5wvf6AG6Kw5D0chdVdH-ZcQaT2Vq8AmVFkM1-k4E5-MAtFLOCcM500YzVHwYm91FkE3dgjyJyk-mObPyadW6eatWAhnI-QSfrO_edsIujUjZqZw3DHABzBqh7l1VPTmkJtm/s320/confirmed.PNG" width="230" height="320" data-original-width="428" data-original-height="595" /></a></div>
COVID-19 Death Rate (Real) = Number of Deaths/Number of Infected
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQ0-GQ8TB6-9GS14CyVbIqTaxlrtL-l9uWe5C7ReOM9eUVcambeth1yK1XDAA5DfyPNLNC3z5GeDrRigBy2GYn2i888pIBSSLJfEet4Mb9qCzkh4xUEfoykzXVRnmE4zAUEIEa/s1600/all.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQ0-GQ8TB6-9GS14CyVbIqTaxlrtL-l9uWe5C7ReOM9eUVcambeth1yK1XDAA5DfyPNLNC3z5GeDrRigBy2GYn2i888pIBSSLJfEet4Mb9qCzkh4xUEfoykzXVRnmE4zAUEIEa/s320/all.PNG" width="320" height="296" data-original-width="721" data-original-height="666" /></a></div>
As we can see, the chance of COVID-19 bullet hitting the bullseye, i.e., causing death, is much slimmer that appears based on confirmed cases alone.
</p>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-35892682.post-40580624066850910862020-04-02T20:31:00.001-04:002020-04-04T09:36:49.858-04:00Study on COVID-19 Annualized Death Rate<html>
<style type="text/css">
pre{border: 2px solid #666; padding: 10px; background-color: lightgray;}
pre.code {border: 2px solid #666; padding: 10px; background-color: lightyellow;}
pre.out {border: 2px solid #666; padding: 10px; background-color: lightgray;}
div.code {color:blue}
</style>
<p>Probably this is the first time you see a chart like this. When people hear COVID-19 death rate for older people is high, they panic. We did research and published a paper on COVID-19 death rate( <a href="https://docs.google.com/document/d/e/2PACX-1vRS_petpmuLlvM0UeqNLXE5-rmftg7OK595dl_sdKdl7bFQ5PEq6OZkDLBjr8aBlB1yV66iohUc-uHC/pub"> Study on COVID-19 Annualized Death Rate</a>). Please notice the death rates for COVID-19 are "annualized". But we have to look at things in context. When COVID-19 death rate is annualized, it can be compared with other statistical data that are on annual basis. This is the key contribution of our research. </br></br>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAWi40MkBfwQW4IxTgsl-JrjKjGyBsfxa1hD4QXpLMzTmw7STBn-aVZ_HKHVlShjCEpnygXuZG4p1pw9gjZ-SdNzMsSbLSq5MUibqQPVqj3_5U5TjkpRdL_FPAkCw35s99ZxKG/s1600/COVID-19-2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAWi40MkBfwQW4IxTgsl-JrjKjGyBsfxa1hD4QXpLMzTmw7STBn-aVZ_HKHVlShjCEpnygXuZG4p1pw9gjZ-SdNzMsSbLSq5MUibqQPVqj3_5U5TjkpRdL_FPAkCw35s99ZxKG/s640/COVID-19-2.png" width="640" height="377" data-original-width="876" data-original-height="516" /></a></div>
<center>Please click the chart for sharper view.</center></br>
Only when COVID-19 death rate is annualized, it can be compared with other statistical data that are on annual basis. This is the key contribution of our research. The following are the conclusions. </br> </br>
<strong> Conclusions </strong></br></br>
We propose a method to calculate the annualized death rate (ADR) related to COVID-19. Based on ADR related to COVID-19 and the 2018 death rate for the population of the United States, we gain the following insights:</br>
<li>Incremental annual death rates related to COVID-19 for age groups 45-54, 55-64, 65-74, 75-84 and 85+ are 0.4%, 1.2%, 2.2%, 3.1% and 6.0%, respectively.</li>
<li>Percentages of incremental annual death rates related to COVID-19 for age groups 45-54, 55-64, 65-74, 75-84 and 85+ are 100.9%, 131.8%, 124.4%, 69.8% and 44.5%, respectively. </li>
<li>If the herd immunity strategy is used in the United States, the incremental annual number of deaths related to COVID-19 for people equal to or older than 45 will be between 1.1 and 1.47 million.</li>
</p>
The PDF file for the paper can be downloaded<a href="https://docs.google.com/document/d/e/2PACX-1vRS_petpmuLlvM0UeqNLXE5-rmftg7OK595dl_sdKdl7bFQ5PEq6OZkDLBjr8aBlB1yV66iohUc-uHC/pub"> Study on COVID-19 Annualized Death Rate
</a>Unknownnoreply@blogger.com0