Duration 33:23

PowerBI Tutorial: Investment Screener and ETF Research

431 watched
0
6
Published 10 Sep 2023

For the PowerBI template, free download is located here: www.ptarmy.com/joinus We are going deep into ETF data here with our step-by-step PowerBI tutorial, transforming rich data from Profit.com's API into a powerful one-screen investment research tool. Lots of juicy techniques in here including looping through an api request with custom functions, and company logo images in our visuals. Whether you're an investment pro or just starting, this guide will supercharge your research game. Vids mentioned in THIS vid: Using powerpoint to wireframe your dashboard: /watch/AnehsNAPxb7Ph Creating dynamic time series charts with slicer: /watch/AlZSHiarr0WrS 🎯Timestamps: [00:00] Opening [01:40] Data from Profit.com API [03:00] Our Queries in PowerQuery [07:50] Custom Functions to Loop the API Calls [11:00] Data Overview [14:00] Table Relationships [15:00] Start Designing Dashboard [21:30] Image URLs in Matrix Visual [28:40] Line and Candlestick Charts [

Category

Show more

Comments - 6