Microsoft Power BI is a collection of software services, apps, and connectors that work together to transform unrelated data sources into coherent, interactive, and visually appealing insights.
This training discusses: Basic use of the Power BI application, installation, retrieving data sources, connecting data sources, using DAX functions, analysis, and visualization in the form of a Dashboard.
With these basic skills, participants can process raw data into interesting data visualizations.
Outlines:
1. Introduction to Power BI:
- What is Power BI
- Power BI Desktop; The First Experience
- Introduction to Power BI Components: Power Query, Power Pivot, Power View, Power Map and Power Q&A
2. Pengenalan power BI
- What is Power Query
- Get Started with Power Query
- Power BI Get Data From Excel: Everything You Need to Know
- Definitive Guide to Power BI Personal Gateway
- File Sources
- Folder as a Source
- Database Sources
- Analysis Services Connection
3. Data Visualization With Power BI
- Data Visualization Best Practices
- Power BI Desktop Visualization
- Custom Visuals in Power BI Desktop
- Formatting Visuals in Power BI Desktop
- Power View for Excel
- Charts, Scorecards, and other visualization items in Power View
- Sorting, Filtering and categorization with Power View
- Best Practices to work with Power View
- 3D Geospatial visualization with Power Map
4. Power Query For Data Transformation
- Installation, Requirements and Configuration
- Different versions of Power Query
- Power Query Introduction
- Query Editor
- Transformation GUI
- Row Transformations
- Column Transformations
- Data Type
- Adding Column
- Text Transformations
- Number Column Calculations
- Date and Time Calculations
- Data types, Lists, Records, and tables in M
- M built-in functions
- Generators in M
- Writing Custom Functions
- Error handling
- Advanced Data Transformations with M
5. Power Pivot For Data Modelling
- Power Pivot xVelocity engine basics and concepts
- Different versions of Power Pivot
- Relationships in Power Pivot
- Best practices
- Introduction to DAX
- Calculated Members
- Row Context vs Set Context
- Advanced calculations using Calculate functions
- Time Functions
- DAX Advanced
- Power Pivot embedded in Power BI Desktop
- Different versions of Power Map
- Best Practices to work with Power Map
6. Power BI Desktop; Combination Of Three Tools
- Power BI Desktop Introduction
- Getting data from different data sources
- Differences of Power Query stand-alone with Power Query in Power BI Desktop
- Modeling data, and relationships
- Creating calculated measures
- Power Pivot difference in Power BI Desktop
- Visualizing data in Power BI Desktop
- Power View difference in Power BI Desktop
- Best practices of designing solutions with Power BI
- Custom Visuals for Power BI Desktop
Pilihan Kelas:
1. Online In-House Training (Group Perusahaan)
2. Online Training Class (Private)
2. OFFLINE Training / Kelas Tatap Muka di Jakarta.
Fasilitas:
- Modul Digital
- Sertifikat
- Class Room Training : PC/Laptop, LCD Projector/LED TV.
INFO PENDAFTARAN
- Jadwal kelas baru dibuka setiap waktu.
- Untuk permintaan Surat Penawaran > Hubungi Customer Service.
INFO & PENDAFTARAN HUBUNGI CUSTOMER SERVICE : INFO CENTER 0812 9787 0123
