DataZen Syllabus

INTRODUCTION TO DATAZEN
  1. PRODUCT ELEMENTS
  2. ARCHITECTURE
DATAZEN ENTERPRISE SERVER
  1. INTRODUCTION
  2. SERVER ARCHITECTURE
  3. INSTALLATION
  4. SECURITY
  5. CONTROL PANEL
  6. WEB VIEWER
  7. SERVER ADMINISTRATION
CREATING AND PUBLISHING DASHBOARDS
  1. CONNECTING TO DATASOURCES
  2. DESIGNER
  3. CONFIGURING NAVIGATOR
  4. CONFIGURING VISUALIZATION
  5.  PUBLISHING DASHBOARD
  6. WORKING WITH MAP 
  7. WORKING WITH DRILL THROUGH DASHBOARDS

T-SQL LEAD LAG and SUM function based query

  Query on T-SQL window clause Below is the sales table Order_Date Name Product SubCategory ...