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":


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


SAP Analytics Cloud automatically built this story


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.



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



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


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


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


Above shows the online registration histogram showing contribution by SIG



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.



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?


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


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


More attend online when the webcast is held on a Tuesday


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



Reg #Online #Attendance RatioRegistration Conv Rate
Standard Error11.2447Standard Error6.86701Standard Error0.012020236Standard Error0.025869585
Standard Deviation94.07994Standard Deviation57.45353Standard Deviation0.100568512Standard Deviation0.216440478
Sample Variance8851.035Sample Variance3300.908Sample Variance0.010114026Sample Variance0.04684648



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?



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


Mobility SAP Analytics Cloud


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.


iPhone resolution is very good


Smart Discovery


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


Word Clouds


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



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


More upcoming webcasts

Upcoming ASUG Business Intelligence Community Webcasts