IEBI: Immersion Event on Business Intelligence

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!

Instructor: Stacia Misner

Need Help Justifying Training? Here’s a letter to your boss explaining why SQLskills training is worthwhile and a list of community blog posts about our classes.

Ready to register? Please see our Immersion Events Schedule for class dates and our comprehensive Immersion Events F.A.Q. for class costs and other frequently asked questions.


Quotes From Past Attendees

Listed below are some verbatim quotes from recent attendees of this class:

  • “It was everything I expected it to be and more. I look forward to returning for another event!”
  • “Stacia was excellent at communicating complex concepts in a manner that was easy to understand.”

Curriculum

Day 1: Preparing Data for Business Intelligence

  • Relational Data Warehousing
    • Requirements analysis
    • Data warehouse design principles
    • Building the physical model
  • Rapid DW and Integration Services Development with Biml
    • Problems solved with Biml
    • Tools for Biml development
    • Basic Biml Syntax
    • Biml and the Data Warehouse
  • Tabular vs. Multi-dimensional: Which Model?

Day 2: Building Multi-dimensional Models

  • Multidimensional Model Development
    • Data Source View
    • Dimensions
    • Cubes
  • Partition Concepts
    • Storage modes
    • Processing options
    • Aggregation design
  • MDX Concepts
    • MDX fundamentals
    • Query development
    • Cube calculations
    • KPIs

Day 3: Building Tabular Models

  • Tabular Model Development in SSAS and Power BI
    • Data access options
    • Relationships
  • DAX Concepts
    • DAX fundamentals
    • Query development
    • Calculated columns
    • Measures
    • KPIs
    • DAX query development

 Day 4: Developing the Presentation Layer

  • Reporting Services
    • Report design tools
    • Paginated reports
    • Mobile-ready reports
    • KPIs
  • Other Presentation Layer Tools
    • Comparison and contrast of tools: Excel, Power View, and Power BI
    • Pivot tables and pivot charts
    • Data visualization do’s and don’ts

Day 5: Managing a Business Intelligence Platform

  • Managing BI in Production
    • Deployment and change management
    • Security
    • Scalability and high availability options
    • Disaster recovery
  • Performance Monitoring
    • Performance monitoring tools
    • Performance analysis
    • Tuning options

Ready to register? Please see our Immersion Events Schedule for class dates and our comprehensive Immersion Events F.A.Q. for class costs and other frequently asked questions.


Questions?

If you have any questions not answered by our F.A.Q., please contact us.