Join Ron Davis for an in-depth discussion in this video Power Pivot and Excel, part of Microsoft Business Intelligence Stack in Depth.
…Power Pivot and Excel.…In the last chapter, we looked at Tabular Model.…Power Pivot is the desktop version of the Tabular Model.…The main difference is the size of the database.…In Power Pivot and Excel, I can go up to two gigs.…Now, we do compress all that information, but…that's the size limitation I have on Excel,…whereas on the Tabular, it's practically unlimited, only by your memory.…So, everything you learned over in Tabular applies here in Power Pivot.…
Let's go and import some data.…I'm on the Power Pivot tab and I'm going to click manage and…let the Power Pivot open up.…Now I'm going to click get external data, and…you see here's my different selections.…I can go from database, from a service, from other sources.…And if I click other sources, that should look pretty familiar.…It was the exact same set of drivers, or…connections, that I had over when I was in Tabular.…
Let's close that.…External Data > From Database > From Analysis Services or Power Pivot.…And now I'm going to give it a name.…So dot, we all remember is localhost, slash.…
- Working with data sources and data views in SQL
- Understanding the star and snowflake database schemas
- Working with the SQL 2012 semantic model (aka tabular mode)
- Using Data Analysis Expressions (DAX)
- Using Excel Web Parts to connect to spreadsheets
- Building dashboards with key performance indicators (KPIs) and reports
- Understanding the Microsoft data-mining process
Skill Level Intermediate
Microsoft Business Intelligence Stack Fundamentalswith Ron Davis43m 39s Intermediate
1. The Traditional Multidimensional Model
2. The New Tabular Model
3. Basic Power Pivot
4. SharePoint Excel Services
5. Basic PerformancePoint
6. SharePoint Visio Services
7. Data Mining and Predictive Analytics
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.