According to a Forbes survey, business users spend up to 80% of their time on data preparation, delaying the time to data analysis and decision making. Power Query is one of the most important data preparation tools. It acts as an ETL tool that can extract data across a wide variety of sources, transform it quickly and easily, and then load it directly into your table/data model. This course will teach you everything you need to know to import, merge, shape, and clean data. Power Query Course learning means you will spend negligible time in data preparation.
★ ★ ★ ★
- Access 46 lectures & 2 hours of content 24/7
- Get data from a single file (Excel, Text, CSV, & more)
- Import multiple files from a given folder
- Get data from other sources like a table/range from the web & current workbook
- Sort & filter columns
- Convert data types – text, numbers, dates
- Split or merge columns
- Merge two queries like joining in SQL
- Add calculated columns
- Unpivot data to use pivot tables
Note: Software NOT included.
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certificate of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: intermediate
- Excel 2010+ and Power BI
★ ★ ★ ★
Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.