To pass the certification process, please complete the following steps.
Deploy DataSelf Analytics connected to a live or demo ERP database.
To select your source system and execute the deployment and testing: click here.
Deploy ETL+. The trial license is free.
Execute Level 1 Testing.
Email certified_training @dataself.com screenshots of your Level 1 Testing results.
Connect to the Tableau Embedded web portal at https://dataselfbi.com. You should receive your credentials during step 1 above.
Create and save the following new Sales Invoice reports. You can use a single Tableau workbook with a new tab for each new report.
A grid report showing Sales by Customer in the past two years. Show filter.
A grid report showing Sales by Salesperson and Item by quarter in the past two years. Show filter.
A chart report showing Gross Profit by Customer State (or ShipTo State) in the past year. Show filter.
A chart report showing Qty Sold by Item sorted in descending order by Qty Sold (top items at the top). No filter.
Create a calculated field with “Avg Sales Amount” (sales/qty sold) and add it to the b) report.
Create calculated fields for FY2023 Sales, FY2022 Sales, and Sales Pct Variance between 2023 and 2022. Then create a report showing these measures by Customer.
Take report a), convert the Sales measure to a Quick Table Calculation showing the Percentage Difference, and then add Sales to the reports. It should show both measures.
Create a Hierarchy with Salesperson and Customer. On report a), replace Customer with Salesperson from the Hierarchy and test the expand/collapse (drill down) on the report.
Create a dashboard with reports from a), c), d), and f).
Clean up the filters.
Make each report have a short descriptive title.
Make the d) report work as a dashboard filter.
Make a Year filter to apply to all sections of the dashboard.
Save the workbook.
Leave the report edit mode and subscribe to this dashboard:
Add yourself and Clark Walliser as the recipients (Subscribe Users).
Receive it as a PDF.
Set the schedule to Daily 8am EST.
Email certified_training @dataself.com with the link to the Tableau workbook created above.
Feel free to reach out for support as needed.