Description
Data is life. In this session, we will explore the basics of Excel's Power Query add-in; extracting, transforming and preparing data for analysis
Designed For
- Any business professional responsible for managing and working with data.
Objectives
- Import and transform basic data into Excel using Power Query
- Understand and apply the data load capabilities of loading into Excel versus loading into the "data model", and why it matters
- Identify the basics of extracting and transforming data
Highlights
- Deep dive into Power Query (Excel 2016 Get & Transform)
- Explore the basics of extracting and transforming data, which is the first necessary step to data analysis and reporting
- Top 6 features most important to accountants (data source flexibility, appending queries, unpivot, etc.)
- Exploration of real Power Query use cases, many of which accountants could implement immediately
- A summary of top resources and experts to get you started on the journey of learning Power Query
- Excel workbooks will be made available for all participants to use at their leisure and further explore the topics discussed