<p>When you see Power Pivot for the first time it can be confusing.&nbsp; It’s a new interface, with new ribbons and views.&nbsp; Before you start working with tables of data and complex models, you need to get comfortable with the user interface.&nbsp; </p>
<p>In this article, we will take a look around Power Pivots user interface so you get a good orientation.</p>
<h2><strong><em>Power Pivot user Interface Orientation</em></strong></h2>
<p>At any stage when you are in an Excel workbook, you can
open power pivot by selecting Manage from the Power Pivot Ribbon.</p>
<center><img src="https://theexcelclub.com/wp-content/uploads/2019/06/1.0.png" alt="Power Pivot Orientation" class="wp-image-1745"/></center>

<ol><li>When you are in Power Pivot, you can switch
back to the workbook by pressing the excel symbol on your quick access toolbar</li><li>Power Pivot contains 3 ribbons.&nbsp; The Home ribbon, Design ribbon and Advanced.</li><li>Column name box contain a drop down which
lists all the columns in the current table.&nbsp;
By selecting one of these, you will jump to that column</li><li>Formulas, such as calculated columns and
measures are carried out in the formula bar</li><li>Column headers on power pivot tables contain
filters so you can quickly look at subsets of your data.&nbsp; </li><li>The calculation area is used to create
measures, you will learn about these in a later section.&nbsp; The calculation area can be turned on or off
from the home ribbon</li><li>The tabs show the different tables of data
available in the workbook.&nbsp; You can use
these to quickly switch between tables.</li></ol>
<center><img src="https://theexcelclub.com/wp-content/uploads/2019/06/1.1.png" alt="How to use PowerPivot" class="wp-image-1746"/></center>

<h2>Switching Between Views</h2>
<p>You can also switch between views.&nbsp; The image above that we have looked at in detail is known as the data view and is the default view.&nbsp; Views can be found on the Power Pivot Home ribbon</p>
<center><img src="https://theexcelclub.com/wp-content/uploads/2019/06/2.png" alt="Excels PowerPivot" class="wp-image-1747"/></center>

<ul><li>Diagram view is used for viewing and setting up relationships and hierarchy.</li><li>Show hidden will ensure all tables are visible</li><li>Calculation area will turn on or off the calculation area in the power pivot window.</li></ul>
<h2>Power Pivot Ribbons</h2>
<center><img src="https://theexcelclub.com/wp-content/uploads/2019/06/3.png" alt="PowerPivot home ribbon" class="wp-image-1748"/></center>

<p>The Home Ribbon in Power Pivot includes commands for </p>
<ul><li>Getting External data</li><li>Formatting</li><li>Sort and Filter</li><li>Quick calculations</li><li>View</li></ul>
<center><img src="https://theexcelclub.com/wp-content/uploads/2019/06/4.png" alt="Power Pivot design ribbon" class="wp-image-1749"/></center>

<p>The Design Ribbon includes commands for:</p>
<ul><li>Adding DAX functions and setting calculation options</li><li>Setting up and managing relations</li><li>Setting table properties and dates tables</li></ul>
<center><img src="https://theexcelclub.com/wp-content/uploads/2019/06/5.png" alt="PowerPivot advanced robbon" class="wp-image-1750"/></center>

<p>The Advanced Ribbon will allow you update</p>
<ul><li>Perspectives </li><li>Reporting Properties</li></ul>
<center><img src="https://theexcelclub.com/wp-content/uploads/2019/06/6-1.png" alt="" class="wp-image-1752"/></center>

<p>There is also a Power Pivot Ribbon in the Excel interface.  From here you can:</p>
<ul><li>Access the Power Pivot user Interface</li><li>Add measure and KPIs</li><li>Add Excel data to the Power Pivot Model</li><li>Detect relationships</li></ul>
<h2>Power Pivot Orientation Video </h2>
<div class="wp-block-embed__wrapper">
https://youtu.be/12QeK5UVA8Q
</div>
<h2>Learn and Earn Activity</h2>
<p>If you are not familiar with the PowerPivot user interface, take some time now to open Excel and take a look around Power Pivot.  The Power Pivot user interface can be accessed via the PowerPivot Ribbon in Excel.</p>
<p><strong><em>In the comments section below let me know how much experience you have with Power Pivot and what you have used it for in the past or what you are looking forward to using it for in the future.</em></strong></p>
<h4><strong>Sign up for my newsletter – Don’t worry, I won’t spam. Just useful Excel and Power BI tips and tricks to your inbox</strong> with Earn and Learn activities.</h4>
<div class="wp-block-button aligncenter"><a class="wp-block-button__link" href="https://theexcelclub.newzenler.com/f/sign-up-for-newsletter">SIGN UP NOW</a></div>
<div class="wp-block-columns has-2-columns"><div class="wp-block-column"><center><img src="http://theexcelclub.com/wp-content/uploads/2019/05/steem.png" alt="learn and earn steem activity" class="wp-image-1604"/></center></div>
<div class="wp-block-column"><p style="text-align:center"><strong>Now there is value in Learning with The Excel Club and our Learn and Earn STEEM activities.  </strong></p>
<p><strong>We are the first Excel, PowerBI and DAX blog in the world where you can Earn while you Learn.</strong></p>
<p style="text-align:center" class="has-medium-font-size"><a href="https://theexcelclub.com/learn-and-earn-steem-activities/">Find out more now and start earning while you are learning Excel and Power BI</a></p>
</div>
</div>
 <br /><center><hr/><em>Posted from my blog with <a href='https://wordpress.org/plugins/steempress/'>SteemPress</a> : http://theexcelclub.com/power-pivot-orientation/ </em><hr/></center>