PowerPivot and Report Builder Combo Pack

Niveau
Tijdsduur
Startdatum en plaats
Logo van @The Academy
Opleiderscore: starstarstarstarstar_border 8,1 @The Academy heeft een gemiddelde beoordeling van 8,1 (uit 161 ervaringen)

Tip: meer info over het programma, startdatum, prijs, en inschrijven? Download de brochure!

Startdata en plaatsen

Eindhoven
1 mei. 2019 tot 9 mei. 2019
Eindhoven
19 jun. 2019 tot 27 jun. 2019

Beschrijving

<div class="domino-par--indent" style="padding-left: 0pt"><font size="2" face="Verdana"><b>Course Description</b></font><br /> <font size="2" face="Verdana">This four-day course concentrates on PowerPivot and Power View in Excel 2013. The attendees will learn how to surface the workbooks and visualizations using the Business Intelligence Center in SharePoint 2013. </font><br /> <font size="2" face="Verdana">As 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.</font><br /> <font size="2" face="Verdana">This course also provides students with the necessary knowledge to develop r…

Lees de volledige beschrijving

Veelgestelde vragen

Heb je een vraag? Onze adviseurs helpen je graag. Bel ons op 085 7440830 of e-mail naar info@springest.nl.

<div class="domino-par--indent" style="padding-left: 0pt"><font size="2" face="Verdana"><b>Course Description</b></font><br /> <font size="2" face="Verdana">This four-day course concentrates on PowerPivot and Power View in Excel 2013. The attendees will learn how to surface the workbooks and visualizations using the Business Intelligence Center in SharePoint 2013. </font><br /> <font size="2" face="Verdana">As 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.</font><br /> <font size="2" face="Verdana">This course also provides students with the necessary knowledge to develop reports using Microsoft Report Builder 3.0. The training environment includes SQL 2008R2, SQL Express 2012 and SQL 2012 Standard and Enterprise so that the students can utilize Report Builder 3.0 and generate reports from multiple sources to investigate the different features of each release.</font><br /> <font size="2" face="Verdana">The course covers the Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters and report expressions, report visualizations including graphs, charts, images, and gauges, advanced reporting including the utilization of maps, interactive reports, Report Parts and subreports.</font><br /> <font size="2" face="Verdana">The course concludes with a special module that includes over 100 tips and tricks for Report Builder 3.0 with step-by-step instructions. All of the examples are available as a take-away for the students after the course.</font><br /> <br /> <font size="2" face="Verdana"><b>At Course Completion</b></font><br /> <font size="2" face="Verdana">After completing this course, students will be able to:</font> <ul type="disc" class="domino-par-list" style="padding-left: 18pt"> <li><font size="2" face="Verdana">Use PowerPivot within Excel to import a table from SQL Server.</font></li> <li><font size="2" face="Verdana">Use PowerPivot within Excel to import large datasets.</font></li> <li><font size="2" face="Verdana">Use PowerPivot within Excel to import with a query.</font></li> <li><font size="2" face="Verdana">Create relationships between tables.</font></li> <li><font size="2" face="Verdana">Create a cascading relationship.</font></li> <li><font size="2" face="Verdana">Create a relationship between two tables from different sources.</font></li> <li><font size="2" face="Verdana">Hide columns they don’t want reflected in the resulting PivotTable.</font></li> <li><font size="2" face="Verdana">Change data types.</font></li> <li><font size="2" face="Verdana">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.</font></li> <li><font size="2" face="Verdana">Create a PivotTable within an existing worksheet.</font></li> <li><font size="2" face="Verdana">Add a calculated field to a table from the PivotTable.</font></li> <li><font size="2" face="Verdana">Use the FILTER function.</font></li> <li><font size="2" face="Verdana">Use the CALCULATE function.</font></li> <li><font size="2" face="Verdana">Build a date table in excel.</font></li> <li><font size="2" face="Verdana">Relate a table to the date table created in Excel.</font></li> <li><font size="2" face="Verdana">Create and configure perspectives.</font></li> <li><font size="2" face="Verdana">Create and configure hierarchies.</font></li> <li><font size="2" face="Verdana">Create and configure KPIs.</font></li> <li><font size="2" face="Verdana">Navigate and successfully use Power View.</font></li> <li><font size="2" face="Verdana">Create a table.</font></li> <li><font size="2" face="Verdana">Create a chart.</font></li> <li><font size="2" face="Verdana">Save and share their work.</font></li> <li><font size="2" face="Verdana">Explore the options and settings available within the new SharePoint 2013 Central Administration.</font></li> <li><font size="2" face="Verdana">Access and review the Secure Store.</font></li> <li><font size="2" face="Verdana">Create a new web application and business intelligence site while exploring the features of both.</font></li> <li><font size="2" face="Verdana">Create custom apps to store visualizations and/or workbooks in SharePoint 2013 Business Intelligence Center.</font></li> <li><font size="2" face="Verdana">Plan your reports.</font></li> <li><font size="2" face="Verdana">Utilize Report Builder 3.0 wizards.</font></li> <li><font size="2" face="Verdana">Create an embedded data source.</font></li> <li><font size="2" face="Verdana">Create an embedded dataset.</font></li> <li><font size="2" face="Verdana">Create shared data sources and datasets.</font></li> <li><font size="2" face="Verdana">Use report parameters.</font></li> <li><font size="2" face="Verdana">Use report expressions.</font></li> <li><font size="2" face="Verdana">Create report gauges.</font></li> <li><font size="2" face="Verdana">Create report graphs.</font></li> <li><font size="2" face="Verdana">Use images in reports.</font></li> <li><font size="2" face="Verdana">Use report lists.</font></li> <li><font size="2" face="Verdana">Use report tables.</font></li> <li><font size="2" face="Verdana">Use the matrix.</font></li> <li><font size="2" face="Verdana">Create maps in reports.</font></li> <li><font size="2" face="Verdana">Create subreports.</font></li> <li><font size="2" face="Verdana">Use Report Parts.</font></li> <li><font size="2" face="Verdana">Create interactive reports.</font></li> <li><font size="2" face="Verdana">Use keyboard shortcuts.</font></li> </ul> </div>

Efficient, kostenbewust, innovatief, met hoogste slagingspercentage opleiden bij @The Academy! 

Blijf op de hoogte van nieuwe ervaringen

Er zijn nog geen ervaringen.

Deel je ervaring

Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.

Heb je een vraag? Onze adviseurs helpen je graag. Bel ons op 085 7440830 of e-mail naar info@springest.nl.

Download gratis en vrijblijvend de informatiebrochure

Aanhef
(optioneel)
(optioneel)
(optioneel)
(optioneel)
infoEr is een telefoonnummer vereist om deze informatieaanvraag in behandeling te nemen. (optioneel)
(optioneel)
(optioneel)
(optioneel)

Heeft u nog vragen?

(optioneel)
We slaan je gegevens op om je via e-mail en evt. telefoon verder te helpen.
Meer info vind je in ons privacybeleid.