Overview
Join our Power BI Tools: Get and Transform Data course, designed for individuals aiming to convert data into impactful business intelligence solutions. Utilizing Power Query, participants will learn to transform data effectively by reducing, adding columns, and merging data sets, making data preparation seamless for further analysis.
This comprehensive course delves into Power Query, introducing the M language to enable the automation of transformation processes, particularly for tasks that recur weekly, monthly, or quarterly. Mastering M Code offers advanced data manipulation capabilities beyond standard keyboard commands.
Target Audience: The course is perfect for users of Power BI, Excel Power Tools, or SQL Server Analysis Services (SSAS), ensuring ease of understanding due to the similar interfaces across these platforms. Taught using Excel 2016, the course remains accessible to users of diverse software versions.
The course is aimed at Excel power-users, BI professionals, and those familiar with Power Query looking to enhance their expertise. It complements our Essential Report Building Skills Using DAX course, suitable for Excel, Power BI, or SQL Server users.
Prerequisites: While extensive knowledge of DAX formulas isn't mandatory, we recommend prior experience through either our "Analyzing Data with Power BI" or "Excel BI Tools" class or analogous experience.
- Course Outline
- Power Query Overview
- Power Query with Power BI and Excel
- Power Query Concepts
- Data Sources: Querying Databases, Extracting Files, Other Sources
- Transforming Data: Columns, Rows, Table Sorting, Value Changes, Unpivoting, Transposing
- Creating Custom Columns and Introduction to M
- M Language: Writing, Understanding, and Application
- Working with Multiple Queries and External Data Sources
- Appending and Merging Queries
Appendix: Power Query Recipes, Calculations, Table Transformations, Web Data Integration.
Course offered by University and available through CourseHorse. Categories include Data Analysis, Business Intelligence, DAX, Data Transformation, Data Modeling, Power Query, ETL, and SQL Server Analysis Services.
Syllabus
Taught by
Tags
