Prerequisiti
Questo corso è dedicato ai Data e Business Analysts che vogliono migliorare la propria capacità di ottimizzare la modellazione e la visualizzazione dei dati. È preferibile avere qualche esperienza pregressa con strumenti di visualizzazione dei dati come Power BI, Tableau, QlikView o Excel con PowerPivot e Power View.
Obiettivi di apprendimento
- Raccolta e analisi dei dati da qualsiasi fonte inclusi Excel, Access, SQL, sistemi ERP, siti web, servizi online, social media e altro
- Trasformare e modellare i dati per visualizzare accuratamente le relazioni che vuoi vedere.
- Sviluppare calcoli analitici utilizzando Data Analysis Expressions (DAX)
- Costruire visualizzazioni di dati avanzate che rendono i tuoi insight più facili da comprendere
- Creare dashboard complete come Customer Analysis Dashboard, HR Analytics Dashboard, Executive Insights Dashboard e molte altre
- Ottimizzare la collaborazione e la distribuzione all’interno della tua rete utilizzando Workspaces e Apps
- Ottimizzare i reporti per visualizzarli tramite mobile
Course Outline
Module 01 Introductions & Setup
- Introductions
- Course Overview
- Course Materials & Setup Module 01 Introduction to Business Intelligence
- Business Intelligence Overview
- Business Analytics
- Business Trends – Self Service – Enterprise
- Common Approaches
- Common Pitfalls
- Common Architectures
- Business Intelligence Applications
- Microsoft BI Tool
- Module Summary
Module 02 Introduction to Power BI Ecosystem
- Power BI Overview – Components of the Ecosystem – Power BI Desktop – Power BI Service – Power BI Mobile – Power BI Embedded – Power BI Report Server
- Components of Power BI
- Power BI Licensing
- Module Summary
Module 03 Introduction to Power BI Desktop
- Power BI Development Life Cycle – Data Discovery – Data Modeling – Data Visualization
- Power BI Desktop: Core Activities
- Power BI Desktop Key Features & Navigation – Main Canvas – Left Navigation Pane – Visualization Navigation Pane – Fields Navigation Pane
- Module Summary
Module 04 Get Data – Gathering & Cleansing
- Data Source – Connectors
- Getting Data
- Query Editor
- Advanced Editor – Welcome to M – Work with Transformations – Navigate the Process Pane – Load the Model – Show Advanced Editor options
- Module Summary
Module 05 Modeling – Dimensional Modeling
- Key Concepts
- Basic Modeling Enhancements – Tables/Column – Data Formatting and Categorization
- Relationships – Hierarchies
- Introduction to DAX
- Measures & Calculated Columns – Implicit/Explicit Measures – Calculated Columns
- Date Table
- Module Summary
Module 06 Modeling – Improving the Data Model
- Key Concepts
- Basic Modeling Enhancements – Tables/Column – Data Formatting and Categorization – Relationships – Hierarchies – DEMO 06-01 – Apply modeling enhancement to existing model
- Introduction to DAX
- Measures & Calculated Columns – Implicit/Explicit Measures – Calculated Columns
- Date Table
- Module Summary
Module 07 Visualize – Introduction to Visuals & Chart Interactions
- Power BI Reports (Desktop)
- Visualization Pane
- Fields Pane
- Top Navigation Ribbon
- Key Visual Elements – Visuals – Slicers – Visual Interaction – Data/Drill – See Records/Data – Maps
- Drillthrough
- Module Summary
Module 08 Introduction to Power BI Service
- Power BI Service
- Navigating Power BI Service
- Workspaces – Creation – Roles – Limitations
- Workspace Content – Dataset – Workbooks – Reports – Dashboards
- Module Summary
Module 09 Get Data – Advanced Transformations
- Advanced Transformations
- Power Query (M Language)
- Parameters/Functions
- R & Python (Transformations)
- Module Summary
Module 10 Modeling – Introduction to DAX
- DAX Explained
- DAX Function
- Understanding Context – Row Context – Query Context – Filter Context
- CALCULATE Function
- Time Intelligence – Date Table
- Variables (VAR)
- Module Summary
Module 11 Modeling – Advanced Modeling Techniques
- Calculated Tables
- Disconnected Slicers
- Time Intelligence
- Relationships – Active/Inactive – Cross Filter
- Role-Playing Dimensions
- Q&A(Desktop)
- What-If Parameters
- Grouping & Binning Data
- Module Summary
Module 12 Visualize – Advanced Visualizations
- Visuals
- Analytical Pane – Reference Lines – Trend Lines – Percentile Lines – Forecasting
- Importing Visuals
- Dynamic Visuals
- Custom Visuals
- R & Python Visualizations
- Module Summary
Module 13 Visualize – Advanced Features
- Bookmarks
- Report Design – Buttons, Images, Shapes – Filters – Conditional Formatting – Tool Tips – Sync Slicers – Themes – Templates
- Module Summary
