Introduction to Data Analytics with Power Query (Get and Transform)
Available for 1 year after purchase date
**OnDemand**
4.0 Credits
Member Price $35.00
Non-Member Price $45.00
Overview
In the accounting profession, dealing with data is life. Doing it efficiently and effectively are skill differentiators.
Highlights
Key Topics
- 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
Prerequisites
Comfortable with Excel navigation and data related topics - LOOKUP, Pivot Tables, Data Tables, etc. would be helpful, but not required
Designed For
Who Will Benefit
- Any business professional responsible for managing and working with data.
Objectives
Learning Outcomes
- 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
Non-Member Price $45.00
Member Price $35.00