Webinar Series: Week of Business Intelligence
In these sessions you will learn how to design a data warehouse, load it using SSIS, place a cube on top of it using SSAS and report against it using SSRS. Finally, you'll see how to performance tune and scale the data warehouse using common techniques. All speakers have authored many of your favorite books from Wrox.
Meet the Authors:
Joy Mundy, Brian Knight, Devin Knight, Adam Jorgensen, Paul Turley, Mark Stacey, Donald Farmer
02/13/2010
March 22-26- Webinar Series:Week of BI
February 22-26 - SQL Server 101 Webinar Series
Join Authors Brian Knight, Jorge Segarra, Steve Jones, Brad McGehee, Patrick LeBlanc, Christian Bolton, Adam Jorgensen, and Devin Knight
This webinar series will walk you through the Microsoft SQL Server stack so that you can become a DBA or Business Intelligence (BI) developer. Click here to reserve your free seat
01/11/2010
12/28/2009
January 11-14, 2010 – SSAS Trianing with Brian Knight
SQL Server Analysis Services (SSAS) with Brian Knight
January 11 - 14, 2010 2:00 - 5:00 PM EST
Starting from the ground-up, teaching you the fundamental skills you need to develop and deploy SSAS solutions and present this new data to your end users. See Complete Details
January 18-21, 2010 – SSIS Training
SQL Server Integration Services (SSIS)
January 18-21, 2010 2:00 - 5:00 PM EST
Designed to help you understand the core concepts of SQL Server 2005 and 2008 Integration Services (SSIS), the ETL tool of choice for SQL Server DBA's. We will use a variety of lab exercises and small projects to ensure you gain familiarity in how the design and execution environments work and be prepared to build your own real world applications using this SQL Server subsystem. See Complete Details
January 25-28, 2010- SSRS Training
SQL Server Reporting Services (SSRS)
January 25-28 2:00 - 5:00 PM EST
Designed to help you understand all aspects of SQL Server 2008 Reporting Services (SSRS), the reporting tool of choice for SQL Server developers. We will use a variety of lab exercises and small projects to ensure you gain familiarity in how the design and execution environments work and be prepared to build your own real world applications using this SQL Server subsystem. This course will cover all the key concepts of Reporting Services from basic reporting, parameters, deploying, and scheduling. See Complete Outline
12/01/2009
Pragmatic Works’ Launches BIDN.com, Business Intelligence Developer Network
December 1, 2009, Pragmatic Works™, a Microsoft Gold Certified Partner launches a new online resource Business Intelligence Developer’s Network (BIDN.com) – a site designed to help BI Developers find answers, locate reference materials, and share knowledge with their peers and colleagues.
“As a leading provider of business intelligence solutions and software, BIDN.com was the next logical step for Pragmatic Works to further democratize technology. The demand for knowledge and resources related to SQL Server business intelligence created the need for BIDN.com. The site allows users to ramp-up business intelligence faster by giving a reader access to the best experts in the world. It is also a great way for Pragmatic Works to give back to the community,” said Brian Knight, founder of Pragmatic Works.
As the first free dedicated business intelligence online community, BIDN.com offers access to articles, blogs, videos and forums to post user questions. Registered users can also add their own content easily to share with peers while building their personal brand.
“The site houses at launch hundreds of SSIS, SSAS, and SSRS blog posts and articles,” Knight said. “It will feature a new article every weekday so users will have something new to learn every day. BIDN.com is a great way to assist companies in utilizing their existing staff by helping them learn new skills in one of the hottest growing industries in technology without having to pay for formal training.”
The site is currently in public beta. Be part of the community today by giving back or learn through teaching others. Go to www.bidn.com
About Pragmatic Works:
Pragmatic Works Software, a Microsoft Gold Partner, headquartered in Jacksonville, Florida with offices in Massachusetts and California, provides business intelligence solutions that complement the Microsoft SQL Server platform. For more information or free trial go to www.pragmaticworks.com
11/24/2009
BI xPress 2.0 democratizes SSIS Development
Latest release offers Package Builder Wizard – reuse and deploy hundreds of SSIS packages in seconds.
Jacksonville, Fla.— November 23, 2009, Pragmatic Works™, www.pragmaticworks.com, a Microsoft Gold Certified Partner and provider of business intelligence solutions that complement Microsoft SQL Server released BI xPress™ 2.0 with added feature called Package Builder. The Package Builder Wizard democratizes SSIS development by making complex SSIS development simple. BI xPress captures components of SSIS into a template which can be reused and shared across hundreds of SSIS packages in seconds. BI xPress also allows for Package Builder template and code sharing across the SSIS development team creating the optimal ETL development environment.
The latest version of BI xPress includes:
· NEW: Package Builder Wizard for quickly building packages from several predefined templates. Create new packages from predefined package templates or modify existing packages
· NEW: Three new Date Time expressions for BI xPress Expression Edit dialog box.
· NEW: Shows correct icon instead of generic task icon for 3rd party tasks in Expression List
· Snippet Wizard Use Snippet Wizard to add reusable code from snippet library. Snippet framework is extensible framework to create reusable scripting code and control flow.
· Auditing Framework - easily track how long each package took to execute by date, computer, environment (QA, Prod, etc.), machine type, and more.
· Notification Framework - receive instant e-mails and/or text messages, notifying you of package errors, warnings, successes, and failures.
· Deployment Utility - easily deploy single or multiple SSIS packages at one time, along with their Configuration Files.
“This latest release delivers a huge business value to customers as it reduces developer’s time sometimes by 98%,” says Pragmatic Works’ President Brian Knight. “It’s a Consultant in a Can. Even a seasoned SSIS developer can increase their productivity by using these reusable package templates.”
“BI xPress has saved us an incredible amount of SSIS development time, allowed us to create new across the board development standards for all of our Onshore and Offshore SSIS developers all while utilizing reusable templates for SSIS development.” says Dave Fraser, Sr. SQL Server DBA at Tech Data. “The easy to use auditing and notification frameworks are incredible and definitely add significant value to the product here at Tech Data.”
BI xPress, integrated with Microsoft Visual Studio (BIDS) allows for a familiar development interface and minimal training, easily builds SSIS packages and views historical reports about package activity, performance trends, errors and/or warnings, extracted and loaded records summary along with source and target information, such as table and file names. For a free trial go to http://www.pragmaticworks.com/products/business-intelligence/bixpress/default.aspx
10/16/2009
Data Cleansing Webinar
|
|
|
|
|
|
|
|
Data Cleansing with the SSIS Data
Flow |
|
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|
|
|||||||||||||||||||||||||||
|
|
|
|
|
|
|||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||
10/06/2009
Nov 3-4 SSIS Tips & Tricks Mini Sessions!
Stop by the Pragmatic Works booth # 402 at PASS Summit. Schedule your personal mini session with Brian Knight. Brian will be presenting SSIS Tips & Tricks Mini sessions in the booth. Stop by for the schedule or schedule a personal session with Brian.
Also Monday November 2, 2009 Pre-Conference Workshop “Building a Microsoft Data Warehousing Platform” with Brian Knight. Thursday November 5, 2009 “Loading a Data Warehouse with SSIS” with Brian Knight
Recent Comments