reports – KPI of the elearning sector for a BI tool

I am working on a BI tool, specific to the elearning sector. Currently the metrics concern Users, Courses, Enrollments and Learning. Data that is purchased from LMS platforms.

In your opinion, what can be added and / or what are the best metrics for such a tool?

Tool to analyze frequency of purchases


Does anyone know or use a tool to analyze a frequency of purchases? For example:

Case 1

‘Client A’ had bought a ‘Product B’ 1st March and it was his 1st purchase ever. Then 1st April a ‘Client A’ made another (2nd) purchase and bought a ‘Product C’.

I would like to measure/check:

  1. Period of time between 1st and 2nd purchase
  2. What is the most popular product buying as a 2nd if 1st purchase was a ‘Product B’?

Case 2

‘Client A’ bought at least 2 items during 1st purchase. A ‘Product B’ and a ‘Product C’.

I would like to measure/check:

  1. What is the most frequently buying product in pair with a ‘Product B’

Platform : PrestaShop

Thanks in advance for your responses


Google change of address tool from to .com resulted in huge derank

December 2020 I moved a site from a to a .com. No other changes, simple 301 redirect and use of the tool in google webmaster tools. The site had existed since 2006 and was the de facto site in the vertical, meaning I had plenty of P1s on google for medium tail keywords.

Now, 2.5 months later I am still hugely deranked for 10,000s of key words, and as a result I’ve dropped 40% of my traffic.

I was wondering whether anyone had any advice. Obviously this is a huge issue for me as it’s my livelihood I’ve built up over 15 years of hard work. I followed googles direction perfectly (my background is actually web dev and SEO) and it’s still deranked me.

I’m not sure the linking policy here, but the site is tyrereviews dot com, it used to be tyrereviews dot couk, and for example we used to rank 1 or 2 for the search “michelin primacy 4” in google UK however we are now page 2.

The new .com domain is targeted properly to the UK in webmaster tools too.

This is the same for many many medium tail keywords.

windows – CMD crashes without any error when running Citrix clean up tool

I have had a cmd batch file to reset my Citrix receiver:

@echo off
set /p Choice="Do you want to reset Citrix settings? (y/n)"
if (Choice==y) (goto :RESET) else (exit)

start "Citrix reset tool" /b "C:Program Files (x86)CitrixICA ClientSelfServicePluginCleanUp.exe" /silent -cleanUser
if (%errorlevel%==0) (goto :SUCCESS)  else (goto :ERROR)

echo Citrix should be rested by now. You may close this window!

echo Citrix was not successfully reset. Please contact your IT department.

It used to work just fine. But today I tried it and it crashes the terminal without any error messages. I would appreciate it if you could help me know what are the possible issues and how I can resolve them.

High SEO error Bing webmaster tool

I recently tried to index my website with Bing but I found Errors that I don't know how to resolve, the error message was :

Remove redundant <h1> tags from the page source, so that only one <h1> tag exists.
These pages have more than one <h1> tag. Multiple <h1> header tags might confuse search engine bots and website users. It is recommended to use only one <h1> tag per page.
My website is a forum, and the front page shows my forums
please help.
thanks in advance?

Unable to install an update via the softwareupdate command line tool

I am trying to install a macOS update from the command line. Let’s see what updates are available:

$/usr/sbin/softwareupdate -l
Software Update Tool

Finding available software
Software Update found the following new or updated software:
* Label: macOS Catalina 10.15.7 Update- 
    Title: macOS Catalina 10.15.7 Update, Version:  , Size: 5099042K, Recommended: YES, Action: restart, 

But what is the actual label? According to this resource it is the exact wording:

enter image description here

So the analogous value here would be macOS Catalina 10.15.7 Update- . However that does not work:

 $/usr/sbin/softwareupdate -i "macOS Catalina 10.15.7 Update-"
Software Update Tool

macOS Catalina 10.15.7 Update-: No such update
No updates are available.

I also tried some variants:

(python39) 10:25:21/~ $/usr/sbin/softwareupdate -i "macOS Catalina 10.15.7 Update"
Software Update Tool

macOS Catalina 10.15.7 Update: No such update
No updates are available.

$/usr/sbin/softwareupdate -i "macOS Catalina 10.15.7"
Software Update Tool

macOS Catalina 10.15.7: No such update
No updates are available.

So then how is the softwareupdate tool supposed to be used ?

deployment – Tool to Execute SQL Server Scripts and Automatically Recognize and Prompt for Scripting Variables

I have a folder of scripts that contain multiple objects and jobs that I roll out every time I deploy a new SQL Server Instance. The scripts utilize scripting variables, as an example, here is an abridged example of a job creation script:

DECLARE @Owner SYSNAME = (SELECT (name) FROM sys.server_principals WHERE (sid) = 0x01)

EXEC @ReturnCode =  msdb.dbo.sp_add_job @job_name=N'Myjob', 
        @category_name=N'Database Maintenance', 
        @notify_email_operator_name=N'$(AlertOperator)', @job_id = @jobId OUTPUT

Note that @notify_email_operator_name will be set to whatever value is passed to $(AlertOperator)

These scripts are usually run through a Powershell script which loops through the folder and passes values to the $(AlertOperator) variable.

This approach allows a suite of scripts to be kept which can be rolled out to a new server easily.

I was wondering if there was a GUI tool where I can open one or more .sql files and it would automatically recognize the scripting variables in those files and prompt for their values before running the files against one or more defined servers?

How Do You Use Social Media As A Tool For Customer Service?

How do you use social media as a tool for customer service?

automation – Manually add dimensions (for select tool) in a photoshop script

I have a question, can you manually add the dimensions you want to perform an action on in a script?
So of course to work on all 4 edges I can choose 4 different selects, but what I want to do is just enter the data (similar to what you would do with (for example) image size.

To the following

Set Selection

To: rectangle
Top: 11 pixels
Left 5 pixels
Bottom 679 pixels
Right 499 pixels

Then select the inverse (I have a 510 x 690 image, perhaps there is a way to do an offset with the inverse even, I don’t know)

If it was just once I had to do this, it is no problems I would then just select those pixels manually when I was recording and live with it, but I am more interested for my own education where this is possible or you need to drag the select tool, because with an image my size it is not such an issue, but with an image of say 5000 x 6000 it is just a little frustrating

Any help is much appreciated..

Also one other thing, in a script can I chose to ‘brush’ certain pixels by their address?
When I do the “record” tool, it just records as I press, but I am looking to manually add these also, but again it is just for my own education I would like to know this

Thanks very much in advance

seo – Google webmaster tool excludes all urls of site

I have generated a sitemap.xml file for my new website.
It has one root url and 9 products url.

I have added robots.txt file with the following content (changed actual url of sitemap):

User-agent: *
Allow: /


I submitted sitemap.xml file to webmaster tool on 15th of February.
After three days, I can see all 10 urls are marked excluded in coverage:
enter image description here

My site is still not appearing on google what can be the reason of it?