SQL Server Reporting Services 2014: Data Sourcing Playbook
Data teams waste hours wrestling with poorly configured data sources in SSRS—this playbook cuts through that friction. You’ll move from basic connectivity to production-ready data sourcing patterns in under 2.5 hours, giving you the tactical edge to build reports that actually scale.
AIU.ac Verdict: Ideal for BI developers and data analysts who need hands-on SSRS 2014 fundamentals without the fluff. Thomas LeBlanc’s vendor-backed expertise (Pluralsight’s top 5.5% author tier) ensures practical relevance. Note: This is 2014-focused, so organisations on newer SQL Server versions may need supplementary material.
What This Course Covers
This course unpacks the complete data sourcing workflow in SSRS 2014: configuring shared and embedded data sources, writing efficient T-SQL queries, managing credentials and authentication, and troubleshooting common connectivity issues. You’ll work through real scenarios—relational databases, stored procedures, and parameterised queries—that reflect what you’ll encounter in production environments.
Beyond mechanics, LeBlanc covers performance optimisation strategies, caching logic, and best practices for maintaining data source integrity across enterprise deployments. The hands-on labs let you apply each concept immediately, so you’re not just watching—you’re building muscle memory for the decisions that separate solid reports from brittle ones.
Who Is This Course For?
Ideal for:
- BI Developers: Building SSRS 2014 reports and need to master data source configuration without trial-and-error delays.
- Data Analysts: Transitioning into reporting roles and require foundational SSRS skills to connect analytics to business stakeholders.
- SQL Server DBAs: Supporting reporting infrastructure and wanting to understand SSRS data sourcing from the database perspective.
May not suit:
- Power BI / Tableau Users: If your organisation has moved to modern BI platforms, SSRS 2014 skills may not transfer directly to your tech stack.
- Advanced SSRS Architects: This is fundamentals-focused; if you’re designing enterprise reporting frameworks, you’ll likely find the scope too introductory.
Frequently Asked Questions
How long does SQL Server Reporting Services 2014: Data Sourcing Playbook take?
2 hours 23 minutes of video content. Most learners complete it in one focused session or split across two shorter sittings, depending on how deeply you engage with the hands-on labs.
Do I need SQL Server 2014 installed locally to follow along?
Pluralsight provides sandboxed environments for hands-on labs, so you don’t need local infrastructure. However, having SQL Server 2014 or later available helps reinforce learning in your own environment post-course.
Will this course help me if my organisation uses SQL Server 2016 or later?
Yes—SSRS data sourcing fundamentals remain consistent across versions. You’ll learn core patterns that apply to newer releases, though UI and some advanced features may differ slightly. Check Pluralsight’s newer SSRS courses if you need version-specific guidance.
What’s the difference between this and Pluralsight’s other SSRS courses?
This playbook is laser-focused on data sourcing—the foundation layer. Other Pluralsight SSRS courses cover report design, visualisation, or administration. Start here if data connectivity is your gap; combine with others for broader mastery.
Course by Thomas LeBlanc on Pluralsight. Duration: 2h 23m. Last verified by AIU.ac: March 2026.
