Data Mining Assignment 2 with OData…

Data Mining Assignment 2 with OData

Complete the following exercises with Power BI.

Import Product Data from Excel

  1. Review for practice
  2. Make a screen print showing you complete import and data steps using the Excel spreadsheet.
  3. Make several screen prints showing you created visualizations.

Import Order Data from OData Feed

  1. Complete the steps to import an OData Feed into Power BI.
  2. Make screen prints of your Data, Queries, and Relationships. 
  3. Review the relationships between the tables for your analysis.

In MS Word, explain the purpose of using OData. You will also need to discuss the Data and Relationship options with this OData model. What tables are connected to the Orders table.

Also, generate at least three new visuals showing valuable information for the measurements and fields. Explain what each of these visualizations represent in at least two paragraphs per output.