Then we will look at basics such as: filtering, exploring, relationships, perspectives, slicers and drill through. Next we will look at how to format Pivot Tables, explain the differences between Calculated Fields and Columns and then how to hide and refresh our data. In this course we'll start looking at the visual differences between Power Pivot 20.Then move into creating our first Power Pivot Workbook and Pivot Table. Then we will look at importing data from other Data Connections and combining them together within a Power Pivot Workbook.
Then we will take a look at Data Models and how they fit within Power Pivot 2013.We’ll then see types of Data Models and how they relate to Data Connections and how SQL Query Designer can be used as a Data Modeling Tool. Leading us into what is a Pivot Table, configuring and enabling Power Pivot 2013 and finalizing with platforms that support Power Pivot. In the course will be introduced to Power Pivot 2013, what it is, what is new to Power Pivot 2013 and its place in Business Intelligence arena.
0 kommentar(er)
