The Epic Microsoft Power Business Intelligence (Power BI) in just 2 days

Power BI is a technology-driven business intelligence tool provided by Microsoft for analyzing and visualizing raw data to present actionable information. It combines business analytics, data visualization, and best practices that help an organization to make data-driven decisions.

Power BI can access vast volumes of data from multiple sources. It allows you to view, analyze, and visualize vast quantities of data that cannot be opened in Excel. Some of the important data sources available for Power BI are Excel, CSV, XML, JSON, PDF and more. Power BI uses powerful compression algorithms to import and cache the data within the.PBIX file.

Analyze data with Power BI.

Microsoft Power Business Intelligence

Come and learn Microsoft Power Bi in 3 days

Choose Your Course

We offer two levels of Microsoft Power BI training course which you can take individually or consecutively.

1) Microsoft Power Business Intelligence (Power BI) Essentials (2 Days)

In this class, Power BI makes things visually appealing. It has an easy drag and drops functionality, with features that allow you to copy all formatting across similar visualizations. With the exceptional Excel integration, Power BI helps to gather, analyze, publish, and share Excel business data. Anyone familiar with Office 365 can easily connect Excel queries, data models, and reports to Power BI Dashboards.

Power BI allows you to gain insights from data and turn those insights into actions to make data-driven business decisions.

Who is it for: This course is designed for professionals who needs to analyze data utilizing Power BI. This can come under business analysts, data analysts, data scientists, and professionals involved in data visualization and business intelligence. It is also suitable for individuals who work with data in various capacities and want to create interactive reports and dashboards to gain insights and make informed decisions. Additionally, anyone interested in data analysis and visualization, regardless of their specific role, can benefit from learning Power BI.

Take Note: Beginners seeking to learn Power BI must be proficient in Excel Basics

Duration: 2 Days

Cost: Normal price RM2450 – *Promotional Price* RM1890

 

Details & Booking

Course Content
Lesson 1: 
  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Consideration of self-service BI
  • Microsoft tools for self-service BI
  • Lab: Exploring an enterprise BI solution

Lesson 2: 
  • Power BI
  • The Power BI service
  • Power BI mobile apps
  • Lab: Creating a Power BI dashboard

Lesson 3: 
  • Using Excel as a Power BI data source
  • Using databases as a Power BI data source
  • The Power BI service
  • Lab: Import data into Power BI

Lesson 4: 
  • Power BI desktop queries
  • Shaping data
  • Combining data
  • Lab: Shaping and combining data

Lesson 5: 
  • Relationships
  • DAX queries
  • Calculations and measures
  • Lab: Modelling data

Lesson 6:
  • Creating Power BI reports
  • Managing a Power BI solution
  • Lab: Creating a Power BI report

2)

Microsoft Power BI Advanced (1 day)

In this course, we will explore the advanced concepts of Power BI Desktop, focusing on DAX functions, advanced Power Query techniques, and complex data modeling. Participants will learn how to use DAX for advanced calculations such as selected value and ranking, clean and transform messy data using Power Query, and create sophisticated data models linking multiple tables. By the end of the course, participants will be equipped to handle complex data analysis and modeling challenges in Power BI Desktop.

Who is it for: This programme is suitable for someone who is experienced Power BI users, business analysts, data analysts, and data professionals who want to enhance their skills in DAX, Power Query, and data modeling.

Duration: 1 Day

Cost: Normal price RM 1570 –*Promo* RM990

 

Details & Booking

Course Content Excel Intermediate
Lesson 1: Review of Power BI Desktop Basics
  • Review of basic DAX and Power Query

Lesson 2: Advanced DAX Functions
  • Using selected value
  • Ranking functions
  • Time intelligence functions

    Lesson 3: Advanced Power Query Techniques
  • Message messy data
  • Customs functions in Power Query

    Lesson 4: Data Modeling
  • Linking more than one table
  • Creating complex relationships
  • Managing relationships
  • Handling complex data models

    Lesson 5: Q&A and Conclusion
  • Answering participant questions
  • Recap of key learnings
  • Next steps and resources for further learning


Class Duration and Schedule

Aside from this we also conduct short courses that cover all the essentials and advanced knowledge of MS Excel.

Microsoft Excel Basics – 1 days
Microsoft Excel Intermediate – 1 days
Microsoft Excel Advanced –  1 days
Microsoft Power Business Intelligence – 3 days

Our classes start at 9:00 am to 5:00 pm with regular breaks. These breaks give the participants time to rest and to process the information that they receive during the course.

**Free Repeats**

To help our participants better, we offer free repeat classes. Students can revisit the institute and refresh their skills if needed. These free repeat classes are available every month. 

View Schedule

Who Should Attend

Our Microsoft Power Business Intelligence (Power BI) courses are designed for people who understand the concept of Excel Advanced and responsible to  analyse heavily on data visualization. Participants enrolling in this training should have basic knowledge of the Microsoft Excel Basics.


Classroom Training and Facilities

 

Our training centre is located in Bandar Puteri, Puchong and is only a 2-minute walk from the Bandar Puteri LRT station with many restaurants nearby. For those who drive, nearby there is a shaded car park which is free. Due to its proximity, our centre gets many students from Kuala Lumpur and Klang Valley.

 

    • Our training sessions are held in a classroom setting. The instructor teaches the theory and shows various practical examples. 
    • Participants also get to try out numerous exercises and experience the learning-by-applying concept.
    • The training style consists of 70% practical and 30% theory, workshop style. We intend that students learn more by doing rather than just listening.
    • You will receive personal guidance from our trainers during the class. 
    • Our trainers will have Q&A sessions to answer the various questions throughout the class.
    • Our typical class size is between 6-10 students. This setup allows our trainers to spend more time with each of their students.

 

[Covid-19 Update]

At CAD Training Centre, we take social distancing and SOP regulations very seriously in the interest of the safety of our fellow participants.

Our training centre is sanitized and disinfected regularly. There are ample hand sanitizers placed around the room.

Our classroom settings follow the standard guidelines of 1-meter space between participants’ seating areas and 1.5 meters space between the table rows. Safety and wellbeing of our students is our number one priority.

 

Online Training

 

Our online classes are conducted via digital platforms such as Zoom and Cisco Webex. Classes are both exciting and relaxed as our trainers have a lively approach that works well for online training. We also designed the lessons to promote ease of learning. 

Our experienced trainers will teach and guide the students with practical hands-on exercises that are done via screen sharing.

Because there are no geographic limitations, our students are from all over Malaysia.

 

In-house and Corporate Training

 

We also conduct in-house training programmes based on request. 

Notable clients for Power BI

Here are our trusted clients

Why Choose Us

 

Free Repeats & Tutorials

We offer free unlimited repeats, no questions asked. 

In rare instances, some students are unable to digest all the information at one go and may need a refresher.   

Also, we have our students’ best interests at heart and want them to leave the class with full confidence. 

Upon completing the course, we also provide free online tutorials for your continuous learning.

Professional Certification 

Upon completing the Power BI course, a Certification of Achievement will be issued.

We have professional certification issued by our partners at UTM (University Technology Malaysia) and other professional bodies.

CIDB & MOF Registered Provider

Our institute is a registered training provider for the Construction Industry Development Board (CIDB). As such, we provide CCD points under the Continuous Contractor Development program as required by the construction industry. Participants from the construction industry will receive CCD points for attending our training courses. 

We are also a registered training provider with the Ministry of Finance, MOF.

HRDF Claimable

We are accredited by the Human Resource Development Fund, HRDFAll our courses offered by us are HRDF claimable under the ‘SBL’ Scheme.

Beginner Friendly

We are known for our tagline “Start from zero!” – students do not need any prior knowledge or experience to take our basic courses.

Conducive Learning Experience 

Our classes focus on the practical aspects and less about theory to the ratio of 70:30 – we found that this approach helps with learning and remembering. 

Our class sizes are small at about 4-12 pax per session, and this gets each student more attention from the trainer.

Learning Aids

We provide laptops during the classroom sessions for your convenience.

During your training, a handbook will be given for your reference.

Meal options are also provided.

Our intention is for you to focus on the training and not worry about what to bring to class.

 

Frequently Asked Questions

What is Microsoft Power Business Intelligence (Power BI) course all about?

The Microsoft Power BI course is designed to teach participants how to connect, transform, and visualize data effectively, enabling them to create insightful reports and dashboards for informed business decision-making.

What are the benefits of learning Power BI?

Learning Power BI offers several benefits, including the acquisition of skills to connect and analyze diverse data sources. With this knowledge, individuals can transform raw data into meaningful insights, fostering informed decision-making within businesses.

The ability to create visually engaging reports and dashboards is a key outcome, enhancing communication and understanding of complex data sets. Power BI proficiency empowers professionals to identify trends, patterns, and outliers in data, leading to more strategic and data-driven decisions.

Additionally, the platform’s integration capabilities with other Microsoft products contribute to a comprehensive skill set that aligns with modern data analytics practices. Overall, mastering Power BI enhances one’s capacity to navigate and harness the power of data, making it a valuable asset in various industries and roles.

What are the prerequisites?

A prerequisite for this course includes having a foundational understanding of the Microsoft Windows operating system, familiarity with data warehouse schema topology, exposure to basic programming concepts, and an awareness of key business priorities, with a particular emphasis on revenue, profitability, and financial accounting; additionally, familiarity with Microsoft Office applications, especially Excel, is beneficial.

How long does it take to learn Power BI?

Learning the basics takes approximately two days. 

What is the difference between classroom learning vs online courses? 

Classroom Learning

    • Participants will attend the course at the training centre in Bandar Puteri, Puchong.
    • Face to Face Interaction with the trainer in a classroom setting.
    • Immediate guidance & attention from the trainer
    • More focused
    • Learning among other participants during exercises

Online Course

    • Participants will attend the course using online platforms such as Zoom and Cisco Webex
    • Can save on travel and food expenses
    • Learn from the comfort of your own home/office
    • More flexibility
    • Able to discuss with people from different companies.

What Participants Say

We have trained many well-known companies and individuals who completed their course highly satisfied. We feel honoured to receive their encouraging feedback and positive reviews.

 

Here is our Google Review Power BI

Enrol Today

 

Begin your journey in mastering Power BI today. Getting started is easy; just click an option below:

 

WhatsApp chat