Search Results: data (5296)

Get ready to explore the Dynamics GP Manufacturing modules! 

This targeted hands-on training course provides an overview of the Dynamics GP Manufacturing Series followed by detailed instruction on the primary master data and transactions offered for manufacturing. 

Instructor Sunny Mattoon will guide you through entering and maintaining Bills of Materials, tracking non-material cost by work center with Routings and best practices for the FIFO Periodic method (standard costing). You will learn how to process a Manufacturing Order from beginning to end – including component issue transactions, finished good receipts, how to work with lot/serialized items and how each transaction impacts the general ledger and inventory.

This class is essential for anyone who needs to utilize the essentials of GP Manufacturing.

Learning Objectives

Following completion of the course you will be able to:

•Describe how manufacturing integrates within GP
•Create and maintain Bills of Materials
•Create and maintain Routings
•Process Manufacturing Orders for in-house production
•Maintain FIFO Periodic (standard cost) items
Instructor: Sunny Mattoon, CPIM

Audience: Dynamics GP user, support or implementers

Level: Beginner to Intermediate

Prerequisites: Students should have a strong working knowledge of Microsoft Dynamics GP – Inventory

Preparation: Please bring an internet capable Windows PC to class for the Academy hands-on training environment.

Delivery Method: Group Live

This session is suitable for an existing Microsoft Dynamics Field Service customer or for person looking at adopting mobile technology to reinvent their field processes. We will discuss and demo the concept of multi-experience apps, continuous experience, optimizing the travel, or efficient data collection. You will leave this session with real-life examples and improvements.

Don’t be afraid of your accounting software! Be honest. Managing your accounting software can be daunting and many IT departments take a “hands off” policy, but it doesn’t have to be that way. 

This technical hands-on course will teach you what makes GP tick, from “Why it’s done that way” in client installation, to GP table structure, managing Security, SQL backup strategy and connecting GP using web services and other tools.

We will navigate the ins and outs of the client installation, explore the depths of security, not only for GP, but for SSRS and Excel Reports, and dive into the GP tables to understand how they interrelate and how to setup SQL maintenance for peak efficiency. 

We will review the importance of SQL backups, selecting a strategy that best fits your requirements, and discuss disaster recovery options.

We will review the GP web client install process and common mistakes that administrators make that require you to reinstall every year if not done properly.  You will understand why in today’s environment you can NOT afford to deploy the web client.

You will also come away with a better understanding of how you can integrate with GP using web services, econnect and OData.  We will review the major options for integration and, time permitting, may dive into a few of the tools towards the end of the course.  

Audience: Dynamics GP Power-Users, IT Professionals, and Dynamics GP Support Professionals

Level: Beginner to Intermediate

Prerequisites: Functional knowledge of Microsoft Dynamics GP

Preparation: Please bring an internet capable Windows PC to class for the Academy’s hands-on training environment.

Training Materials: Will be supplied by the instructor as appropriate.

e.

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.

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

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

Are you ready to think like DAX?

DAX is both a programming and query language that gives you the ability to extend what is possible in either your Power BI or Tabular data models. This hands-on DAX Bootcamp is designed to teach the fundamentals of DAX, while emphasizing the basic building blocks required to author more complex DAX calculations. 

The goal of this course is to give students the tools necessary to think like DAX and understand the ‘why’ behind how calculations work.

•Module 01 – Understanding and Defining Relationships
•Module 02 – DAX Fundamentals
•Module 03 – Creating Calculated Columns
•Module 04 – Navigation Functions
•Module 05 – Conditional and Logical Functions
•Module 06 – Creating Calculated Measures
•Module 07 – Understanding the Calculate Function
•Module 08 – Built-in Time Intelligence
•Module 09 – Interactive Functions
•Module 10 – Table Functions
•Module 11 – Working with Variables
•Module 12 – Understanding Evaluation Context (Filter and Row Context)
•Module 13 – Nested Row Context
•Module 14 – Advanced Time Intelligence and Custom Calendars
•Module 15 – Semi-Additive Measures
•Module 16 – Error handling
•Module 17 – Managing Dynamic Security with DAX
•Module 18 – Dealing with Multiple Relationships Between Tables
•Module 19 – Advanced Design Patterns with DAX
•Module 20 – Performance Tuning
•Module 21 – DAX as a Query Language
Target Audience: Business Analysts & Citizen Developers

Level: Intermediate/Advanced

Computer Requirements: Please bring an internet capable Windows laptop with the latest version of the Power BI Desktop Installed.

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

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.

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 

SQL Reporting Services is Microsoft’s powerful reporting engine that can allow you to deploy reports to your entire organization.  With the integration of Power BI visuals, SSRS can be the one-stop shop for all of your reporting needs.  This session will look at the setup and deployment of SSRS in your organization and some report designing tips and tricks to take your reports beyond simple tables of data!

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.

We are all familiar with two types of apps within the Power Platform – canvas apps and model-driven apps. Canvas apps provide complete control over user experience whereas model-driven apps are more data-driven with comparatively lesser user experience flexibility. Now how about having the best of both worlds? That’s where embedded canvas apps come into play. Simply put, they are canvas apps within a model-driven form. This session takes you through the experience of creating and embedding a canvas app into a model-driven form and overcoming challenges with embedded canvas apps.

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

It may be time to up your Power game with some new belts!

Getting Started with Power BI ~ PowerBIUG is excited to offer both the Power BI Blue Belt & Purple Belt training courses at Summit 2020! 

These are the first two belts in a four-part series and will provide you with a great foundation on which to build your knowledge and expertise. For more information on the full Black Belt Series visit: www.dynamiccommunities/training. 

These first two belts will be covered in this live, hands-on training. Registrants will also have access to the Blue Belt and Purple Belt training materials online to support continued learning, and receive a 50% off coupon toward the remaining Brown and Black Belt courses available on demand online from Dynamic Communities Academy. 

By attending this Full Day training class, you will complete the Blue Belt and Purple Belt courses and be well on your way to achieving your Power BI Black Belt Certification! 

In this live full day course, you will learn:

Blue Belt Training

An Introduction to Microsoft Power BI – Blue Belt

•Get Data
•Creating Visuals
•Publishing Reports & Templates
•Using Power BI Service
•Using Power BI Mobile Apps
Purple Belt Training

Data Modeling & DAX – Purple Belt

•Introduction to Data Modeling
•Advanced Visuals
•Introduction to DAX
Audience: Anybody looking to expand their foundational knowledge of Microsoft Power BI; from business leader to front-line worker or business analyst to developer. Anybody looking to model, explore, analyze, and present data in a user-friendly environment. 

For more information on the full Black Belt Series or to register for the remaining Brown and Black Belts visit: www.dynamiccommunities/training. 

Preparation: Please bring your own internet capable Windows PC to class for the hands on lab portion/class exercises.

In this session, we will design 4 reports using different methods to retrieve and display data in Excel Refreshable reports. We will cover setting up the data sources and why to utilize the reports. Tools included in this presentation are SQL Views, custom Excel Data Connections, VBA code and Excel Query functionality. This session will be an intermediate to advanced session where knowledge of using SQL Server Management Studio, TSQL, VBA and Excel Data Connections is recommended.

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.

It’s a Classical problem, lots of time spent on lists of data in Excel – adding formulas, formats, filters, totals.  Then, after you add a New Wave of data everything has to be updated again?  Jazz things up with an Alternative method.  Use Excels Tables and eliminate your Blues.  Swing into this session and find out about Slicers, Timelines, Filters and other .  Don’t be a Punk and miss out.

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.

Do your salespeople need data from multiple systems to do their jobs? Do they ask you to gather reports so they can print them and take them to a customer meeting? Is your data siloed in disparate systems? In this session we will discuss how to give your CRM users a self-service reporting experience.

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

We get it, you love SmartList and well you should.  But too many of you are running SmartLists just to export them to Excel!  There are so many other ways, both easier and quicker, to get your data into Excel if you need to.  In some cases, you can even have the Go To’s you’ve come to love.  In this session we will go over the methods available to you – the non-developer – to get your data into Excel where you want it.

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.

With Dynamics 365 for Finance and Operations, Microsoft has introduced new integration technology options that expand real-time integration to and from external applications in a secure and more flexible manner than in Dynamics AX. These options include OData Web Service and the Data Management Framework (DMF). This session will explore the benefits and challenges of the different integration options and the factors that can help you determine which technology is best suited for the task. The presentation will be technical in nature and include how to create and modify entities with sample integrations via the OData Entity Framework and will explain how to maximize throughput using web service integration to Dynamics 365.