Loading…
DSLUG is the only event exclusively for Dynamics SL users, partners, and solution providers and you won’t want to miss it. With over 124 sessions in four days, you’ll have the opportunity to explore solutions and gain a deeper understanding of Dynamics SL. No matter how experienced you are or what version you’re using, you’re guaranteed to walk away with valuable tools and connections that you can leverage all year.
Wednesday, April 17 • 8:30am - 10:00am
Hakuna Matata - Power BI In Depth for Accountants and Others

Sign up or log in to save this to your schedule and see who's attending!

While keeping the needs of Accounting in mind, we will discover how Power BI lifts the lid to uncover the vast amount of data stored in your organization. We will talk about what to include in Power BI and not to include. We will cover connecting to data from multiple locations including Dynamics SL. Once you have connected to data you will learn about data transformation and calculation building. Most of this session covers the critical task of organizing your data to work best in Power BI. We will cover unique issues accountants face like beginning balances, prior periods, fiscal vs calendar year, security, and linking to data outside of Dynamics. Then will cover a few helpful hints about working with visualization.
Learning Objectives
Upon completion of this session, participants should be able to:
  • You will be able to connect to multiple data sources like Excel, Quick Query, and SQL
  • You will learn about the many data transformation functions found in Power BI
  • You will learn how to use some of the functions like CALCULATE, DIVIDE, and SAMEPERIODLASTYEAR
  • You will be able to use Date tables and Hierarchies



Speakers
avatar for JR Price

JR Price

Business Systems Administrator, Creative Associates International


Wednesday April 17, 2019 8:30am - 10:00am
Platinum 9