55164A Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI

Scopul principal al acestui curs este de a învăța participantii cum să combine funcțiile Power View, Power Pivot, Power Query și Power BI în grafice, diagrame, KPI-uri, rapoarte și alte vizualizări. Ca atare, publicul ţintă este format din profesionişti si administratori de baze de date, dezvoltatori BI.

Inscrie-te folosind formularul de mai jos!
Contacteaza-ne daca ai nevoie de mai multe informatii
0728 ADVICE sau office@itadviser.ro
  • Pret 450€
  • Durata 2 zile
  • Nivel 200
  • Cursanti 10
  • Limba curs Engleza/Romana
  • Examen -
  • Certificare -

Detalii curs Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI

La curs pot participa si alte categorii de profesionisti IT care analizeaza sau optimizeaza lucrul cu baze de date : analişti de afaceri, dezvoltatori de aplicaţii.

După finalizarea acestui curs Microsoft SQL Server, participantii vor putea:

• Naviga in interfata Power View.

• Utiliza rapoartele Power View.

• Lucra cu tabele.

• Intelege datele agregate.

• Aplica filtre.

• Crea diagrame.

• Adauga rapoartelor componente de filtrare.

• Utiliza teme.

• Naviga in interfata Power Pivot.

• Incarca date.

• Examina si configura relatii.

• Configura coloane calculate.

• Crea Tabele Pivot.

• Intelege si utiliza DAX.

• Utiliza KPI.

• Lucra cu ierarhii.

• Gestiona perspectivele..

• Naviga in interfata Power Query.

• Filtra date.

•Imbina seturi de date.

• Administra modificari.

• Efectua stergerea datelor.

• Naviga in interfata Power Map.

• Utiliza hartile Bing.

• Examina harti.

• Adauga timp pentru o prezentare.

• Naviga in interfata Power BI.

• Utiliza surse de date.

• Intelege interogarile.

Course Outline

Module 1: Course Overview

This module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons

Introduction
Course Materials
Facilities
Prerequisites
What We’ll Be Discussing
Lab : Course Overview

After completing this module, students will be able to:

Successfully log into their virtual machine.
Have a full understanding of what the course intends to cover.
Module 2: Power View

In this module, we will explore Power View and its capabilities, then briefly walk-through the types of reports available and how to format them.

Lessons

Exploring the Power View Interface
Visualizing Power View Reports
Working with Tables
Understanding Aggregations
Utilizing Matrix
Configuring Drill Through
Using Cards
Applying Filters
Creating Charts
Examining Tiles
Adding Slicers to Reports
Theming Reports
Lab : Power View

Power View Interface
Working with Tables
Aggregations
Matrix
Drill Through
Cards
Filters
Charts
Tiles
Adding Slicers to Reports
After completing this module, students will be able to:

Navigate the Power View interface.
Utilize Power View reports.
Work with tables.
Understand aggregations.
Utilize matrix.
Configure drill through.
Use cards as a visualization.
Apply filters.
Create charts.
Utilize tiles.
Add slicers to reports.
Utilize themes.
Module 3: PowerPivot

In this module, we will explore PowerPivot and its capabilities, then briefly walk-through the options available and how to configure them.

Lessons

Exploring the PowerPivot Interface
Loading Data
Examining Relationships
Configuring Calculated Columns and Calculated Fields
Creating PivotTables
Understanding DAX
Utilizing DAX Functions
Using KPIs
Working with Hierarchies
Managing Perspectives
Lab : PowerPivot

Introduction to the PowerPivot Interface
Importing Data
Importing Large Datasets
Importing Data with a Query
Creating Relationships
Creating a Cascading Relationship
Hiding Columns, Change Data Type, Sorting, and Filtering
Calculated Columns and Calculated Fields
KPIs
Hierarchies
Perspectives
After completing this module, students will be able to:

Navigate the PowerPivot interface.
Load data.
Examine and configure relationships.
Configure calculated columns are calculated fields.
Create PivotTables.
Understand and utilize DAX.
Use KPIs.
Work with hierarchies.
Manage perspectives.


Module 4: Power Query

In this module, we will delve into the benefits and features provided using Power Query. We will examine the options available within the ribbon, as well as explore and demonstrate importing, filtering, and merging data using Power Query.

Lessons

Exploring The Power Query Interface
Loading Data
Managing Modifications
Examining Data Cleaning
Lab : Power Query

Getting External Data
Data Filtering
Merging Datasets
After completing this module, students will be able to:

Navigate the Power Query interface.
Load data.
Filter data.
Merge datasets.
Manage modifications.
Perform data cleaning.
Module 5: Power Map

In this module we will explore Power Map and its capabilities.

Lessons

Exploring The Power Map Interface
Using Bing Maps
Examining Map Data
Reviewing Map Types and Presentation
Lab : Power Map

View Power Map in Action
Geocoding
Tours, Scenes, and Layers
Adding Time
After completing this module, students will be able to:

Navigate the Power Map interface.
Use Bing maps.
Examine map data.
Configure tours, scenes, and layers.
Add time to a presentation.


Module 6: Introduction to Power BI

In this module, we will explore the Power BI interface and walk-through the options available.

Lessons

Introducing Power BI
Explaining Excel and Power BI
Examining Data Sources
Querying with Natural Language
Lab : Introduction to Power BI

Introduction to Power BI
Data Sources
After completing this module, students will be able to:

Navigate the Power BI interface.
Utilize data sources.
Understand querying with natural language.

    Call Now Button