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

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

An engaged leader is effective support for your initiatives in your organization.  This presentation will focus on how to engage your leadership, to support the technology.  I will be speaking about the success I have had in my organization as well as many additional encounters with other organizations where the support was not shown, and what has been done to change the thought process of the leadership to understand why their support is so very important to the ultimate success of the organization.

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

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.

While you know you need the tool, the headaches and politics you have to maneuver through just to get a solution can be daunting. The last thing you want is for the onboarding to drag on and suck more time from your team, ultimately decreasing morale.

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

Flip your organization upside-down and see what comes out!

In this session, you will learn a simple technique for changing the culture inside your organization, which can result in increased process efficiency and reduced costs.

This approach is not just for manufacturing! A continuous process improvement culture can be effective for all functional areas (finance, IT, warehouse, sales, etc.) and all types of businesses (grocery stores, law firms, hospitals, distribution centers, and much more). If you have any process at all, this method can help you!

Join us and see how continuous process improvement works and how you can start implementing it in your organization today.

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 

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.

Have you ever wanted to be up on the Opry stage? Maybe the Opryland Conference Center? Now is your chance to learn what it means to be a speaker at User Group Summit! Practice your banjo, shine your belt buckles and get ready to join the lineup next year.

We will share with you the process of session submission, selection and presentation prep so you are ready for wherever 2021 will take us!

The User Speaker Cultivation program started this year and you can learn what that means and hear the results. It will be a toe tapping good time!

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

Do you love Excel? Who doesn’t?! There’s always more to learn and we’ll step through some often overlooked and hidden functions and features that will be sure to help save you time back at the office. From beginner to expert, there will be something for everyone. See use cases in action so you can relate to these tips and return to the office the revived Excel champion! 

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

Level: Intermediate

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.

Love Excel? ME TOO!! Want to learn more things about Excel to save you time and be more productive? Join me for this session to go over some cool formulas and excel functions that will take your excel skills to the next level and save you time!!   Brand new tips for 2020!

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.

Join this member-led session, where Arrowhead Pharmaceutical, a life sciences company,  will share the challenges, approaches, and tactics it uses to  stay current with continuous updates from Microsoft, while effectively  remaining compliant in this highly-regulated industry.

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.

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.

Customer expectations have historically evolved faster than business applications. This has usually resulted in a gap between a business’ CRM-related tools and processes, and the demand by their customers for a personalized, timely and meaningful experience. Today, however, the technology has finally caught up. Learn how recent innovations can empower your organization to move beyond internally-focused sales and marketing processes to deliver individually tailored customer-centric experiences.

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.

With the ever growing universe of Marketing Technology, it’s important for IT and Marketing to work together to ensure compatibility and ease of management of the Martech stack. In this session we’ll explore how marketing platforms enable CRM Administrators and Marketers to work together to ensure that Marketing has their technology needs met which the IT side of the house has options that seamlessly integrate into CRM and are easily managed and maintained.

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.

Do you want to drive innovation across your organization? Innovia Consulting’s Chief Operating Officer, Chad Williams explores how Microsoft Power Apps can solve your business problems quickly.

This session is not just theoretical, though. Chad has seen these solutions work. During his presentation, he will draw on examples of businesses that have found real-world success incorporating Power Apps with Business Central. His practical approach ensures you leave the session already thinking about how you can use Power Apps in your own business.

The pandemic has brought on a new set of business challenges while the e-commerce industry has managed to continue growing. It’s time to get the most out of your BC/NAV solution to increase your online sales despite today’s business climate. In this session, join us as we discuss opportunities that businesses have experienced from the COVID-19 crisis and how to leverage your Microsoft Dynamics BC/NAV investment to grow your e-commerce business. We will provide you with strategies to identify e-commerce opportunities and ways to seamlessly integrate your electronic channels to increase sales and improve operations while providing an enhanced, secure customer experience.