From all my SQL experience, I've worked mostly with SSIS (SQL Server Integration Services). This seems to have become an antiquated technology. Most organizations are now looking for people who have experience in SSRS (SQL Server Reporting Services). Doing my research online, I've come across a very simple YouTube video that walks through steps of setting up reports in SSRS.
Here is some even more basic instructions for SSRS that would be useful to know when setting up your server: