Online Class
Data Analysis & Visualisation
✅Whatsapp Support Group 24 Jam
✅FREE CERTIFICATE
✅FREE RECORDING
✅FREE WORKBOOK
Understanding Business Intelligence
What is Power BI?
Understanding Power BI Ecosystem
Getting to know Power BI Desktop Interface
Navigating with the application
Get data
Create basic report
Introduction to Data Model
Designing Data Model
Set relationships between tables using the MODEL view
Create reports using data model
Creating our first chart!
Analyzing Sales Person Performance
Adding More Measures
Formatting The Visuals + Conditional Formatting
Understanding different filters that are available
Visual, Page, Report and Slicer
Enable/Disable filter interactions between visuals
Setting up Drill through
Understanding Power Query Editor
Transforming, clean, append and merge data
Removing unwanted columns & duplicates
Renaming, merging & splitting columns
Replacing Null Values
Introduction to DAX (Data Analysis Expressions)
Working with Calculated Columns & Measures
Aggregations, Filter & Logical Functions
Time Intelligence Functions
Report Drillthrough
Enable Drilldown data in visuals
Bookmarks and Buttons
Selection and Layers
Build and format a custom tooltip
Power BI Dashboard Tips and Tricks
Conditional Formatting of Charts
Align Objects
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.
✅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.
✅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.
✅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.
✅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.
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
❌Data terlalu banyak, selalu error
❌Kerja tak siap,selalu balik lambat
❌Bazir masa "analyse" data
❌Search tutorial di Youtube tapi tak faham
Ada soalan? Kami ada jawapan:
Ya! Ada Workbook Excel PERCUMA yang kami akan berikan kepada anda untuk digunakan ketika kelas berlangsung.
Ya! Setiap peserta yang menghabiskan kelas Aidea Big Excel Course akan mendapatkan sijil secara automatic yang akan dihantar terus ke email anda.
Untuk training company kami suggest pihak anda untuk contact kami di +60 11-5857 7185 kerana anda akan mungkin layak untuk dapat Group Discount!