Analyzing Covid-19 data with Power BI
What you'll learn
- Power BI, DAX, Python visualizations in Power BI
- A basic idea of Power BI is sufficient. We have used project based approach to teach basic concepts.
- Basically, this is a beginner + intermediate1 level course on the scale of - beginner, intermediate1, intermediate2, advanced1, advanced2
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.
Who this course is for:
- Power BI students, Business intelligence students
I'm a Senior Consultant in one of the MNCs. I hold a masters degree in computer science and I like to share the knowledge while learning from others. Udemy has provided a good opportunity to do this with their platform and I hope to share good quality material here.
Working as a BI consultant in a MNC, having 6+ years of industry experience, having done multiple live projects in various domains like Manufacturing, Mining, Retail, Investment, Insurance etc. utilizing various ETL and reporting tools such as Power BI(Certified), Tableau(Certified) , SSRS, SSIS and Alteryx. Looking forward to share my knowledge with other aspiring techies.