sharepoint 2013 to empower end users - atsip 2013 to empower end users ... power view is an...
TRANSCRIPT
SHAREPOINT 2013 TO EMPOWER END USERS
Manoj Manda SharePoint Administrator
&
Mark VerretNetwork/Security Administrator
What Is SharePoint?
People use SharePoint for different aspects.
If you ask them? Different Answers
SharePoint is a Web application platform developed by Microsoft. SharePoint can be used to provide intranet portals, document & file management, collaboration, social networks, extranets, websites, enterprise search, and business intelligence.
Most Organizations use SharePoint to create websites. You can use it as a secure place to store, organize, share, and access information from almost any device. All you need is a web browser, such as Internet Explorer, Chrome, or Firefox.
SharePoint 2013 Versions
SharePoint 2013 Foundation
SharePoint Server 2013 Standard
SharePoint Server 2013 Enterprise
SharePoint Online in office 365(Cloud)
SharePoint Server 2013 Enterprise Business Intelligence Features
Excel Services
PowerPivot
Power View
PerformancePoint Services
Reporting Services
SharePoint 2013 Installation
Planning (Very Important) Windows Server
– Windows 2008 R2 SP1 or Windows 2012
• Standard, Enterprise, or Data Center
• 64 bit only
SQL Server
– 2008 R2 Service Pack 1
• Standard, Enterprise, or Datacenter
– 2012
• Standard, BI, or Datacenter
– 2012 SP1 required for Business Intelligence bits
– Remember this is where your performance comes from!
SharePoint 2013 Production Hardware• 100 GB C: Drive
– Windows
– SharePoint root
– All of those hotfixes & service packs for the next few years
– Some SharePoint operations spool here
• X GB second drive
– Move all possible files here (logs, etc.)
– All servers must have the same drive letters
• 4 cores
• Memory
– 12 GB for production servers in 3 tier topology
– 24 GB for all-in-one test or dev
– 8 GB for test or dev Foundation
• Gigabit Ethernet
– All servers must have less than 1 ms of latency to each other
SharePoint 2013 InstallationTwo Options
1. User Interface
Additional Steps for Advanced Features
2. Power Shell Script
AutoSPInstaller
Additional Steps for Advanced Features
– Reporting Services
– PowerPivot
– Workflow Manager 2013
SharePoint 2013 Central AdministrationThis is where you manage your sites, content databases, Farm Administrators, Farm & Site Backups, Monitor , Services etc.
SharePoint Permissions
Permissions Plays a Vital Role in SharePoint Roles- Owner, Contributor, Visitor Etc
Different level of Permissions within a Site, library or list
Permissions for BI Content for Displaying data Service account
Per User based (User must have access to Data Source) Via Kerberos authentication
DAX(Data Analysis Expression) Query is used to query the Model
SharePoint Excel Services - BI FeatureShared service that allows you to directly publish Excel 2013 workbooks to SharePoint sites
SharePoint Excel Services
Enables us to view and interact with published Excel workbooks in a browser with out the need of Excel client on the machine
SharePoint Excel Services – Centralized Management
Power View in SharePoint Power View is an interactive data exploration, visualization, and
presentation experience.
Power View is a feature of
• Microsoft Excel 2013
• Microsoft SharePoint Server 2010 and 2013 as part of the SQL Server 2012 Service Pack 1 Reporting Services Add-in for Enterprise Edition Only.
Power View in SharePoint
Explore, visualize and share insights with Power View
Interactive, browser-based, ad-hoc data exploration for gathering insights
Rich data visualizations bar, line, pie and trellis charts, mapping and animations for identifying patterns and trends
Power View in SharePointExplore, visualize and share insights with Power View
Advanced filtering capabilities enable powerful analysis
SharePoint Power View Smart Querying
• End user must have permissions to access data from Data Source (SQL DB, Analysis Server etc.)
• Enables us to filter data
Example - Same Report but data filtered as per the user accessDOTD Has access to all data(Right)Agency has access to their data(Bottom Slides)
SharePoint Power View
Export to PowerPoint for presentation
Demo SharePoint - Helpdesk
SharePoint Community Site
Distributing Interactive Reports Using SharePoint 2013
Downloadable Excel reports
View Excel reports online in a browser
Power View reports(Queried against the data source which gives you the most updated information-At HSRG ETL runs every 7 days, Secure as login required, Data can be filtered)
Can edit or create reports (Require permissions)
Reports can be printed, saved to SharePoint libraries, exported to PowerPoint
Questions ?
Manoj Manda
Email: [email protected]
http://hsrg.lsu.edu
Mark Verret
Email: [email protected]
http://hsrg.lsu.edu