<p>In this article I am going to talk about getting data and doing transformations and Visualization in Power BI.</p>
<blockquote>
<p>Energy consumption by source, World:</p>
</blockquote>
<iframe src="https://ourworldindata.org/grapher/energy-consumption-by-source-and-country?stackMode=absolute&amp;tab=chart" style="width:100%;height:600px;border:0px none"></iframe>

<hr />
<h1 id="heading-get-data">Get data</h1>
<p><img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1714031895000/ccff1c4d-03d3-49c8-b2f9-c7aecc2e1bda.png" alt class="image--center mx-auto" /></p>
<h1 id="heading-bronze-transformations">Bronze transformations</h1>
<p>None</p>
<h1 id="heading-silver-transformations">Silver transformations</h1>
<p>Unpivot columns</p>
<p><img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1714032744147/d541ff6a-bbf6-41b8-9dea-e49ba4e2fe00.png" alt class="image--center mx-auto" /></p>
<h1 id="heading-load-data">Load data</h1>
<p>close and apply in power query editor.</p>
<h1 id="heading-visualization-in-power-bi">Visualization in Power BI</h1>
<p><img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1714034623711/20ea354d-cca8-4e17-a30c-ed5c8e220449.png" alt class="image--center mx-auto" /></p>
<h1 id="heading-conclusion">Conclusion</h1>
<p>Learning Objectives,</p>
<ol>
<li><p>Ingest data</p>
</li>
<li><p>Medallion architecture</p>
</li>
<li><p>Transformations in Power Query</p>
</li>
<li><p>Visualization in Power Query</p>
</li>
</ol>
<h1 id="heading-source-energy-mix-linkhttpsourworldindataorgenergy-mix">Source: Energy Mix [<a target="_blank" href="https://ourworldindata.org/energy-mix">Link</a>]</h1>
<h1 id="heading-author-dheeraj-yss">Author: Dheeraj. Yss</h1>
<h1 id="heading-connect-with-me">Connect with me:</h1>
<ul>
<li><p><a target="_blank" href="https://twitter.com/yssdheeraj">My Twitter</a></p>
</li>
<li><p><a target="_blank" href="https://www.linkedin.com/in/dheerajy1/">My LinkedIn</a></p>
</li>
<li><p><a target="_blank" href="https://github.com/dheerajy1">My GitHub</a></p>
</li>
<li><p><a target="_blank" href="https://dheerajy1.hashnode.dev/">My Hashnode</a></p>
</li>
</ul>


In this article I am going to talk about getting data and doing transformations and Visualization in Power BI.

> Energy consumption by source, World:

<iframe src="https://ourworldindata.org/grapher/energy-consumption-by-source-and-country?stackMode=absolute&tab=chart" style="width:100%;height:600px;border:0px none"></iframe>

---

# Get data

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1714031895000/ccff1c4d-03d3-49c8-b2f9-c7aecc2e1bda.png align="center")

# Bronze transformations

None

# Silver transformations

Unpivot columns

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1714032744147/d541ff6a-bbf6-41b8-9dea-e49ba4e2fe00.png align="center")

# Load data

close and apply in power query editor.

# Visualization in Power BI

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1714034623711/20ea354d-cca8-4e17-a30c-ed5c8e220449.png align="center")

# Conclusion

Learning Objectives,

1. Ingest data
    
2. Medallion architecture
    
3. Transformations in Power Query
    
4. Visualization in Power Query
    

# Source: Energy Mix \[[Link](https://ourworldindata.org/energy-mix)\]

# Author: Dheeraj. Yss

# Connect with me:

* [My Twitter](https://twitter.com/yssdheeraj)
    
* [My LinkedIn](https://www.linkedin.com/in/dheerajy1/)
    
* [My GitHub](https://github.com/dheerajy1)
    
* [My Hashnode](https://dheerajy1.hashnode.dev/)

OWID ETL & Visualization in Power BI

Get data

Bronze transformations

Silver transformations

Load data

Visualization in Power BI

Conclusion

Source: Energy Mix [Link]

Author: Dheeraj. Yss

Connect with me: