Microsoft Guaranteed-to-Run

Microsoft SharePoint 2013 End to End Business Intelligence (SQL Integration Focus)

The Microsoft SharePoint 2013 End to End Business Intelligence course equips developers and IT specialists with the skills to design and deploy robust BI solutions using SharePoint 2013 and SQL Server 2012. This training solves the challenge of fragmented data analysis by unifying Excel Services, PerformancePoint, PowerPivot, and Business Connectivity Services into a cohesive platform. Koenig Solutions delivers official vendor-authorized courseware and 30-day lab access, ensuring hands-on mastery. Graduates gain the technical ability to build enterprise dashboards and drive data-driven decisions within their organizations.

40 Hours (5 Days)
Live Online / Classroom
8+ professionals trained

Training Formats & Pricing

1-on-1 On Request
Dedicated instructor, your schedule Fastest
Public Batch On Request
Group class, fixed schedule Most Popular
Self-Paced On Request
Recorded sessions, learn anytime Best Value

100% Happiness Guarantee · Free Rescheduling · Secure Payment

Course Overview

The Microsoft SharePoint 2013 End to End Business Intelligence course by Microsoft is a comprehensive five-day training program designed for business intelligence developers, SQL Server developers, and IT professionals involved in designing and maintaining BI solutions. While not tied to a single certification exam, this course aligns with broader Microsoft data platform expertise credentials and delivers foundational knowledge for roles such as Business Analyst, BI Developer, and Data Platform Consultant. According to industry analysis, professionals with SharePoint BI skills command strong market demand, with mid-level BI analysts earning median salaries exceeding $108,000 annually in the United States, reflecting sustained enterprise reliance on integrated reporting environments.

This course covers core components of the Microsoft Business Intelligence stack, including PerformancePoint Services, Excel Services, Business Connectivity Services, Visio Services, SQL Server 2012 Analysis Services, and the SharePoint 2013 Business Intelligence Center. Participants engage in hands-on labs using a dedicated test lab environment based on a three-tier SharePoint farm, where they configure secure data connections, deploy interactive dashboards, and build real-time scorecards that pull from multiple data sources. A key project involves constructing an end-to-end BI solution that integrates KPIs from SQL Server into a unified dashboard using PerformancePoint, demonstrating how these services interoperate within enterprise deployments.

By mastering Microsoft SharePoint 2013 End to End Business Intelligence, learners prepare for advanced roles in data visualization and enterprise reporting, backed by Microsoft’s recognized platform expertise. Graduates gain practical experience with official Microsoft courseware, enabling them to design scalable BI infrastructures that support executive decision-making. Koenig Solutions enhances this learning with Guaranteed-to-Run scheduling and access to expert instructors, ensuring personalized guidance. Upon completion, professionals are positioned to lead BI initiatives, drive data democratization across organizations, and pursue career advancement in analytics leadership and enterprise architecture.

What You'll Learn

Configure SharePoint 2013 End to End Business Intelligence sites to optimize data analysis and reporting
Deploy Microsoft Excel Services within SharePoint 2013 for advanced data visualization and interactive reports
Implement Microsoft PowerPivot in SharePoint 2013 for efficient data modeling and automatic refreshes
Manage Microsoft Reporting Services in SharePoint 2013 libraries to streamline report delivery and access
Design PerformancePoint dashboards with KPIs and scorecards to monitor business performance effectively
Integrate Power BI with Microsoft SharePoint 2013 environments for seamless data insights and collaboration

Prerequisites

Recommended knowledge before taking this course
  • Working knowledge of Microsoft SharePoint 2013 architecture and site administration for effective BI implementation
  • Experience configuring Excel Services and Secure Store in SharePoint 2013 environments to ensure secure data access
  • Understanding of SQL Server 2012 SP1 Analysis Services (SSAS) in SharePoint mode for comprehensive business analytics
  • Familiarity with Power Pivot for SharePoint 2013 and data model integration to enhance data analysis capabilities
  • Hands-on experience with PerformancePoint Services, Visio Services, and Business Connectivity Services for building interactive dashboards
  • Ability to deploy and manage Reporting Services reports within SharePoint 2013 to deliver actionable insights
Corporate Training
Get a Corporate Quote

Volume discounts · Dedicated account manager · Custom scheduling

Certification Exam

Everything you need to know about the Microsoft SharePoint 2013 End to End Business Intelligence (SQL Integration Focus) certification exam

Exam Details
Exam Name
Microsoft SharePoint 2013 End to End Business Intelligence (SQL Integration Focus)
Format
Multiple choice, labs & case studies
Questions
Duration
Passing Score
Validity
Retake Policy
Not applicable
Let's Talk

Request for more information

Microsoft SharePoint 2013 End to End Business Intelligence (SQL Integration Focus)

We'll respond within 1 business day · No spam, ever.

Course Curriculum

Structured learning with hands-on labs and real-world scenarios

1
Day 1– Microsoft SharePoint 2013 End to End Business Intelligence Stack
Core Business Intelligence Concepts Three Strategic BI Perspectives SQL Server 2012 BI Integration SharePoint 2013 BI Framework Advanced SharePoint 2013 BI Features Excel 2013 PowerPivot Analytics BI Semantic Model Fundamentals Lab: Mastering the BI Stack
2
Day 2– Data Integration and Modeling Techniques
SQL Server 2012 Integration Services Essential ETL Process Workflows Managing SSIS Packages and Tasks SQL Multidimensional Model Design SQL Tabular Model Architecture Master Data Services Overview Data Mining Strategy Concepts Lab: Building Tabular Data Models
3
Day 3– Reporting and Data Publishing Workflows
SQL Server 2012 Reporting Services Report Builder 3.0 Essentials Publishing Reports to SharePoint Configuring Automated Report Subscriptions Utilizing Report Viewer Web Parts SharePoint 2013 Excel Services Streamlined Excel Workbook Publishing Lab: Configuring Reporting Services
4
Day 4– Advanced Data Visualization Strategies
PerformancePoint Services Architecture Dashboard Designer Configuration Setup Developing KPIs and Scorecards Building PerformancePoint Dashboards SharePoint 2013 Visio Services Dynamic Data-Driven Visio Diagrams PowerPivot for SharePoint Configuration Lab: Creating PerformancePoint Dashboards
5
Day 5– Business Connectivity and Dashboard Integration
Business Connectivity Services Implementation Defining External Content Types Configuring Secure BCS Access Building External Data Lists SharePoint BI Center Configuration Dashboard Design Best Practices Integrating Complex BI Components Lab: Building Unified BI Dashboards

What's Included in Your Training

Every enrollment comes packed with resources to maximise your learning and exam success

Career Outcomes

78%

of Microsoft SharePoint 2013 End to End Business Intelligence (SQL Integration Focus) certified professionals report career advancement within 6 months

Salary Impact

+22%

Average salary increase reported after obtaining the Microsoft SharePoint 2013 End to End Business Intelligence (SQL Integration Focus) certification

Typical Salary Range (Global)
Entry$90,000–$115,000
Mid$115,000–$145,000
Senior$145,000–$180,000

*Source: Glassdoor / LinkedIn 2025

Job Roles

6
  • SharePoint BI Developer
  • Business Intelligence Analyst
  • SharePoint Administrator
  • PerformancePoint Specialist
  • Excel Services Developer
  • BI Consultant

Companies Hiring

5,000+
Microsoft Accenture Deloitte Capgemini TCS Infosys Wipro JP Morgan Chase IBM Bank of America

and 5,000+ organizations worldwide seeking Microsoft SharePoint 2013 End to End Business Intelligence (SQL Integration Focus) certified professionals

Real Transformations

Course Student Reviews

Real results from IT professionals who trained with Koenig — rated 4.9/5 from 18,400+ verified reviews.

18,400+
Verified Reviews
4.9 / 5
Average Rating
95%
Would Recommend
1M+
Professionals Trained
  • ★★★★★

    “Passed AZ-104 on first attempt. The MCT knew the exact exam patterns and the labs were exactly what Microsoft tests. Worth every penny.”

    Rahul M.

    Rahul M.

    Azure Administrator

    AZ-104 Certified ✓ Verified
  • ★★★★★

    “I trained 15 of my team members for SC-200. Koenig's on-site delivery was seamless and all 15 passed within 3 months.”

    Sarah K.

    Sarah K.

    CISO, Financial Services

    Enterprise Client ✓ Verified
  • ★★★★★

    “The 1-on-1 format was a game changer. My trainer adjusted the pace to my schedule and I cleared PL-300 while working full-time.”

    Ahmed R.

    Ahmed R.

    Business Intelligence Lead

    PL-300 Certified ✓ Verified
  • ★★★★★

    “From AZ-900 to AZ-305 in 6 months. Koenig's structured roadmap and MCT mentoring made the expert level achievable.”

    Priya S.

    Priya S.

    Cloud Solutions Architect

    AZ-305 Expert ✓ Verified
  • ★★★★★

    “As an L&D head I've used 5 training vendors. Koenig's MCT quality, MOC materials, and ESI compliance is in a different league.”

    James T.

    James T.

    Head of L&D, UK Enterprise

    100+ Learners Trained ✓ Verified
  • ★★★★★

    “SC-900 and SC-300 back to back — both cleared first try. The security curriculum at Koenig is incredibly thorough and up to date.”

    Aisha N.

    Aisha N.

    Security Analyst

    SC-300 Certified ✓ Verified
  • ★★★★★

    “AI-102 was daunting but the trainer broke it down perfectly. Real Azure OpenAI labs made the difference. Highly recommend.”

    David L.

    David L.

    AI Engineer

    AI-102 Certified ✓ Verified
  • ★★★★★

    “DP-600 Fabric certification done in 3 weeks of part-time study. The customised schedule around my timezone was a lifesaver.”

    Mei W.

    Mei W.

    Data Platform Engineer

    DP-600 Certified ✓ Verified
  • ★★★★★

    “Our whole DevOps team got AZ-400 certified through Koenig's corporate training. Smooth logistics and top-tier MCTs throughout.”

    Carlos R.

    Carlos R.

    Engineering Manager

    AZ-400 Team Training ✓ Verified
  • ★★★★★

    “Passed AZ-104 on first attempt. The MCT knew the exact exam patterns and the labs were exactly what Microsoft tests. Worth every penny.”

    Rahul M.

    Rahul M.

    Azure Administrator

    AZ-104 Certified ✓ Verified
  • ★★★★★

    “I trained 15 of my team members for SC-200. Koenig's on-site delivery was seamless and all 15 passed within 3 months.”

    Sarah K.

    Sarah K.

    CISO, Financial Services

    Enterprise Client ✓ Verified
  • ★★★★★

    “The 1-on-1 format was a game changer. My trainer adjusted the pace to my schedule and I cleared PL-300 while working full-time.”

    Ahmed R.

    Ahmed R.

    Business Intelligence Lead

    PL-300 Certified ✓ Verified
  • ★★★★★

    “From AZ-900 to AZ-305 in 6 months. Koenig's structured roadmap and MCT mentoring made the expert level achievable.”

    Priya S.

    Priya S.

    Cloud Solutions Architect

    AZ-305 Expert ✓ Verified
  • ★★★★★

    “As an L&D head I've used 5 training vendors. Koenig's MCT quality, MOC materials, and ESI compliance is in a different league.”

    James T.

    James T.

    Head of L&D, UK Enterprise

    100+ Learners Trained ✓ Verified
  • ★★★★★

    “SC-900 and SC-300 back to back — both cleared first try. The security curriculum at Koenig is incredibly thorough and up to date.”

    Aisha N.

    Aisha N.

    Security Analyst

    SC-300 Certified ✓ Verified
  • ★★★★★

    “AI-102 was daunting but the trainer broke it down perfectly. Real Azure OpenAI labs made the difference. Highly recommend.”

    David L.

    David L.

    AI Engineer

    AI-102 Certified ✓ Verified
  • ★★★★★

    “DP-600 Fabric certification done in 3 weeks of part-time study. The customised schedule around my timezone was a lifesaver.”

    Mei W.

    Mei W.

    Data Platform Engineer

    DP-600 Certified ✓ Verified
  • ★★★★★

    “Our whole DevOps team got AZ-400 certified through Koenig's corporate training. Smooth logistics and top-tier MCTs throughout.”

    Carlos R.

    Carlos R.

    Engineering Manager

    AZ-400 Team Training ✓ Verified
  • ★★★★★

    “Passed AZ-104 on first attempt. The MCT knew the exact exam patterns and the labs were exactly what Microsoft tests. Worth every penny.”

    Rahul M.

    Rahul M.

    Azure Administrator

    AZ-104 Certified ✓ Verified
  • ★★★★★

    “I trained 15 of my team members for SC-200. Koenig's on-site delivery was seamless and all 15 passed within 3 months.”

    Sarah K.

    Sarah K.

    CISO, Financial Services

    Enterprise Client ✓ Verified
  • ★★★★★

    “The 1-on-1 format was a game changer. My trainer adjusted the pace to my schedule and I cleared PL-300 while working full-time.”

    Ahmed R.

    Ahmed R.

    Business Intelligence Lead

    PL-300 Certified ✓ Verified
  • ★★★★★

    “Passed AZ-104 on first attempt. The MCT knew the exact exam patterns and the labs were exactly what Microsoft tests. Worth every penny.”

    Rahul M.

    Rahul M.

    Azure Administrator

    AZ-104 Certified ✓ Verified
  • ★★★★★

    “I trained 15 of my team members for SC-200. Koenig's on-site delivery was seamless and all 15 passed within 3 months.”

    Sarah K.

    Sarah K.

    CISO, Financial Services

    Enterprise Client ✓ Verified
  • ★★★★★

    “The 1-on-1 format was a game changer. My trainer adjusted the pace to my schedule and I cleared PL-300 while working full-time.”

    Ahmed R.

    Ahmed R.

    Business Intelligence Lead

    PL-300 Certified ✓ Verified
  • ★★★★★

    “From AZ-900 to AZ-305 in 6 months. Koenig's structured roadmap and MCT mentoring made the expert level achievable.”

    Priya S.

    Priya S.

    Cloud Solutions Architect

    AZ-305 Expert ✓ Verified
  • ★★★★★

    “As an L&D head I've used 5 training vendors. Koenig's MCT quality, MOC materials, and ESI compliance is in a different league.”

    James T.

    James T.

    Head of L&D, UK Enterprise

    100+ Learners Trained ✓ Verified
  • ★★★★★

    “SC-900 and SC-300 back to back — both cleared first try. The security curriculum at Koenig is incredibly thorough and up to date.”

    Aisha N.

    Aisha N.

    Security Analyst

    SC-300 Certified ✓ Verified
  • ★★★★★

    “From AZ-900 to AZ-305 in 6 months. Koenig's structured roadmap and MCT mentoring made the expert level achievable.”

    Priya S.

    Priya S.

    Cloud Solutions Architect

    AZ-305 Expert ✓ Verified
  • ★★★★★

    “As an L&D head I've used 5 training vendors. Koenig's MCT quality, MOC materials, and ESI compliance is in a different league.”

    James T.

    James T.

    Head of L&D, UK Enterprise

    100+ Learners Trained ✓ Verified
  • ★★★★★

    “SC-900 and SC-300 back to back — both cleared first try. The security curriculum at Koenig is incredibly thorough and up to date.”

    Aisha N.

    Aisha N.

    Security Analyst

    SC-300 Certified ✓ Verified
  • ★★★★★

    “AI-102 was daunting but the trainer broke it down perfectly. Real Azure OpenAI labs made the difference. Highly recommend.”

    David L.

    David L.

    AI Engineer

    AI-102 Certified ✓ Verified
  • ★★★★★

    “DP-600 Fabric certification done in 3 weeks of part-time study. The customised schedule around my timezone was a lifesaver.”

    Mei W.

    Mei W.

    Data Platform Engineer

    DP-600 Certified ✓ Verified
  • ★★★★★

    “Our whole DevOps team got AZ-400 certified through Koenig's corporate training. Smooth logistics and top-tier MCTs throughout.”

    Carlos R.

    Carlos R.

    Engineering Manager

    AZ-400 Team Training ✓ Verified
  • ★★★★★

    “AI-102 was daunting but the trainer broke it down perfectly. Real Azure OpenAI labs made the difference. Highly recommend.”

    David L.

    David L.

    AI Engineer

    AI-102 Certified ✓ Verified
  • ★★★★★

    “DP-600 Fabric certification done in 3 weeks of part-time study. The customised schedule around my timezone was a lifesaver.”

    Mei W.

    Mei W.

    Data Platform Engineer

    DP-600 Certified ✓ Verified
  • ★★★★★

    “Our whole DevOps team got AZ-400 certified through Koenig's corporate training. Smooth logistics and top-tier MCTs throughout.”

    Carlos R.

    Carlos R.

    Engineering Manager

    AZ-400 Team Training ✓ Verified
100%

Happiness Guarantee

We are so confident in the quality of our training that we offer a full money-back guarantee. Not satisfied? Contact us within 24 hours of your first session — we'll refund you completely, no questions asked.

Full Refund

Within 24 hours

No Questions

Asked ever

Secure Payment

Encrypted checkout

PCI DSS

Compliant