Power Query/M - Nested Structures
Get familiar with structured values in the M language and discover how to interact with them.
schedule3 hours
play_circle27 videos
unfold_more33 exercises
trending_up395 xp

Let’s create your free account

OR

By continuing, you accept our Enterprise DNA Terms & Conditions , our Privacy & Cookie Policy and that your data is stored.

If you have an account Login here

Trusted by 220,000+ people worldwide.

coca-cola-logouniliver-logonhs-logonestle-logoatt-logoanglo-logomackinsey-logoalbemarle-logojonson-logopanasonic-logo

An outline of this training course  

Want to become a better data analyst?  

Whether you are using Power Query in Excel for report automation, Power BI Desktop or Dataflows to design and shape building blocks (tables) for your data model, understanding what structured values are and how to interact with them will give you M(agical) powers. 

Just as virtual tables are the key to unlocking the real power of DAX, learning how to manipulate nested structures will unlock your ability to perform nearly any complex transformation within Power Query.   


What are needed to take this course  

To reap maximum benefit from this course, you should have a working knowledge of the Power Query user interface and have completed Melissa’s eDNA course on Power Query/M Fundamentals. This course builds on the knowledge of basic Power Query structures (values, list, records, tables, and functions) covered extensively in the fundamental course.  

That course dealt with each structure separately.  This course will teach you what can be achieved by combining these types in almost every form (e.g., Lists of tables, tables of lists, records containing lists, functions transforming lists within tables, etc.) 


Who is the course for  

This course is for the intermediate to advanced Data Analyst who wants to make maximal use of Power Query to push transformations “upstream” (e.g., closer to the data source, per Roche’s Maxim), thereby increasing report transparency, maintainability, and speed.  Moving transformations and calculations not dynamic within the context of a reporting session will also dramatically simplify your DAX. 

  


Details of what you will learn during this course 

  • Quick intro to Lists, Records and Tables 
  • Explore expand and extract options 
  • Access structured values 
  • Use Row Index- and or Key Match Lookup 
  • Selection and Projection 
  • Expanded vs Nested transformations 
  • and more 


What you get with the course  

  • A three-hour self-paced video training
  • Resource pack that includes the PBI source files


Program Level  

Intermediate 


Field(s) of Study

Computer Software & App

Instruction Delivery Method

QAS Self-study


***This course was published in January 2023


Enterprise DNA is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

What our

Students Say

Curriculum

1

Course Overview


2

Resources


3

Introduction


4

Expand and Extract Options


5

Item, Field Access, Lookup, Selection and Projection


6

Transforming Nested Values


7

Your Feedback


8

Certification


Your

Instructor

Melissa de Korte

Enterprise DNA Expert

  • Skilled in ETL and Modelling. Delivered practical Power Query solutions in both Excel and Power BI. 
  • Expertise in analysing business process data. Delivering, deploying and supporting Power BI solutions throughout the organisation. 
  • All-round Power platform enthusiast. 

Frequently Asked

Questions

add

What’s the difference between a free account and a paid plan?

add

Do I need to know anything about data science or data analytics to get started with Enterprise DNA?

add

How will I be charged?

add

Can I get an invoice for my company?

add

Are refunds available?

add

Will AI take over the world and make data skills worthless?

Recommended

Courses

Course Cover: ChatGPT for Data Science
beginner
Total points: 170 XP clock-blue 1 hours

ChatGPT for Data Science

Dive deeper into using ChatGPT for data science tasks. Explore techniques for data preprocessing, feature engineering, model training, and deploying ChatGPT models for specific data analysis and prediction tasks.
Tools
ChatGPT
Python
SQL
R
Skills
Data Analysis
Gaelim Holland
Gaelim Holland
See details
Course Cover: Integrate ChatGPT into Excel using Macros and APIs
beginner
Total points: 197 XP clock-blue 1 hours

Integrate ChatGPT into Excel using Macros and APIs

Integrate ChatGPT into Excel using Macros and APIs to enhance your learning experience and maximize productivity.
Tools
ChatGPT
Excel
Skills
Data Analysis
Henry Habib
Henry Habib
See details
Course Cover: ChatGPT to Improve Productivity in Excel
beginner
Total points: 178 XP clock-blue 1 hours

ChatGPT to Improve Productivity in Excel

Boost your Excel productivity with our ChatGPT course designed to enhance your skills!
Tools
ChatGPT
Excel
Skills
Data Analysis
Process Automation
Henry Habib
Henry Habib
See details

Get full access to unparalleled

training & skill-building resources

power-bi-custom-visuals

FOR INDIVIDUALS

Enterprise DNA

For Individuals

Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities.

Learn More chevron_right

FOR BUSINESS

Enterprise DNA

For Business

Training, tools, and guidance to unify and upskill the data analysts in your workplace.

Learn More chevron_right
power-bi-custom-visuals