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
- Does enrollment data match the web and digad data?
- Do certain groups of dealers or providers stand out?
- Show off your DAX skills with some measures. Extra credit for time intelligence measures!
- Remember that reports are often utilized across accounts. Your steps and data model should be clear and concise.
sample Report is attached too