Data Analytics with Power BI

Follow up course after Fundamentals to Power BI Desktop for advanced exploration in Power BI.


Course Info

chart-1This hands-on course is focused on real-world techniques utilising the amazing capabilities of Power BI. The course covers the core elements needed to get an understanding of what Power BI can do. You will use more advance Power Query techniques to extract and shape data and then load and build a complex Power Pivot Model, and write more complex DAX formulas and set up interactive reports or Dashboards.

What Will I Learn From This Course?

Import, shape, and transform data for business intelligence (BI).

Create data models & perform more advance calculations with DAXS.

Create and visualize data over a period of time with time intelligence functions.

Create awesome dashboards based on reports in Power BI desktop.


Participants must have some basic knowledge in Power BI desktop, basic working knowledge in Excel Power Query & Power Pivot. Advance Excel users with good knowledge of functions & formulas and Pivot tables may also attend.

Course Outline for This Programme

a. Synchronize data across pages.
b. Drilling down to a more focus report.
c. Enhancing visuals with more contextual information.
d. Enhancing reports with conditional formatting

a. Customised categorising of data.
b. Aggregating data based on values found in the underlying data.
c. Define parameters for flexibility in data loading.
d. Creating report templates.

a. Pros & Cons using built using built in date tables.
b. Creating custom date tables with Power Query.
c. Creating custom date tables with DAXS.
d. Shaping Data in Power Query

a. Performing calculations with Columns & Measures.
c. Understanding Row Context and Filter Context
e. Grouping data with DAXS.
f. Making DAXS more readable.

a. Functions that return a single date.
b. Functions that return a table of dates.
c. Functions that evaluate expressions over a time period.

a. How relationships works.
b. Both-Directional Relationship in Power BI.
c. Using DAXS to simulate the Both-Directional Relationship.

a. Building A Dynamic Date Table.
b. Filtering Pages Dynamically.
c. Filtering Visuals Dynamically.
d. Dynamic Titles.

Curriculum is empty

Academic Qualifications
  • Diploma in Accountancy
  • ACCA (Association of Chartered Certified Accountants), UK

Professional Certifications
  • Pembangunan Sumber Manusia Berhad (PSMB) Certified Trainer
  • Microsoft Certified Trainer (MCT)

Julian specialises in conducting MS Excel application courses & seminars for various companies, local & multinationals. He teaches practical on-the-job experience, which translates to real-life exercises for participants’ benefit. Julian conducts various IT courses using Word Processors, Spread sheet, Database, Multimedia & Programming applications