Online Class

POWER BI COMBO

Data Analysis & Visualisation

✅Whatsapp Support Group 24 Jam
✅FREE CERTIFICATE
✅FREE RECORDING
✅FREE WORKBOOK

Anda akan belajar 30+ topik

Basic Level >>

  1. Understanding Business Intelligence

  2. What is Power BI?

  3. Understanding Power BI Ecosystem

  4. Getting to know Power BI Desktop Interface

  5. Navigating with the application

  6. Get data

  7. Create basic report

  8. Introduction to Data Model

  9. Designing Data Model

  10. Set relationships between tables using the MODEL view

  11. Create reports using data model

  12. Creating our first chart!

Intermediate Level >>

  1. Analyzing Sales Person Performance

  2. Adding More Measures

  3. Formatting The Visuals + Conditional Formatting

  4. Understanding different filters that are available

    • Visual, Page, Report and Slicer

    • Enable/Disable filter interactions between visuals

  5. Setting up Drill through

  6. Understanding Power Query Editor

  7. Transforming, clean, append and merge data

    • Removing unwanted columns & duplicates

    • Renaming, merging & splitting columns

    • Replacing Null Values

Advanced Level >>

  1. Introduction to DAX (Data Analysis Expressions)

  2. Working with Calculated Columns & Measures

  3. Aggregations, Filter & Logical Functions

  4. Time Intelligence Functions

  5. Report Drillthrough

  6. Enable Drilldown data in visuals

  7. Bookmarks and Buttons

  8. Selection and Layers

  9. Build and format a custom tooltip

  10. Power BI Dashboard Tips and Tricks

  11. Conditional Formatting of Charts

  12. Align Objects

4 Topik Utama Yang Anda Akan Belajar Untuk Mahir Data Analysis 📊

Jangan risau tentang topik apa yang anda akan pelajari. Kami mengajar topik yang terkini yang dapat menaikkan produktiviti anda sebanyak 10x ganda.

Seperti gambar di atas☝️, data yang anda lihat setiap hari boleh mengeluarkan "story" dan "critical information", anda cuma perlu bijak menggunakan tools yang ada untuk "extract" keluar story dan information itu.

4 topik ini boleh membantu anda baca, process dan visualise data anda.

Jom tengok topik-topik yang anda akan belajar.

Data Transformation >>

Overview:

This topic covers how to connect Power BI to various data sources (e.g., Excel, SQL Server, cloud services) and transform the data using Power Query.

Key Concepts:

Data import, data cleaning, data transformation, and data modeling.

Data Modeling >>

Overview:

This topic focuses on structuring and organizing data to create meaningful relationships between tables, enabling accurate analysis and reporting.

Key Concepts:

Relationships, calculated columns, measures, and the use of DAX (Data Analysis Expressions) for advanced calculations.

Data Visualization >>

Overview:

This topic emphasizes the creation of reports and dashboards to visualize data effectively, using various visual elements such as charts, graphs, and maps.

Key Concepts:

Choosing the right visualizations, customizing visuals, creating interactive reports, and using slicers and filters.

Power Query

Overview:

This topic delves into the Power Query Editor, which allows users to connect, combine, and refine data from multiple sources before loading it into Power BI.

Key Concepts:

Query editing, data transformation techniques (e.g., merging, appending), and applying filters and calculations within the query.

Siapakah Mrs Iman?

  • Senior Auditor at Deloitte UK

  • First Class Degree in Accounting, University of Manchester

  • Certified HRDF Trainer

  • Founder Excelmudah, lebih 500k Followers di Instagram & Tiktok

  • Expert in Microsoft 365 & Google Workspace Tools.

  • Membantu clients dari Singapore, Brunei, dan serata Indonesia.

Dipercayai lebih daripada 10,000 organisasi

Adakah anda mempunyai masalah di bawah?

❌Data terlalu banyak, selalu error

❌Kerja tak siap,selalu balik lambat

❌Bazir masa "analyse" data

❌Search tutorial di Youtube tapi tak faham

FAQ

Ada soalan? Kami ada jawapan:

Macam mana saya nak practise ada workbook ke?

Ya! Ada Workbook Excel PERCUMA yang kami akan berikan kepada anda untuk digunakan ketika kelas berlangsung.

Saya akan dapat sijil ke?

Ya! Setiap peserta yang menghabiskan kelas Aidea Big Excel Course akan mendapatkan sijil secara automatic yang akan dihantar terus ke email anda.

Saya nak beli untuk company, boleh ke?

Untuk training company kami suggest pihak anda untuk contact kami di +60 11-5857 7185 kerana anda akan mungkin layak untuk dapat Group Discount!