Data Preparation and Transformation with Power Query
Description
Power BI is a business intelligence tool that allows you to share and build reports and dashboards with various sources that help increase a company’s productivity by delivering useful, time-sensitive, and dynamic information for monitoring and decision-making process. This is great for those who want to quickly learn and upskill on reporting, building dashboards, and data visualization not only user-friendly, Power BI offers numerous complimentary applications, easy access from any location, and have a large and thriving community for forum discussion and development.
The first part of the Intermediate Power BI course focus in-depth on topics such as creating and getting data, learning how to perform data discovery, exploring a different way of data transformation via Power Query built-in features and M query, an introduction to M query language and its applications and lastly, understanding data modeling and how it impacts on the report.
Each topic is designed and layout to give a comprehensive understanding of how each component in Power BI works and impacts each other as well as a hands-on practical exercise and quiz to help familiarize with the tools and application.
What Will I Learn?
- Able to import and connect data to the report
- Perform data discovery and apply the different methods to transform data
- Learn data modelling, comprehensive usage
Topics for this course
Getting Your Data
Creating your own data
Getting your data, part 1
Getting your data, part 2
Assignments
Topic 1 – Quiz 1
Data Discovery and Transformation via Power Query
Data Transformation via M Query, part 1
Data Transformation via M query, part 2
Data Modeling
About the instructors
6 Courses
17 students
2 Courses
0 students