Course ID: IDAEPP
About & Customize
Popular Options
Dealing with data and building analysis efficiently and effectively have become core skills for today’s accounting and finance professional. Power Pivot, part of Microsoft Excel and Power BI suite, is indispensable for transforming, loading and analyzing data (the “TLR” of the commonly referred to ETLR – “Extract, Transform, Load, Report”). This session builds on the “Introduction to Power Query” session and explores working with the Data Model, building relationships between queries, creating a date table, building basic “DAX” functions and building pivot tables with the new supercharged functionality that Power Pivot allows.
Any business professional responsible for, or interested in, managing and working with data and delivering insight to their organization
Comfortable with Excel navigation; Understanding of data related topics – LOOKUP, Pivot Tables, Data Tables, etc. would be helpful, but not required
This course, like all courses in the BLI catalog, is customizable for your organization. Format, length, and content customizations are available.
To get started, contact BLI:
(888) 777-7077
team@blionline.org