Netinho  Santos

Netinho Santos

1658302915

How to Solve Chemical Equilibrium Problems | Chemical Equilibrium Constant K

This chemistry video tutorial provides a basic introduction into how to solve chemical equilibrium problems.  It explains how to calculate the equilibrium constant k value given the equilibrium concentrations and equilibrium partial pressures of all reactants and products.  If explains how to calculate the equilibrium constant k for a new reaction by changing another reaction.  Finally, it discusses how to calculate the equilibrium constant k using ice tables.

Subscribe: https://www.youtube.com/c/TheOrganicChemistryTutor/featured 

#maths #mathematics  

What is GEEK

Buddha Community

How to Solve Chemical Equilibrium Problems | Chemical Equilibrium Constant K
Vincent Lab

Vincent Lab

1605176864

How to do Problem Solving as a Developer

In this video, I will be talking about problem-solving as a developer.

#problem solving skills #problem solving how to #problem solving strategies #problem solving #developer

Vincent Lab

Vincent Lab

1605176646

How to Ask a Good Question on the Internet as a Programmer

In this video, I will be talking about how to ask for help as a developer.

#problem solving skills #problem solving how to #coding interviews #problem solving #how to ask a good question

Netinho  Santos

Netinho Santos

1658302915

How to Solve Chemical Equilibrium Problems | Chemical Equilibrium Constant K

This chemistry video tutorial provides a basic introduction into how to solve chemical equilibrium problems.  It explains how to calculate the equilibrium constant k value given the equilibrium concentrations and equilibrium partial pressures of all reactants and products.  If explains how to calculate the equilibrium constant k for a new reaction by changing another reaction.  Finally, it discusses how to calculate the equilibrium constant k using ice tables.

Subscribe: https://www.youtube.com/c/TheOrganicChemistryTutor/featured 

#maths #mathematics  

Biju Augustian

Biju Augustian

1574684368

Introduction to Solving Data Problems with UNIX

Description
UNIX, Linux, and their variants are wonderful operating systems, with great capabilities of doing data processing. But they are often ignored when people think about solving data problems, or in general, Data Science. This short course provides a hands-on approach to using UNIX/Linux for solving various data problems from sorting and searching to extracting and manipulating information. And all of these without writing any code! That’s right. With just a few commands of UNIX, and appropriate combinations of them, one could solve many data problems within seconds without writing thousands of lines or code or spending hours and days.

Basic knowledge
This course is for beginners, but it helps to have some basic understanding of operating systems (e.g., finding and launching programs, installing and configuring apps), as well as some basic knowledge of any programming. The course also assumes that you have a way to connect to a UNIX/Linux system. Alternatively, you could install a free utility on your computer that enables you to work on a UNIX-like environment (not needed for a Mac or a Linux desktop)
What will you learn
Remotely logging into a UNIX/Linux machine
File transfer to a remote machine
A basic understanding of some of the common tools useful for doing programming
Several basic UNIX commands and utilities
Solving several kinds of data problems using UNIX
To continue:

#developmenttool #data-problems #unix #solving-data-problems-with-unix

How to Approach Solving Complex Problems

How to approach solving a complex problem? Is there a simple way?

In this article, I am sharing one simple method that I learned while working on a data analytics requirement, which can be applied to solve pretty much all complex problems.


A bit of context and problem definition

A few years ago, I had recently started working on a project for one of our new clients. The client had implemented ERP in the Oracle EBS suite recently and at the moment they were undergoing a business transformation.

In this context, they required some data crunching to be done in a quick time to find out business insights on various businesses so management could decide on several next steps.

I didn’t know much about the business and functionalities implemented, however as a software developer, I had worked on Oracle Ebusiness Suite for the past six years so I was comfortable working on such requirements.

To give an example, this was one requirement regarding the client’s trial order business that I got in the beginning. Our client would give some pieces of equipment to their clients on a trial basis for free, hoping that after the trial period clients will convert into actual sales.

The requirement for me was to do some analytics — how many trial orders were placed by the top ten customers in the past year and how many of them were converted to real orders within three months of placing them, reasons for non-conversion, what can I find out when there was faster conversion, etc.

This would then allow the management to find patterns and come up with ideas to increase the trial conversion rates to increase the revenue. This was a onetime activity.


The solution and the outcome

When I looked at the problem, it looked so simple. The solution I came up with was to write an SQL query to extract the data from Oracle DB and do analysis further.

Writing the SQL query was easy. You just need to identify the tables that store this information, identify the primary and foreign keys, and join them with a where clause with all the filter criteria each record needs to satisfy, optimize for excellent performance, and execute it. There you go, you get results.

I wrote the SQL query. I had written hundreds of them prior to it, so I knew the nuances involved even in simple queries, and I took care of all of that. I ensured the optimizer used the indexes for better performance, etc.

But when I executed the query in TOAD, the query didn’t result in any records. In fact, query execution didn’t complete. It took time; the performance was poor, and I just had to wait. I waited for a few mins, then a few more mins, then a few more. The result would not come in.

I lost patience after a while and canceled the query and tried tweaking a bit. I reviewed the query again to make sure everything was right, re-executed it. Still, I could not get the results.

Since I was new to the project, I didn’t know the size of the database, didn’t know much about the business scenario, how many records it had to process. That’s what happens when you work for a new client, but I needed the result in quick time. I had just reviewed it technically, and I was sure I was not missing anything. The execution plan was looking good, however, the query kept on executing and wouldn’t finish.

This was an onetime data extraction requirement, and they needed quickly and I was getting late. I tried for three-four hours and I still could not complete it. I struggled.

I reviewed the query with one of my colleagues who was working on the project for a little more time than me. He also said that the query seemed to be correct. It should have worked.

I reviewed from all angles, and it looked fine. Probably, the data it had to fetch was so much, that’s why the performance was poor. I tried rewriting the query a few times, but I still didn’t get the data till the end of the day.

#software-development #software-engineering #problem-solving #technology #data #data analysis