Building Business Intelligence with Pivot Tables is an online video course that is perfect for anyone looking to build reports and quickly summarize 10s to 1,000s of rows of data. This course will provide the analyst with the best ways to source and clean up source data for reporting. As the data is cleansed, the course will show you how to present the data in a way that is easy to use for analysis by presenting data in both tabular and visually. The course will further explore the best ways to analyze the data and drill in and out of data. By the end of this course, you will feel confident sourcing, cleansing, and analyzing data through pivot tables and dashboards.
This is a course aimed squarely at the beginner/intermediate Excel users looking to take their skills to the next level. Before starting this course, you should be comfortable working in Excel. Knowledge of a variety of formula can be helpful, although is by no means necessary. While those comfortable with Pivot Tables are likely to pick up new tricks to make their lives easier, the course is designed to take someone with absolutely no Pivot Table knowledge and teach them how to collect, clean and set up the data, present it in Pivot Tables and build dashboards using Pivot Charts. A basic understand of Excel functions is helpful but not necessary for this course. The target audience of this course is for Power Users who are learning DAX for the first time.
All PivotTable tasks can be performed in any version of Excel. Tasks related to Power Query require installation of the free Power Query tools in some versions of Excel. Tasks related to Power Pivot can only be performed if Power Pivot is installed in your product. Details to activate these tools can be found below:
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.