Master Microsoft POWER QUERY in POWER BI & Excel (ETL Tool)
What you'll learn
- Enjoy CLEAR and CONCISE step by step lessons from instructor in FULL HD 1080 P video
- Perform BASIC transformations such as filtering, changing data types, remove columns and creating new calculated columns
- Learn to CLEAN data and LOAD data using parameters
- Perform ADVANCED transformations such as Merging, Appending, Unpivoting, Grouping and Calculating Custom Columns
Requirements
- Download the Power BI Desktop app which is available free from Microsoft for Windows
Description
Skills in data analysis, reporting and the creation of dashboards are HIGHLY valued in today's business environment. Microsoft Power BI is now recognized as the leading Business Intelligence tool in the world for the development of reports, data analysis and dashboards.
In this course you will learn the to use the AMAZING Power BI tool to transform and prepare your data for analysis. You will learn to use the Query Editor to connect to data, perform advanced transformation and also to clean data.
In this course :
Introduction and Course Content
Basic Data Transformations - Learn about filtering data, changing data types, adding new columns and removing columns
Advanced Data Transformations - Merging data into one table, Appending data, Unpivoting data, Grouping data, conditional rules and custom fields
Data Cleansing - Techniques and skills to clean up your data
If you are new to Power BI or want to fill in some gaps in your knowledge, THIS is the course for you. We've focused on providing you with the fundamentals you need to work with Power BI data effectively!
Don't sit through days of boring training to understand how Power BI works! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming a Power BI expert.
This course has been updated for 2022 in full HD video quality, so you will learn on the latest Power BI interface.
Who this course is for:
- Excel users who want to learn how to create PROFESSIONAL reports in Power BI with Power Query
- Learners who want to LEARN Microsoft Power Query in Power BI
Instructor
- 4.5 Instructor Rating
- 5,749 Reviews
- 92,549 Students
- 18 Courses
• Founder & CEO (EXCEL BASEMENT)
• Certified Analytics and Data Specialist (DigitalMarketer)
• Microsoft Innovative Educator Expert at Microsoft Education
• Certified Microsoft Global Challenger
• Microsoft Certified Trainer (MCT) 2016 till present.
• Microsoft Office Specialist Expert & Master Excel 2013, 2016 & 2019 (MSOM)
• 13+ years of experience as a Corporate Trainer for Excel & 8+ years for POWER BI.
• Community Leader for Tableau
Rahim has been actively involved in training & teaching professionals with many organizations and institutions as visiting faculty members and trained thousands of professionals. He gained the repute of an international level trainer in excel with his knowledge of enabling maximum learning & retention in the least possible time.
Positively, training is more of his passion than a profession as he empowers others to create value for their enterprises. Rahim is driven by a mission in life that aims to provide a better understanding to his participants enabling them to focus better and achieve the results they seek.