We may earn an affiliate commission when you visit our partners.
Eugene Meidinger
We all have to deal with dirty data. By using the M language, we can clean and prep our data for use in Power BI. M turns manual data cleanup into an automated process.
Read more
We all have to deal with dirty data. By using the M language, we can clean and prep our data for use in Power BI. M turns manual data cleanup into an automated process.
Read more
We all have to deal with dirty data. By using the M language, we can clean and prep our data for use in Power BI. M turns manual data cleanup into an automated process.
We all have to deal with semi-structured data that is scattered across multiple data sources. In this course, Querying and Shaping Data in Power BI Using M, you'll learn how the Power Query formula language known as M can automate data cleanup. First, you'll learn how to extract trapped data. Next, you'll discover how to massage and shape it. Finally, you'll explore how to work with text and date values. By the end of this course, you'll have a deeper understanding of the M language.
Register for this course and see more details by visiting:
OpenCourser.com/course/nde2ih/querying
What's inside
Syllabus
Course Overview
Meet M, a Macro Language for Data Prep
Extracting Your Trapped Data
Molding Your Data into the Right Shape
Read more
Syllabus
Course Overview
Meet M, a Macro Language for Data Prep
Extracting Your Trapped Data
Molding Your Data into the Right Shape
Read more
Combining and Merging Multiple Data Sources
Cleaning up Messy Text Values
Manipulating Dates and Times
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Covers fundamental data cleaning, shaping, and transformation techniques using Power BI's M language, which is essential for data analysts in various industries
Taught by Eugene Meidinger, an experienced instructor recognized for his expertise in data analytics and Power BI
Provides hands-on practice through interactive materials and exercises, fostering practical skill development
Covers essential data manipulation techniques, such as extracting and transforming data from multiple sources, which is crucial for data integration and analysis
Suitable for beginners seeking a foundation in data preparation and transformation, as it covers the basics of the M language and data cleaning principles
May require prior knowledge of Power BI or data analysis concepts to fully benefit from the course
Save this course
Save Querying and Shaping Data in Power BI Using M to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Querying and Shaping Data in Power BI Using M with these
activities:
Join a Power BI Community Forum
Show steps
Engaging with a community of Power BI users will provide you with access to a wealth of knowledge, support, and collaboration opportunities, enhancing your learning experience.
Browse courses on
Peer Support
Show steps
-
Search for active Power BI community forums online.
-
Join a forum and introduce yourself.
-
Participate in discussions, ask questions, and share your experiences.
Review data visualization techniques
Show steps
Brushing up on visualization techniques will ensure you have the skills needed to create compelling data visualizations in Power BI.
Browse courses on
Data Visualization
Show steps
-
Refer back to previous coursework or tutorials on data visualization.
-
Explore online resources such as websites or YouTube videos.
-
Read articles or books on the topic of data visualization.
-
Practice creating visualizations using tools like Excel or Google Sheets.
M Query Language Tutorial
Show steps
Completing a tutorial on the M Query Language will provide you with a deeper understanding of its syntax and features, enabling you to leverage its full potential in Power BI.
Browse courses on
Power Query
Show steps
-
Search for online tutorials on the M Query Language.
-
Follow along with the steps and examples provided in the tutorials.
-
Experiment with the M Query Language using the Power Query Editor.
Two other activities
Expand to see all activities and additional details
Show all five activities
Data Cleanup and Transformation Drills
Show steps
Engaging in practice drills will enhance your ability to effectively clean and transform data, a crucial skill for working with real-world datasets in Power BI.
Browse courses on
Data Transformation
Show steps
-
Find practice problems or exercises online.
-
Use the M Query Language to solve the problems or complete the exercises.
-
Review your solutions and identify areas for improvement.
Review Pro Data Science with Power BI
Show steps
Reading this book will provide you with insights into advanced techniques and best practices for data science with Power BI, enhancing your understanding and capabilities.
View
Microsoft SQL Server 2012 Analysis Services:...
on Amazon
Show steps
-
Read the book thoroughly, taking notes and highlighting key concepts.
-
Complete the exercises and examples provided in the book.
-
Apply the techniques and methods to your own data science projects.
Join a Power BI Community Forum
Show steps
Engaging with a community of Power BI users will provide you with access to a wealth of knowledge, support, and collaboration opportunities, enhancing your learning experience.
Browse courses on
Peer Support
Show steps
Show steps
Show steps
- Search for active Power BI community forums online.
- Join a forum and introduce yourself.
- Participate in discussions, ask questions, and share your experiences.
Review data visualization techniques
Show steps
Brushing up on visualization techniques will ensure you have the skills needed to create compelling data visualizations in Power BI.
Browse courses on
Data Visualization
Show steps
Show steps
Show steps
- Refer back to previous coursework or tutorials on data visualization.
- Explore online resources such as websites or YouTube videos.
- Read articles or books on the topic of data visualization.
- Practice creating visualizations using tools like Excel or Google Sheets.
M Query Language Tutorial
Show steps
Completing a tutorial on the M Query Language will provide you with a deeper understanding of its syntax and features, enabling you to leverage its full potential in Power BI.
Browse courses on
Power Query
Show steps
Show steps
Show steps
- Search for online tutorials on the M Query Language.
- Follow along with the steps and examples provided in the tutorials.
- Experiment with the M Query Language using the Power Query Editor.
Two other activities
Expand to see all activities and additional details
Show all five activities
Data Cleanup and Transformation Drills
Show steps
Engaging in practice drills will enhance your ability to effectively clean and transform data, a crucial skill for working with real-world datasets in Power BI.
Browse courses on
Data Transformation
Show steps
Show steps
Show steps
- Find practice problems or exercises online.
- Use the M Query Language to solve the problems or complete the exercises.
- Review your solutions and identify areas for improvement.
Review Pro Data Science with Power BI
Show steps
Reading this book will provide you with insights into advanced techniques and best practices for data science with Power BI, enhancing your understanding and capabilities.
View
Microsoft SQL Server 2012 Analysis Services:...
on Amazon
Show steps
Show steps
Show steps
- Read the book thoroughly, taking notes and highlighting key concepts.
- Complete the exercises and examples provided in the book.
- Apply the techniques and methods to your own data science projects.
Career center
Learners who complete Querying and Shaping Data in Power BI Using M will develop knowledge and skills
that may be useful to these careers:
Data Analyst
Data Analyst
A Data Analyst collects, processes, and analyzes large amounts of data to extract meaningful insights. This course on Querying and Shaping Data in Power BI Using M can help you develop the skills needed to succeed in this role. You'll learn how to use the M language to clean and prep data, which is a critical step in data analysis. You'll also learn how to manipulate dates and times, which is often necessary when working with data. Overall, this course can help you build a strong foundation for a career as a Data Analyst.
Data Scientist
Data Scientist
A Data Scientist uses data to build models that can predict future events or trends. This course on Querying and Shaping Data in Power BI Using M can help you develop the skills needed to succeed in this role. You'll learn how to use the M language to clean and prep data, which is a critical step in data science. You'll also learn how to manipulate dates and times, which is often necessary when working with data. Overall, this course can help you build a strong foundation for a career as a Data Scientist.
Business Analyst
Business Analyst
A Business Analyst uses data to identify opportunities and solve problems for businesses. This course on Querying and Shaping Data in Power BI Using M can help you develop the skills needed to succeed in this role. You'll learn how to use the M language to clean and prep data, which is a critical step in business analysis. You'll also learn how to manipulate dates and times, which is often necessary when working with data. Overall, this course can help you build a strong foundation for a career as a Business Analyst.
Database Administrator
Database Administrator
A Database Administrator manages and maintains databases. This course on Querying and Shaping Data in Power BI Using M may be useful for aspiring Database Administrators. You'll learn how to use the M language to clean and prep data, which is a critical step in database administration. You'll also learn how to manipulate dates and times, which is often necessary when working with databases. Overall, this course can help you build a foundation for a career as a Database Administrator.
Data Architect
Data Architect
A Data Architect designs and manages the architecture of data systems. This course on Querying and Shaping Data in Power BI Using M may be useful for aspiring Data Architects. You'll learn how to use the M language to clean and prep data, which is a critical step in data architecture. You'll also learn how to manipulate dates and times, which is often necessary when working with data. Overall, this course can help you build a foundation for a career as a Data Architect.
Data Engineer
Data Engineer
A Data Engineer designs and builds the infrastructure that stores and processes data. This course on Querying and Shaping Data in Power BI Using M may be useful for aspiring Data Engineers. You'll learn how to use the M language to clean and prep data, which is a critical step in data engineering. You'll also learn how to manipulate dates and times, which is often necessary when working with data. Overall, this course can help you build a foundation for a career as a Data Engineer.
Statistician
Statistician
A Statistician collects, analyzes, and interprets data. This course on Querying and Shaping Data in Power BI Using M may be useful for aspiring Statisticians. You'll learn how to use the M language to clean and prep data, which is a critical step in statistics. You'll also learn how to manipulate dates and times, which is often necessary when working with statistical data. Overall, this course can help you build a foundation for a career as a Statistician.
Operations Research Analyst
Operations Research Analyst
An Operations Research Analyst uses data to improve the efficiency of organizations. This course on Querying and Shaping Data in Power BI Using M may be useful for aspiring Operations Research Analysts. You'll learn how to use the M language to clean and prep data, which is a critical step in operations research. You'll also learn how to manipulate dates and times, which is often necessary when working with operational data. Overall, this course can help you build a foundation for a career as an Operations Research Analyst.
Financial Analyst
Financial Analyst
A Financial Analyst uses data to make investment decisions. This course on Querying and Shaping Data in Power BI Using M may be useful for aspiring Financial Analysts. You'll learn how to use the M language to clean and prep data, which is a critical step in financial analysis. You'll also learn how to manipulate dates and times, which is often necessary when working with financial data. Overall, this course can help you build a foundation for a career as a Financial Analyst.
Product Manager
Product Manager
A Product Manager manages the development and launch of new products. This course on Querying and Shaping Data in Power BI Using M may be useful for aspiring Product Managers. You'll learn how to use the M language to clean and prep data, which is a critical step in product management. You'll also learn how to manipulate dates and times, which is often necessary when working with product data. Overall, this course can help you build a foundation for a career as a Product Manager.
Data Journalist
Data Journalist
A Data Journalist uses data to tell stories and inform the public. This course on Querying and Shaping Data in Power BI Using M may be useful for aspiring Data Journalists. You'll learn how to use the M language to clean and prep data, which is a critical step in data journalism. You'll also learn how to manipulate dates and times, which is often necessary when working with data. Overall, this course can help you build a foundation for a career as a Data Journalist.
Quantitative Analyst
Quantitative Analyst
A Quantitative Analyst uses data to make investment decisions. This course on Querying and Shaping Data in Power BI Using M may be useful for aspiring Quantitative Analysts. You'll learn how to use the M language to clean and prep data, which is a critical step in quantitative analysis. You'll also learn how to manipulate dates and times, which is often necessary when working with financial data. Overall, this course can help you build a foundation for a career as a Quantitative Analyst.
Risk Manager
Risk Manager
A Risk Manager identifies and manages risks for organizations. This course on Querying and Shaping Data in Power BI Using M may be useful for aspiring Risk Managers. You'll learn how to use the M language to clean and prep data, which is a critical step in risk management. You'll also learn how to manipulate dates and times, which is often necessary when working with risk data. Overall, this course can help you build a foundation for a career as a Risk Manager.
Market Researcher
Market Researcher
A Market Researcher uses data to understand consumer behavior. This course on Querying and Shaping Data in Power BI Using M may be useful for aspiring Market Researchers. You'll learn how to use the M language to clean and prep data, which is a critical step in market research. You'll also learn how to manipulate dates and times, which is often necessary when working with market data. Overall, this course can help you build a foundation for a career as a Market Researcher.
Software Engineer
Software Engineer
A Software Engineer designs, develops, and maintains software applications. This course on Querying and Shaping Data in Power BI Using M may be useful for aspiring Software Engineers. You'll learn how to use the M language to clean and prep data, which is a critical step in software development. You'll also learn how to manipulate dates and times, which is often necessary when working with data. Overall, this course can help you build a foundation for a career as a Software Engineer.
For more career information including salaries, visit:
OpenCourser.com/course/nde2ih/querying
Reading list
We've selected 11 books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Querying and Shaping Data in Power BI Using M.
Includes a thorough treatment of the M language as well as insights into data transformation. It is particularly useful for readers with experience in data analysis who want to learn more about M. While the book is not a comprehensive reference, it valuable resource for those who want to learn how to transform and clean data in Power BI using M language.
Provides a collection of recipes for common data transformation tasks in Power Query. It valuable resource for anyone who wants to learn how to use Power Query to clean and transform data efficiently.
Is an excellent companion to this course as it provides readers with a deep dive into the Power Query formula language (M).
As this course provides an overview of M, this book can serve as an excellent reference text. Additionally, the book covers updates to Power Query in recent releases of Power BI and the Power Platform that may not yet be covered in this course.
Comprehensive guide to Power Query that covers all aspects of the tool, from basic to advanced. It useful reference for those who want to learn how to use Power Query to its full potential. As the book is quite long, it is better suited as a reference than a cover-to-cover read.
Save
Provides a comprehensive overview of data preparation for data science. While this book is not specific to M or Power BI, it valuable resource for anyone who wants to learn how to prepare data for data science.
Comprehensive guide to Power Query, covering everything from the basics to advanced topics such as data modeling and automation.
Provides a practical introduction to data manipulation in R. While this book is not specific to M or Power BI, it valuable resource for anyone who wants to learn how to clean and transform data.
Provides a comprehensive overview of Python for data analysis. While this book is not specific to M or Power BI, it valuable resource for anyone who wants to learn how to use Python to clean and transform data.
Cookbook of recipes for DAX, the data modeling language used in Power BI.
Cookbook of recipes for creating visualizations in Power BI.
Provides a comprehensive overview of SQL. While this book is not specific to M or Power BI, it valuable resource for anyone who wants to learn how to use SQL to clean and transform data.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/nde2ih/querying
Share
Similar courses
Here are nine courses similar to
Querying and Shaping Data in Power BI Using M.
Advanced Data Analysis with Power BI
OpenCourser.com/course/ix4pue/advanced
Advanced Data Analysis with Power BI
Most relevant
Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS
OpenCourser.com/course/8zjbcy/getting
Getting Started with DAX Formulas in Power BI, Power...
Most relevant
Modeling Data in Power BI
OpenCourser.com/course/dtehdb/modeling
Modeling Data in Power BI
Most relevant
Power BI Data Import Playbook
OpenCourser.com/course/6xii2o/power
Power BI Data Import Playbook
Most relevant
PL-300 certification: Microsoft Power BI Data Analyst
OpenCourser.com/course/paw0jp/da
PL-300 certification: Microsoft Power BI Data Analyst
Most relevant
Common DAX Expressions and Scenarios Power BI Playbook
OpenCourser.com/course/64r5in/common
Common DAX Expressions and Scenarios Power BI Playbook
Most relevant
Data Modeling in Power BI
OpenCourser.com/course/cw7018/data
Data Modeling in Power BI
Most relevant
Data Connection and Functionalities in Power BI
OpenCourser.com/course/qbbepx/data
Data Connection and Functionalities in Power BI
Most relevant
Create Measures by Using DAX with Power BI
OpenCourser.com/course/qkgzbm/create
Create Measures by Using DAX with Power BI
Most relevant
Time
156 hours
Level
Intermediate
Via
Pluralsight
Instructor
Eugene Meidinger
Language
English
This course belongs to a
collection
called
Microsoft Power BI for Analysts. It's comprised of 13 courses:
- Building Your First Power BI Report
- Power BI Data Import Playbook
- Power BI Data Preparation Playbook
- Modeling Data in Power BI
- Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS
- Effective Reporting with Power BI
- Creating Dashboards with Power BI
- Deploying and Publishing Power BI Reports
- Effective Quick Insights and Q&A in Power BI
- Querying and Shaping Data in Power BI Using M (viewing)
- Leveraging Timely On-premises Data with Power BI
- Power BI Playbook: Securing Shared Data with Power BI
- Common DAX Expressions and Scenarios Power BI Playbook
Good to know
Covers fundamental data cleaning, shaping, and transformation techniques using Power BI's M language, which is essential for data analysts in various industries
Taught by Eugene Meidinger, an experienced instructor recognized for his expertise in data analytics and Power BI
Provides hands-on practice through interactive materials and exercises, fostering practical skill development
Covers essential data manipulation techniques, such as extracting and transforming data from multiple sources, which is crucial for data integration and analysis
Suitable for beginners seeking a foundation in data preparation and transformation, as it covers the basics of the M language and data cleaning principles
May require prior knowledge of Power BI or data analysis concepts to fully benefit from the course
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser