The focus of this course is on the SharePoint 2013 business intelligence platform and not on the SQL business intelligence services.Īs far as possible each of the modules is stand-alone allowing for customization of the course for those audiences that may not have an interest in a certain service. The new and improved Business Intelligence Center is explored, and all the exciting new features within the SharePoint 2013 release are covered. This four-day instructor-led course provides students with the necessary knowledge to work with all the associated SharePoint business intelligence services including PerformancePoint Service, Excel Services, Business Connectivity Services, and Visio Services. Navigate the Report Builder 3.0 interface.Ĭreate an embedded data source connecting into a database.Ĭreate an embedded data source connecting into an OLAP database.Ĭreate a shared data source using Reporting Services.Ĭreate a shared dataset using the shared connection created in the previous exercise.An understanding of the benefits of business intelligence.
Hide columns they don?t want reflected in the resulting PivotTable.Ĭreate a PivotTable within an existing worksheet.Īssign administrators and permissions on the BDC Metadata Store.Ĭreate and configure a new external content type. View the relationships existing within the imported tables from SQL Server and then import an additional table and configure a relationship between it and the existing. Use PowerPivot within Excel to import a table from SQL Server. Navigate and utilize some of the management features within Dashboard Designer.Ĭreate a drawing, upload the document to the Student BI Site documents library, and view the drawing in a browser.Ĭreate a data-connected drawing and upload the document to the Student BI Site documents library.Ĭreate an objective scorecard and matching strategy map, place them in a dashboard, and then upload the dashboard to the Student BI Site.
#Sharepoint 2013 business intelligence training how to#
Import Data Using the Table Import Wizard.Įxplore the options and settings available within the new SharePoint 2013 Central Administration.Ĭreate a new web application and business intelligence site while exploring the features of both.Ĭreate a SharePoint library to hold Excel workbooks and explore trusted file locations.Įxplore the Dashboard Designer interface and know how to create and configure a data source.Ĭreate and configure a standard KPI and a scorecard.Ĭreate and configure a leaf KPI and a scorecard.Ĭreate two blank KPI?s and then roll them into an objective KPI.Ĭreate and configure an analytic chart and an analytic grid, add them to a dashboard, deploy them to SharePoint, and explore the options available.Ĭreate a Time Intelligence filter, and use it in a scorecard. Understand How to Use MDX to Navigate Hierarchies. Successfully Navigate and Configure Partitions.Ĭreate and Configure a Data Profiling Task.
Successfully Navigate and Use Key Objects.
Successfully Navigate SQL Server Management Studio.Īdd and Configure Connections to the Control Flow.Ĭonnect and Configure Precedence Constraints.Ĭopy a Package and Reuse Project Connection Managers.Īdd and Configure a Data Conversion Transformation.Īdd and Configure a Conditional Split Transformation.Īdd and Configure a Multicast Transformation.Īdd and Configure an Aggregate Transformation.Īdd and Configure a Derived Column Transformation.Īdd and Configure a Lookup Transformation. Successfully Navigate SQL Server Data Tools. Browse the data within the cube using SQL Server Management Studio.Ĭonnect to a tabular source, import tables, and explore the data.
0 kommentar(er)
