PowerPivot Data Analyst 1 - What is PowerPivot?
Loading...
Uploader Comments (bjele123)
All Comments (7)
-
@Melchizeedek Just wanted to say that I agree with Bill's points completely. I'd also add that Access can serve two complementary roles with PowerPivot. One is data shaping - transformations etc. PowerPivot offers nothing for that. The other is as a data collection/entry tool, via forms. Either way, the role of Access would be to feed source data into PowerPivot. I'm thinking about doing a blog post soon on "Access vs. PowerPivot." Watch powerpivotpro (it's .com) over the next week.
-
Hello bill,
I followed the instructions as mentioned in your book pg 18 fig 2.2..but I am getting blank dates in date column for 50% of the data. Can you please help me understand why???
-
best piece of software to come out of microsoft in 20 years...quite a statement!
-
Amazing! How do I download this video and the data set?
-
Totally awesome!
3:33
PowerPivot Data Analyst 2 - Importing Data to PowerPivotby bjele1236,250 views- 18:27
Power Pivot Step By Stepby MichaelGannotti6,991 views
- 9:20
Creating a Simple Dashboard - Part 1by ProphetSuite42,312 views
- 5:25
Excel Pivot tables: Basicby hpgetit3,722 views
- 4:33
PowerPivot Data Analyst 6 - Calculated Columnsby bjele1233,995 views
- 4:18
Many VLOOKUP Columns - 1123 - Learn Excel from MrExcelby bjele12312,911 views
- 12:58
PowerPivot in Microsoft Excel 2010by Office2010HK6,533 views
- 27:01
Business Intelligence Demonstrationby DarwinsHamster345,002 views
- 1:34
Microsoft PowerPivot (video 1)by vectorformSurface16,335 views
- 14:58
PowerPivot in Actionby chakkeldey2,327 views
- 7:05
PowerPivot Tutorial 2: How to Create a Linked Tableby RushabhRambhia2,785 views
- 10:59
PowerPivot Tutorial Teil 1by ExcellentControlling1,865 views
- 2:02
PowerPivot Data Analyst 5 - Creating Relationshipsby bjele1234,359 views
- 1:37
Data Analystby thedeticachannel2,815 views
- 4:41
The iPad: What Apple doesn't want u to know.by SoldierKnowsBest6,056,305 views
- 1:11
BMX FLIP TRICKSby hoeltzel1828,791 views
- 3:07
PowerPivot in Excel 2010. How to refresh data.by stevefox19731,400 views
- 6:36
Pivot Macro - Episode 1211by bjele1232,546 views
- 2:31
PowerPivot Data Analyst 4 - Linking Tablesby bjele1234,707 views
- 3:05
PowerPivot Data Analyst 8 - Top 5 Storesby bjele1233,162 views
Hi Bill!
What is the difference between PowerPivot and Microsoft Access? melch
Melchizeedek 5 months ago
@Melchizeedek 1 PowerPivot offers the DAX formula language that allows complex calculations that Access can not do. 2 PowerPivot offers the ability to create professional looking web apps by publishing to SharePoint or to HostedPowerPivot. 3 PowerPivot lets data analysts use the rich Excel front-end that they already know. 4 PowerPivot consumes more data types, 5 World-class vertical compression of the data improves speed over Access
bjele123 5 months ago