Mastering Power Platform: Power Apps, Power Automate, DataVerse, Power BI, and Power Virtual Agents Training Course

Microsoft Power Platform adalah platform yang dibuat dari tiga Microsoft produk: Power BI, PowerApps, dan Power Automate. Produk ini menggunakan program kode rendah untuk membantu pengguna membangun aplikasi sederhana, membuat fluxos otomatis, dan menghasilkan analytik bisnis. Platform Power membolehkan integrasi dengan berbagai sumber data bagi organisasi untuk meluaskan solusi bisnis mereka melalui layanan dan platform yang ada.

Latihan yang dibimbing oleh instruktor ini (outline atau di situ) bertujuan untuk pengurus bisnis, manajer, penyiar, dan analis data yang ingin ada ada, melakukan, integrasi, dan mengatur Microsoft Power Platform komponan dan cara yang digunakan dalam organisasi mereka.

Pada akhir latihan ini, para pegawai akan bisa:

Bangunan aplikasi sederhana dengan Power Apps untuk menciptakan solusi custom untuk keperluan bisnis setiap hari. Otomatis proses pekerjaan menggunakan Power Automate (sebelumnya dikenal sebagai Microsoft Flow) untuk menguntungkan tugas manual dan kelakuan. Membuat laporan data dan dashboard dengan Power BI untuk menghasilkan analytik yang menceritakan untuk bisnis. Build chatbots menggunakan Power Virtual Agens untuk otomatis dan menyelesaikan pertanyaan dan masalah pelanggan umum.

Format Course

Ceramah interaktif dan diskusi. Banyak latihan dan latihan. Implementasi tangan dalam lingkungan live-lab.

Pilihan Kusuasi Kursus

Untuk meminta pelatihan yang dipakai untuk kursus ini, silakan menghubungi kita untuk mengatur.

Analytic Functions are a powerful feature in SQL that enables efficient and concise data analysis within a relational database. 

This instructor-led, live training (online or onsite) is aimed at intermediate-level database administrators, SQL developers, and data analysts who wish to enhance their SQL skills by mastering the use of Analytic Functions.

By the end of this training, participants will be able to:

• Understand the concept and importance of Analytic Functions.
• Apply various Analytic Functions to solve complex analytical problems.
• Combine Analytic Functions with other SQL features for comprehensive data analysis.
• Optimize queries for better performance using Analytic Functions.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Apache Arrow is an open-source in-memory data processing framework. It is often used together with other data science tools for accessing disparate data stores for analysis. It integrates well with other technologies such as GPU databases, machine learning libraries and tools, execution engines, and data visualization frameworks.

In this onsite instructor-led, live training, participants will learn how to integrate Apache Arrow with various Data Science frameworks to access data from disparate data sources.

By the end of this training, participants will be able to:

• Install and configure Apache Arrow in a distributed clustered environment
• Use Apache Arrow to access data from disparate data sources
• Use Apache Arrow to bypass the need for constructing and maintaining complex ETL pipelines
• Analyze data across disparate data sources without having to consolidate it into a centralized repository

Audience

• Data scientists
• Data engineers

Format of the Course

• Part lecture, part discussion, exercises and heavy hands-on practice

Note

• To request a customized training for this course, please contact us to arrange.

AWS Glue adalah layanan tanpa server untuk integrasi data dari berbagai sumber yang memungkinkan pengguna menemukan, menyiapkan, memindahkan, mengintegrasikan, dan menganalisis data dengan mudah.

Pelatihan langsung yang dipandu instruktur ini (online atau di tempat) ditujukan untuk insinyur data dan analis yang ingin mempelajari pengetahuan tingkat pemula hingga menengah dalam menggunakan AWS Glue untuk menyiapkan saluran data.

Pada akhir pelatihan ini, peserta akan dapat:

Pahami dasar-dasar AWS Glue. Siapkan pipeline AWS Glue. Siapkan perayap dan pekerjaan AWS Glue. Pelajari cara menggunakan transformasi AWS Glue.

Format Kursus

Kuliah dan diskusi interaktif. Banyak latihan dan latihan. Implementasi langsung di lingkungan lab langsung.

Opsi Penyesuaian Kursus

Untuk meminta pelatihan khusus untuk kursus ini, silakan hubungi kami untuk mengaturnya.

Data analysis refers to the process of obtaining, cleaning, and analyzing data, often times in a visual manner, to derive insights for better decision making. More and more data is being stored in databases in the cloud so it is important to have a strategy for understanding, managing and accessing such data. One popular tool for accessing and visualizing data is Power Bi.

This instructor-led, live training (online or onsite) is aimed at technical persons who wish to gain a practical understanding of available cloud solutions, the data analysis processes needed to work with data in the cloud, and the hands-on practice to apply tools such as Power BI to analyze data.

By the end of this training, participants will be able to:

• Install and configure Power BI.
• Evaluate the various data solutions offered by cloud providers such as Azure.
• Gain an understanding of the different structures, modeling approaches, and data warehouse designs used to store, manage and access Big Data.
• Apply tools and techniques to clean data in preparation for analysis.
• Build reporting and analytics solutions based on on-premise as well as cloud data.
• Integrate data analytics solutions with a data warehouse.
• Mitigate data security risks and ensure data privacy.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Participants who complete this instructor-led, live training will gain a practical, real-world understanding of Big Data and its related technologies, methodologies and tools.

Participants will have the opportunity to put this knowledge into practice through hands-on exercises. Group interaction and instructor feedback make up an important component of the class.

The course starts with an introduction to elemental concepts of Big Data, then progresses into the programming languages and methodologies used to perform Data Analysis. Finally, we discuss the tools and infrastructure that enable Big Data storage, Distributed Processing, and Scalability.

Format of the Course

• Part lecture, part discussion, hands-on practice and implementation, occasional quizing to measure progress.

Dask adalah perpustakaan yang fleksibel dan berprestasi tinggi Python untuk komputer paralel. Ini memperluas dan mempercepat pemrosesan data besar dengan perpustakaan ilmu data lain yang berbasis Python seperti Pandas, Numpy, dan Scikit-Learn.

Pelatihan ini didorong oleh instruktur, secara langsung (online atau on-site) ditujukan untuk ilmuwan data dan insinyur perangkat lunak yang ingin menggunakan Dask dengan Python ekosistem untuk membangun, mengukur, dan menganalisis set data besar.

Pada akhir latihan ini, peserta akan dapat:

Tetapkan lingkungan untuk mulai membangun pemrosesan data besar dengan Dask dan Python. Temukan fitur, perpustakaan, alat, dan API yang tersedia di Dask. Memahami bagaimana Dask mempercepat pengkomputeran paralel dalam Python. Belajarlah bagaimana mengukur ekosistem Python (Numpy, SciPy, dan Pandas) menggunakan Dask. Optimalkan lingkungan Dask untuk mempertahankan kinerja yang tinggi dalam mengendalikan set data besar.

Format Kursus

Konferensi dan diskusi interaktif. Banyak latihan dan praktek. Pelaksanaan tangan di lingkungan live-lab.

Opsi Customization Kursus

Untuk meminta pelatihan tersuai untuk kursus ini, silakan hubungi kami untuk mengatur.

A business' marketing strategy is one of its most essential tools to ensure success. The rise in technology and advances in data gathering and analysis has led to a continuous transformation of marketing. Data analysis is now considered to be a crucial skill for marketers to learn. Likewise, applying data science to marketing principles is also important in helping data science professionals maximize their contributions.

In this instructor-led, live training, participants will learn how to gain valuable insights from large data sets and how to use these for marketing strategies.

By the end of this training, participants will be able to:

• Install and configure tools for data-driven marketing tools (Tableau, Google Analytics, Zarget, etc)
• Measure, test, and optimize the performance of their marketing strategies using data
• Use data to segment their customers and prospects
• Use predictive modeling to improve response rates
• Implement step-by-step data analytics to drive better marketing decisions

Audience

• Marketers
• Data scientists

Format of the course

• Part lecture, part discussion, exercises and heavy hands-on practice

Note

• To request a customized training for this course, please contact us to arrange.

Datameer is a business intelligence and analytics platform built on Hadoop. It allows end-users to access, explore and correlate large-scale, structured, semi-structured and unstructured data in an easy-to-use fashion.

In this instructor-led, live training, participants will learn how to use Datameer to overcome Hadoop's steep learning curve as they step through the setup and analysis of a series of big data sources.

By the end of this training, participants will be able to:

• Create, curate, and interactively explore an enterprise data lake
• Access business intelligence data warehouses, transactional databases and other analytic stores
• Use a spreadsheet user-interface to design end-to-end data processing pipelines
• Access pre-built functions to explore complex data relationships
• Use drag-and-drop wizards to visualize data and create dashboards
• Use tables, charts, graphs, and maps to analyze query results

Audience

• Data analysts

Format of the course

• Part lecture, part discussion, exercises and heavy hands-on practice

Python is a versatile programming language known for its simplicity and readability. Pandas is a Python package that provides data structures for working with structured (tabular, multidimensional, potentially heterogeneous) and time series data. Numpy provides fundamental support for numerical computing with its array operations. Together, they form a robust ecosystem for efficient data handling and analysis in Python.

This instructor-led, live training (online or onsite) is aimed at intermediate-level Python developers and data analysts who wish to enhance their skills in data analysis and manipulation using Pandas and NumPy.

By the end of this training, participants will be able to:

• Set up a development environment that includes Python, Pandas, and NumPy.
• Create a data analysis application using Pandas and NumPy.
• Perform advanced data wrangling, sorting, and filtering operations.
• Conduct aggregate operations and analyze time series data.
• Visualize data using Matplotlib and other visualization libraries.
• Debug and optimize their data analysis code.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Participants who complete this training will gain a practical, real-world understanding of Data Science and its related technologies, methodologies and tools.

Participants will have the opportunity to put this knowledge into practice through hands-on exercises. Group interaction and instructor feedback make up an important component of the class.

The course starts with an introduction to elemental concepts of Data Science, then progresses into the tools and methodologies used in Data Science.

Audience

• Developers
• Technical analysts
• IT consultants

Format of the Course

• Part lecture, part discussion, exercises and heavy hands-on practice

Note

• To request a customized training for this course, please contact us to arrange.

dbt (alat pembuatan data) adalah alat antarmuka baris perintah (CLI) sumber terbuka yang digunakan untuk mengelola dan mengubah data di gudang data berbasis SQL. dbt Cloud adalah versi alat dbt yang dihosting di cloud yang menyediakan antarmuka yang mudah digunakan untuk mengelola dan menerapkan proyek dbt.

Pelatihan langsung yang dipandu instruktur ini (online atau onsite) ditujukan untuk insinyur data, analis, dan ilmuwan tingkat pemula yang ingin memahami cara menggunakan dbt Cloud untuk mengelola pergudangan data dan proyek transformasi mereka di cloud.

Pada akhir pelatihan ini, peserta akan dapat:

Buat dan kelola proyek di dbt Cloud. Gunakan antarmuka dbt Cloud untuk menjadwalkan dan menjalankan transformasi data. Berkolaborasi dalam proyek dengan anggota tim. Terapkan proyek dbt mereka ke produksi. Debug dan atasi masalah proyek dbt.

Format Kursus

Kuliah dan diskusi interaktif. Banyak latihan dan latihan. Implementasi langsung di lingkungan lab langsung.

Opsi Penyesuaian Kursus

Untuk meminta pelatihan khusus untuk kursus ini, silakan hubungi kami untuk mengaturnya.

Dremio is an open-source "self-service data platform" that accelerates the querying of different types of data sources. Dremio integrates with relational databases, Apache Hadoop, MongoDB, Amazon S3, ElasticSearch, and other data sources. It supports SQL and provides a web UI for building queries.

In this instructor-led, live training, participants will learn how to install, configure and use Dremio as a unifying layer for data analysis tools and the underlying data repositories.

By the end of this training, participants will be able to:

• Install and configure Dremio
• Execute queries against multiple data sources, regardless of location, size, or structure
• Integrate Dremio with BI and data sources such as Tableau and Elasticsearch

Audience

• Data scientists
• Business analysts
• Data engineers

Format of the course

• Part lecture, part discussion, exercises and heavy hands-on practice

Notes

• To request a customized training for this course, please contact us to arrange.