Excel 2010 PowerPivot & Advanced Business Intelligence Tools
Enter the very hot world of BI, Power Pivot, DAX, and big data. This investment of your time is a no brainer.
4.26 (64 reviews)
575
students
4 hours
content
Feb 2016
last update
$19.99
regular price
What you will learn
An understanding of relational databases, a great source for pivot tables, and how queries can be used to import the data you need
How to import data from various relational sources into Excel with Microsoft Query
An understanding of how the new PowerPivot add-in adds significant power to Excel’s existing data analysis tools
How to use the PowerPivot user interface for Excel 2010
How to import data into PowerPivot and how to use PowerPivot to create relationships between relatable tables
How to build pivot tables from PowerPivot data
How to use the DAX language in PowerPivot to create calculated columns and measures, and why DAX is so powerful
How to create named sets, hierarchies, and KPIs (key performance indicators) with PowerPivot
How PowerPivot is related to OLAP cubes
531366
udemy ID
6/18/2015
course created date
3/22/2020
course indexed date
Bot
course submited by