Pragmatic Works’ BI Boot Camp provides a hands-on lab environment. In five days, you will build a fully functional prototype data warehouse using SQL Server 2012/2014/2016, along with the complete Microsoft BI Platform: SSIS, SSAS, SSRS and Power BI.
Please Note: You do not need to bring a Laptop
With the purchase of this class, you get complete access to our On-Demand Training platform for 7 days.
Alan is an IT professional offering over 20+ years of progressive technical experience with managing, consulting, software development, data integration architecture, data warehousing, and business intelligence development projects. Alan’s focus is to work closely with stakeholders to develop architecture frameworks that align with organizational strategy, processes, and IT assets. He specializes in Business Intelligence (BI), Data Warehousing, database architecture, design and implementation, performance tuning and troubleshooting.
There are no prerequisites for this course.
So you have used SSIS for years to do all your ETL and loading of your data warehouse, but did you know you could also handle all your cube processing inside of SSIS? In this session Mitchell will introduce you to four little know tasks in SSIS that will help to automate the processing of your cube.
For those who have never worked with SSIS, it can look quite daunting at first. In this webinar we are going to take the time to break down some of the basics. SSIS is a very robust tool for your ETL development. Eventually, with enough practice and experience, you can take advantage of the more advanced items and techniques available. Join Manuel in making your first SSIS package and see some of the basic, but constantly used, items inside of this BI tool.
You always have more report requests than you can possibly fulfill. Wouldn’t it be great if you could speed up the generation of reports? What about after the report has been released into production? How do you find reports that are no longer being used? Templates can streamline the life cycle of a report for the whole team, and auditing your report catalog can keep your catalog lean and healthy. In this session, you’ll learn how templates in your tool belt can help you efficiently gather requirements, quickly design mock-ups, and standardize the look and feel of your SSRS reports. Mickey also talk about how to keep track of change requests and how to analyze the utilization of existing reports over time. You can view the recording here: http://pragmaticworks.wistia.com/medias/k9zzbmtngf
LegiTest is licensed per user, per machine where it is used. LegiTest Server is licensed per server instance, with unlimited client access licenses. Please contact firstname.lastname@example.org for more information.
DTS xChange is licensed per package conversion. Please contact email@example.com for more information.
DBA xPress is licensed per user, per machine where it is used. Please contact firstname.lastname@example.org for more information.
BI xPress is licensed per user, per machine where it is used. BI xPress Server is licensed per server instance with 5 client access licenses included. A client access license is assigned to a single user. Additional client access licenses can be purchased. Please contact email@example.com for more information.
Task Factory is licensed per server instance. There is no license necessary to use Task Factory in the Integration Services development environment (Visual Studio, SQL Server Data Tools, or Business Intelligence Developer Studio). Please contact firstname.lastname@example.org for more information.
DOC xPress is licensed per user, per machine where it is used. DOC xPress Server is licensed per server instance with 5 client access licenses included. A client access license is assigned to a single user. Additional client access licenses can be purchased. Please contact email@example.com for more information.
Yes, DOC xPress supports SSIS projects and ISPAC that encrypt passwords. It also supports encrypted SSIS packages.
Yes, but in order to continue using the Salesforce features, you must upgrade to the latest version of Task Factory. Click here for more information on Salesforce's upgrade to TLS 1.2.
LegiTest is only compatible with Visual Studio 2012 or 2013. If you are running on an older version, you will need to upgrade.
Most testing software only tests certain aspects of data-centric development. LegiTest allows testing across all aspects of your development lifecycle, providing validation at each stage of development
Yes. LegiTest easily integrates with existing systems. It can be incorporated into build processes such as MSBuild, TFS, TeamCity and much more.
Testing your data ensures you catch bugs early, reduce delivery time, reduce the cost of testing and provides provable assurances of the validity of the data. But most of all, testing just works. Testing ensures accurate code, and more importantly accurate data.
DTS xChange only does conversions for SSIS 2005 or 2008.
In many cases it can, however it is dependent upon the contents of the existing DTS package.
DTS xChange uses proprietary rule based engine to migrate DTS Packages to SSIS by applying best practices of SSIS. So by using DTS xChange you not only get higher migration success rate but you also get new features supported by SSIS (e.g. Event Handlers, Logging, XML Configuration Files etc.)
DBA xPress is a suite of tools designed to aid the DBA with the management of their SQL Servers and data. BI xPress Pro includes DBA xPress with it.
You can! Click here to download a sample document. Having trouble viewing CHM files? Click here for instructions on how to view them.
DOC xPress Server makes it easier to share and explore documentation across the enterprise. It eliminates the need to install DOC xPress Pro to view documentation, do lineage analysis, and update data dictionaries.
The DOC xPress and DOC xPress Server templates are used to lend form and reason to the output. They are fully customizable and control what information is included in the documentation. For more information, click here.
There are a number of functions available with Task Factory. Click here to view a complete list.
Yes, Task Factory components can be used with Azure databases.
BI xPress comes bundled and there is no way to only sell one feature of the product.
Yes, you can designate the reason for the message to go out and make your own custom message that you can share with others.
BI xPress Server provides the ability to monitor SSIS package execution as well as Reporting Services, making it easier to provide access to this information without the need to install the full BI xPress Pro software.