We work with many customers in many industries to connect our advanced analytical, forecasting, and inventory planning software to their ERP systems. Despite the variety of situations we encounter, some data-related problems tend to crop up over and over. This blog lists ten tips that can help you avoid these common problems.
The cloud database market is being upended by a new breed of providers, led by Snowflake but there are many others.
Covid-19 has accelerated digital transformation for 88% of global organizations. Trend Micro research reveals the increase in cloud adoption may leave business data insecure.
In this session, we’ll show you how easy it can be to mistakenly create what seems to be a useful dashboard in Excel or Power BI, but isn’t truly relevant due to poor data management. Then we’ll walk through best practices and tools for effective data organization and governance processes so you can ensure you’ll always walk away with what are helpful, accurate dashboards that will drive competitive, stellar results.
Oracle claims that its Autonomous Data Warehouse has three significant advantages over category-king Amazon and shiny new object Snowflake.
Learn options for sharing your MRP data out to the shop floor. This webinar will cover handhelds, touch on MES and discuss what tools you already own vs what you might consider.
Oracle has pointedly and publicly called out AWS by claiming Oracle’s new Exadata Cloud Service X8M crushes competing services from AWS.
In this session we are going to give a quick overview on connecting to data in D365FO with Power BI and closing major reporting gaps. We will be spending most of our session looking at a simple deployment trick that allows us to create one data set and multiple reports.
Deliverable: Session Attendees will be provided with:
• Power Point documentation on deployment and steps.
• Project Accounting Power BI Example – We will give you the datasets and report files we use in this session. These examples can be deployed in users own environments as a starting point.
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.
It’s easy to get started with Power BI, but it’s also easy to end up with an out of control data model that grinds report visuals to a halt. How can you find and fix the problems slowing down performance?
We’ll show you common pitfalls to avoid, along with handy tools to help you maintain and optimize your models, whether you created them yourself or inherited them from others. You’ll leave this session armed with the tools and knowledge you need to improve the performance, organization, and readability of your models, and monitor for the future to prevent angry calls!
Session Level: Intermediate
A Microsoft MVP will show several ways the Dynamics 365 for Finance and Operations Excel integration can be leveraged to drastically improve the employee experience at your company. From data cleansing, to centralized template management, to process optimization, see how this incredibly valuable integration can be leveraged in ways you may be surprised by!
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 case study, we will describe how a company in the glass industry captured IoT data for analysis in order to mitigate production quality issues. The company needed a solution that would reduce their data acquisition and processing time so they could make in-process changes to the production line and reduce quality incidents. We will highlight the strategy, approach and delivery of a system built with Azure tools that increases response to quality issues by more than 70 percent!
The content of this session is geared toward an audience with intermediate to advanced-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 walk through creating a Common Data Service (CDS) Entity from your GP Database. Then we’ll create an ongoing scheduled integration to the CDS. We’ll wrap up by building a Model-driven Power App that provides a Sales Manager with an amazing experience exploring and managing Sales Order Processing (SOP) Data using Power Apps.
This session is geared for an audience with an intermediate skill set.
This session is focused on the best practices for data migration and upgrade from Dynamics AX 2012 to Dynamics 365 Finance & Supply Chain. With data migration and upgrade projects, the best practice methodology followed is to execute these upgrades in a prescribed manner to limit risk and costs. We’ll review leveraging the available tools as templates, DMF Data Management Framework and RSAT regression testing. Their usage depends on the client’s needs for the migration and upgrade.
Project leads, Technical leads, Architects, Developers, Database specialist will learn from a best practice and proven approach to executing a data migration and upgrade in three phases; Analyze, Execute and Validate. This includes analyzing the data and code upgrade, setting up Azure LCS, performing the upgrade to plan and validation of the upgrade before cut over to production.
This session will be available for CPE credits pending completion of session survey post event.
Every project requires data movement in and out of Dynamics 365 Finance and Operations apps. The keys are using bulk imports and effectively keeping a track of multiple moving parts. This session will address:
1. How to import data in bulk with multi-threading for general journal lines
2. How to keep original load and delta loads in sync
3. How to import customers quickly without spending hours to process load
The content of this session is geared toward an audience with intermediate-level knowledge of the subject area.
This session will be available for CPE credits pending completion of session survey post event.
Do you really know what’s going on in your database? Are you sure you’re not affected by some of the most common data quality & integrity problems?
In this session, I’ll present some free tools and queries to find some of the less visible data quality problems and discuss how to fix and prevent them.
The content of this session is geared toward an audience with intermediate-level knowledge of the subject area.
We will discuss the myriad ways to do data repair in GP, we’ll cover normal repair scenarios and go through the best practices for advanced or complex data repair in GP. We will also be reviewing the myriad tools at your disposal for ensuring you efficiently and accurately get the data repaired with low risk to your employer or client. Some little known tools will also be shown (free tools) that you can use to your advantage for accurately repairing or cleaning up data! Some of these tools will be given to you! Tons of tips, tricks and resources to help.
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 is easy to use Power BI as a self-service tool. However, using it in a multi-developer environment comes with challenges. You can easily end up with silos of Power BI solutions, duplicates of Power Query, and DAX codes.
Come to this session to learn how to avoid duplicate work using the right architecture for developing your Power BI solution.
Session Level: Intermediate
Are you ready to take your reporting and data analysis to the next level?
This course is an accelerated hands-on 2-day training designed to teach how attendees how to build reporting and data analysis projects with Power BI Desktop and how to share Power BI reports and dashboards with a wide audience of consumers.
During the course, students will gain the real-world skills required to design, deploy, upgrade and monitor reporting and dashboard solutions using the rapidly-evolving Power BI platform. All the essential Power BI concepts and techniques discussed in lectures are reinforced with hands-on lab exercises in which students will move through the actual steps required to build reporting and dashboard solutions and then to make those solutions accessible using app workspaces and the Power BI app model.
This course includes in-depth coverage of the query tools and data modeling tools in Power BI Desktop. Students will learn how to design complex queries and to write advanced DAX expressions to calculate rankings, rolling averages and year-to-year comparisons. Students will also learn how to design interactive reports using slicers, bookmarks and drillthrough pages.
The course discusses essential differences between reports and dashboards and also examines the strengths and weaknesses between the various types of datasets including imported datasets, DirectQuery datasets and LiveConnect datasets.
Instructor: Ted Pattison
Audience: Business Users and Data Analysts
Level: Intermediate
Prerequisites: All students will require a Windows PC running Windows 10, Windows 8.1 or Windows 7 to complete the lab exercises for this course. It is recommended that students install Power BI Desktop before arriving.
Course Modules
1.Introducing the Power BI Platform
2. Designing Queries with Power BI Desktop
3. Designing a Data Model with Power BI Desktop
4. Designing Interactive Reports in Power BI Desktop
5. Designing Dashboards in the Power BI Service
6. Distributing Content using App Workspaces
With the release of Azure Data Lake and surrounding technologies, it is easy to see why there is hope within the AX and F&SCM communities for a better reporting solution than BYOD. Attend this session to gain a fundamental understanding of what an ADL project may entail, its time frame, estimated cost, and the resulting reporting options available to finance teams to make meaningful business decisions. It’s always best to have clear visibility and understanding of the full implementation cycle before making an investment in a new technology.
PowerGP Online takes your Dynamics GP to the cloud – but it also provides you with a new arsenal of custom-built modules that enhance your GP experience. Learn about how to best use these complimentary, PowerGP Online exclusives to bring added ease and robust capabilities to your daily processes.
