Home Remote DBA Service Consulting and Performance Server Health Checks Training Resources Calendar Past Customers What our Students say About SQLskills.com		IEBI: Immersion Event on Business Intelligence   Overview Even with little to no knowledge of BI, this course will provide you with immediately-usable, production-level knowledge of BI. The course has been designed to take you from installation to configuration to application and integration – for all facets of the BI stack (SSIS, SSAS, SSRS, PowerPivot, and SharePoint) - it is meant for anyone who wants to get involved in BI. Are you a DBA who wants to better understand how to support BI projects on your servers? Or do you need to jumpstart your skills so you can start building solid, scalable 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. Maybe you accomplish quite a bit with Excel - but how do you get the data there? Quite a few folks use cut-and-paste, or import from a CSV - but of course there's a much better, and much more scalable and robust way using SSIS! Relational data warehousing – with lots of aggregate tables – helps you keep your data organized for Excel or any other type of reporting or analysis tool that you might want to use, but some types of business questions are answered more easily when you move your data from the data warehouse into SSAS cubes. Whether you store data in tables or cubes, you have a variety of options in the BI stack to access and analyze the data, but which is best? Learn how to choose the right tool for the task and how to manage a secure and scalable environment for reporting and analysis. 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. For each technology in the BI stack, you’ll learn basic usage and design principles, followed by more coverage of configuration, performance tuning, and other management 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 continue on to take you a lot further. If you’ve always wanted to immerse yourself into BI, figure out the end-to-end story, and go behind-the-scenes to learn how to install, configure, and deploy BI solutions, this is the place to be! Please see our Immersion Events Schedule for class dates and our comprehensive Immersion Events FAQ for class costs and other frequently asked questions. Day 1: Getting Started with Business Intelligence What is Business Intelligence? The evolution of business intelligence "Doing BI": Microsoft business intelligence in action Terms, concepts and key components Building a Business Intelligence Infrastructure Reviewing the architecture Installing BI server components Installing BI client components Relational Data Warehousing Kimball versus Inmon Data warehouse design principles Building the physical model Day 2: Building a Business Intelligence Foundation Introduction to Integration Services Getting started with SSIS Development strategy for populating a data warehouse Working with control flow and data flow components Working with scripts and expressions Managing Package Reliability Auditing and logging techniques Package transactions Checkpoints Package Performance Execution threads and execution trees Tips for optimizing package performance Using monitoring tools Managing Integration in Production Configuring packages Deploying packages Understanding the service account Executing packages Securing packages Day 3: Building a Business Intelligence Foundation Introduction to Analysis Services Top down versus bottom up development Techniques for developing data source views Dimension and cube development Storage modes Processing options Designing Aggregations User hierarchies and attribute relationships Aggregation Design Wizard versus Usage Based Optimization Tuning aggregations Using MDX to Enhance a Cube MDX fundamentals MDX Scripts MDX query performance analysis Calculation optimization Managing Analysis Services in Production Scalability options Securing cube access and dimensions Using deployment tools Working with XMLA scripts Using integration services to automate database processing Backing up and restoring an analysis services database Day 4: Developing the Presentation Layer Introduction to Reporting Services Report design tools Report server projects Report design tasks Report items Tablix concepts Reporting Services Development Using expressions Configuring parameters Creating data visualizations Developing maps Managing Reporting Services in Production Reporting Services architecture Report server management Report deployment Securing reports Excel and PowerPivot for Excel Understanding reporting versus analysis Using Excel for analysis Extending analysis with PowerPivot Integrating with SharePoint Day 5: Developing the Presentation Layer Introduction to SharePoint 2010 SharePoint architecture Configuring SharePoint for BI Creating sites for BI Building KPIs and dashboards Other options: FAST, Business Connectivity Services, Visio Services PerformancePoint Services Working with Dashboard Designer Scorecards, reports, and dashboards Managing authentication SharePoint deployment PowerPivot for SharePoint PowerPivot for SharePoint architecture Self-service reporting Managing data refresh Monitoring server health and activity Questions? If you have any questions about the training classes that SQLskills.com provides, please don't hesitate to send us email!
Privacy Policy. All Rights Reserved. Copyright 2011 SQLskills.com