Course description
In this interactive Business Intelligence course, you’ll learn how to use Power Query Editor to transform and shape your data to be ready for analysis.
Upcoming start dates
1 start date available
Training Course Content
Transform and shape your data in Business Intelligence. In just 3 hours, you’ll cover essential data preparation steps, previewing data in power query, and transformations.
By the end of this course, you’ll feel confident using a range of Power Query Editor tools and techniques and know how to clean and prepare your data for the next stage in the data analysis workflow.
Manipulate Data in Business Intelligence
Power Query is a powerful data manipulation framework available throughout a number of Microsoft tools, which allows you to clean different data types ready for analysis. You’ll learn how to deal with duplicates, missing values, and profiling to find anomalies. After each new topic is introduced, you'll have the opportunity to put your new knowledge into practice with hands-on exercises, such as splitting and merging text columns.
Master Data Transformation in Power Query
The last two chapters of this course are focused on helping you with transformations in Business Intelligence, allowing you to transform text, apply logarithmic and square root transformations, and date transformations.
This course is part of the Data Analyst and Business Intelligence tracks, offering you plenty of ways to improve your Business Intelligence skills or even build towards a career in data analysis.
Why choose DataCamp
More than 14 Million learners worldwide
80% of the Fortune 1000 use DataCamp
DataCamp
Data Science Central UK Limited, 25 Luke Street
EC2A 4EE London
DataCamp
DataCamp offers a comprehensive platform for learning data skills, specializing in training individuals and teams in data science, analytics, and AI. With a focus on interactive, hands-on learning, DataCamp provides courses across key programming languages such as Python, R, SQL,...
Ads