<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Hardik Joshi on Medium]]></title>
        <description><![CDATA[Stories by Hardik Joshi on Medium]]></description>
        <link>https://medium.com/@harijos?source=rss-dcf77c0658fd------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*EuOoP0xeLjgXh1lLlBV4bA.jpeg</url>
            <title>Stories by Hardik Joshi on Medium</title>
            <link>https://medium.com/@harijos?source=rss-dcf77c0658fd------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 22:13:01 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@harijos/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[How I created a fantasy game week dashboard with Power BI]]></title>
            <link>https://medium.com/@harijos/how-i-created-a-fantasy-game-week-dashboard-with-power-bi-b4efcce3f854?source=rss-dcf77c0658fd------2</link>
            <guid isPermaLink="false">https://medium.com/p/b4efcce3f854</guid>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[fantasy-football]]></category>
            <category><![CDATA[api]]></category>
            <category><![CDATA[football]]></category>
            <dc:creator><![CDATA[Hardik Joshi]]></dc:creator>
            <pubDate>Tue, 22 Sep 2020 15:18:07 GMT</pubDate>
            <atom:updated>2020-09-22T15:18:07.817Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DfrTLBhAw57BJ_ehjCXYkw.png" /><figcaption>FPL Player performance dashboard</figcaption></figure><p>So your mate got you signed up for a fantasy league? Don’t know who to select into your team for the coming game week?</p><p>The problem starts when you know you don’t have enough time to watch all the league games. On top of that, you are a nerd and you are excited about the number crunching. Let me show you how you can setup an FPL control centre to take you to the top!</p><p>This is what you will need:</p><ul><li><strong>Familiarity with APIs. (/Postman)</strong></li></ul><p>Start by scraping the FPL website. Chrome inspect tool will reveal all you need to know. To test out your requests/authentication, power them up in a tool like Postman. This is what you should be aiming for:</p><blockquote>Its important to stay classy and not bombard the FPL website</blockquote><figure><img alt="FPL Api call on Postman" src="https://cdn-images-1.medium.com/max/933/1*mtaf2ISvlvUw2JMh2yLFsA.png" /></figure><p>This is an example curl code:</p><pre>curl --location --request GET &#39;https://fantasy.premierleague.com/api/bootstrap-static/&#39; \</pre><pre>--header &#39;accept-encoding: gzip, deflate, br&#39; \</pre><pre>--header &#39;accept: */*&#39; \</pre><pre>--header &#39;authority: fantasy.premierleague.com&#39; \</pre><pre>--header &#39;scheme: https&#39; \</pre><pre>--header &#39;sec-fetch-dest: empty&#39; \</pre><pre>--header &#39;sec-fetch-mode: cors&#39; \</pre><pre>--header &#39;sec-fetch-site: same-origin&#39; \</pre><pre>--header &#39;dnt: 1&#39; \</pre><pre>--header &#39;user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.121 Safari/537.36&#39; \</pre><pre>--header &#39;accept-language: en-GB,en;q=0.9,nl;q=0.8,en-US;q=0.7&#39; \</pre><pre>--header &#39;Authorization: Basic ***&#39;</pre><ul><li><strong>Knowledge of DAX queries</strong></li></ul><p>Once you have got your queries running, translate them into DAX. DAX is Power BI’s star product differentiator. Your DAX code to query the fantasy REST API could look something like this:</p><pre>let<br>    Source = Json.Document(Web.Contents(&quot;<a href="https://fantasy.premierleague.com/api/bootstrap-static/">https://fantasy.premierleague.com/api/bootstrap-static/</a>&quot;)),<br>    #&quot;Converted to Table&quot; = Record.ToTable(Source),<br>    Value = #&quot;Converted to Table&quot;{5}[Value],<br>    #&quot;Converted to Table1&quot; = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)<br>in<br>    #&quot;Converted to Table1&quot;</pre><ul><li><strong>Knowledge of data modelling and visualization in Power BI</strong></li></ul><p>Build a suitable data model and KPIs. The end result should look like this:</p><p>This is what the end result looks like. (Stuck somewhere? get in touch!)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DfrTLBhAw57BJ_ehjCXYkw.png" /><figcaption>FPL Player performance dashboard</figcaption></figure><p>Next time we can discuss how to build a historical performance chart and move towards predictions:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vRFvZyxEl74mttueXhDemg.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b4efcce3f854" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>