A step by step guide to enhance your skill in Power BI

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights.

 

Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses.

Power BI lets you easily connect to your data sources, visualize and discover what’s important, and share that with anyone or everyone you want.

 

Do you want to enhance your skill in Power BI ?

1. You plan to organize a Power BI class at your company? 

 

2. You look for experienced trainer to train your class?

 

3. You look for the class that within your training budget?

 

If YES, you have one of the situation above, this is the right place for you.

INTRODUCING:-

Microsoft Power BI Training

Special packages for in-house & public class

Course contents

MICROSOFT POWER BI

Duration: 3 Days

 

OVERVIEW

Learn how to create, control and present you report professionally with Microsoft Power BI.

 

AUDIENCE:

The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.

 

SOFTWARE REQUIREMENT:

Each computer will need to have the following software installed. Unless otherwise specified, the software should be full licensed versions.

  • Microsoft® Windows® 10
  • Microsoft .NET version 4.5
  • Microsoft® 365 Business Premium (Trial)

NOTE: Students will need to be provided with a Microsoft 365 Business Premium trial email address that they can access during the course.

  • Adobe® Acrobat® Reader
  • Power BI ® Desktop
  • Any web browser

 

METHODOLOGY:

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.

 

COURSE OBJECTIVES:

  • Analyze data with self-service BI.
  • Connect to data sources.
  • Perform data cleaning, profiling, and shaping.
  • Visualize data with Power BI.
  • Enhance data analysis by adding and customizing visual elements.
  • Model data with calculations.
  • Create interactive visualizations.

Upon completion, participants will be able to perform related topics covered and easily collaborate with work colleagues and related parties.

 

Module 1 – Introducing Power BI

  • Getting started with Power BI
  • Uploading data to Power BI
  • Introducing natural-language queries
  • Introducing Quick Insights
  • Introduction to reports
  • Introducing Visual Interactions
  • Decorating the report
  • Saving the report
  • Pinning a report
  • Refreshing the budget workbook
  • Filtering a report

 

Module 2 – Sharing The Dashboard

  • Inviting a user to see a dashboard
  • Inviting users outside your organization
  • Creating a group workspace in Power BI
  • Turning on sharing with Microsoft OneDrive for Business
  • Viewing reports and dashboards on mobile devices

 

Module 3 – Understanding Data Refresh

  • Introducing data refresh
  • Introducing the Power BI refresh architecture
  • Introducing Power BI Desktop
  • Publishing to Power BI
  • Installing the Power BI Personal Gateway
  • Configuring automatic refresh

 

Module 4 – Using Power BI Desktop

  • Connecting to a database
  • Loading from multiple sources
  • Using Query Editor
  • Hiding or removing tables
  • Handling seasonality and sorting months

Module 5 – Getting Data From Services And Content Packs

  • Consuming a service content pack
  • Creating a custom dataset from a service
  • Creating a content pack for your organization
  • Consuming an organizational content pack
  • Updating an organizational content pack

 

Module 6 – Building A Data Model

  • Loading individual tables
  • Implementing measures
  • Creating calculated columns
  • Improving the report by using measures
  • Integrating budget information
  • Reallocating the budget

 

Module 7 – Improving Power BI Reports

  • Choosing the right visualizations
  • Choosing between standard visuals
  • Using custom visualizations
  • First steps with custom visualizations
  • Improving reports by using custom visualizations
  • Identifying conditions when custom visualizations are required
  • Using DAX in data models
  • Creating high-density reports

 

Module 8 – Using Microsoft Power BI In Your Company

  • Getting data from existing systems
  • Understanding differences between data refresh and live connections
  • Using relational databases on-premises
  • Using relational databases in the cloud
  • Using live connections to Analysis Services
  • Integrating Power BI with Office
  • Publish Excel data models in Power BI
  • Consume Power BI content from Excel
  • Using Power BI Tiles from Office Store
  • Managing security to access data
  • Using row-level security
  • Extending and customizing Power BI
  • Creating custom visualizations for Power BI
  • Introducing the Power BI REST API
  • Pushing real-time data to Power BI dashboards
  • Power BI embedded in applications

The trainer

RIDZUAN RASHID

Born in 1972. Received early education in Kuantan, Pahang and graduated Diploma in Information Technology in Kuala Lumpur.
 
Experienced in IT since 1986 and started to be an in-house Microsoft Office trainer for Oil & Gas multi-national foreign company since 1997. Moved into IT Corporate training as a freelance trainer since 2007.

Educations & Certifications.
Diploma – Info Technology
Microsoft Certified Trainer
Microsoft Office Specialist Double Master
Word Expert
Excel Expert
PowerPoint
Outlook
Access
Certified Shell IT Trainer
Exempted HRDF SBL Khas

Skills & Experiences
Microsoft – Word, Excel, PowerPoint, Outlook, Teams, OneNote, Forms. Power Query, Power Maps, Power Pivot, Power View, Power BI, Access, VBA, Project, SharePoint, Office 365.

Google – Drive, Mail, Sheet, Docs, Slides, Forms

Adobe – Photoshop, Lightroom, Premier

Work Experience
Oil Palm Plantation – Accounts and Admin, Golf & Resort – Accounts and Admin, Oil & Gas – Materials Controller and Procurement, HVAC – Sales Manager, Confined Space / Tank Cleaning – Ops Manager

Past Consultation Clients
Shell Global Solution Asia Pac , Exxon Mobil Malaysia

Some of the companies that have benefited from his expertise:-.
Jabatan Perdana Menteri Malaysia | Jabatan Akauntan Negara | Jabatan Imigresen | Jabatan Alam Sekitar Kementerian Pertahanan Malaysia | Kementerian Kesihatan Malaysia | Kementerian Pelancongan Malaysia Tourism Malaysia | TH Plantation | MPOB | Bintulu Port Authority | GlaxoSmithKlein | DHL | HSBC INTAN – Bukit Kiara | Wilayah Utara (Intura) | Wilayah Selatan (Ikwas) | Sabah | Sarawak Keretapi Tanah Melayu | Tractors Malaysia | Volvo Assembly | UMW Corporation Shell Global Solution Asia Pac | Exxon Mobil Malaysia | Petronas | Malakoff Microsoft Malaysia | Intel | Toshiba Carsem Semiconductors | OnSemiconductors | Flextronics | Texas Instruments Celcom Axiata | Digi Communication | Motorola Solutions | Media Prima | Utusan Malaysia Toyota Assembly | Proton | Edaran Otomobil Nasional | MAS Academy | Air Asia Academy

The organizer

Sk Biz Solution is a one stop center for Microsoft Office applications trainings such Microsoft Project, Excel, Word, PowerPoint, Outlook, Access, Visio and other IT training.

 

We organize a lot of training for both private & government sectors. We have more than 20 active trainers and most of them are certified trainers under Microsoft and HRD Corp.

 

Some of our clients:-

 

Gas Malaysia, TM, Perodua, Uniten, MAA Takaful, Microtel Sdn Bhd, FELCRA, Syarikat Prasarana Negara, IBFIM, LPPSA, JOBSTREET, Pantai Hospital, TNB, JCA Builders, Teras Teknologi, H.Rosen Engineering, Jabatan Perdana Menteri, Bank Negara Malaysia, Suruhanjaya Syarikat Malaysia, Kumpulan Semesta, LIM Legacy Development, Salcon Engineering, Binamust Sdn Bhd, Jabatan Akauntan, Builden Engineering, DNB Petroleum, Mach3 Engineering, Raya Airways Sdn Bhd, Kementerian Kesihatan Malaysia, Ingress Precision Sdn Bhd, Jalur Cahaya Sdn Bhd, Standard Builders Work Sdn Bhd, BWS Engineering Sdn Bhd, PA Interiors Sdn Bhd, Syarikat Pumpro Sdn Bhd, Avin Engineering, FFM Pulau Indah, and many more

We do online & face to face class

The training center

Some feedback from past attendees

Special training packages as below

3 days training package.

Price before RM15,000, Now RM12,000 Per Session (Fee Inclusive of trainer, training material & E-certificate of attendance)

  • Duration – 3 days.
  • Number of participants – Maximum 35 pax per class. 
  • Online or face-to-face.
  • Venue – at client’s place, KL and Selangor.
  • If the venue outside KL & Selangor – Additional fee for accommodation & transportation.
  • HRD Corp claimable – SBL KHAS
  • Training delivery – Malay & English 
  • We provide lap top and training room (upon request)

100% money back guarantee

You don’t have to worry about the quality of the training because this training comes with a 100% Money back guarantee.

At any time, if you find the training doesn’t meet your expectations in any way, you don’t need to pay a single cent.

If you aren’t satisfied we would not feel right keeping your money.

So, you have nothing to lose.

FILL IN FORM BELOW TO REQUEST QUOTATION

    This form uses Akismet to reduce spam. Learn how your data is processed.

    Contact Us:-

    Sk Biz Solution Technology Sdn Bhd (1015977-P)
    1 Stop Center – Microsoft Office Application Training.
    *Use Excel, PowerPoint, Word, Project, Outlook, Access Like a PRO!

    Address: 5G-6, Pusat Daerah Seksyen 6, Jalan Cenderawasih 6/7, 40000 Shah Alam, Selangor.

    Contact No: +6017- 694 7031 (Call / Whats App)

    Email: hi@skbizsolution.net