• Home
  • Courses
    • Microsoft Technical
      • Microsoft Azure
      • Microsoft Exchange Server
      • Microsoft SQL Server
      • Microsoft SharePoint
      • Microsoft Office 365
      • Microsoft Teams
      • Microsoft Virtualization
      • Microsoft Visual Studio
      • Microsoft Windows Server
      • Microsoft Windows Client
    • Microsoft Office
      • Microsoft Excel-Advanced
      • Microsoft Excel-Basic
      • Microsoft Word-Advanced
      • Microsoft Word-Basic
      • Microsoft Power BI
      • Microsoft Access
      • Microsoft PowerPoint
      • Microsoft Project
      • Microsoft Publisher
      • Microsoft Visio
    • Security
      • CCSA – Check Point Certified Admin
      • CND-Certified Network Defender
      • CSCU – Certified Secure Computer User
      • CEH-Certified Ethical Hacker v11
      • CAST 611-Advanced Penetration Testing
      • CISM – Certified Information Security Manager
      • CISA-Certified Information Systems Auditor
      • CISSP – Certified Information Systems Security Professional
    • AWS
    • Blockchain
    • Digital Marketing
    • Cisco
    • Oracle
    • Linux
      • LPI
      • Red Hat
    • Adobe
      • Photoshop-Basic
      • Photoshop-Advanced
      • Illustrator
      • InDesign
      • Dreamweaver
      • Flash
      • Premiere Pro
    • Autodesk
    • Project Management
    • Service Management
    • SPSS
    • Web Design
    • VMware
  • Certifications
    • Microsoft Technical
      • Microsoft Certified: Azure Administrator Associate
      • Microsoft 365 Certified: Enterprise Administrator Expert
      • Microsoft Certified: Data Analyst Associate
      • Microsoft Certified: Azure Developer Associate
    • Microsoft Office
      • MOS: Associate (Office 365 and Office 2019)
      • MOS: Expert (Office 365 and Office 2019)
      • MOS-Microsoft Office Specialist
      • Microsoft 365 Certified
    • Security Specialist
      • CND-Certified Network Defender
      • CSCU
      • CEH – Certified Ethical Hacker v11
      • CAST 611 – Advanced Penetration Testing
      • CISA – Certified Information Systems Auditor
      • CISM – Certified Information Security Manager
      • CISCO SECURITY
    • Cisco
      • CCNA – Cisco Certified Network Associate
    • Certified Blockchain Professional
    • Certified Digital Marketer (CDM)
    • ECDL Standard
    • Linux
      • Linux Professional Institute
    • Oracle
      • OCA – Oracle Certified Associate: PL/SQL Developer
      • OCA – Oracle Certified Associate: Database 11g Administrator
      • OCA – Oracle Certified Associate: Database 12c Administrator
    • VMware
    • Project Management Professional ( PMP )
    • Service Management
    • Pearson Vue
  • Solutions
    • For Business
    • For Individuals
    • Training Options
  • Contact
  • More
    • About Us
    • Request Info
    • Become a Trainer
    • News & Events
    Tel: (+357) 22.81.81.01
    Tel: (+357) 25.37.38.00
    sales@aktina.com.cy
    AKTINA – IT Training Center
    • Home
    • Courses
      • Microsoft Technical
        • Microsoft Azure
        • Microsoft Exchange Server
        • Microsoft SQL Server
        • Microsoft SharePoint
        • Microsoft Office 365
        • Microsoft Teams
        • Microsoft Virtualization
        • Microsoft Visual Studio
        • Microsoft Windows Server
        • Microsoft Windows Client
      • Microsoft Office
        • Microsoft Excel-Advanced
        • Microsoft Excel-Basic
        • Microsoft Word-Advanced
        • Microsoft Word-Basic
        • Microsoft Power BI
        • Microsoft Access
        • Microsoft PowerPoint
        • Microsoft Project
        • Microsoft Publisher
        • Microsoft Visio
      • Security
        • CCSA – Check Point Certified Admin
        • CND-Certified Network Defender
        • CSCU – Certified Secure Computer User
        • CEH-Certified Ethical Hacker v11
        • CAST 611-Advanced Penetration Testing
        • CISM – Certified Information Security Manager
        • CISA-Certified Information Systems Auditor
        • CISSP – Certified Information Systems Security Professional
      • AWS
      • Blockchain
      • Digital Marketing
      • Cisco
      • Oracle
      • Linux
        • LPI
        • Red Hat
      • Adobe
        • Photoshop-Basic
        • Photoshop-Advanced
        • Illustrator
        • InDesign
        • Dreamweaver
        • Flash
        • Premiere Pro
      • Autodesk
      • Project Management
      • Service Management
      • SPSS
      • Web Design
      • VMware
    • Certifications
      • Microsoft Technical
        • Microsoft Certified: Azure Administrator Associate
        • Microsoft 365 Certified: Enterprise Administrator Expert
        • Microsoft Certified: Data Analyst Associate
        • Microsoft Certified: Azure Developer Associate
      • Microsoft Office
        • MOS: Associate (Office 365 and Office 2019)
        • MOS: Expert (Office 365 and Office 2019)
        • MOS-Microsoft Office Specialist
        • Microsoft 365 Certified
      • Security Specialist
        • CND-Certified Network Defender
        • CSCU
        • CEH – Certified Ethical Hacker v11
        • CAST 611 – Advanced Penetration Testing
        • CISA – Certified Information Systems Auditor
        • CISM – Certified Information Security Manager
        • CISCO SECURITY
      • Cisco
        • CCNA – Cisco Certified Network Associate
      • Certified Blockchain Professional
      • Certified Digital Marketer (CDM)
      • ECDL Standard
      • Linux
        • Linux Professional Institute
      • Oracle
        • OCA – Oracle Certified Associate: PL/SQL Developer
        • OCA – Oracle Certified Associate: Database 11g Administrator
        • OCA – Oracle Certified Associate: Database 12c Administrator
      • VMware
      • Project Management Professional ( PMP )
      • Service Management
      • Pearson Vue
    • Solutions
      • For Business
      • For Individuals
      • Training Options
    • Contact
    • More
      • About Us
      • Request Info
      • Become a Trainer
      • News & Events

      SharePoint

      • Home
      • All courses
      • SharePoint
      • 55049: PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts – Official Microsoft Course

      55049: PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts – Official Microsoft Course

      User Avatar
      aktina
      SharePoint
      Free
      sharepoint
      • Course Overview
      • Course Outline
      • Course Arrangements
      • Costs
      Introduction
      This course concentrates on PowerPivot and Power View in Excel 2013. The attendees will learn how to surface the workbooks and visualizations using the Business Intelligence Center in SharePoint 2013.
      As far as possible each of the modules is stand-alone allowing for customization of the course for those audiences that may not have an interest in a certain service.
      Audience:

      This course is intended for analysts, business intelligence (BI) developers and IT professionals that will be involved with the design, development, and maintenance of Excel workbooks utilizing PowerPivot and Power View 2013 to be surfaced on SharePoint.

      At Course Completion
      After completing this course, students will be able to:
      • Use PowerPivot 2013 in Excel.
      • Work with DAX.
      • Create Power View visualizations.
      • Understand data models.
      • Save to SharePoint.
      • Surface on SharePoint.
      • Work with the SharePoint Business Intelligence Center.
      • Create dedicated apps in SharePoint for PowerPivot and Power View.
      • Use PowerPivot within Excel to import a table from SQL Server.
      • Use PowerPivot within Excel to import a table from SQL Server Analysis Services.
      • Hide columns they don’t want reflected in the resulting PivotTable.
      • View the relationships existing within the imported tables from SQL Server and then import an additional table and configure a relationship between it and the existing.
      • Create a PivotTable within an existing worksheet.
      • Navigate and successfully use Power View.
      • Create a table.
      • Create a chart.
      • Save and share their work.
      • Create a BI semantic model.
      • Explore the options and settings available within the new SharePoint 2013 Central Administration and Excel Services.
      • Access and review the Secure Store.
      • Create a new web application and business intelligence site while exploring the features of both.
      Prerequisites
      Before attending this course, students must have:
      • Experience with Excel 2007 or higher.
      • An understanding of PivotTables.
      CoursesMicrosoft TechnicalSharePoint55049: PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts – Official Microsoft Course
      • MODULES
        4
        • Lecture1.1
          Course Overview 30 min
        • Lecture1.2
          PowerPivot 30 min
        • Lecture1.3
          Power View 30 min
        • Lecture1.4
          SharePoint 2013 Business Intelligence Center 30 min
      City
      Nicosia
      Dates and Times
      Class A
      1. Friday Dec 7 9:00 - 12:40
      2. Wednesday Dec 12 9:00 - 12:40
      3. Friday Dec 14 9:00 - 12:40
      4. Wednesday Dec 19 9:00 - 12:40
      Duration (Hours)
      14
      Location
      20 Louki Akrita street, 2064 Strovolos
      (behind Kykko secondary schools)
      City
      Limassol
      Dates and Times
      Duration (Hours)
      14
      Location
      22 Griva Digeni Avenue, 3106 Agios Nikolaos
      (200 m. from the roundabout, near Agios Nikolaos church)

      For participants eligible for subsidy by the Human Resource Development Authority:
      Participation *Course Manual
      Official Course 55049Official - digital
      Amount€275,00€89,00
      VAT *€70,87€16,91
      * denotes a course subsidised by the Human Resource Development Authority. VAT is applied on the amount before subsidy.
      .

      For participants not eligible for subsidy by the Human Resource Development Authority:

      ParticipationCourse Manual(s)
      Official Course 55049Official - digital
      Amount€675,00€205,00
      VAT €128,25€16,91

      • Course Overview
      • Course Outline
      • Course Arrangements
      • Costs
      Free
      • Share:

      You May Like

      20339-1A – Planning and Administering SharePoint 2016 Read More
      aktina

      20339-1A - Planning and Administering SharePoint 2016

      0
      Free
      20331: Core Solutions of Microsoft SharePoint Server 2013 – Official Microsoft Course Read More
      aktina

      20331: Core Solutions of Microsoft SharePoint Server 2013 – Official Microsoft Course

      0
      Free
      20332: Advanced Solutions of Microsoft SharePoint Server 2013 – Official Microsoft Course Read More
      aktina

      20332: Advanced Solutions of Microsoft SharePoint Server 2013 – Official Microsoft Course

      0
      Free
      20488: Developing Microsoft SharePoint Server 2013 Core Solutions – Official Microsoft Course Read More
      aktina

      20488: Developing Microsoft SharePoint Server 2013 Core Solutions – Official Microsoft Course

      0
      Free
      20489: Developing Microsoft SharePoint Server 2013 Advanced Solutions – Official Microsoft Course Read More
      aktina

      20489: Developing Microsoft SharePoint Server 2013 Advanced Solutions – Official Microsoft Course

      0
      Free

      LEMESOS (LIMASSOL)

      22 Griva Digeni Avenue, 1st floor 3106 Agios Nikolaos (200 m. from the roundabout, near Agios Nikolaos church)

      LEFKOSIA (NICOSIA)

      20 Louki Akrita street, 2064 Strovolos (behind Kykko secondary schools)

      Popular Courses

      Digital Marketing e-course

      Digital Marketing e-course

      Blockchain Professional e-course

      Blockchain Professional e-course

      Implementing and Administering Cisco Solutions (CCNA)

      Implementing and Administering Cisco Solutions (CCNA)

      20740: Installation, Storage and Compute with Windows Server 2016 – Official Microsoft Course

      20740: Installation, Storage and Compute with Windows Server 2016 – Official Microsoft Course

      More Courses

      Limassol Training Center

      22 Griva Digeni Avenue, 1st floor 3106 Agios Nikolaos (200 m. from the roundabout, near Agios Nikolaos church) Lemesos (Limassol), Cyprus

      (+357) 25.37.38.00

       

      Nicosia Training Center

      20 Louki Akrita street, 2064 Strovolos (behind Kykko secondary schools) PO Box 25252, CY-1308 Lefkosia (Nicosia), Cyprus

      (+357) 22 81.81.01

       

      TOP COURSES

      • 20740: Windows Server 2016
      • 20461: Querying Microsoft SQL
      • 20483: Programming in C#
      • 20461: Microsoft SQL Server
      • 20480: HTML5 ,JavaScript…
      • VMware vSphere
      • Oracle Database: Backup and Recover

      Recommended

      • Security
      • Microsoft
      • Oracle
      • Cisco
      • Linux
      • Adobe

      Contact

      sales@aktina.com.cy

      Developed by AKTINA . IT Training organisation in Cyprus.

      • COURSES
      • CERTIFICATIONS
      • SOLUTIONS
      • CONTACT

      BECOME A TRAINER

      Join our team of trainers and earn money hassle free!

      Get Started Now
      Modal title

      Message modal