Excel & Power BI Data Prep with Power Query and M Language

Transform and Automate Data with Power Query for Excel & Power BI This course equips students with advanced Excel skills to learn the essentials of Power Query for data transformation in both Excel and Power BI.

Learners will import, clean, and shape complex datasets, connecting to sources like CSV, databases, and APIs.

They will apply transformations, automate tasks, and create custom columns using M language.

The course covers error handling, query optimization, and Power BI integration for data modeling.

Through hands-on exercises, students will build reusable queries, ensuring analysis-ready datasets for reports.

By completion, learners will confidently transform data, enhancing Excel dashboards and preparing for Power BI Desktop, ready to tackle real-world data challenges efficiently.

Course Highlights: Principles of data extraction from diverse sources Theoretical foundations of data cleansing methods General concepts of automation in data processing work flows General structure and logic of M language programming Strategies for error management in data transformation Approaches to query optimization for performance Design principles for reusable data queries Fundamentals of data modeling and relationships Integration frameworks for Power Query and Power BI Principles of dataset preparation for analytics Course Learning Outcomes: Connect to diverse data sources like CSV, databases, APIs Clean datasets using Power Query’s filtering, merging tools Automate repetitive data preparation tasks in Excel Create advanced custom columns with M language Handle data errors for reliable, accurate outputs Optimize queries for efficient large dataset processing Build reusable queries for consistent transformations Understand data modeling concepts like relationships, types Integrate Power Query with Power BI seamlessly Prepare datasets for Excel dashboards, Power BI reports Course Typically Offered: Online in Fall and Spring quarters Prerequisite: CSE-41161 Advanced Excel for Analysis and Business Intelligence or equivalent knowledge and experience Contact: For more information about this course, please email unex-techdata@ucsd.edu Next Step: After completing this course, consider taking other courses in our Business Intelligence Analysis certificate program