Even with little to no knowledge of BI, this course will provide you with immediately-usable, production-level knowledge of BI. The SQL Server training course has been designed for anyone who needs to become familiar with all facets of the Microsoft BI stack—from modeling to development of the presentation layer and beyond to key administration tasks. Are you a DBA who wants to better understand how to support BI projects on your servers? Or do you need to jump-start your skills so you can start building solid, high-performing, and user-friendly BI solutions? This class might be the perfect way to advance your career and dig deeper into topics that don’t typically get covered in most BI classes.
Relational data warehousing – with lots of aggregate tables – helps you keep your data organized for any type of reporting or analysis tool that you might want to use, but there are some rules to follow to build a structure that both performs well and makes sense to your business users. (If the data warehouse structure is too confusing, they are not going to use it!) How can you quickly build and test your design or organically add new content over time without burning up precious hours on tedious SSIS package development? This class shows you to how to jump-start your BI project by automating your SSIS development efforts.
Do you know which types of business questions are answered more easily when you move your data from the data warehouse into SSAS cubes. Or maybe tabular models? How do you know which technology to use? In this class, you’ll learn the pros and cons of each approach and the decision points to consider before you choose.
Whether you store data in tables, cubes, or tabular models, you have a variety of options in the BI stack to access and analyze the data, but which is best for your needs? Learn the key features of each tool, how to choose the right tool for the task, and how to apply best practices to the design of your reports and dashboards.
Once you build a solution, what are your options for managing a secure, scalable, and high-performing environment for reporting and analysis? Can you properly identify performance issues across the data platform and take the appropriate steps to resolve those issues? This class walks you through key aspects of deploying, managing, and monitoring each component of your BI solution.
The course starts out in the 100-200 range on Day 1 but moves into the 200-300 range for the remainder of the week. You’ll learn basic usage and design principles for the reporting and analysis components of the Microsoft data platform, followed by more coverage of management and performance tuning tasks than you’ll find in most BI end-to-end classes. The course will not only bridge the gap in your BI knowledge, but will provide a solid foundation for building a complete solution. If you’ve always wanted to immerse yourself into BI, explore an end-to-end solution, and go behind-the-scenes to learn how to develop and deploy BI solutions, this is the place to be!
This course will cover SQL Server 2005 through SQL Server 2016, and is essential for all SQL Server BI developers, DBAs, and architects. We will answer all your questions, to whatever depth you want to go.
For a detailed agenda click HERE.
If you need help justifying training to your organization, we can help you:
Listed below are some verbatim quotes from recent attendees of this class:
Click HERE to go to our events registration page, and please make sure to select the correct class from the drop-down menu at the top of the page.
If you have any questions, please contact us.