January | 2021 | Nanang Sadikin Official

Archive for January, 2021

Sertifikasi Internasional Microsoft Certified: Data Analyst Associate

January 14, 2021

Buat kamu yang berprofesi sebagai Database Analyst, kurang lengkap rasanya kalau kamu belum punya sertifikasi Microsoft Certified: Data Analyst Associate. Untuk mendapatkan Sertifikasi Microsoft Certified: Data Analyst Associate, kamu harus ikut ujian DA-100: Analyzing Data with Microsoft Power BI di Pearson VUE Testing Center yang ada di seluruh Indonesia. Ujiannya berbahasa Inggris dengan jumlah pertanyaan 65 buah dan lama ujiannya sekitar 90 menit.

Harga Ujiannya Sendiri : 80 USD (Indonesia)

Berikut adalah exam objectives untuk ujian DA-100: Analyzing Data with Microsoft Power BI

Prepare the Data (20-25%)

Get data from different data sources
identify and connect to a data source
change data source settings
select a shared dataset or create a local dataset
select a storage mode
choose an appropriate query type
identify query performance issues
use Microsoft Dataversethe Common Data Service (CDS)
use parameters
use or create a PBIDS file
use or create a data flow

Profile the data
identify data anomalies
examine data structures
interrogate column properties
interrogate data statistics

Clean, transform, and load the data
resolve inconsistencies, unexpected or null values, and data quality issues
apply user-friendly value replacements
identify and create appropriate keys for joins
evaluate and transform column data types
apply data shape transformations to table structures
combine queries
apply user-friendly naming conventions to columns and queries
leverage Advanced Editor to modify Power Query M code
configure data loading
resolve data import errors

Model the Data (25-30%)

Design a data model
define the tables
configure table and column properties
define quick measures
flatten out a parent-child hierarchy
define role-playing dimensions
define a relationship’s cardinality and cross-filter direction
design the data model to meet performance requirements
resolve many-to-many relationships
create a common date table
define the appropriate level of data granularity

Develop a data model
apply cross-filter direction and security filtering
create calculated tables
create hierarchies
create calculated columns
implement row-level security roles
set up the Q&A feature

Create measures by using DAX
use DAX to build complex measures
use CALCULATE to manipulate filters
implement Time Intelligence using DAX
replace numeric columns with measures
use basic statistical functions to enhance data
create semi-additive measures

Optimize model performance
remove unnecessary rows and columns
identify poorly performing measures, relationships, and visuals
improve cardinality levels by changing data types
improve cardinality levels through summarization
create and manage aggregations

Visualize the Data (20-25%)

Create reports
add visualization items to reports
choose an appropriate visualization type
format and configure visualizations
import a custom visual
configure conditional formatting
apply slicing and filtering
add an R or Python visual
configure the report page
design and configure for accessibility
configure automatic page refresh

Create dashboards
set mobile view
manage tiles on a dashboard
configure data alerts
use the Q&A feature
add a dashboard theme
pin a live report page to a dashboard
configure data classification

Enrich reports for usability
configure bookmarks
create custom tooltips
edit and configure interactions between visuals
configure navigation for a report
apply sorting
configure Sync Slicers
use the selection pane
use drillthrough and cross filter
drilldown into data using interactive visuals
export report data
design reports for mobile devices

Analyze the Data (10-15%)
Enhance reports to expose insights
apply conditional formatting
apply slicers and filters
perform top N analysis
explore statistical summary
use the Q&A visual
add a Quick Insights result to a report
create reference lines by using Analytics pane
use the Play Axis feature of a visualization
personalize visuals

Perform advanced analysis
identify outliers
conduct Time Series analysis
use groupings and binnings
use the Key Influencers to explore dimensional variances
use the decomposition tree visual to break down a measure
apply AI Insights

Deploy and Maintain Deliverables (10-15%)

Manage datasets
configure a dataset scheduled refresh
configure row-level security group membership
providing access to datasets
configure incremental refresh settings
promote or certify Power BI content a dataset
identify downstream dataset dependencies

Create and manage workspaces
create and configure a workspace
recommend a development lifecycle strategy
assign workspace roles
configure and update a workspace app
publish, import, or update assets in a workspace
apply sensitivity labels to workspace content
use deployment pipelines

Buat kamu yang mau belajar berbagai macam materi Teknologi Informasi, kamu bisa melihat kumpulan tutorialnya disini :

Cloud Computing : https://bukutrainingns.blogspot.com/2020/01/kumpulan-tutorial-belajar-cloud.html
Web : https://bukutrainingns.blogspot.com/2020/02/kumpulan-tutorial-belajar-web.html
Server Hardware : https://bukutrainingns.blogspot.com/2020/01/kumpulan-tutorial-belajar-server.html
Data Center : https://bukutrainingns.blogspot.com/2020/01/kumpulan-tutorial-belajar-data-center.html
Veritas Backup Exec : https://bukutrainingns.blogspot.com/2020/01/kumpulan-tutorial-belajar-veritas.html
Windows Server 2012R2 : https://bukutrainingns.blogspot.com/2019/12/kumpulan-tutorial-belajar-windows.html
Windows Server 2016 : https://bukutrainingns.blogspot.com/2019/12/kumpulan-tutorial-belajar-windows_6.html
Windows Server 2019 : https://bukutrainingns.blogspot.com/2019/12/kumpulan-tutorial-belajar-windows_19.html
Active Directory : https://bukutrainingns.blogspot.com/2019/12/kumpulan-tutorial-belajar-active.html
Exchange Server 2013 : https://bukutrainingns.blogspot.com/2019/12/kumpulan-tutorial-belajar-exchange.html
Exchange Server 2016 : https://bukutrainingns.blogspot.com/2019/12/kumpulan-tutorial-belajar-exchange_9.html
Exchange Server 2019 : https://bukutrainingns.blogspot.com/2019/12/kumpulan-tutorial-belajar-exchange_20.html
Linux Ubuntu : https://bukutrainingns.blogspot.com/2019/12/kumpulan-tutorial-belajar-linux-ubuntu.html
Linux RedHat : https://bukutrainingns.blogspot.com/2019/12/kumpulan-tutorial-belajar-linux-redhat.html
Linux CEntOS : https://bukutrainingns.blogspot.com/2019/12/kumpulan-tutorial-belajar-linux-centos.html
Cisco : https://bukutrainingns.blogspot.com/2019/12/kumpulan-tutorial-belajar-cisco.html
Mikrotik : https://bukutrainingns.blogspot.com/2019/12/kumpulan-tutorial-belajar-router.html
Hyper-V : https://bukutrainingns.blogspot.com/2019/12/belajar-hyper-v-kumpulan-tutorial.html
SQL Server 2014 : https://bukutrainingns.blogspot.com/2019/12/kumpulan-tutorial-belajar-sql-server.html
Jobs dan Career : https://bukutrainingns.blogspot.com/2019/12/kumpulan-tutorial-karir-dunia-teknologi.html
Microsoft Office Word : https://bukutrainingns.blogspot.com/2019/12/kumpulan-tutorial-belajar-microsoft.html
VMWare VSphere : https://bukutrainingns.blogspot.com/2019/12/kumpulan-tutorial-belajar-vmware-vsphere.html

Buat kamu yang mau belajar Sertifikasi Internasional bisa lihat kumpulan tutorialnya disini:

Untuk artikel dan tutorial seputar IT kamu bisa kunjungi web saya berikut ini:

https://bukutrainingns.blogspot.com/

Untuk video tutorial seputar IT dan lainnya kamu bisa kunjungi Channel YouTube saya disini ya:

https://www.youtube.com/channel/UCikwGDYfTFWQxdiCqKvx6_w

Semoga bermanfaat.

Salam

Nanang

Posted in Karir | Leave a Comment »

Sertifikasi Internasional Microsoft 365 Certified: Modern Desktop Administrator Associate

January 5, 2021

Buat kamu yang berprofesi sebagai Systems Administrator, kurang lengkap rasanya kalau kamu belum punya sertifikasi Microsoft 365 Certified: Modern Desktop Administrator Associate. Untuk mendapatkan Sertifikasi Microsoft 365 Certified: Modern Desktop Administrator Associate, kamu harus ikut ujian Ujian MD-100: Windows 10 dan Ujian MD-101: Managing Modern Desktops di Pearson VUE Testing Center yang ada di seluruh Indonesia. Ujiannya berbahasa Inggris dengan jumlah pertanyaan 65 buah dan lama ujiannya sekitar 90 menit.

Harga Ujiannya Sendiri : 80 USD (Indonesia)

Berikut adalah exam objectives untuk Ujian MD-100: Windows 10

Deploy Windows (15-20%)

Deploy Windows 10
configure language packs
migrate user data
perform a clean installation
perform an in-place upgrade (using tools such as MDT, WDS, ADK, etc.)
select the appropriate Windows edition
troubleshoot activation issues

Perform post-installation configuration
configure Edge and Internet Explorer
configure mobility settings
configure sign-in options
customize the Windows desktop

Manage devices and data (35-40%)

Manage local users, local groups, and devices
manage devices in directories
manage local groups
manage local users

Configure data access and protection
configure NTFS permissions
configure shared permissions

Configure devices by using local policies
configure local registry
implement local policy
troubleshoot group policies on devices

Manage Windows security
configure user account control (UAC)
configure Windows Defender Firewall
implement encryption

Configure connectivity (15-20%)

Configure networking
configure client IP settings
configure mobile networking
configure VPN client
troubleshoot networking
configure Wi-Fi profiles

Configure remote connectivity
configure remote management
enable PowerShell Remoting
configure remote desktop access

Maintain Windows (25-30%)
Configure system and data recovery
perform file recovery (including OneDrive)
recover Windows 10
troubleshoot startup/boot process

Manage updates
check for updates
troubleshoot updates
validate and test updates
select the appropriate servicing channel
configure Windows update options

Monitor and manage Windows
configure and analyze event logs
manage performance
manage Windows 10 environment

Berikut adalah exam objectives untuk Ujian MD-101: Managing Modern Desktops

Deploy and update operating systems (35-40%)

Plan and implement Windows 10 by using dynamic deployment
evaluate and select an appropriate deployment options
pilot deployment
manage and troubleshoot provisioning packages
evaluate deployment options in Microsoft Endpoint Manager

Plan and implement Windows 10 by using Windows Autopilot
evaluate and select an appropriate deployment options
pilot deployment
create, validate, and assign deployment profile
extract device HW information to CSV file
import device HW information to cloud service
troubleshoot deployment

Upgrade devices to Windows 10
identify upgrade and downgrade paths
manage in-place upgrades
configure a Desktop Analytics environment
assess which computers can be upgraded to Windows 10
migrate user profiles

Manage updates
configure Windows 10 delivery optimization
configure Windows Update for Business
deploy Windows updates
implement feature updates
monitor Windows 10 updates

Manage device authentication
manage authentication policies
manage sign-on options
perform Azure AD join

Manage policies and profiles (25-30%)

Plan and implement co-management
implement co-management precedence
migrate group policy to MDM policies
recommend a co-management strategy

Implement conditional access and compliance policies for devices
implement conditional access policies
manage conditional access policies
plan conditional access policies
implement device compliance policies
manage device compliance policies
plan device compliance policies

Configure device profiles
implement device profiles
manage device profiles
plan device profiles

Manage user profiles
configure user profiles
configure Enterprise State Roaming in Azure AD
configure sync settings
implement Folder Redirection, including OneDrive

Manage and protect devices (20-25%)

Manage Windows Defender
implement and manage Windows Defender Application Guard
implement and manage Windows Defender Credential Guard
implement and manage Windows Defender Exploit Guard
implement Microsoft Defender Advanced Threat Protection
integrate Windows Defender Application Control
manage Windows Defender Antivirus

Manage Intune device enrollment and inventory
configure enrollment settings
configure Intune automatic enrollment
enable device enrollment
enroll non-Windows devices
enroll Windows devices
generate custom device inventory reports’ Review device inventory

Monitor devices
monitor device health (e.g., log analytics, Desktop Analytics, or other cloud-based tools, etc.)
monitor device security

Manage apps and data (10-15%)
Deploy and update applications
assign apps to groups
deploy apps by using Intune
deploy apps by using Microsoft Store for Business
deploy Microsoft 365 Apps for Enterprise
enable sideloading of apps into images
gather Microsoft 365 Apps readiness data
configure and implement kiosk (assigned access) or public devices

Implement Mobile Application Management (MAM)
implement MAM policies
manage MAM policies
plan MAM
configure Windows Information Protection
securing data by using Intune