DataSelf Analytics Certification
Green-Belt
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. Part 1 of the training is for Acumatica only. Parts 2 to 4 apply to Acumatica, Sage 100, Sage 300 and Sage X3. Part 1 for Sage is still under construction.
Target audience: VAR consultants & sales engineers.
Seats are limited. Sign up now by clicking the Register button below!
Mar Classes: SALE CLOSED.
Apr Classes: 14, 16, 21, and 23, from 12:00pm to 2:30pm PT
May Classes: 12, 14, 19, and 21, from 11:30am to 2:00pm PT
Jun Classes: 16, 18, 23, and 25, from 11:30am to 2:00pm PT
Jul Classes: 14, 16, 21, and 23, from 11:30am to 2:00pm PT
Aug Classes: 11, 13, 20, and 22, from 11:30am to 2:00pm PT
Sep Classes: 15, 17, 22, and 24, from 11:30am to 2:00pm PT
Oct Classes: 13, 15, 20, and 22, from 11:30am to 2:00pm PT
Nov Classes: 10, 12, 17, and 19, from 11:30am to 2:00pm PT
Dec Classes: 8, 10, 15, and 17, from 11:30am to 2:00pm 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 | Session 2: Acumatica, Sage 100, Sage 300, Sage X3 | Session 3: Acumatica, Sage 100, Sage 300, Sage X3 | Session 4: Acumatica, Sage 100, Sage 300, Sage X3 |
|---|---|---|---|
| Intro & Overview Deployment Adding Fields Embedding | Report Design Part 1 User Security Overview | Natural Language Query Report Design Part 2 | Report Design Part 3 User Onboarding Sales Process Support Certification Overview |
———————————————————————————————————————————————————————————————–
Sales Training for Acumatica VARs
You must register separately for each part of the web-based, instructor-led training for Advanced Analytics by DataSelf.
Target audience: Acumatica VAR sales team & sales engineers.
Seats are limited. Sign up now!
| Sales Training Part 1 April 17, 11am-noon PT | Sales Training Part 2 April 24, 11am-noon PT | Sales Training Part 1 May 15, 11am-noon PT | Sales Training Part 2 May 22, 11am-noon PT |
|---|---|---|---|
| Positioning, Pricing 5-min demo Regiter now! | Part 1 Review 20-min demo Register now! | Positioning, Pricing 5-min demo Register now! | Part 1 Review 20-min demo Register now! |
| Sales Training Part 1 June 19, 11am-noon PT | Sales Training Part 2 June 26, 11am-noon PT | Sales Training Part 1 July 17, 11am-noon PT | Sales Training Part 2 July 24, 11am-noon PT |
|---|---|---|---|
| Positioning, Pricing 5-min demo Regiter now! | Part 1 Review 20-min demo Register now! | Positioning, Pricing 5-min demo Register now! | Part 1 Review 20-min demo Register now! |
| Sales Training Part 1 Aug 14, 11am-noon PT | Sales Training Part 2 Aug 21, 11am-noon PT | Sales Training Part 1 Sept 18, 11am-noon PT | Sales Training Part 2 Sept 25, 11am-noon PT |
|---|---|---|---|
| Positioning, Pricing 5-min demo Regiter now! | Part 1 Review 20-min demo Register now! | Positioning, Pricing 5-min demo Register now! | Part 1 Review 20-min demo Register now! |
| Sales Training Part 1 Oct 16, 11am-noon PT | Sales Training Part 2 Oct 23, 11am-noon PT | Sales Training Part 1 Nov 13, 11am-noon PT | Sales Training Part 2 Nov 20, 11am-noon PT |
|---|---|---|---|
| Positioning, Pricing 5-min demo Regiter now! | Part 1 Review 20-min demo Register now! | Positioning, Pricing 5-min demo Register now! | Part 1 Review 20-min demo Register now! |
ONLINE CLASSES – GETTING STARTED
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 rapid Fire Tips & Tricks – Video Conference
(30 mins)
40 tips and tricks in 20 minutes! 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)
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
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.