Power Pivot Excel 365 - From Zero to Hero

Partner: Udemy
Affiliate Name:
Area:
Description: This course has been designed to take novice, Powerpivot users, to a level where they are comfortable working with Power Pivot Models, using Pivot tables and charts along with carrying out DAX calculations and using DAX time intelligence functions.Power Pivot is an Excel add-in, available in Excel 2010 and certain versions of Excel 2013 and later. You can use Power Pivot, with its own DAX functions to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.  Power Pivot is the gateway to business intelligence and data all within Excel.This course consists of 5 modules, each with learning activities, and workbooks to download.  To make sure you get the most out of this course, the learning material is made up of both videos and articles to reinforce what is covered.Module 1Get your head around the basics of Powerpivot, learn how to link a table, and work with that table and find out how you can get data into PowerPivot to work with it. If you are new to Power Pivot this module will show you around, so you become more familiar with the user interface and become more confident adding data to a power pivot model.· What is Power Pivot?· How do I create a linked table from Excel to Power Pivot?· What other ways can I get data into Power Pivot?· How do I find my way around Power Pivot?· How do I work with tables in Power Pivot?·Module 2Powerpivot allows you to perform calculations across different tables of data. In order to do this, you must link the tables together by means of relationships. Relationships can be difficult to understand at first and they are a big change to working in Excel. In this module, you will learn· What are relationships?· How do I create a relationship in PowerPivot?· How do I
Category: Business > Business Analytics & Intelligence > Power Pivot
Partner ID:
Price: 149.99
Commission:
Source: Impact
Go to Course