Unlocking Reporting Capabilities for Business Central

Discover the secrets to effective reporting with Business Central:
- Learn how to build data models tailored for specific purposes, ensuring your reports deliver optimal insights.
- Explore techniques to seamlessly embed your reports within Business Central, providing users with an intuitive and integrated experience.
- Dive into analysis mode to explore your data dynamically, unveiling hidden insights and enhancing your decision-making process.
- Develop robust Excel layouts to effortlessly export data and empower users in constructing final reports, putting control in their hands.
- Harness the capabilities of artificial intelligence to elevate your Power BI reporting. Learn advanced features in both Power BI Desktop and Power BI Service.

Join me for a session filled with invaluable tips and tricks that will transform your Business Central reporting game. Don't miss out on optimizing your reporting processes for greater efficiency and impact!

Telemetry Tales: How It Saved a CEO’s Life in the SaaS Universe

Join us for an enlightening session on harnessing the full potential of telemetry to monitor and optimize your Business Central solution. Imagine staying one step ahead of customer issues, and proactively addressing them even before they become noticeable. Telemetry provides valuable insights into user behavior, system performance, and application health, paving the way for enhanced customer satisfaction.

Gain a unique perspective from a CEO’s angle on using telemetry in the day-to-day operations of a SaaS company. The focus of this presentation will be on sharing practical examples of how the CEO of a SaaS company like NaviPartner uses telemetry to get useful information about programming and user errors, as well as to monitor that all server jobs are running well, and simulate a high load so we know the code is ready for the next Black Friday. On the other hand, we will also share with you the fascinating reasons why NaviPartner developers ask their CEO not to look at telemetry multiple times a day.

Learn how to seamlessly integrate telemetry into your Business Central solution, unlocking its troubleshooting capabilities and gaining real-time notifications about potential issues. Discover how to leverage telemetry data to make informed decisions, driving application improvements and delivering exceptional value to your customers.

Don’t miss this opportunity to become a telemetry master and gain insights from the CEO’s viewpoint on utilizing telemetry.

Telemetry from basics to advanced usage

Imagine knowing about the issues before the customer even notices them. Telemetry is one of the things that makes Business Central maintenance easier. Thanks to it you can get more insights about users, systems, and applications. And it allows making your customer happier.

During the presentation I will present how to start using the telemetry, how it can help in troubleshooting, how to create an easy way notifications about the issues, and how to use telemetry to make decisions about the application if you are the ISV or VAR.

Telemetry for Consultants

Telemetry is just a fancy word for "usage data". As a functional consultant, you can use telemetry to learn how the customer is using (or not using) base app functionality, reports, Microsoft connectors, and features. And you can dive into the errors that customers experience in their environments. In this session, I will show scenarios for you and how you can use them in your daily work in Business Central projects.

Reporting and analytics product strategy – past, present, and future

Come to this session to learn about the Business Central product strategy of Data Analysis, Business Intelligence, and Reporting. We will discuss the vision in this space, how features in this area over the last four release waves fit into the strategy, and maybe also show a high-level roadmap on the future direction of this area.

Microsoft workshop at the expo booth: Join the Kusto Detective Agency

Want to learn KQL and have fun at the same time? In this two-hour workshop, you can do both. Bring a laptop and try to crack the challenges in the Kusto Detective Agency (season 1 or 2). We have some KQL experts in the room that can help you get unblocked.

Opening Session

Welcome to Days of Knowledge Americas - Join us in this opening session to kick-off 2 days with in-depth education, knowledge sharing and networking.
Microsoft, eOne, insightsoftware

Microsoft roundtable: Future of Business Central document reporting

Join this roundtable if you want to discuss the future of document reporting in Business Central. We can talk about current gaps in Word layouts, possibilities to do PDF post-processing, and where the RDL technology stack can/should fit in Business Central.

Microsoft roundtable: Future business intelligence in Business Central

In this roundtable we will present ideas for future built-in Power BI reports and discuss how you see this work with your customers.

Microsoft roundtable: Data-driven implementations

Lets get together and discuss how we can use telemetry pro-actively in our project implementation lifecycle - from prospect meetings, during implementation, and before/after go-live.

Microsoft presents: What's new: introducing new Power BI reports in Business Central

Join this session to learn about all the new 70+ Power BI reports that was added in 2024 release wave 2 across functional areas such as finance, sales, purchase, inventory, and projects. We will also discuss the plans for the next iteration of Power BI content for the upcoming release wave.

Microsoft presents: What's new in telemetry

Come to this session and get an overview on the innovations that has happened in telemetry in the the 2023 release waves 2. We will cover new capabilities in the Power BI apps, new signal, tips and tricks, and learning resources. The session is not only for techies.

Microsoft presents: Whats new in reporting (for developers)

Join this session to learn about new features in Word layouts, Excel layouts, and report layout management.

Microsoft presents: Whats new in server and database

Join this session to learn all things new in the 2024 release wave 2 (and a short recap on wave 1) of the Server and the Database. We will cover performance improvements, AL runtime, database, search, web services stack, and reporting.

Microsoft presents: What's new in Power BI embedded in Business Central (for developers)

In this session, you'll learn all about the new features for embedding Power BI reports in Business Central, and the increasing flexibility that you have as an AL developer to leverage more and more features of the Power BI platform.

We will discuss how to embed you Power BI app as full page embeddings, how to make them discoverable in Tell-me and in the Report explorer, how to create multi-language Power BI apps that show with correct language embedded, and show you some tools that can help you speed up this work.

Microsoft presents: What's new in Power BI

In this session, we will cover Power BI metrics and how they now can be embedded in the client. We will showcase new embed capabilities for the AL developer and the consultant - showcase embedding in full page, embed on role centers, embed on cards, and embed in fact boxes.

Microsoft presents: Reporting, Power BI and analytics overview

Come to this session to learn about our product strategy of Data Analysis, Business Intelligence, and Reporting. We will discuss our vision in this space, how features in this area over the last four release waves fit into the strategy, and maybe also show a high-level roadmap on the future direction of this area. This session is for consultants, sales people, ISVs, developers, and architects.

Microsoft presents: What's new in Excel reporting

Come to this session to learn about the new innovations we are bringing to Excel layouts in version 23.1. We will show how you can get data into multiple worksheets and how to do data models in Excel Power Pivot. Then show examples on usage in brand new reports in the base app.

Microsoft presents: What's new in Excel reporting

In this session, we will present new features for Excel layouts. We will cover how the new data contract works with multiple top-level dataitems, how to develop reports with Excel layouts that translate to the users language when they run the report, and how you can also develop Excel reports that call Business Central REST APIs to augment the dataset defined in the report.

Microsoft presents: What's new in Excel reporting

In this session, we will present new features for Excel layouts. We will cover how the new data contract works with multiple top-level dataitems, how to develop reports with Excel layouts that translate to the users language when they run the report, and how you can also develop Excel reports that call Business Central REST APIs to augment the dataset defined in the report.

Microsoft presents: What's new in data analysis and reporting

Come and get an overview over the many innovations we have done in the area of reporting and data analysis in 2023 release waves 1 and 2: Analyze, group, and pivot data on lists/queries, improvements to Excel layouts, new Power BI embed experience for users, and new capabilities for AL developers to control embedded Power BI.

Microsoft presents: Telling and selling the analytics story in Business Central

Join this session to learn how to tell and sell the analytics story in Business Central to prospective customers (and maybe also to existing customers ). We will cover all aspects of analytics (KPIs, ad-hoc analysis, and reporting) as seen from different organizational roles in the customer organization (leadership, middle management, and staff) as well as seen from functional areas (finance, sales, purchasing, inventory, ...) so that your conversations can move from "does Business Central have reporting?" to "How Business Central help your company be data-driven" and "This is how Business Central support analytics for the Sales department". We will also briefly cover how this story compares to leading competitors.

Microsoft presents: Server and database

In this technical tour-de-force session, we will present new features and improvements in the AL runtime and the Business Central database. Fasten your seatbelts, there will be bits and bytes. We will focus on features from 2023 release wave 2 and 2024 release wave 1.

Microsoft presents: Server and database

In this technical tour-de-force session, we will present new features and improvements in the AL runtime and the Business Central database. Fasten your seatbelts, there will be bits and bytes. We will focus on features from 2023 release wave 2 and 2024 release wave 1.

Microsoft presents: Reporting, Power BI and analytics overview

Come to this session to learn about our product strategy of Data Analysis, Business Intelligence, and Reporting. We will discuss our vision in this space, how features in this area over the last four release waves fit into the strategy, and maybe also show a high-level roadmap on the future direction of this area.

Microsoft presents: Reporting, Power BI and analytics overview

Come to this session to learn about our product strategy of Data Analysis, Business Intelligence, and Reporting. We will discuss our vision in this space, how features in this area over the last four release waves fit into the strategy, and maybe also show a high-level roadmap on the future direction of this area. This session is for consultants, sales people, ISVs, developers, and architects.

Microsoft presents: New table extension schema, less locking and other features in Server & Database

Come to this session, fasten your seat belt, and get a deep-dive overview on the innovations that has happened in the server and database over the 2023 release waves 1 and 2. We will cover the web services stack, data stack, AL runtime, security, and telemetry.

Microsoft presents: New and enhanced documentation for AL developers

Over the last 6-12 months, we have added a ton of new content in our documentation for developers. If you are a Business Central developer, then come to this session to get a quick update on where in the documentation you probably should get more familiar with. We will cover data analytics, reporting, error handling, troubleshooting tools and guides, async processing, telemetry, and security.

Microsoft presents: Measuring performance with the Performance Toolkit

In this session, we will discuss how you can measure performance with the Business Central Performance Toolkit (BCTP). We will go through usage scenarios and demo how the tool works. This session is for developers, ISVs, project managers, and architects.

Business Central Excel Layout Reports Demystified

Learn in this session, how to create Excel report layouts in Business Central

Discover how you can create a report that generates a dataset and leave it up to the end-user to further modify it by using the full palette of capabilities in Excel such as sliders, diagrams, charts, pivot tables, and Power Query to design the report.

On top of that, let's also look how Power BI Datasets and/or Dataflows can be integrated in the same Excel layouts.

Telemetry from basics to advanced usage

Imagine knowing about the issues before the customer even notices them. Telemetry is one of the things that makes Business Central maintenance easier. Thanks to it you can get more insights about users, systems, and applications. And it allows making your customer happier.

During 90 minutes I will present how to start using the telemetry, how it can help in troubleshooting, how to create an easy way notifications about the issues, and how to use telemetry to make decisions about the application if you are the ISV or VAR.

Telemetry for Consultants

Performance tips and tricks for consultants and developers

Do you want your customers ERP system to run blazingly fast? Join this session to learn about best practices for performance, focusing on what you can do both as a consultant and/or as a developer.

Microsoft presents: Data analysis on list pages

Learn about the cool new data analysis feature in Business Central where end users quickly can extract insights from their data directly in Business Central with no need to involve developers. The can design data their way: pick columns, reorder them, freeze left/right, set additional data filters, group and pivot, and export data to Excel or PowerPoint. We will showcase capabilities and tons of analysis scenarios that you can take directly home to your customers and implement with them.

Lessons learned making Dynamics NAV GDPR compliant

As of May 2018, all Microsoft products must be compliant with the new GDPR law. One of these, Dynamics NAV, is developed in the Copenhagen Development Center, MDCC. In this talk, I will share some of the lessons learned making Dynamics NAV GDPR compliant. Don’t expect a full course on GDPR, expect to see code snippets.

Kusto Query Language (KQL) and Power BI - a love story

Over the last 3 years, I have worked extensively with KQL and Power BI to help Dynamics 365 Business Central partners be data-driven with telemetry. Thousands of our partners use telemetry to troubleshoot things and more than 800 partners/customers use our Power BI apps on telemetry every month.

In this session, I will share KQL dos and don'ts, code samples, and best practices that you can take home and apply immediately if you work with telemetry data in Kusto and want to take your skills to the next level.

Kennie, LogAnalytics, and Facts - What time is love? (live from Billund)

For the last 4 years, I have worked extensively with telemetry on the Dynamics 365 Business Central product. All of this telemetry is stored in Azure LogAnalytics, a big data store that can handle A LOT OF data. In this session I will share my love for this technology, giving you an overview of LogAnalytics and KQL, including KQL vs. SQL. I will show you use cases from Azure Monitor / Azure Application Insights as use cases of Log Analytics. Finally, I will discuss cost (and cost control strategies) of LogAnalytics.

How to Get Customers up and Running When your Data Center is Hit by Lightning

Using the real-world story of our response to a recent weather-induced regional Azure outage, I will show you the Monitoring, Diagnostics, and Analytics tools and data we use to run Dynamics 365 Business Central (and all other Azure services).

From the initial monitoring alerts through to the final post mortem analysis, I will take you through the incident and the entire data lifecycle to reveal how we maintain control and perspective on the service and the KPIs we use to drive data-driven decision making, even when lightning strikes!

Think of this session as a factory floor tour inside incident management of Azure.