Site menu
Section categories
| PORTABLE SOFTWARE |
| SOFTWARE |
| SARADADDY REPACK GAMES |
| PC GAMES |
| KIDS GAMES |
| VIDEO TUTORIALS |
| MOVIES |
| ANIMATED MOVIES |
| e-BOOKS |
| Hidden Object Games |
| Dash / Time Management |
| Casino Games |
| MAHJONG |
Statistics
Total online: 1
Guests: 1
Users: 0
Main » 2022 December 12 » Lynda Data Modeling with Excel Power Pivot
19:35:32 Lynda Data Modeling with Excel Power Pivot |
Lynda Data Modeling with Excel Power Pivot  Included Exercise Files Language : English Size : 399,59 Mb 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. Topics include: 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  https://www.filefactory.com/file/7c3463l0uqf9/ |
|
|
| Total comments: 0 | |