Training

Home/Training

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. 

Register

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

Register

———————————————————————————————————————————————————————————————–

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!

Register

May 15, 11am-12pm PT                                        May 22, 11am-12pm PT 

Sales Training Part 1                                                      Sales Training Part 2
Positioning, Pricing and 5-min demo.                            Part 1 Review and 20-min demo.

Register
Register

June 19, 11am-12pm PT                                       June 26, 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

Register
Register

July 17, 11am-12pm PT                                        July 24, 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

Register

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)
Button_downloadworkbook
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 1: Caveman Brain Science

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Part 2: Color

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

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.