Tuesday, May 14 - Thursday, May 16, 2024
Times vary daily
Online
Special Guest
Rusty Pelt
Senior Consultant
Rusty Pelt has worked in the construction industry building homes in several states for over 20 years. He has held positions in purchasing, estimating, operations management, and business owner. Rusty has extensive experience setting up databases for homebuilding companies and writing custom reports with Crystal Reports, MySQL, etc. In his role as Senior Consultant for MarkSystems, Rusty provides consulting services, teaches best practices, and helps drive the adoption of MarkSystems to ensure customers get the most value from their software.
Rusty Pelt has worked in the construction industry building homes in several states for over 20 years. He has held positions in purchasing, estimating, operations management, and business owner. Rusty has extensive experience setting up databases for homebuilding companies and writing custom reports with Crystal Reports, MySQL, etc. In his role as Senior Consultant for MarkSystems, Rusty provides consulting services, teaches best practices, and helps drive the adoption of MarkSystems to ensure customers get the most value from their software.
*Register early to get the 10% Early Bird Discount
(Expires 14 days before the course start date)
PREREQUISITES: Advanced experience with Excel formulas. MYSQL Report Database Installed for your company. ODBC driver installed and configured on local system. Connection verified by MarkSystems Support Team. Details will be provided upon registration.
In this MSU Offering, the Instructor will show you how to Build Data Analytics and Dynamic Reports. They will take you through the MarkSystems database structure, showing you how to build data tables and build datasets, and how they relate to MarkSystems. You will then use those datasets to write relevant dynamic reports. You will also learn how to take copies of existing excel reports and reverse engineer them to MarkSystems. At the end of the course you will be eagerly writing your own!
There will be instructor-led conversations and interactive demonstrations on:
This is all done in Microsoft Excel, the most common spread sheet application in our industry. Other report writing tools illustrated will be Google Data Studio and Power Bi. These concepts and techniques are transferable to other report writing tools.
By the end of this MSU Event, you will understand what tables and fields are available, how they work and communicate with each other – and - be able to connect to your database and select multiple tables.
Course Schedule
Day One - Tuesday Morning - Live Session at 9:30 AM-12:00 PM ET
LIVE SESSION: Class Welcome
Day One - Tuesday Afternoon - Live Session at 1:30-4:00 PM ET
LIVE SESSION: Table Talk
Day Two - Wednesday Morning - Live Session at 9:30 AM-12:00 PM ET
LIVE SESSION: Building Data Sets
Day Two - Wednesday Afternoon - Live Session at 1:30-4:00 PM ET
LIVE SESSION: Report Formatting for Presentation
Day Three - Thursday Morning - Live Session at 9:30 AM-12:00 PM ET
LIVE SESSION: Building Reports by Module
Day Three - Thursday Afternoon - Live Session at 1:30-4:00 PM ET
LIVE SESSION: Building Reports by Module Continued & More
MSU Report Writing 202 Sneak Peak
Course Agenda
Click here to view the Detailed Course Agenda, including session times.
Contact us at msu_info@ecisolutions.com