Part of the education that ASUG offers is webcasts, as part of the "YRC" (year-round community) offerings.  Not everyone has a budget to attend face-to-face events and it is easy to attend a webcast from the comfort of your office.

 

Part of "YRC" is measuring how we are doing.  While this review is late, I did want to share some results.

 

First, using SAP Analytics Cloud "build my story":

overviewreg.jpg

So over 12K registered for our webcasts, with the highest webcast registration at 457, lowest at 36.

2bysig.jpg

SAP Analytics Cloud automatically built this story

hover.jpg

If you hover over the outlier, you can see which webcast was the outlier, which was Overview of Lumira 2.x Roadmap which had 457 register, 319 watch online.

 

buildmystoryonlinereg.jpg

You can see over 6K actually watched the ASUG BI webcasts in 2017.

 

2bysig.jpg

Again, this is a build my story automatically shows registration by SIG.

histogramreg.jpg

This is an attempt at a histogram for registration, using Lumira.  This is showing distributions of webcast registrations.

histogramstackedreg.jpg

This is a stacked "histogram" to show contribution of registration by SIG, using Lumira.

histogramonline.jpg

Above shows the online registration histogram showing contribution by SIG

registrationonlinebymonth.jpg

 

Registration is shown by month; note that there are ASUG blackout periods in January and December, thus resulting in lower registration.  Additionally, last year, the BI+Analytics Conference was held in August; we try to not to schedule webcasts during that time frame.   September was a little lower too as that was during SAP TechEd Las Vegas.

 

registrbyqtr.jpg

Q2 was the highest month for registration and online, Q1/Q4 contain ASUG HQ blackout dates, and Q3 was when we held our face-to-face events (BI+Analytics and SAP TechEd Las Vegas)

 

Does Day of Week impact Webcast Registration?

dayofweek.jpg

Above is the automatic distribution that SAP Analytics Cloud provides - counts of webcasts by weekday

dayofweek2.jpg

Tuesday is the magic day; ASUG prefers not holding webcasts on Mondays or Fridays but sometimes that cannot be avoided.

weekdayonline.jpg

More attend online when the webcast is held on a Tuesday

impactdayofweeksigreg.jpg

This was automatically built by SAP Analytics Cloud and I find it interesting

 

      

Reg #Online #Attendance RatioRegistration Conv Rate
Mean171.5286Mean88.92857Mean0.508330846Mean0.653571429
Standard Error11.2447Standard Error6.86701Standard Error0.012020236Standard Error0.025869585
Median151.5Median74.5Median0.51329099Median0.6
Mode140Mode55Mode#N/AMode1
Standard Deviation94.07994Standard Deviation57.45353Standard Deviation0.100568512Standard Deviation0.216440478
Sample Variance8851.035Sample Variance3300.908Sample Variance0.010114026Sample Variance0.04684648
Kurtosis-0.2443Kurtosis2.243971Kurtosis-0.177564305Kurtosis-0.373494926
Skewness0.567586Skewness1.213323Skewness-0.438287917Skewness0.208104324
Range421Range299Range0.438771375Range0.87
Minimum36Minimum20Minimum0.259259259Minimum0.13
Maximum457Maximum319Maximum0.698030635Maximum1
Sum12007Sum6225Sum35.58315923Sum45.75
Count70Count70Count70Count70

 

 

Above is automatically provided from the Excel Analysis Pak, Descriptive Statistics

Mean registration webcast is 171.5

Mean online webcast is 88.9

The attendance ratio is online / registered - and mean is 50.8%

 

The "descriptive statistics" show the "central tendency" - mean, median and mode

 

Median is the middlemost value; the formula is total number of observations + 1 / 2  and the data has to be ordered

 

Mode -is most frequent value in dataset, usually seen via a histogram, and you can see how far off data is from normal

 

If mode and median are less than mean, this indicates a right skewed distribution

 

This covers how the data is shaped

_________________

 

 

Variability covers how spread apart data values

 

The range is max minus min and tells story of how disperse data is

 

Variance indicates how variable is data; can be unwieldy

 

 

Standard deviation (square root of variance) - understand how data distributed around mean

 

 

Standard error is variance around true mean; at shows how close to mean

 

N/A - in mode - no single value that is more common than anything else (see Attendance ratio above)

 

Shape of distribution - Kurtosis is an estimate of normality of data (Microsoft) -  closer to 0, more likely the data is normally distributed

 

Skewness - tails; positive number means it is right skewed, negative means it is left-skewed - +2 / -2 are good for statistical analysis

 

Webinar Pipeline

If I were a marketing/saleperson, I would like at how to turn the registration clicks into registered, and registered into online.

 

Of those who clicked the webcast page, what is the percentage registered?

2017webinarfunnel.jpg

 

So over 21K were aware of the webcast, over 12K were interested (registered), and over 6K actually attended.

 

Mobility SAP Analytics Cloud

onlinevsregistered.PNG

Above shows how it looks on my iPhone with SAP Analytics Cloud; the resolution was crisp.  I copied some of the stories to the "responsive" lanes.

mobilesac.PNG

iPhone resolution is very good

 

Smart Discovery

1smartdiscovery.jpg

Not sure this can be seen, but it shows 44% of the webcasts have above average registration

 

Word Clouds

webcast1wordcloud.jpg

This is text analysis on single words from webcast titles; with SAP and BusinessObjects leading the way

2wordwebcasttitles.jpg

 

Two word text analysis, with SAP BusinessObjects and Web Intelligence leading the way

 

More upcoming webcasts

Upcoming ASUG Business Intelligence Community Webcasts