#FREE Data Modeling with Excel Power Pivot #Business #Excel

Aggregating and analyzing data from different sources is made easy with Excel’s Power Pivot plugin. But before you can glean insights from your data, you’ll need to know how to build an effective data model, or collection of tables. In this course, Ron Davis covers all the steps for data modeling with Excel: adding data sources, setting up relationships between tables, and configuring hierarchies. Additionally, he explores the power of DAX, the language behind the calculated columns and calculated fields that make for powerful PivotTables.

LEVEL –  Intermediate

COURSE TOPICS:

Data modeling concepts and terminology
Exploring the Power Pivot interface
Adding data sources
Working with date tables
Understanding perspectives and key performance indicators (KPIs)
Getting started with DAX syntax
Understanding evaluation context

READ MORE

LEARN THIS COURSE FOR FREE *10 days of free unlimited access to “Data Modeling with Excel Power Pivot”

Instructor’s Welcome Note:

– Hi, I’m Ron Davis, and we’re going to look at Data Modeling with Excel PowerPivot. In this course, we’re going to look at how you source data, bring it into the data model, then once it’s in there, you’re going to join it together by creating relationships. Further, we’ll then take our tables and add calculative fields and calculative columns to them. We’ll expand on out, and we’ll explain to you things such as evaluation context.
We’ll go in and we’ll look at how to create certain DAX expressions so that you can create very powerful Pivot tables. Now let’s get rolling on Data Modeling with Excel PowerPivot.

 

 

Get 10 days of FREE unlimited access to Lynda.com.

Data Modeling with Excel Power Pivot
Business Intelligence T
Ron Davis tutorials
Lynda review

from Course reviews, freebies, coupons http://www.coursetag.com/free-data-modeling-with-excel-power-pivot-business-excel/