Help with Project The project entails using Power BI to analyze and report on data from the open payments website:...

Help with Project

The project entails using Power BI to analyze and report on data from the open payments website: https://openpaymentsdata.cms.gov/about　(Links to an external site.)Links to an external site.

Data file -- classprojectdata.csv

The data provided to you is for research payments in 2017 -- the columns in the original file are described in the data dictionary -- OpenPaymentsDataDictionary.pdf　-- in Appendix D, but the file provided in this assignment has been modified to reduce the number of columns and make it easier to work with as a class project　

The task:

1. Choose two of the following questions to explore:

• Where are the research dollars flowing in healthcare? -- Can you find common factors by analyzing the type of drug, device, company, hospital, or therapeutics?
• Which diseases are being ignored?
• Which physician specialties are the most and least popular in terms of investment and what implications does that have for the future?
• Can you identify areas of concern or gaps in healthcare research spending?
• Can you identify opportunities for investment and areas of over spending?

1. Create appropriate reports to provide meaningful insights into your chosen questions

Submit:

1. Power BI workbook (.pbix) with the visualizations you created.
2. A PowerPoint file that contains:
3. Screen shots of each report/visualization
4. Summary description of each report/visualization - describe the purpose of each report -- which question is being explored -- interesting features or insights
5. Summary description of the dashboard - how a user should interact with it to explore the data
6. Overall summary that lists each question you explored and the insights that you obtained from the analysis

Grading criteria:

• Relevance (analysis relates to the problem statement)
• Completeness (thoroughness of the analysis)
• Depth (sophistication of the analysis)
• Consistency (conclusions consistent with the analysis)
• Interest (unique/unexpected approach or insights

Please let Me know where to send Attachments