Covid-19 has hit all of us badly. Its impressions will last forever. It has shutdown businesses, affected economies and without a question, health. We have lost a lot of near and dear ones. To analyze the effects of Covid-19, we have used Power BI. Power BI is a data visualization tool by Microsoft and it has free desktop version. However, to use it professionally, we need to purchase the license. There are two types of license available - pro and premium. Power BI can get data from assorted data sources like databases, flat files, excel files, sharepoint, web etc. It used a basic ETL tool - Power query.

This course is based on the open source datasets of covid-19. The datasets referred here are taken from the 'Our world in data' website and the official website of Irish Government. We have used following tools and technologies in this course - SQL server, Power BI desktop, Power query, Power BI service, Python. We have used SQL server to fetch one of the data-set, Power BI desktop for creation of visualizations, Power query for transformations, Power BI service for publishing the report and Python for Python visuals in Power BI.

I hope you will like our efforts and contributions in this field.