Description
COURSE DESCRIPTION
This course takes up where the Optima Train Excel 2013 Pivot Tables and Pivot Charts course leaves off. It has two primary themes, each ultimately related to data analysis with pivot tables. First, it teaches you a number of methods for importing external data (from a database, text files, or other sources) into Excel for analysis. Second, it devotes considerable time to the PowerPivot add-in originally introduced with Excel 2010 and now included (with a new look) in Excel 2013. To learn Excel PowerPivot & Advanced Business Intelligence Tools quickly and effectively, download the companion exercise files so you can follow along with the instructor by performing the same actions he is showing you on the videos.
Category: Office Productivity/Microsoft
What are the requirements?
- Microsoft Office 2013
What am I going to get from this course?
- Over 4 hours of video content, with corresponding Excel data files for hands-on practice
- 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 the relationship between the Excel Data Model and the PowerPivot add-in, as well as Microsoft’s marketing strategy in Excel 2013
- An understanding of how the new PowerPivot add-in, as part of Microsoft’s “self-service BI” offerings, adds significant power to Excel’s existing data analysis tools
- How to use the (revised) PowerPivot user interface for Excel 2013
- 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
- How the Power View add-in, new to Excel 2013, complements PowerPivot
What is the target audience?
- Any competent Excel users who want to be on the leading edge with Excel’s latest and most powerful data analysis tools
