PLEASE CLICK HERE to view upcoming event. Information here is outdated

Analyzing Data with Power BI

23-24 Sep, 2024, CONCORDE HOTEL KUALA LUMPUR

IPA Training is Registered with

Venue Details

CONCORDE HOTEL KUALA LUMPUR
2 Jalan Sultan Ismail, 50250 Kuala Lumpur, Malaysia,

https://kualalumpur.concorde hotelsresorts.com/


Phone : +603 2144 2200

Contact us

FOR COURSE DETAILS

Juliany,

Office: 03 2283 6109

Mobile: +60 122281247

juliany@ipa.com.my

Phoebe,

Office: 03 2283 6100

Mobile: +60 193637822

phoebe@ipa.com.my

Bee Teng,

Office: 03 2282 6112

Mobile: +60 172566121

beeteng@ipa.com.my

FOR CUSTOMISED IN-HOUSE TRAINING

ADDRESS

A-28-5, 28th Floor, Menara UOA Bangsar,
No.5, Jalan Bangsar Utama 1,
59000 Kuala Lumpur

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