POWER BI DESKTOP: MASTERING DATA VISUALIZATION (16–17 Jan 2025)

Please call 012-588 2728

 email to pearl-otc@outlook.com

 

HYBRID PUBLIC PROGRAM

POWER BI DESKTOP:

MASTERING DATA VISUALIZATION

8 CPD Points Awarded by MBOT.

 

(** Choose either Zoom OR Physical Session)

Remote Online Training (Via Zoom)  &

Wyndham Grand Bangsar Kuala Lumpur Hotel (Physical)

  (SBL Khas / HRD Corp Claimable Course)

Date : 16 Jan 2025 (Thu) |  9am – 5pm                             By Siti

17 Jan 2025 (Fri)  |  9am – 5pm                            .

                       .

INTRODUCTION:

-       Are you tired of feeling perplexed by complex data and unsure of how to interpret it? Do you aspire to elevate your data analysis proficiency? Look no further! Our course is tailored to help you master the art of Business Intelligence using Power BI Desktop.

-       This course is suitable for business analysts, data analysts, and individuals who are eager to learn about BI and data analytics, whether you're a recent graduate, a young professional, or a manager. With the guidance of our expert instructor, you'll gain a comprehensive understanding of Power BI, from connecting to various data sources to creating interactive dashboards and visualizations. You'll also learn how to use advanced features, such as tooltips, animation, and bookmarks, to make your data more captivating and design effective dashboards.

 

OBJECTIVE:

By the end of this course:

-       Help you learn Power BI Desktop from scratch

-       Covers all the essential features and functions

-       Skills you need to effectively use Power BI Desktop for data analysis

-       You will be able to analyze & visualize data like a pro

-       You will be able to make data-driven decisions with ease

-       You will also learn how to design effective dashboards

-       How to use Power BI's many features to effectively analyze and present your data

-       You'll be ready to take your data analysis skills and your career to the next level

 

WHICH MICROSOFT OFFICE VERSION SUITABLE FOR POWER BI DESKTOP?

-       Power BI Desktop is a standalone application and not a part of the Microsoft Office suite. Therefore, any version of Microsoft Office is not required for using Power BI Desktop.

-       However, if you want to export data from Power BI Desktop to Excel, then you can use Microsoft Excel, which is a part of the Microsoft Office suite. Power BI Desktop can export data to Excel in several formats, including CSV, XLSX, and PDF. So, it is recommended to use the latest version of Microsoft Excel for optimal compatibility with Power BI Desktop.

 

OUTLINE OF WORKSHOP

1.0 Power BI Desktop

1.1 What is Power BI?

1.2 Why Power BI?

1.3 How Power BI Works

1.4 How to Install Power BI Desktop

 

2.0 Basic Charts in Power BI Desktop

2.1 Column Chart

2.2 Stacked Column Chart

2.3 Pie Chart

2.4 Donut Chart

2.5 Funnel Chart

2.6 Ribbon Chart

2.7 Filter - Keep only and Exclude

2.8 View Data and Export

 

3.0 How to Create a Map in Power BI

3.1 Map

3.2 Filled Map

3.3 Map with Pie Chart

3.4 Formatting in Map

3.5 How to Change Background in Power BI Map

 

4.0 Table and Matrix in Power BI

4.1 Creating a Simple Table

4.2 Formatting in Table

4.3 Conditional Formatting in Table

4.4 Changing Aggregation in Table

4.5 Creating a Matrix in Power BI

4.6 Automatic Hierarchy in Matrix

4.7 Subtotal and Grand Total

4.8 Number Formatting in Table and Matrix

 

5.0 Other Charts in Power Bi Charts

5.1 Line Chart

5.2 Drill down in Line Chart

5.3 Area Chart

5.4 Line vs Column Chart

5.5 Scatter Plot

5.6 Waterfall Chart

5.7 TreeMap

5.8 Guage Chart

 

6.0 Cards and Filters

6.1 Number Card

6.2 Text Card

6.3 Date Card

6.4 Multi-Row Card

6.5 Filter on Visual

6.6 Filter on Page

6.7 Filter on All Pages

6.8 Drill through

 

7.0 Slicers in Power BI Desktop

7.1 Slicer for Text

7.2 Format Text Slicer

7.3 Date Slicer

7.4 Format Date Slicer

7.5 Number Slicer

 

8.0 Advanced Charts in Power BI

8.1 Animated Bar Chart Race

8.2 Drill Down Donut Chart

8.3 Drill Down Column Chart

8.4 Word Count

8.5 Sankey Chart

8.6 Infographic

8.7 Play Axis

8.8 Scoller

8.9 Sunburst Chart

8.10 Histogram

 

9.0 Object and Actions (Hyperlinks)

9.1 Insert Image

9.2 Insert Text

9.3 Insert Shapes

9.4 Insert Buttons

9.5 Action – Web URL

9.6 Action – Page Navigation

9.7 Action – Back

9.8 Action – Bookmark

 

10.0 Power BI Services Introduction

10.1 Creating a Report

10.2 Publish Report to Power BI Service Account

10.3 Export (PPT, PDF, PBIX) Report and Share

10.4 Create a dashboard in Power BI Service

 

 

** Certificate of attendance will be awarded for those who completed the course

 

ABOUT THE FACILITATOR

 

Siti  

Microsoft Office Specialist (MOS)

 

Siti  started her career as an Information Technology Lecturer in few local colleges and universities back in year 1999. In her 8 years’ experience as a lecturer, she picks up various discipline in IT related subjects. She also involved in giving Microsoft Office Applications training to various companies.

 

Since 20 March 2006 till present, Siti Suriani decided for a career change. She moved to IT related training. As a Training Consultant, she focused more on Microsoft Office Applications training. She has facilitated training programs in link with broad-ranging groups of training institutes and clients. She is familiar and proficient with Microsoft Office Applications and during her training she will address the day to day issues faced by employees in today’s corporate environment.

 

In year 2007 till 2008 Siti Suriani had been appointed as one of the Master Trainer for The Teaching and Learning of Science and Mathematics in English (Pengajaran dan Pembelajaran Sainsdan Matematik Dalam Bahasa Inggeris - PPSMI). Her role as a Master Trainer was to give training to all the trainers representing different states around Malaysia on how to deliver the training to all the teachers in various schools in Malaysia.

 

Aside to giving training, Microsoft Malaysia has engaged her to share her expertise on how to fully maximize the usage of Microsoft Office Applications since year 2008 till current. She had done many workshops around Malaysia for major Microsoft Malaysia customers mostly focusing on the Tips and Tricks and also best practices.

 

Siti  was involved as a Handyman in Handyman Project under Shell Global Solutions, Malaysia since 2008 till 2011. To be given the opportunity to give One-to-one consultation with the client by looking, asking and solve problem related to the data provided by the clients.


Examples of topics covered for Handyman sessions are E-mail and Calendar, Standard & Mobile Office, Archiving & Back-ups, NetMeeting, Livelink, Live Meeting? and Microsoft
Office Applications.

 

Nov 2010 to Feb 2011 she was being given another golden opportunity by ExxonMobil Malaysia to be the lead trainer in the Migration from XME to GME project to train almost 3000 staffs. This training also includes Microsoft Office 2010 and Windows 7.

 

Academic Qualification

1999 – Bachelor of Computer Science (Honours) · Computing (Single Major) - USM

2001 – Master of Science · Distributed Computing - UPM

 

Working Experience

-       Cybernetics International College of Technology · Lecturer · (June 1999 to May 2002)

-       MARA University of Technology (UiTM Seri Iskandar) · Lecturer · (June 2002 to July 2003)

-       Cosmopoint College of Technology · Lecturer · (September 2005 to March 2006)

-       Iverson Associates SdnBhd · Senior Training Consultant · (March 2006 to February 2011)

-       Info TrekSdnBhd · Senior Training Consultant· (February 2011 to April 2017)

-       Fulltime Senior Training Consultant · (May 2017 to present)

 

Professional Certification

-       Microsoft Certified Application Specialist for Office Excel 2007

-       Microsoft Certified Application Specialist for Office PowerPoint 2007

-       Microsoft Certified Application Specialist for Office Word 2007

-       Microsoft Office Specialist for Office Excel 2016

-       Microsoft Office Specialist for Office Word 2016

-       PSMB Certified Trainer

 

(SBL Khas / HRD Corp Claimable Course)

TRAINING FEE

14 hours Remote Online Training (Via Zoom)

RM 1,296.00/pax     (excluded 8% SST)

2 days Face-to-Face Training (Physical Training at Hotel)

RM 1,850.00/pax     (excluded 8% SST)

Group Registration: Register 3 participants from the same organization, the 4th participant is FREE.
(Buy 3 Get 1 Free) if
Register before 9 Jan 2025. Please act fast to grab your favourite training program!

 

We hope you find it informative and interesting and we look forward to seeing you soon.

Please act fast to grab your favorite training program! Please call 012-588 2728

or email to pearl-otc@outlook.com

 

Do forward this email to all your friends and colleagues who might be interested to attend these programs

 

If you would like to unsubscribe from our email list at any time, please simply reply to the e-mail and type Unsubscribe in the subject area.

We will remove your name from the list and you will not receive any additional e-mail

 

Thanks 

Regards

Pearl


by "pearl@otcmarketing.com.my" <pearl@otcmarketing.com.my> - 10:07 - 18 Nov 2024