Next public class: Power BI Mastery Live · 24 Oct 2026 · Zoom. Register now
Digital AnalyticSolution Sdn Bhd
  • Services
  • Team trainingIn-house programmes for your organisationProgramme cataloguePower BI, Excel and AI agentsLive trainingUpcoming Zoom and classroom sessionsE-learning coursesSelf-paced video lessons, learn anytime
  • Power BI hubConsulting, training and learning in one placeLive dashboard demosClick through real Power BI dashboardsE-Learning Power BI MasterySelf-paced video libraryLive Webinar Power BI MasteryLive on Zoom with the trainerSeminar Fizikal Power BI MasteryTwo-day classroom in Shah AlamAll Access: Power BI + PL-300E-learning plus PL-300 preparation
  • ArticlesPractical notes on Power BI, automation and AIFree resourcesTemplates, guides and checklistsReporting assessmentCheck how ready your reporting is
  • About
  • Contact
Log inBook a Call
Services
TrainingTeam trainingProgramme catalogueLive trainingE-learning courses
Power BIPower BI hubLive dashboard demosE-Learning Power BI MasteryLive Webinar Power BI MasterySeminar Fizikal Power BI MasteryAll Access: Power BI + PL-300
ResourcesArticlesFree resourcesReporting assessment
AboutContactLog inBook a Call

Loading...

Digital AnalyticSolution Sdn Bhd

From data to decisions.

  • 012-341 1354
  • admin@digitalanalyticsolution.com
  • WhatsApp us

Our work

HomeServicesLive dashboardsProgramme cataloguePublic classes

Company

AboutBlogFree resourcesContact

© 2026 Digital Analytic Solution Sdn Bhd · 202401013298 (1559148-D) · Puchong, Selangor

Let’s continue on WhatsApp

Share a few details and we will reply on WhatsApp.

“”

We save your details to follow up on this inquiry.

In-house training/Programmes/Power BI
Beginner to intermediate2 daysMost popularHRD Corp claimable

Microsoft Power BI: Data Analysis, Dashboarding and Reporting Automation

From scattered spreadsheets to a Power BI dashboard your management trusts, in 2 days.

Clean data with Power Query, build KPIs with DAX (the formula language behind Power BI measures) and publish to Power BI Service.

Request a corporate proposalRequest programme outline
HomeInsertModelingView–✕
Power BIData analysis & dashboardswith Hariz Sharif
For
All departments
Duration
2 days (9:00am – 5:00pm)
Mode
In-house, public classroom or live online
Level
Beginner to intermediate
Trainer
Hariz Sharif & team

Programme overview

A structured, hands-on route to practical Power BI reporting capability for teams who want clearer dashboards and more confident data-driven decisions.

Participants work through the full reporting workflow: data connection and transformation, modelling, DAX, dashboard development and sharing in Power BI Service. Guided exercises use realistic business data, so the same method carries straight into their own reports.

What your team will learn

  • Connect and consolidate business data from Excel, CSV, folders and related sources.
  • Clean, transform and prepare repeatable datasets with Power Query.
  • Build data models, relationships, DAX measures and time-intelligence logic.
  • Design interactive dashboards, then publish and share them through Power BI Service.

Who should join

  • Executives and managers who need clearer reporting visibility
  • Business and data analysts producing recurring reports
  • Finance, HR, sales, marketing, procurement and operations teams
  • Engineers and technical staff supporting operational reporting

Prerequisites

  • Basic Microsoft Excel familiarity
  • General experience working with business data
  • A laptop with Power BI Desktop installed (setup steps are sent before the session)

Programme modules

  1. Module 1Power BI orientation and reporting workflow
    • Desktop, Service and Mobile
    • The Connect, Build, Design workflow
    • Where AI fits in reporting
  2. Module 2Power BI Desktop setup and data import
    • Importing Excel and CSV
    • Combining a folder of files
    • Checking data quality
  3. Module 3Power Query foundations
    • Applied steps
    • Data types and clean-up
    • Repeatable transformations
  4. Module 4Advanced transformation and data modelling
    • Merge, append and unpivot
    • Star schema
    • Relationships and filter flow
  5. Module 5DAX foundations for business reporting
    • Measures versus columns
    • SUM, DIVIDE and CALCULATE
    • Checking business logic
  6. Module 6DAX calculations and time intelligence
    • Year-to-date and prior year
    • Growth and variance
    • Date tables
  7. Module 7Dashboard design and interactive navigation
    • Visual hierarchy
    • Filters and slicers
    • Page navigation and drill-through
  8. Module 8Guided dashboard build
    • Building a management dashboard
    • Layout and storytelling
    • Review against business questions
  9. Module 9Power BI Service, publishing and governance
    • Workspaces and sharing
    • Scheduled refresh
    • Security basics
  10. Module 10Capstone review and Q&A
    • Dashboard review
    • Adoption at work
    • Next steps
Participants building Power BI dashboards on their laptops
Hands-on Power BI class

What participants say

  • “One of the biggest takeaways from this workshop is that effective analytics goes beyond creating dashboards.”

    Aliya Zarena ZainulanuarPower BI workshop participant

  • “The session sharpened and strengthened my understanding of how Power BI can transform raw data into meaningful insights through dashboards, visualisations, and data-driven reporting.”

    Nufail IsmailPower BI Mastery webinar participant

  • “Looking forward to applying what I’ve learned in data analysis, reporting, and data-driven decision-making.”

    Siti Nabihah Abdul HamidPower BI Mastery webinar participant

Meet your lead trainer

Hariz Sharif
Hariz SharifFounder, Digital Analytic Solution

Hariz has 8+ years in the energy, utilities and engineering sectors and leads Power BI work for operations and maintenance at a multinational oil and gas operator. He is Microsoft PL-300 certified, an HRD Corp accredited trainer and a Professional Technologist (Ts.), and has trained more than 3,000 learners since 2024.

Trainers are assigned per programme. Not every trainer attends every session.

Frequently asked questions

Can the programme run at our office?

Yes. We can deliver at your premises, at a training venue or virtually over Zoom or Microsoft Teams.

Is the programme HRD Corp claimable?

We are an HRD Corp registered training provider. Eligible programmes can be claimed, and we provide the documents your HR team needs for the application.

Can you customise the content for our team?

Yes. We adjust the examples, exercises and level to your industry and data. We can also combine topics from several programmes.

Will participants receive a certificate?

Yes. Participants who complete the programme receive a certificate of completion.

How many participants can join?

Share your group size when you request a proposal. We will recommend the right format and trainer support so everyone gets hands-on help.

Bring this to your team

Microsoft Power BI: Data Analysis, Dashboarding and Reporting Automation
  • 2 days, 9:00am – 5:00pm
  • In-house, public classroom or live online
  • Content adjusted to your data
Request a corporate proposalRequest an official quotation
HRD Corp registered training providerHRD Corp claim support for eligible programmes.

Recommended reading

Get a head start.

Power BIGetting Started with Power BIHariz SharifTutorial
RM 4.7MRevenue31%Margin

Getting Started with Power BI: Your First Dashboard in Under an Hour

Read article →
DAXIntroduction to DAX for Power BIHariz SharifTutorial

Revenue = SUM(Sales[Amount])

Margin % =

  DIVIDE([Revenue] - [Cost],

    [Revenue])

YoY = CALCULATE(...)

Introduction to DAX for Power BI: Formulas That Transform Your Reports

Read article →
Dashboard designDashboard Design PrinciplesHariz SharifIndustry Insights

Dashboard Design Principles: Build Power BI Reports People Actually Use

Read article →

Related programmes

Build on this programme.

HomeTransformAdd ColumnView–✕
Power BIAutomated reportingwith Hariz Sharif
Applied stepsSourceCombined filesChanged typeUnpivoted columns
1 day
Excel usersIntermediate

Power BI for Automated Reporting: Turn Excel Reports into Interactive Dashboards

Rebuild a manual Excel report in Power BI, so it refreshes itself.

6 modules · 1 dayView programme→
FileHomeInsertFormulasData–✕
ExcelData analysis & reportingwith Hariz Sharif
1234
1 day
All departmentsBeginner to intermediate

Excel for Data Analysis and Reporting: From Raw Data to Management Dashboard

A clean, reliable Excel report and a dashboard template you reuse every month.

6 modules · 1 dayView programme→
Browse all programmes

Let’s work together

Plan Microsoft Power BI for your team.

Share your team size, level and preferred dates. We will recommend a format and send a proposal.

Request a corporate proposalRequest an official quotation