Improving Construction of Statistical Process Control Charts
(Page 1 of 4 )
In the first article, you learned how to manually construct statistical control charts to monitor and detect problems pertaining to website traffic. This procedure has certain disadvantages. In this article, we'll tackle those problems by using macros.
The manual procedure has three major disadvantages.
First, it cannot be updated in real time. Therefore, to update the data, any webmaster or analyst needs to log in to Google Analytics first in order to fetch results.
Second, there is a higher chance of computational error since it is done manually. Computational errors are both risky and costly to any process.
Third, it takes a lot of time to construct control charts. This is because of the lengthy processes involved that require exporting of data from Google Analytics to Excel/CSV format, as well as the time-consuming computations that must be performed.
However, the main advantage is security. The shortcut method involves running macros on your MS Excel. There are some companies which do not allow macros to be run on their Windows-based machines. Since you are using the manual method, you can be sure that there are no macros executed which have been created by other parties.
Disclaimer: the macro developed to shorten the process of statistical process control chart creation has been thoroughly checked by us to be virus-free. Even so, it is your responsibility to double check the scripts and ensure that the file has been scanned before running macros. We are not liable for any negative consequences that may result from running macros.
Next: Using VBA Macros to communicate with Google Analytics >>
More Microsoft Access Articles
More By Codex-M
