Search Results: ai data (5505)

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.

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.

The cost of storage and API calls in the Common Data Service and Dynamics 365 can be a concern for many organizations. The good news is there are ways to reduce your cost for storage and for integrations by leveraging Virtual Entities. In this session we’ll take a look at building a custom data provider that connects to Azure SQL and eliminates the need to push certain kinds of data out of your Azure hosted or on-prem databases and into the potentially more costly CDS storage for your Model Driven App to consume.

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

The decision to move your mission-critical business applications to the cloud is no longer IF but WHEN. Chances are you’re already successfully running applications in the cloud today. Cloud-based payroll, HR benefits, marketing automation and email are amongst the many available solutions that companies have been managing online for years. Historically companies hesitated to move business applications like GP, SL, NAV, AX and CRM to the cloud, but to stay competitive and drive business continuity, the time to migrate is now.

Regardless of your company size or industry, recent events have shown us how important moving to the cloud is for all businesses. As companies went to being fully remote for months, some found that their on-premises solutions could not accommodate a virtual work force and caused unnecessary problems with day-to-day operations. Real-time secure access to data, regular back up provisions, remote access for all users are just some of the cloud benefits.

In this session, learn best practices on how building an effective migration strategy and plan will support a successful move to the cloud and help maximize your business application investments.

Geared to experienced Workflow builders and Power Automate novices, this will teach Dynamics 365 users how to make the jump to Power Automate. We will cover existing D365 workflow steps and how to replicate them in Power Automate, where you still want to use classic workflows over Power Automate, and of course some of the cool things you can only do in Power Automate such as querying for data other long requested features.

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

This session is ideal for accountants who are responsible for creating and generating financial reports for their organization but have little training with Management Reporter for Dynamics GP and SL.  Learn the basics of report building blocks and leave with the know-how to create four key financial statements within Manager Reporter:  Trial Balance, Income Statement, and Balance Sheet.  Discover the power and flexibility of reporting trees and get the skill you need to present useful data to your executive team. 

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

Level: Basic 

You already know that Power BI is a powerful tool for visualizing and presenting your data, but where do you begin? 

In this session,  we’ll provide you with a path for getting started and explain the differences between the desktop and service, Power Query and DAX, and different methods of sharing.  This will be a demo-rich session with our favorite tips and tricks we’ve learned over the years, as well as pitfalls to avoid.  

You will leave with everything you need to get started, including samples and resources to keep you on the path to Power BI success.

Session Level: Basic

Customer case study – learn how Caplugs, a global manufacturer of product protection, implemented Business Central SaaS in 4 different countries over 12 months.  Localizations, master data management, data migrations, 3rd party integrations, RPA, user training and lessons learned are just some of the topics that will be covered.  If you are considering launching Business Central and want a global platform offering a single pane of glass back to corporate, this is the session for you! 

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

Level: Intermediate

Is losing SQL access holding you back from moving to D365 or making support difficult? Do you need better tools when troubleshooting performance issues? Do you wonder when it’s best to use DMF or OData? Would expert advice help you when it comes to data entities? This presentation will answer those questions and deliver techniques that make your job easier. You will receive information on how the right tools help you do your job efficiently without SQL access in the Microsoft cloud.

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

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

How can you manage your paper-based AP operations with a distributed workforce? You really can’t if everyone is working from different locations. If this year has shown us one thing it’s that companies MUST take everything digital and provide access to company data from anywhere to maintain and grow their business. DocLink extends the value of your Dynamics ERP not only by allowing you to go paperless, but also automating your entire AP process from POs to payments. In this session you’ll hear from DocLink customers who have achieved success in going digital, and you’ll learn how you can:

•    Eliminate paper and manual processes

•    Capture and access documents instantaneously

•    Streamline and accelerate approvals

•    Automate 3-way matching

Join us to learn how to gain improved efficiency, visibility and control by going paperless and touchless in AP. This session is for the following products: Dynamics GP, AX, Nav, SL, D365 F&O and D365 Business.

Did you just say Power BI for GP Payroll?  Well certainly!  The Payroll table structure in Dynamics GP is unlike other modules, but that doesn’t prevent us from using Power BI to support and enhance your Payroll reporting capacity.  Perhaps you have a system that integrates employee and/or timesheet data into Dynamics GP, and you want to review for miscoding, thoroughness, and investigate or highlight any outlier situations or use cases.  Current methods of review rely on SmartLists, Edit Lists, and SSRS reports, but in this session you will learn a new, more visual way of reviewing payroll transactions in Dynamics GP with Power BI.  We will show you some of the possibilities and even show you the steps to create your own Power BI views for Dynamics GP and beyond as well as an introduction to other Power Platform tools.

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.

Excel is a product that is used by over 750 million people.  We will show you many tips, tricks, and new functions that you can use instantly.  Many of these will be items that will enhance your daily work.  The session will include introduction of Excel formulas and functions, introduce visualizations, and show how to create dashboards based off of large data sets. 

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

Level: Basic

A well thought out Power BI data model can make creating a well functioning report a breeze. Relationships form the core of any model, but what if the relationships you have won’t allow the calculations you want? Do you want dimension tables to filter each other? Should a fact table filter a dimension? By getting creative with your DAX measures, it is possible to do this and more, while still keeping the model functional. 

This session will introduce and explain several DAX functions for manipulating relationships including CROSSFILTER, USERELATIONSHIP, and TREATAS.

Session Level: Intermediate

Do you use the Inventory module in GP?  Then you should use HITB.  The HITB was designed to be your inventory subledger to the GL.  There are gaps in capturing all the data if you are currently using the Historical Stock Status report as subledger, but HITB captures it all.  The gaps will be exposed, the process defined, and you will be empowered to overcome the possible objections from the accounting team.

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.

Ever need to look in multiple places to understand a customer’s profile? Ever find that prioritizing leads and nurturing prospects are challenging? Is your customer information lacking?

Customer Insights uses AI and Machine Learning to provide a 360° customer view. With Customer Insights, Dynamics 365 delivers the ability to connect to multiple data sources, model profiles of customers, their interactions and insightful KPI’s.

In this demo heavy session, we’ll demonstrate building a customer profile and show how you can use the results for increasing sales, marketing and service effectiveness. Then display it inside of PowerApps, Mobile, and BI tools.

We’ll go over the use of PowerAutomate Flow to connect to Business Central page data through the WebService.

We will review How to:

–    Create a recurring PowerAutomate Flow;

–    Review BC page data and how we want to change it;

–    What credentials and data we need to set up the connection to BC environment;

–    Sending request to get data though the web service and parse it;

–    Analyze received data and send an email based on field values;

–    Change page data.

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

Level: Intermediate

Manage your projects using Dev Ops (formerly VSTS). DevOps gives your users, managers, SME’s, and customers the ability to collaborate based on the project plan and business processes. We will show you how DevOps is used in a project and customized to the industry by using industry specific Business Process Models and capturing all backlog items under the BPM. Defining dashboards and queries for different models such as the operating model, integration model and data model allows the team to quickly focus on the current project state and key activities.

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

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

We’ll provide a high-level overview on the main topics of C/AL to AL development. You’ll become acquainted with the technology and what’s involved, while gauging your interest and skill level for pursuing advanced classes. Learn what next questions to ask in your development journey.

This is a summarized / high-level version of the Academy class of the same name.

We’ll cover:

1)  What is allowed in Base C/AL Tables and Pages.

2)  Understanding of Events – Integration, Database Trigger, & Page Trigger.

3)  Understanding of how to Subscribe Microsoft/Add-on Events.

4)  C/AL to AL Conversion.

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

Level: Intermediate