Analyzing Data with Power BI

25-26 Mar, 2024, Wyndham Grand Bangsar Kuala Lumpur (Formerly Known As Pullman Bangsar Kuala Lumpur)

IPA Training is Registered with

Learn from the Best

Morgan holds a Degree in IT & Tech Management from UTM, he has 20 years working experience as a trainer in the field of Information Technology. He has obtained ITIL Certification and also PSMB approved trainer (TTT). He has conducted various trainings. His key expertise are:

  • Conducting IT Training in the area of Basic Networking, PC Repairing, PC Troubleshooting & Microsoft Office Training
  • Conducting research on the latest development and requirement for training based on customer request
  • Developing & Maintaining a sound marketing strategy
  • Ensure KPI and Customer Satisfaction are meet

As a qualified professional educator, he has personally designed and delivered many specialized training courses including the validation and management of over 10 other trainers, operating nationwide in Malaysia

Venue Details

Wyndham Grand Bangsar Kuala Lumpur (Formerly Known As Pullman Bangsar Kuala Lumpur)
Jalan Pantai Baharu, Jaya Tower 3,
Phone : 03-2298 1888

Contact us

Juliany,
03 2283 6109
juliany@ipa.com.my

Phoebe,
03 2283 6100
phoebe@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
Jane,
03 2283 6101
Jane@ipa.com.my

ADDRESS 
A-28-5, 28th Floor, Menara UOA Bangsar, 
No.5, Jalan Bangsar Utama 1, 
59000 Kuala Lumpur
www.ipa.com.my

FOCUSING ON
  • Module 1: Introduction to Self-Service BI Solutions
  • Module 2: Introducing Power BI
  • Module 3: Power BI Data
  • Module 4: Shaping & Combining Data
  • Module 5: Modelling Data
  • Module 6: Interactive Data Visualizations
COURSE OBJECTIVES

The objectives of Analyzing data with Power BI course is to provide learners skills and knowledge to use Power BI to create Data Models, Visualizations, and Reports that facilitate analysis and decision-making. The course covers crucial topics such as:

  1. Connecting To Data Sources And Importing Data Into Power BI.
  2. Building Data Models Using Relationships, Calculated Columns, And Measures.
  3. Obtaining Data And Transforming Your Data.
  4. Creating Powerful, Automatically Updated Interactive Visuals.
  5. Collaborating On Reports And Sharing Across Your Organization.
  6. Delivering Dashboards With Automated Alerts To Drive Action.
  7. Creating And Formatting Visualizations, Such As Charts, Tables, And Maps.
  8. Building Interactive Reports And Dashboards, Such As Using Drill- Downs and Slicers.
  9. Improving Reports And Dashboards With Custom Visuals And Themes.
  10. Sharing And Collaborating On Reports And Dashboards.
  11. Using Advanced Features, Such As Integrating With External Data Sources, Using DAX Formulas.

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
After Attending This Course, You Will Return To Your Job And Be Able To Use Power BI To Create Data Models, Visualizations, And Reports That Facilitate Analysis And Decision-Making.
WHO SHOULD ATTEND

This course is specially designed for Professionals who can benefit from leveraging Power BI for data analysis, visualization, and reporting.

- Business Analysts:
• Individuals responsible for analyzing business data to derive insights and make informed decisions.
- Data Analysts:
• Professionals working with data to extract meaningful information and create reports.
- IT Professionals:
• IT staff who are looking to improve their skills in data analysis and reporting using Power BI.- Financial Analysts:
• Finance professionals who want to leverage Power BI for financial data analysis and reporting.
- Financial Analysts:
• Finance professionals who want to leverage Power BI for financial data analysis and reporting.
- Project Managers:
• Those who want to use Power BI for project reporting, tracking, and analysis.
- Marketing Professionals:
• Marketing analysts and managers who want to analyze and visualize marketing data.
- Operations Managers:
• Professionals responsible for optimizing business operations through data-driven insights.
- Human Resources Professionals:
• HR staff who are looking to analyze workforce data, employee performance, and other HR metrics.
- Entrepreneurs and Small Business Owners:
• Individuals who run their own businesses and want to gain insights from their data.
- Anyone Interested in Data Visualization:
• Individuals with a general interest in data visualization and analysis.
- Excel Users:
• Individuals familiar with Excel who want to transition to more advanced and scalable data analysis using Power BI.


METHODOLOGY

Training for Power BI typically involves a combination of theoretical concepts, hands-on exercises, and real-world scenarios to ensure participants gain both knowledge and practical skills.

- Classroom Training:
• Traditional classroom-style training where an instructor leads the session, covers theory, and guides participants through hands-on exercises.
- Workshops:
• Interactive workshops that focus on practical application. Participants work on exercises and projects to reinforce their understanding of Power BI concepts.
- Interactive Dashboards:
• Using Power BI itself as a teaching tool by creating interactive dashboards that demonstrate various features and functionalities.
- Hands-On Labs:
• Practical exercises and labs where participants can apply what they’ve learned in a controlled environment.

DAY 1
9:00

MODULE 1: INTRODUCTION TO SELF- SERVICE BI SOLUTIONS

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Microsoft tools for self-service BI

10.45

MODULE 2: INTRODUCING POWER BI

  • Power BI
  • The Power BI service
1:00 Lunch
2:00

MODULE 3: POWER BI DATA

  • Excel files, CSV & Text files as a Power BI data source
  • Using databases as a Power BI data source
5:00 End of Day 1
DAY 2
9:00

MODULE 4: SHAPING & COMBINING DATA

  • Power BI desktop queries
  • Shaping data
  • Combining data
10.45

MODULE 5: MODELLING DATA

  • Relationships
  • DAX queries
  • Calculations and measures
1:00 Lunch
2:00

MODULE 6: INTERACTIVE DATA VISUALIZATIONS

  • Creating Power BI reports
  • Managing a Power BI solution
5:00 End of Course