An Interactive 5-Day Training Course
Power BI: Intermediate Data Analysis Techniques
Course Overview
This Intermediate Data Analysis Using Power BI training course takes participants beyond the basics. With laptops at hand, participants will develop skills in data modeling, DAX, and advanced data transformations. Each day will include practical, hands-on exercises in Power BI, with a final day dedicated to a preview of advanced techniques, ensuring a seamless progression to the next level.
This GLOMACS training course will highlight:
- Data modeling fundamentals for Power BI
- DAX (Data Analysis Expressions) for calculations
- Advanced data transformation techniques
- Improved reporting and visualization strategies
- Skills to optimize data handling for analysis
Training Objectives
At the end of this Power BI: Intermediate Data Analysis Techniques training course, you will learn to:
- Build data models effectively
- Apply DAX functions for deeper analysis
- Transform data using Power Query
- Design intermediate-level reports and dashboards
- Prepare for advanced analytics in Power BI
Who should Attend?
This GLOMACS training course is ideal for professionals with basic Power BI skills who want to enhance their data analysis abilities:
- Data Analysts
- Business Data Users
- Financial Analysts
- Operations Team Members
- Professionals working with data insights
About Saudi Glomacs
At Saudi GLOMACS, we specialize in delivering world-class training courses in Saudi Arabia and across various international locations. Our training courses are tailored to meet the unique demands of Saudi Vision 2030 and the Human Capability Development Program, focusing on empowering Saudi citizens and enhancing workforce skills. We offer diverse courses spanning leadership, management, engineering, and technical disciplines to cultivate expertise and drive professional growth. Our flexible learning options—whether in-person, online, or in-house—ensure accessibility and convenience for individuals and organizations alike.
With over 30+ years of experience through the GLOMACS global network, we are committed to delivering innovative, results-driven training solutions. Our expert instructors combine industry knowledge with dynamic teaching methods, fostering practical skill development and long-term career success. By choosing Saudi GLOMACS, you're investing in personal excellence and contributing to the Kingdom’s sustainable economic growth and vision-driven transformation.
Training Outline
DAY 1: Deep Dive into Data Modeling
- Advanced data relationships
- Normalization and star schema
- Practical data model building
End-of-Day Exercise: Build a star schema model with imported tables
DAY 2: Introduction to DAX for Data Analysis
- DAX fundamentals
- Calculated columns and measures
- Common DAX functions
End-of-Day Exercise: Use DAX to create calculated fields and measures
DAY 3: Advanced Data Transformation
- Data cleaning with Power Query
- Merging and appending data
- Creating custom columns
End-of-Day Exercise: Clean and merge a multi-source dataset
DAY 4: Building Interactive Reports
- Intermediate visualization techniques
- Using bookmarks and buttons
- Multi-layered reports
End-of-Day Exercise: Build an interactive report with drillthrough pages and bookmarks
DAY 5: Preparing for Advanced Analytics with a Sneak Peek
- Advanced DAX functions introduction
- Complex data modeling techniques
- Sneak peek into advanced Power BI: Custom visuals and managing large datasets
End-of-Day Exercise: Apply advanced DAX in a report and experiment with R/Python integration
Certificates
- On successful completion of this training course, GLOMACS Certificate will be awarded to the delegates
- Continuing Professional Education credits (CPE) : In accordance with the standards of the National Registry of CPE Sponsor, one CPE credit is granted per 50 minutes of attendance
Accreditation
GLOMACS is registered with NASBA as a sponsor of Continuing Professional Education (CPE) on the National Registry of CPE Sponsors. NASBA have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.
All Training Seminars delivered by GLOMACS by default are eligible for CPE Credit.
What do you need to learn next?
Check our list of courses or let us customize a course for you.
View courses
