March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
05-03-2023 00:57 AM - last edited 05-03-2023 01:00 AM
Hello Everyone,
This is my first ever post to the Data Stories Gallery here on Power BI Community.
CO2 emissions globally are impacting the world in different ways.
I have tried to create some analysis at Region and Country level to see how the impact has been overtime and whether the countries are taking any measures to control their CO2 emissions or are getting worse.
This analysis looks at some insights around -
The data for this analysis has been taken from the freely available data repository on git-hub:
https://github.com/owid/co2-data
Look forward to the valuable feedback from the community members.
Thanks,
Pragati
eyJrIjoiMjk1OTQwNTgtN2Y0Yi00ZWVhLWExMWUtMjRlMjI5ODZkNzBhIiwidCI6Ijk5Y2FmZTRjLWVlYTktNGFhNy1hMzUwLTQ5YzhkNjNhOTE0YiJ9
How can i download the pbix file, unable to locate it pls
HI @pragnas,
The reason you can't download the pbix file is because I haven't given access to my pbix file to public.
If you have any questions regarding the report, data used underlying it, etc., I am happy to answer them here.
Hello.
How have you performed Data Munging ? "Countries Emissions" table can be created as it contains mostly measures but how have you prepared "Countries" table ?
Will be helpful to perform along with you.
P.S : Above attached file isn't available. Can you please look into this.
Hello. Thank you for replying. Actually attached POWER BI Dashboard was not opening before but, now working absolutely fine.
I am asking can you help us how you performed Data Cleaning on the dataset of this project.
how did you do the second multi-rows bar chart?
A very cool dashboard Pragati. But I had two questions, how did you show the top 5 countries for each year ? And the second question is how did you create the emissions overtime for each country ? Thank You.
HI @Preek ,
Answers to your questions below:
Thank you Pragati for your reply
Hi I have 2 doubts
One, how you create the Growth rate year by year
Second, where you can download a table with all coordinates to create the maps
Thanks!
Hi @mariomarin82 ,
Growth Rate is a measure that is caluclated by comparing the current year emissions versus last year emissions.
A measure something like below:
DIVIDE(
([This Year] - [Last Year]), [Last Year], 0
)
It's a standard metric used in different scenarios.
All the data that I have used is on the gitHub repository link that i have shared in the description above. It has got all the demographic information required to create map visuals on the report.