DataSelf Analytics Certification
Green-Belt: Tech
Description: The DataSelf Analytics Certification grants trainees a free Advanced Analytics by DataSelf NFR Site for one year. The NFR Site can load client data for demo and proof-of-concept purposes. Web-based, instructor-led. Parts 1 to 4 apply to Acumatica, Sage 100, Sage 300 and Sage X3.
Target audience: VAR consultants & sales engineers.
Seats are limited. Sign up now by clicking the Register button below!
May Classes: 12, 14, 19, and 21, from 12:00pm to 2:30pm PT
June Classes: 16, 18, 23, and 25, from 12:00pm to 2:30pm PT
July Classes: 14, 16, 21, and 23, from 12:00pm to 2:30pm PT
August Classes: 11, 13, 20, and 22, from 12:00pm to 2:30pm PT
September Classes: 15, 17, 22, and 24, from 12:00pm to 2:30pm PT
October Classes: 13, 15, 20, and 22, from 12:00pm to 2:30pm PT
November Classes: 10, 12, 17, and 19, from 12:00pm to 2:30pm PT
December Classes: 8, 10, 15, and 17, from 12:00pm to 2:30pm PT
*Each class is 2.5 hours long. The first two hours are training while the additional half hour is designed for questions and comments.
Session 1: Acumatica
Intro & Overview / Deployment / Adding Fields / Embedding
Session 2: Acumatica, Sage 100, Sage 300, Sage X3
Report Design Part 1 / User Security Overview
Session 3: Acumatica, Sage 100, Sage 300, Sage X3
Natural Language Query / Report Design Part 2
Session 4: Acumatica, Sage 100, Sage 300, Sage X3
Report Design Part 3 / User Onboarding / Sales Process Support / Certification Overview
———————————————————————————————————————————————————————————————–
Sales Training for VARs
Green-Belt: Sales
Target audience: Acumatica, Sage 100, Sage 300 and Sage X3 VAR sales team & sales engineers.
Seats are limited. Sign up now!
Aug 14, 11am-12pm PT Aug 21, 11am-12pm PT
Sales Training Part 1 Reviewing topics covered in Part 1
Positioning, Pricing and 5-min demo. Learning how to do a 20 min AAbD demo
Sept 18, 11am-12pm PT Sept 25, 11am-12pm PT
Sales Training Part 1 Reviewing topics covered in Part 1
Positioning, Pricing and 5-min demo. Learning how to do a 20 min AAbD demo
Oct 16, 11am-12pm PT Oct 23, 11am-12pm PT
Sales Training Part 1 Reviewing topics covered in Part 1
Positioning, Pricing and 5-min demo. Learning how to do a 20 min AAbD demo
Nov 13, 11am-12pm PT Nov 20, 11am-12pm PT
Sales Training Part 1 Reviewing topics covered in Part 1
Positioning, Pricing and 5-min demo. Learning how to do a 20 min AAbD demo
Dec 11, 11am-12pm PT Dec 18, 11am-12pm PT
Sales Training Part 1 Reviewing topics covered in Part 1
Positioning, Pricing and 5-min demo. Learning how to do a 20 min AAbD demo
———————————————————————————————————————————————————————————————–
ONLINE CLASSES
1. DataSelf and Tableau Training: Power Users
Audience: Desktop and Web Power users.
Agenda: Basic query techniques. (14 short videos for a total of 58 minutes).
Click here to download the training workbook (v10.3 or newer) so you can replicate the exercises.
2. DataSelf and Tableau Training: Desktop Users
Connecting to your data for the first time. A good entry level introduction to DSA. (22 minutes)
3. DataSelf and Tableau Desktop: Copy and Export Data
DataSelf Analytics, Tableau Desktop, copy data, export data into other applications such as MS Excel, PowerPoint and Email. (6 minutes)
TIPS
DataSelf Analytics: Rapid-Fire Analytics Demo
(15 mins)
Fasten your data-hungry seatbelts!
Charts and Dashboards with DataSelf Analytics (Tableau)
Part I (30 mins)
DataSelf Analytics v9.1 packaged workbook used in this training session:
Basics about charts and dashboards with DataSelf Analytics Desktop – Tableau Desktop:
CHARTS: Show Me panel; Time analysis and comparisons; Lines and colors; Mapping
DASHBOARDS: Drag and drop; Layout changes; Filtering
Filtering with DataSelf Analytics (Tableau)
Part I – The Basics (30 mins)
Basics about filtering with DataSelf Analytics Desktop
Tableau Desktop:
Absolute buckets, ex.: by year;
Relative buckets, ex.: this year
Compound filters, ex.: this quarter prior years
To-date buckets, ex.: last year to date
Wildcards, ex: product names that contain “apple”
Conditions, ex: sales larger than 100,000
Top/Bottom, ex: top customers by the gross profit
Learn more about context filters.
Calculated Measures with DataSelf Analytics (Tableau)
Part I – The Basics (30mins)
Basics about calculated measures with DataSelf Analytics Desktop – Tableau Desktop:
Aggregations
Calculated Measures:
– Simple operations (+**/)
– Groupings
– Slices of data
Table Calculations:
– YTD and YTD Growth
– Growth from other periods
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Analyzing
Different ways DSA makes analyzing your data quick and simple. Sorting, drill-downs, graphing and other powerful functions. (11 minutes)
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Formatting
How to format numbers and text, add shading and more. Customize the look and feel of your visualizations. (17 minutes)
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Sharing
How to share DSA views with others. Views can be shared with a small group of individuals or with an entire enterprise. (3 minutes)
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Dashboards Development
How to create interactive dashboards that empowers others to conduct their own analysis. (13 minutes)
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Miscellaneous tips and tricks (54mins)
Join three of these Zens – as they share the Zens list of “a-ha” moments.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
CALCULATIONS
Introduction to Calculations
How to make various types of calculations in DSA. Some important differences between Row-Level and Aggregate calculations are also covered. (13 minutes)
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Fundamentals about Quick Table Calculations
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
YoY and YTD with Quick Table Calculations
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Data Visualization Techniques
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Part 3: Chart Types and Formatting, Oh My!
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Part 4: Mad Scientist Experiments for Better Dashboards
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
TIPS & TRICKS
Tip#1: Sales pipeline analysis for account managers – Learn to use this DataSelf dashboard starter (Tableau-embedded) to quickly analyze and understand your pipeline.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Tip#2: Report Distribution Options – Learn the options to access and distribute reports on DataSelf Analytics.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Tip #3 – Totals and Subtotals (Tableau) – How to create totals and subtotals in DataSelf Analytics (Tableau).
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Tip #4 – Building a new report (Part I)
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Tip #5 – Building a new report (Part II)
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
20 Quick Design Tips for Tableau Dashboards
From Tableau Coach
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
For further training resources, please visit: Tableau Training Page.
IMPORTANT: DataSelf Analytics incorporates software under an OEM agreement with Tableau Software. Some Tableau instructional videos were selected for their relevance to DSA users. Please assume that Tableau and DataSelf Analytics (DSA) are the same product when watching the videos. Some of Tableau’s data source features are not available or required in DSA.