Session Abstract

In this 2 hour hands-on workshop, you will learn how to: – Create a data model from multiple abstract sources in Power Query Editor (data from .csv files, Excel files, Business Central data) – Create and work with Date tables – Analyze modeled data – Visualize data into reports and dashboards – Sizzle and Security: Animated visuals, Image based filters, Row-Level Security – Package your finished reports as an app – Embed your Power BI reports and visuals inside Business Central Note: This workshop is not exclusively for Business Central users. 90% of this content applies universally, but we also go the extra mile to use some data from Business Central and embed report visuals back into Business Central What You Need to Bring: – A Laptop with internet connectivity. – I will bring the rest, including sample data, workshop instructions, and a Business Central environment to get data from!

AJ Ansari

AJ is a business leader and a recognized veteran of the Microsoft Dynamics 365 Business Central community, bringing nearly two decades of experience as a trusted advisor to businesses seeking to maximize their ERP investments. As a seven-year Microsoft MVP, AJ is passionate about sharing his knowledge with the community and has spoken at over 40 global industry events. Through his workshops, conference sessions and many online contributions, AJ has built a reputation for translating complex technical concepts into practical solutions for the Microsoft community. AJ’s expertise extends to Copilot and Power Automate, where he helps businesses harness the power of AI and process automation to streamline operations and improve decision-making. A dedicated mentor and advocate for continuous learning, AJ is also an active community organizer, serving on the boards, planning committees and content committees of various Microsoft partner associations and user groups.