Download - PowerPivot & QlikView 101
![Page 1: PowerPivot & QlikView 101](https://reader035.vdocuments.us/reader035/viewer/2022062323/56816404550346895dd5a990/html5/thumbnails/1.jpg)
PowerPivot & QlikView 101
Alex WhittlesBusiness Intelligence Consultant
Purple Frog Systems
www.PurpleFrogSystems.com/blogTwitter: @PurpleFrogSys
![Page 2: PowerPivot & QlikView 101](https://reader035.vdocuments.us/reader035/viewer/2022062323/56816404550346895dd5a990/html5/thumbnails/2.jpg)
Alex Whittles
Business Intelligence ConsultancyDimensional Modelling Data QualityData Warehousing ETL Systems OLAP Cubes Reporting Systems
• Runs SQL Server User Group in Birmingham www.SQLMidlands.com
• Studying MSc in Business Intelligence
• Runs Purple Frog BI Consultancy
![Page 3: PowerPivot & QlikView 101](https://reader035.vdocuments.us/reader035/viewer/2022062323/56816404550346895dd5a990/html5/thumbnails/3.jpg)
Self Service BI
• Puts user in control• Greater agility• Faster results
Why?• Lack of data governance• Different versions of truth• Complex source systems
Why Not?
PowerPivot QlikView
![Page 4: PowerPivot & QlikView 101](https://reader035.vdocuments.us/reader035/viewer/2022062323/56816404550346895dd5a990/html5/thumbnails/4.jpg)
Self Service BI
PowerPivot QlikView
![Page 5: PowerPivot & QlikView 101](https://reader035.vdocuments.us/reader035/viewer/2022062323/56816404550346895dd5a990/html5/thumbnails/5.jpg)
Demo
PowerPivotVs
QlikView
![Page 6: PowerPivot & QlikView 101](https://reader035.vdocuments.us/reader035/viewer/2022062323/56816404550346895dd5a990/html5/thumbnails/6.jpg)
Which One’s Best?
PowerPivot QlikViewGetting Started Very Quick Slow
Data Layer Great Poor
Intuitive? Yes (It’s Excel!) No
Formatting Conditional Formatting Expressions required
Expressions DAX QlikView Expressions
Dashboard Capability Limited Extensive
Server Hosting SharePoint QlikView Server
![Page 7: PowerPivot & QlikView 101](https://reader035.vdocuments.us/reader035/viewer/2022062323/56816404550346895dd5a990/html5/thumbnails/7.jpg)
Download Codehttp://www.purplefrogsystems.com/blog/2011/10/sqlbits-9-session-powerpivot-and-qlikview-101
![Page 8: PowerPivot & QlikView 101](https://reader035.vdocuments.us/reader035/viewer/2022062323/56816404550346895dd5a990/html5/thumbnails/8.jpg)
PowerPivot & QlikView 101
[email protected] www.PurpleFrogSystems.com Twitter: @PurpleFrogSys www.PurpleFrogSystems.com/blog