0 items in cart

Microsoft SQL Server 2014 – More Power with PowerBI

Participants learn how to use the tools PowerQuery, PowerPivot, PowerMap, and Power BI Q&A with the aid of an example. This training course is suitable for data and system architects, database developers and administrators, as well as power users on business intelligence projects.

Previously, business intelligence projects used to be defined by data warehouse structures and ETL processes. This went hand-in-hand with long development times and little agility for users. Lately, more and more approaches geared towards self-service BI have been making themselves noticeable. Modern tools allow business units to independently build reporting and analysis structures and effectively adapt them in line with business requirements. Microsoft’s Self-Service BI products are grouped together under the label “Power XY”. The seminar positions the tools PowerQuery, PowerPivot, PowerMap, and Power BI Q&A based on a universal example.

M-SQL2014-PBI

Duration

1 day

target group

Data and system architects, database developers and administrators, power users on BI projects

Contents (new)

  • Overview of Microsoft's Vision for Business Intelligence
  • Data Integration with PowerQuery
    Flat Files
    Web Feeds
    Big Data Sources
    Parallel Data Warehouse
  • Creating BI Models with PowerPivot
  • Overview of DAX
  • Geographic Presentation of Data Using PowerMap
  • Interactive Data Analysis with Power BI Q&A
  • SharePoint Services for BI Projects or From Self-Service BI to Managed BI

Method

Seminar-style with online demos. Handouts with hands-on labs for working at home

Prerequisites

General understanding of data, databases, and Excel

Our Quality Promise

Contact to our service center

DE+49 (0) 711 90363245

CH+41 (0) 584 595795

AT+43 (01) 33 2353160

FR+41 (0) 584 595454

EN+49 (0) 711 90363245

DA+49 (0) 711 90363245

emailTraining@trivadis.com

PlaceDateLanguageprice 
In-house training courses on request!inquiry
back to trainings
0 items in cart

Contact now

Trivadis, Bernd Rössler, Head of Training

Bernd Rössler

Solution Manager Trivadis Training

×

trivadis training satisfaction guarantee

Guarantee of quality

Following completion by the participants, every single training course is assessed at the levels

  • suitability of the training room,
  • suitability of the workplace,
  • functionality of the technical equipment, and
  • satisfaction throughout the entire course / seminar,

and recorded in our "TRIVALUATION" feedback system for quality assurance purposes. This enables us to consistently ensure the high quality and satisfaction of our valued customers. We really appreciate the overall rating of 9.3 from 10 points awarded by our many enthusiastic customers.

 

trivadis training success guarantee

Success guarantee

Trivadis guarantees the success of your training. Having completed the course / seminar, do you have any questions about the practical aspects? Would you like to repeat any of the exercises in the lab environment?

Our success guarantee allows you to repeat individual days, or even the entire training course, free of charge for up to 6 months after attending a training course. You bring with you the course materials from the previous training course.