You are tasked with: A PROJECT ON POWER BI AND AI BUILDER:
Github for the assignment is : Entire project assignment/tasks are in this github link below:
https:
github.com/amynic/oxford-analytics-session
· Task 1: Explore the Public Transport Journeys by Type of Transport - London Datastore open dataset to understand types of journeys people are making around London using Power BI.
· Task 2: Add a page to the Power BI report shared with Tailwind Traders in round one of investigations
· Task 3: Recreate the forms recognizer solution for analysing Tailwind Traders receipts and invoices with no-code using AI Builder and build this functionality into a Power App/Power Automate
· Optional: explore https:
api.tfl.gov.uk to see if you can connect any further transport and activity patterns around London for Tailwind Traders
Detailed Description
Task 1:
Explore the Public Transport Journeys by Type of Transport - London Datastore open dataset to understand types of journeys people are making around London using Power BI
What you need to do:
  •   Dataset is open data and available here: Public Transport Journeys by Type of Transport - London Datastore
  •   Bring that data into Power BI as another dataset into the cu
ent Power BI findings
  •   Investigate the data, share 3 insights you learnt from the dataset and 2 project recommendations Tailwind Traders could work on
Task 2:
Add a new page to the Power BI report shared with Tailwind Traders Business Stakeholders in round one of investigations
What you need to do:
  •   Add a new page to the Power BI Business Stakeholders report
  •   Keep consistency within the report and add your 3 insights to tell the story to the business
Task 3:
Recreate the forms recognizer solution for analysing Tailwind Traders receipts and invoices with no-code using AI Builder and build this functionality into a Power App
What you need to do:
  •   Use the datasets available here to train your invoice model: training/testing
  •   Use AI Builder to create a forms recognizer model to understand Tailwind Trader Invoices
  •   Test your model with 3 different test invoices provided
  •   Publish your model within AI Builde
  •   Build your Invoice Model into a Power App:
    o   Where a Tailwind Traders employee can take a picture/upload an invoice
    o   The invoice gets analysed by your AI Builder model and extracts all data from the invoice
    o   Saves the invoice data digitally in a simple table
  •   Test your app on new data. Record the screen running through your application and showing each step above is completed
Advanced (optional):Â NOTE: THIS IS NOT REQUIRED BUT IF YOU GET TIME AND SOLUTION IS AVAILABLE YOU CAN PROVIDE ELSE SKIP.
  •   Explore https:
api.tfl.gov.uk to see if you can connect any further transport and activity patterns around London for Tailwind Traders
What to submit:
· Task 1:
· They should build on the .pbix file linked in the exercise and submit the PBIX file with filename: task1-powe
i-
.pbix
· Also a text document with filename task1-document-.docx containing the 3 insights and 2 project recommendations explained
· Task 2:
· They should build on the .pbix file linked in the exercise and submit the PBIX file with filename: task2-powe
i-.pbix
· Task 3:
· Record the screen running through your application and showing each step in the task is completed with filename: task3-video-.mp4
What all files I need from this project is:
a) PBIX File for Task 1
) PBIX File for Task 2
c) MP4 video of each step in Task 3.
NOTE:
a) Slides and datasets are also in github.
) There is no programming needed through out the TASK 1,2 & 3.
c) Tools needed are POWER BI and AI Builder.
d) Advanced (Optional): You can skip due to time deficiency…
e) Kindly look all details of this assignment in github link provided in beginning of this document.
PAGE
1