Hi
This can be easily achieved by using many JQuery plugins available.
JQuery Plugins for guide tours :- http://ninodezign.com/25-free-jquery-plugins-for-doing-guided-tours-through-a-website/
Demo :- http://introjs.com/ Click to Demo
Demo 2:- http://blog.tommoor.com/crumble/
How these works:-
1. introJs(".introduction-farm").start();
Just add the Class or Id and get it working.
The basic concept is very simple. This is as simple as creating a custom component for the page using third party JavaScript or Jquery plugins.
How to do it in AEM:
Link:- https://helpx.adobe.com/experience-manager/using/integrating-custom-carousel-component-cq.html
// Creating a component using third party JS.
Link:-https://helpx.adobe.com/experience-manager/using/integrating-custom-cq-widgets-third-party.html
// Integrating custom Adobe Experience Manager Component with third-party libraries
I hope this will help you.
~kautuk