Microsoft Power BI

Actual Training

Training Data Analysis with Microsoft Power BI

Pada tanggal 27 – 30 September 2021 telah dilangsungkan online training dengan judul Data Analysis with Microsoft Power BI. Training ini diikuti oleh 5 orang peserta dari BPJS TK.

Saat ini perusahaan/instansi membutuhkan analisis data lebih dari sebelumnya. Dalam pelatihan ini akan diajarkan tentang bagaimana keterampilan, tugas, dan proses dari analis data untuk menyajikan data sehingga dapat menjadi pendukung keputusan bisnis yang dapat dipercaya. Peserta akan mempelajari bagaimana tools dan layanan Power BI digunakan oleh seorang analis data untuk menyajikan insight data yang menarik melalui report dan dashboard, dan kebutuhan akan BI yang sebenarnya di perusahaan.

Adapun materi yang dibahas pada pelatihan ini adalah sebagai berikut:

Discover data analysis

      • Overview of data analysis
      • Roles in data
      • Tasks of a data analyst
      • Get started building with Power BI
      • Use Power BI
      • Building blocks of Power BI
      • Tour and use the Power BI service

Get data in Power BI

  • Get data from files
  • Get data from relational data sources
  • Get data from a NoSQL database
  • Get data from online services
  • Select a storage mode
  • Resolve data import errors

Clean, transform, and load data in Power BI

  • Shape the initial data
  • Simplify the data structure
  • Evaluate and change column data types
  • Combine multiple tables into a single table
  • Profile data in Power BI
  • Use Advanced Editor to modify M code

Design a data model in Power BI

  • Work with tables
  • Create a date table
  • Work with dimension
  • Define data granularity
  • Work with relationships and cardinality
  • Resolve modeling challenges

Introduction to creating measures using DAX in Power BI

  • Introduction to DAX
  • Understand context
  • Use the Calculate function
  • Use relationships effectively
  • Create semi-additive measures
  • Work with time intelligence

Work with Power BI visuals

  • Introduction to work with Power BI visuals
  • Add visualization items to reports
  • Choose an effective visualization
  • Format and configure visualizations
  • Import a custom visual
  • Work with key performance indicators

Create a data-driven story with Power BI reports

  • Introduction to create a data-driven story with Power BI reports
  • Design a report layout
  • Add buttons, bookmarks, and selections
  • Design report navigation
  • Use basic interactions
  • Use advanced interactions and drill through
  • Configure conditional formatting
  • Apply slicing, filtering, and sorting
  • Publish and export reports
  • Comment on reports
  • Tune report performance
  • Optimize reports for mobile use

Create dashboards in Power BI

  • Introduction to dashboards
  • Configure data alerts
  • Explore data by asking questions
  • Add a dashboard theme
  • Pin a live report page to a dashboard
  • Configure a real-time dashboard
  • Configure data classification
  • Set mobile view

imageimage