The Power BI with Excel course is designed to get you up-to-speed using tools easily accessible to Power Users and all Microsoft Office users including Office 365 (Please note Office 365 is not mandatory for this class). First, you’ll learn the basics of creating models using Power Pivot. Then, using Power Query, you’ll shape additional data that can be found in external data sources.
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.
Power BI Desktop (http://tinyurl.com/powerbidesktop)
You may have either Excel 2010 or Excel 2013 Professional Plus installed for this class but all in class examples will be done using Excel 2013.
Excel 2013 allows you to follow the entire class
Excel 2010 allows you to follow Power Pivot and Power Query sections of the course. A hosted SharePoint service can be used to try Power View
If you do not have this software currently installed you can find a 60 evaluation copy here. We strongly recommend downloading the 64 bit version of Office if possible.
In addition to Excel please also download and install the following free Microsoft Excel Add-in’s:
If you are using Excel 2010
· Power Pivot Add-In (http://tinyurl.com/PowerPivotJan2013)
· Power Query Add-In (http://tinyurl.com/PowerQuerySept2014)
If you are using Excel 2013
· Power Map Add-In (http://tinyurl.com/powermapdownload)
· Power BI Desktop (http://tinyurl.com/powerbidesktop)
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.