Corso Power BI
PANORAMICA
PANORAMICA
Corso di preparazione al superamento dell’esame di Certificazione:
Analyzing and Visualizing Data with Microsoft Power BI
Modulo:
Corso MOC 20778
Analyzing and Visualizing Data with Microsoft Power BI
Contattaci ora per ricevere tutti i dettagli e per richiedere, senza alcun impegno, di parlare direttamente con uno dei nostri Esperti 
CLICCA QUI.
Oppure chiamaci subito al nostro numero verde 
800-177596.
OBIETTIVI DEL CORSO
OBIETTIVI DEL CORSOAlla fine del percorso formativo il corsista avrà acquisito solide competenze nell’analisi e la rappresentazione dei dati attraverso il potente strumento Microsoft Power BI. Il corso approfondisce le principali applicazioni di Power BI. Partendo dall’introduzione dei concetti fondamentali della Business Intelligence e self-service BI, fino ad argomentazioni avanzate come API e Mobile App.
CONTENUTI DEL CORSO
CONTENUTI DEL CORSOAnalyzing and Visualizing Data with Microsoft Power BI
- Module 1: Introduction to Self-Service BI Solutions
- Introduces business intelligence (BI) and how to self-serve with BI.
- Introduction to business intelligence
- Introduction to data analysis
- Introduction to data visualization
- Overview of self-service BI
- Considerations for self-service BI
- Microsoft tools for self-service BI
- Lab: Exploring an Enterprise BI solution
- Viewing reports
- Creating a Power BI report
- Creating a Power BI dashboard
- After completing this module, students will be able to:
- Describe the trends in BI
- Describe the process of data analysis in Power BI.
- Use the key visualizations in Power BI.
- Describe the rationale for self-service BI.
- Describe considerations for self-service BI.
- Understand how you can use Microsoft products to implement a BI solution.
- Module 2: Introducing Power BI
- This module introduces Power BI desktop, and explores the features that enable the rapid creation and publication of sophisticated data visualizations.
- Power BI
- The Power BI service
- Lab : Creating a Power BI dashboard
- Connecting to Power BI data
- Create a Power BI dashboard
- After completing this module, students will be able to:
- Develop reports using the Power BI Desktop app.
- Use report items to create dashboards on the Power BI portal.
- Understand the components of the Power BI service including licensing and tenant management.
- Module 3: Power BI
- At the end of this module students will be able to explain the rationale and advantages of using Power BI.
- Using Excel as a data source for Power BI
- The Power BI data model
- Using databases as a data source for Power BI
- The Power BI service
- Lab : Importing data into Power BI
- Importing Excel files into Power BI
- Viewing reports from Excel files
- After completing this module, students will be able to:
- Describe the data model and know how to optimize data within the model.
- Connect to Excel files and import data
- Use on-premises and cloud Microsoft SQL Server databases as a data source, along with the R script data connector
- Take advantage of the features of the Power BI service by using Q&A to ask questions in natural query language, and create content packs and groups.
- Module 4: Shaping and Combining Data
- With Power BI desktop you can shape and combine data with powerful, buil-in tools.
- This module introduces the tools that are available for preparing your data, and transforming it into a form ready for reporting.
- Power BI desktop queries
- Shaping data
- Combining data
- Lab : Shaping and combining data
- Shape power BI data
- Combine Power BI data
- After completing this module, students will be able to:
- Perform a range of query editing skills in Power BI
- Shape data, using formatting and transformations.
- Combine data together from tables in your dataset.
- Module 5: Modelling data
- This module describes how to shape and enhance data.
- Relationships
- DAX queries
- Calculations and measures
- Lab : Modelling Data
- Create relationships
- Calculations
- After completing this module, students will be able to:
- Describe relationships between data tables.
- Understand the DAX syntax, and use DAX functions to enhance your dataset.
- Create calculated columns, calculated tables and measures.
- Module 6: Interactive Data Visualizations
- This module describes how to create and manage interactive data visualizations.
- Creating Power BI reports
- Managing a Power BI solution
- Lab : Creating a Power BI report
- Connecting to Power BI data
- Building Power BI reports
- Creating a Power BI dashboard
- After completing this module, students will be able to:
- Use Power Bi desktop to create interactive data visualizations.
- Manage a power BI solution.
- Module 7: Direct Connectivity
- This module describes various connectivity options using Power BI.
- Cloud data
- Connecting to analysis services
- Lab : Direct Connectivity
- Direct connectivity from Power BI desktop
- Direct connectivity from the Power BI service
- After completing this module, students will be able to:
- Use Power BI direct connectivity to access data in Azure SQL data warehouse, in addition to big data sources such as Hadoop
- Use Power BI with SQL Server Analysis Services data, including Analysis services modles running in multidimentional mode.
- Module 8: Developer API
- This module describes the developer API within Power BI.
- The developer API
- Custom visuals
- Lab : Using the developer API
- Using custom visuals
- After completing this module, students will be able to:
- Describe the developer API.
- Use the developer API to create custom visuals.
- Module 9: Power BI mobile app
- This module describes the Power BI mobile app.
- The Power BI mobile app
- Using the Power BI mobile app
- Power BI embedded
- After completing this module, students will be able to:
- Describe the Power BI mobile app.
- Download and use the Power BI mobile app.
- Describe Power BI embedded and when you would want to use it.
TIPOLOGIA DEL CORSO
TIPOLOGIA DEL CORSOLezioni frontali Presenza in Aula e Laboratorio;
Lezioni a distanza in Video Presenza Tempo Reale e Laboratorio;
INFRASTRUTTURA LABORATORIALE
INFRASTRUTTURA LABORATORIALEPer tutte le tipologie di erogazione, il Corsista può accedere alle attrezzature e ai sistemi reali Microsoft presenti nei Nostri laboratori o direttamente presso i data center in modalità remota h24. Ogni partecipante dispone di un accesso per implementare le varie configurazioni avendo così un riscontro pratico e immediato della teoria affrontata.
PREREQUISITI
PREREQUISITIAl partecipante si richiede una conoscenza di base su concetti chiave come revenue, profitability e financial accounting. Consolidata competenza sui Database relazionali e Microsoft Excel.
DURATA E FREQUENZA
Durata 3gg – Varie tipologie di Frequenza Estensiva ed Intensiva.
DOCENTI
DOCENTII docenti sono Istruttori Certificati Microsoft e in altre tecnologie IT, con anni di esperienza pratica nel settore e nella Formazione.
MODALITÀ DI ISCRIZIONE
MODALITÀ DI ISCRIZIONELe iscrizioni sono a numero chiuso per garantire ai tutti i partecipanti un servizio eccellente.
L’iscrizione avviene richiedendo di essere contattati dal seguente Link, o contattando la sede al numero verde 800-177596 o inviando una richiesta all’email [email protected].
CALENDARIO
CALENDARIOCorso Power BI – Settembre 2020 – 09:00/18:00 (formula Full-Time)
Posti Rimanenti: __
Elenco Corsi Microsoft
