This class is designed to get you up to speed on the latest with Power BI. First you will learn how to query and pull in data. Then organize the results into a data model with relationships and calculations. Finally, you will learn the best way to visualize your data through a variety of charts, graphs, maps and gauges that are provided. This class exclusively uses the Power BI Desktop application to create solutions that are deployed to the Power BI Service and are then visible from any devices.
With the purchase of this class, you get complete access to our On-Demand Training platform for 7 days.
As a Business Intelligence Consultant and trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS, and SSRS). In addition to the BI Stack he also have experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.
This class is targeted for Power Users or End Users looking to design their own self-service Business Intelligence solutions. Because this class is focused on self-service end user solutions, previous SQL Server knowledge is not required. While it’s not mandatory, ideally students should have a basic understanding database terminology such as tables, views column, rows, etc.
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 email@example.com for more information.
DTS xChange is licensed per package conversion. Please contact firstname.lastname@example.org for more information.
DBA xPress is licensed per user, per machine where it is used. Please contact email@example.com 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 firstname.lastname@example.org 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 email@example.com 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 firstname.lastname@example.org 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.