Please log in to access your purchased courses.
Please log in to access your purchased courses.
Learn how to get data from REST APIs in Power BI using Power Query!
This is what you will learn:
Introduction to the API
- Emphasizing the significance of reading API documentation
- Exploring the basics of API navigation
Exploring API Basics
- Unpacking the RESTful interface of the UN API
- Conducting direct API tests without additional tools
- Extending the base URL with different endpoints for queries
API Versions and Status Codes
- Differentiating between multiple API versions
- Understanding common HTTP status codes for effective debugging
Decoding API Response Structure
- Analyzing the structure of API responses
- Identifying key components such as page number, size, and data
Working with Indicators and Topics
- Categorizing API data into indicators and topics
- Mastering querying and filtering techniques for targeted data retrieval
Crafting Specific Queries
- Demonstrating how to create tailored queries for indicators and countries
- Combining multiple indicators and countries in a single query
Handling Pagination
- Understanding pagination mechanisms within the API
- Navigating through pages of results efficiently
Practical Application with Power BI
- Utilizing Power BI for importing and transforming the data from the API
- Addressing pagination challenges
Advanced Data Manipulation Techniques
- Merging data with UN IDs for enhanced data accuracy
- Preparing data for API queries and optimizing query performance
Visualizing Data and Troubleshooting data quality
- Creating insightful visualizations using Power BI
- Identifying and resolving data inconsistencies and issues
Ensuring Data Refresh and Maintenance
- Setting up scheduled data refresh in Power BI Service
- Troubleshooting potential errors and ensuring data integrity
Course outline:
Was this helpful?