Report using Power Bi software

Use Power BI desktop to connect the files in the attached folder:

  • Dealer File <- info on dealers
  • Enrollment <- what dealers are enrolled in
  • InsightProviderPerformance <-web metrics
  • DigAd files from Providers <- digad metrics

Once you have connected the data to power bi and created a relational data model, use your analytical skills to provide 2 to 3 reports within power bi and subsequent insights into dealers, providers, enrollment and metrics


  1. Does enrollment data match the web and digad data?
  2. Do certain groups of dealers or providers stand out?
  3. Show off your DAX skills with some measures. Extra credit for time intelligence measures!
  4. Remember that reports are often utilized across accounts. Your steps and data model should be clear and concise.

sample Report is attached too