Excel Power Pivot

Build data models with Power Pivot. Discover key features of Power View.

Duration:

One day

09:30 - 17:30

Locations:

Amsterdam

Berlin

Düsseldorf

Münich

Zürich

Price:

495 € (excl. VAT)

Group discounts available

Contact Us: +49 211 99 54 89 84 support@xlyourmind.com

What to Expect? Extend the power of Excel and discover an agile, cost-effective approach to business intelligence. With a focus on real-world scenarios, problem-solving, and data modeling, this training shows you how to perform complex data analysis improves your Excel power-user skills.

This training will enable you to transform data into business intelligence solutions and on-the-job results. It provides you with a solid understanding of managing, analyzing, visualizing data and sharing it across your organization.

Objectives

The training is intended for Excel users, project managers, and decision makers who wish to learn the basics of PowerPivot for Excel 2013, master the new DAX language used by PowerPivot, and learn advanced data modelling and programming techniques with PowerPivot. Typical participants have already some basic knowledge of working in Excel and need to know more advanced applications of formulas and functions.

Who is It For?

About us The transformation of data into meaningful information is crucial for making the right business decisions. We help you to manage the ever widening stream of data in the most time-efficient ways. With trainings that are adjusted to your industry and function, you will quickly become an expert in organizing, analyzing, and visualizing data to gain more insights. In a nutshell - our trainings enable you to do more work in significantly less time and with better results.

Training Topics

Self-service business intelligence is revolutionizing the world of data analysis in which PowerPivot plays a key role. You will be introduced to PowerPivot, its main advantages and analytical applications. Additionally, you will gain an overview of the basic features of PowerPivot, Power View and learn how to perform calculations using the DAX formula language. Example Questions What are the main benefits of the Power View add-in, and when should I be using it? How can I perform calculations within PowerPivot? How is data management within PowerPivot different from normal Excel? Focus points

Exploring PowerPivot, Power Query, and Power View

Discussing the benefits and possibilities of the Power View add-in and creating your first

report.

Understanding DAX calculations Understanding the DAX syntax, performing calculations, and working with DAX

functions.

Managing data within PowerPivot Using the PowerPivot database and adding information to it.

Data forms the cornerstone of working with PowerPivot. With data models you will gain a better understanding of managing your data by connecting to different external data sources and creating relationships between tables.

Example Questions

Why does the data model play a key role in creating a self-service BI reporting? How to work with multiple tables or data sources? What data can and cannot be loaded in PowerPivot?

Introduction to PowerPivot and DAX

Data models and loading data

Focus points Understanding data modeling

Producing reports based on a data model.

Relationships in depth Linking multiple tables with each other.

Understanding normalization and denormalization

Efficiently storing and presenting your data.

Loading from different data sources Exploring data loading options in PowerPivot.

The concepts of evaluation contexts, the CALCULATE function, and hierarchies enable you to enrich the data model. You will create more complex reports and improve your understanding of the DAX language. Example Questions

What is an evaluation context and how to use it? How to use the CALCULATE function and modify the filter? What are the main benefits of using hierarchies and how to build them? Focus points

Understanding context interactions Changing the behavior of formulas through filter- and row contexts.

Using the calculate function Applying the CALCULATE function in combination with complex filtering conditions.

Building hierarchies Moving between levels within your dataset by creating hierarchies.

Contexts, Calculate, and Hierarchies

Graphically explore and present your data with Power View. Retrieve insights from your data in a visual way and produce analysis reports with Power View. Example Questions

How to build a report with Power View? What new features does Power View provide me with that normal Excel doesn’t have? Can I create reports with drill-down functionality? Focus points

Power View essentials Creating a Power View report and exploring its possibilities.

Understanding table and charts in Power View Incorporating different graphical visualizations into analytical Power View reports.

Using matrices, cards, maps, and tiles Building interactive reports and displaying data on maps.

Get to know advanced techniques that improve the quality of your reporting system and share them with your colleagues.

Example Questions

How to create reports that are easy to understand and provide the most insight? Does the data model design depend on what I want in my Power View report? What is the best way to collaborate and share my reports with colleagues? Focus points

Key performance indicators (KPIs) Incorporating KPIs in PowerView reports.

Understanding Metadata and data models for Power View Adjusting data models with Power View in mind and further smoothening the user

experience through Metadata.

Using Power View

Shaping and sharing reports

Creating static and dynamic sets Learning about sets and PowerPivot data model queries.

Publishing to SharePoint Sharing information, managing workflows, and publishing reports using PowerPivot

and SharePoint.

Tackle a wide range of real-world business scenarios with advanced DAX calculations. You will explore which problem sets can be best addressed with PowerPivot, how to use DAX as a query language and how to deal with time intelligence. Example Questions

What date calculations can I perform in DAX? How to handle many-to-many relationships between tables? How can I analyze my data with banding, ranking, and queries? Focus points

Performing date calculations in DAX Building a calendar table and comparisons over time.

Banding and ranking Slicing data using banding techniques and performing analysis with ranking.

Many-to-many relationships Dealing with complex relations between tables.

DAX Query Functions Deepen understanding of how PowerPivot works and utilize this for more complex

analyses that incorporate queries.

E-Mail: support@xlyourmind.com Post: XL Your Mind

Gneisenaustraße 27, 40477, Germany

Business Focus

You will learn practical skills and methods that can be applied straight away. Exercises and cases are based on common business challenges and the content is continuously validated by working professionals from different industries.

Person

Title

Last name, First name

Job Position

Amsterdam

o 15.06.2016

o 05.10.2016

o 14.12.2016

Advanced DAX Calculations

Why Choose our Trainings?

Business Focus

You will learn practical skills and methods that can be applied straight away. Exercises and

cases are based on common business challenges while content is continuously validated

by working professionals from different industries.

Online resources

You will gain access to our online resource database XL+. Every day new information is added here that helps you to apply what you had learned during our trainings sessions and stay on top of the latest developments.

Expert Knowledge

Our trainers are experts in the field of data analysis and automation with Excel. They have

helped many companies build cost effective solutions with Excel and incorporate this

experience in our trainings.

Continuing Support

To ensure that you can apply what you have learned during our trainings, our team stands

ready to give you a timely response to any questions you may still have.

Flexible

We take greatest care that the training content as well as the facilities satisfy your training

requirements.

International

We operate internationally and the training content as well as delivery method are very

well suited to professionals working in multinational organizations.

XL Your Mind Gneisenaustraße 27 40477 Düsseldorf Germany Email: support@xlyourmind.com Phone: +49 211 99 54 89 84 Website: www.xlyourmind.com