Search Results: AI (8691)

Ever wonder what the folks in IT are doing when you ask them to pull data for you from Dynamics GP? Did you ever wish you could do it yourself? Well join us for this fun hands-on class and soon you’ll be speaking and using SQL like a pro!

We’ll start from the very beginning and teach you the elements of a SQL query with a focus on the Dynamics GP data structure. SQL allows users to ask a question of the database, and have it answered in a very specific way. Although it may look like gibberish to you today, SQL is one of the most logical languages there is and we intend to make it easy for you to read and write it, but beyond that, SQL actually allows you to ask a series of leading questions, coupled with specific commands, grouped together to get to the answer you really want. It’s like truth serum for your data!

Through interactive lectures and hands on examples, attendees of this class will learn:

•Understand how to employ SQL to get data out of Dynamics GP
•What is SQL and how can it be used in relation to Dynamics GP
•The components of an SQL Select query
•Different ways to connect data sources (JOINS and UNIONS)
•How to find data within Dynamics GP
•SQL Functions that can make queries better
•What to do with your query after it is written
•What are UPDATE, INSERT, and DELETE commands?
•How do we build a query, stored procedure, or function? For that matter, what are queries, stored procedures, and functions?
•More SQL functions, and how they help us navigate our Dynamics GP data.
The class will start out assuming attendees know nothing about SQL or programming and will quickly progress them to a point where they can effectively ask a complex question of their Dynamics GP database, as opposed to waiting for someone else to ask it for them.

After the basics, attendees will quickly advance to a point where simple reporting, data manipulation, or support needs needn’t wait on an IT resource to be available.

Audience: Anyone who wants to understand SQL

Level: Beginner

Prerequisites: An open mind and a positive attitude.

Preparation: 

•Students should bring an internet capable Windows laptop computer to the course.
•The detailed instructions for connecting and attending the class will be sent a week prior to class. 
•There will be short installation that will need to be completed, in order for you to have access to the training environment needed for labs and exercises.
•Your instructor will use a hands-on training environment.

Should you stay on-premise or go to the cloud? This session will provide you with the knowledge necessary to make an informed decision that best fits your organization. Join a VP of finance whose company recently moved from Dynamics GP to Dynamics 365 Business Central, along with the consultant skilled in both solutions who helped them transition. We will briefly discuss the latest features of GP and reasons to stay on-premise before diving into a short demo of BC and hearing the inside story of one company that decided to go cloud and their experience during the change. 

This session will be available for CPE credits pending completion of session survey post event.

Level: Basic

How do you expand reporting when your GP SQL server is overloaded? Set up a new server…isnt that costly?  What if it was less than $100/month? Don’t we need a SQL DBA? No, with Azure Data Factory it’s easy for a business analyst with intermediate SQL skills to copy tables, transform data, and build sophisticated workflows. Power Platform offers similar capabilities, but you might need a full database where you can build views and stored procedures.

In this session, we will walk you through the process of installing a gateway and programming all the logic from the Azure portal.

This session is geared for an audience with an intermediate skill set.

This session will be available for CPE credits pending completion of session survey post event.

Want to personalize your Dynamics SL experience? Want to streamline data entry? Customization Manager allows users to modify the appearance and functionality of Dynamics SL. In this session we will demonstrate some simple but powerful customization’s that you can do tomorrow like changing font sizes and colors, moving and resizing fields, adding or removing fields, and renaming labels and columns.  This session is for users with little to no customization experience and will demonstrate mostly no code solutions, with some simple low code options.  

Learning Objective: What is customization manager, identify and choose customization levels, how to modify screens and logic using customization’s

Level: Basic

There are so many new technologies that let the outside world interact with Dynamics GP.  In this session we will explain what each of these technologies are and how they can make Dynamics GP so much more useful to your business.   We start high level and then dig deeper into examples of how companies like yours are using these technologies.  This session will help the novice to understand the technology but also have plenty of depth for those that are much more technical.

This session is geared for an audience with an intermediate skill set.

This session will be available for CPE credits pending completion of session survey post event.

Web Apps provides opportunities to remotely access Microsoft Dynamics SL.  Attend this session if you are a Dynamics SL Project user to see a live demonstration of Web Apps and how you can remotely, on any device, access Dynamics SL data and features. This session focuses on Project related features including Time, Timesheet and Expense Entry. 

Upon completion of this session, participants will be able to describe the project Web Apps features including:

Time Entry

Expense Entry

Project Maintenance

This session will be available for CPE credits pending completion of session survey post event.

Level: Basic

Want to do business via EDI, but not sure where to start? Join NAVUG member Osprey Packs for a breakdown of EDI. We’ll take a look at how Osprey uses EDI in day to day business and cover the basics of how EDI works, costs, transmission options, document types, when to integrate, and the benefits of a fully managed solution vs an in-house solution. 

This session will be available for CPE credits pending completion of session survey post event.

Level: Basic 

In this session, attendees will learn how to use Dynamics 365 CE as a tool to organize marketing campaigns and align marketing campaign ROI to sales success. Our discussion will begin with a live, “Art of the Possible” demo of a Marketing Command Center in Dynamics 365. We will then break down the demo step by step and discuss the strategy behind using Marketing Automation and an easy lead management process to make “SMarketing” magic happen between the Sales and Marketing teams.

The content of this session is geared toward an audience with intermediate-level knowledge of the subject area.

Looking for a better way to get payroll information into the hands of your employees? Wanting to do away with mailing W2’s to everyone? Maybe you need a better way for employees to update their W4 information.

In this session, attendees will learn what it takes to get employee self-service set-up and ready to use. Discussion points will include licensing requirements, software installation needed, and set-up in GP for employees.

Then attend the next session where we demonstrate how employees will use Self-Service!

This session is geared for an audience with an intermediate skill set.

This session will be available for CPE credits pending completion of session survey post event.

SmartLists, GP Reports, SSRS, Management Reporter, Excel Reports, Navigation Lists, Power BI… WOW

Feeling lost or that you’re maybe not utilizing the best reporting options in GP?

Join us as we cover…

– Pros vs cons to each reporting option

– Quick how-tos on deploying each option, accessing & making changes

– Most-used scenarios

– Best practices for staying organized & keeping your users in the right place

This session is geared for an audience with a basic skill set.

This session will be available for CPE credits pending completion of session survey post event.

Did your team move to remote work during this year’s global pandemic? Learn the best strategies for managing a fully- or partially-remote workforce without implementing a drastic Big Brother surveillance system.

Participants will learn valuable approaches for:

– Planning and predicting individual and corporate-level capacity using Microsoft technologies

– How to conduct virtual professional development and goal-setting meetings that staff actually find useful

– Effective coaching strategies that drive employees toward fulfilling and results oriented work,

– And more  

This session will be available for CPE credits pending completion of session survey post event.

Level: Basic

We all know the Data Lake and Azure Synapse is on Microsoft’s road-map for D365FO. Join Azure Synapse and Data Lake experts to learn more about this exciting technology and how it can transform you business into a data-driven organization!  Learn how the Canada Goose company is using these business intelligence tools enhance productivity in the company.

The content of this session is geared toward an audience with an intermediate-level knowledge of the subject area.

This session will be available for CPE credits pending completion of session survey post event.

Join us for this session to learn how to make your reports run efficiently and the benefits of utilizing SQL Server Reporting Services (SSRS).

This session will be available for CPE credits pending completion of session survey post event.

Level: Intermediate

Learn enough basic SQL to retrieve data from your Dynamics SL database. We will focus on the select statement and joining tables together in one query. You will learn enough to use SQL with Quick Query, Excel, and reports. SQL 101 caters to those with no (or limited) SQL experience. 

This session will be available for CPE credits pending completion of session survey post event.

Level: Basic

For GP admins, there is often a need for some basic SQL skills and knowledge. You may not have an IT background, but with some light training you can find the details on how to navigate SQL Server Management Studio and perform some valuable SQL tasks. This session with give an overview of that navigation as well as cover some of those key SQL functions including backups and maintenance as well as the table structure and the intro to report writing with views. If you are a GP admin looking for additional SQL knowledge, this session is for you.

This session is geared for an audience with a basic skill set.

This session will be available for CPE credits pending completion of session survey post event.

Build on your basic knowledge of T-SQL queries to present Dynamics SL data in a useful and readable format.  We will use T-SQL string functions, data type conversions, and the LIKE operator with SQL SELECT statements to format, join, and filter Dynamics SL data. Upon completion of this session, participants should be able to:

•     Build T-SQL queries to present Dynamics SL data in a useful and readable  format.

•     Understand and use SQL string functions and data type conversions with Dynamics SL data.

•     Understand and use the SQL LIKE operator when filtering Dynamics SL  data.        

This session will be available for CPE credits pending completion of session survey post event.

Level: Intermediate

Leverage the power of SQL Server to create queries and reports from all of the data from GP.  This session will take a tour of Management Studio and walk through the basics of writing basic SQL queries and creating Views to be used in multiple locations in GP.  Topics will include using Management Studio, basic joins and functions, creating views, and using your views in Smartlist, Smartlist Builder, SQL Reporting Services, and any other reporting tool that you might use.

This session is geared for an audience with a basic skill set.

This session will be available for CPE credits pending completion of session survey post event.

Have you ever found yourself stretched too thin? Do you simultaneously feel overworked and underutilized? Are you often busy but not productive? Do you feel like your time is constantly being hijacked by other people’s agendas? If you answered yes to any of these, Greg McKeown’s book on Essentialism may be the answer.

In this session we’ll look at the book Essentialism: The Disciplined Pursuit of Less and how you might be able to apply it to your situation. Essentialism isn’t about getting more done in less time. It’s about getting only the right things done. The idea is to  identify what is absolutely essential, then eliminate everything that is not, so we can make the highest possible contribution towards the things that really matter.

This session will be available for CPE credits pending completion of session survey post event.

Level: Basic 

We have all heard of SQL Profile, but did you know that everyone should use it? It is  very powerful tool for anyone that has access to SQL and I will show you how anyone can use it.

SQL profiler is not just for a DBA, anyone working with SQL should be using this valuable for their SQL data. You will learn what SQL profiler can do to make you everyday life easier and how to use it for your benefit as a power user.

For the GP users, we will show a few GP specific examples.

This session is geared for an audience with an intermediate skill set.

This session will be available for CPE credits pending completion of session survey post event.

Business Central Configuration Packages are a convenient, powerful tool for importing data into Business Central.  But they are more than just a data migration tool!

In this session learn how to use Configuration Packages, how to prepare data for import, and learn a few neat features, tricks, and limitations of Configuration Packages that will help you better understand and navigate Business Central data.

•What are Configuration Packages?
•How to setup a Configuration Package
•How to prepare data for import into Business Central
•Testing your Configuration Packages
•Reviewing errors, correcting errors, and applying package data
•Performance considerations  
This session will be available for CPE credits pending completion of session survey post event.

Level: Basic