Curs Excel 2013 Self-Service Analytics with No Code for the End User – Curs 55084

Excel 2013 PowerPivot

In this module we will explore PowerPivot and its analytical capabilities. PowerPivot is a data analysis add-on for Microsoft Excel that allows large amounts of data to be collected, aggregated, and analyzed in one workbook. Sound powerful? It is! We’ll cover everything you need to know to get you up, running, and analyzing.

• Best Things That PowerPivot Brings to Excel
• What Will PowerPivot Do for the Analyst?
• Introduction to PivotTables (Optional)
• PowerPivot Versions
• New 2013 PowerPivot Features
• VLOOKUP Not Required (Use Relationships)
• Architectural Changes in Excel 2013
• PowerPivot and Excel 2013
• PowerPivot and SharePoint
• Enterprise Business Intelligence and PowerPivot
• Importing Data
• Data Models
• Relationships
• Simple PivotTable Reports
• Calculated Columns and Calculated Fields
• Refreshing Data
• Calculations
• SharePoint Sharing

Power View

In this module we will cover Power View and the reporting that can be created. From tables to charts and sharing on SharePoint, this module will have you ready to visualize your data in a variety of ways.

• Report Design Principles
• New 2013 Power View Features
• Microsoft Power View User Interface
• Tables
• Charts
• BI Semantic Models
• Saving and Sharing

Power Query

This module explains how to use Power Query effectively.

• Power Query and Power Query Formulas
• ETL with Power Query
• Online Search
• Data Refresh
• Managing Data Sources and Queries

Power Map

This module explores Power Map, a new 3D visualization add-in for mapping, exploring, and interacting with geographical and temporal data, enabling users to discover and share new insights.

• What is Power Map and How Does It Work?
• Data Visualizations and 3D Mapping Using Power Map
• What is a Tour?

Inregistrati-va

Locatia de desfasurare a cursului:

Sediul Learning Solution: Str. Transilvaniei nr. 24, Sector 1, Bucuresti

Cine susține cursul?

Familiarity with Microsoft Office applications – particularly Excel

Curs Creare Dashboards Cu PowerPivot Power View Si SharePoint – Curs 55103
Curs 50450 – Curs Excel Creating and Analyzing Database Using Microsoft Excel
Curs 55084 – Curs Excel 2013 Self-Service Analytics with No Code for the End User
Curs Excel 2013 – Advanced Microsoft Excel 2013
Curs Excel 2013 PowerPivot – PowerBI
Curs 50448 Maximizing PivotTable Microsoft Excel
Curs 55143 Microsoft Office Excel Basic Workbooks Formulas and Functions
Curs Microsoft Excel 2016 – Incepator
Curs Microsoft Excel 2016 – Mediu
Curs Microsoft Excel 2016 – Avansat
Curs Microsoft Excel 2013 – Incepator
Curs Microsoft Excel 2013 – Mediu
Curs Microsoft Excel 2013 – Avansat
Curs Microsoft Excel 2010 – Incepator
Curs Microsoft Excel 2010 – Mediu
Curs Microsoft Excel 2010 – Avansat
Curs Microsoft Excel 2007 – Incepator
Curs Microsoft Excel 2007 – Mediu
Curs Microsoft Excel 2007 – Avansat