Power BI connection to API + data organization in graphs

This require Power BI experience, DAX and "M" language knowledge. Dashboard should show search engine results of a specific website. The task is: 1. Create a re-usable connection in "M" language for Power BI with API specified here: [login to view URL] 2. Extract required data. 3. Put data in Graphs. (no visual designing needed) ------------------------- 3. Put data in Graphs 1. graph - Slicer filter: [Source: Google|Seznam] 2. graph - Slicer filter: [Tags] 3. graph - Table: [best 10 performing Keywords], [rank difference over selected time period] 4. graph - Table: [worsts 10 performing Keywords], [rank difference over selected time period] 5. graph - Stacked area chart: [Keywords], [Date of record], [Seznam rank], [Google rank] a) for this chart first need to be done grouping into 4 different rankings and assign keywords into these groups: 1-3 rank 4-10 rank 11-21 rank 21+ b) on x-axis will be date of keyword rank record, y-axis will be 100% 6-9. graphs - simple card: total amount of keywords, for each card by rank groups 10. graph - Table: Rank Groups(1-3 rank...), [sum searchs Seznam], [sum searchs Google] Whole idea from 5. graph is to get how many keywords shift over time across rank groups. Desired result is possible to see in atached image. 10. graph should bring a potencial overview, how many searches we cover and how many we are missing. I will assist during task. Deadline is to wednesday 12. 7. 2017 have a finished pbix file.