Mastering SQL and PowerBI: From Queries to Dashboards

LEVEL: INTERMEDIATE                   HRDF: CLAIMABLE 

Ten (10) CPD Hours approved by MBOT

TRAINERS: 

Dr. Abdullateef Oluwagbemiga Balogun & Dr. Junaid Shuja

Ten (10) CPD Hours approved by MBOT

 

23 - 25 SEPTEMBER 2024

 

CAPE

Level 8, Permata Sapura, Kuala Lumpur City Centre, 50088 Kuala Lumpur​

 

9.00AM - 5.00PM

 

RM 4,200 FOR PROFESSIONALS

10% Discount for Early Bird (until 23 August 2024) / Group / Students

CONTENT SUMMARY

INTRODUCTION

The workshops' goal is to provide participants with a thorough and practical understanding of SQL, allowing them to interact and manage relational databases, design and optimize data models, perform advanced data analysis, and integrate SQL data into Power BI for effective data visualization. These courses include a strong emphasis on hands-on learning and real-world application, preparing students to flourish in data-related professions and make educated data-driven decisions.

COURSE CONTENT

SQL Fundamentals

  • SQL Fundamentals and Database  Introduction 
  • Data Retrieval Techniques 
  • Working with DDL and DML Commands
  • Integrity Constraints
  • Built-In Functions
  • Data Aggregation

Advanced SQL Techniques, Subqueries, and Database Security

  • Understanding Joins
  • Set Operators and Psuedo columns
  • Subqueries and Views
  • Database transaction and Security

Advanced SQL Techniques and Database Administration

  • SQL Functions and Procedures
  • Database Design and Performance
  • Query Optimization
  • Advanced SQL Techniques
  • SQL Reporting and Analysis
  • Database Administration

Integrating Power BI Advanced SQL

  • Power BI Data Modeling
  • Advanced DAX and Power Query
  • Advanced Power BI Visualization and Reporting


OBJECTIVES

Upon completion of this course, participants will be able to:

  • Mastery of SQL joins for data retrieval.
  • Use of set operators and pseudo columns for complex queries.
  • Creation of subqueries and views for advanced data querying.
  • Handling database transactions and implementing security measures.
  • Proficiency in Power BI data modelling for structured data.
  • Mastery of advanced DAX and Power Query for data transformation.
  • Expertise in advanced Power BI visualization and reporting.
  • Application of Power BI in real-time scenarios to extract actionable insights.


WHO SHOULD ATTEND?

Graduates, Postgraduates, Research Scholars, Academicians, Industry Professionals of
  • Business and Finance
  • Oil and Gas
  • Healthcare
  • IT and Technology
  • Manufacturing and Supply Chain
  • Retail and E-commerce





OUR TRAINERS

1. Dr. Abdullateef Oluwagbemiga Balogun (UTP)

Dr. Abdul-Lateef Balogun received his B.Sc. degree in Surveying and Geoinformatics Engineering from the University of Lagos, Nigeria, his M.Sc. degree in Geoinformatics from the Universiti Teknologi Malaysia (UTM), Malaysia and his Ph.D. degree in Civil Engineering (Geoinformatics) from the Universiti Teknologi PETRONAS (UTP), Malaysia. He received the best student award in his M.Sc. programme and was a recipient of the UTP graduate assistantship funding for doctoral study from 2010 to 2014. Dr Balogun won an excellent (best) paper award at the international conference on future environment and energy, Singapore in 2012, was the winner of the Golden Key International Honor Society (GKI) essay writing competition, UTM in 2008 and second runner-up in the national quiz for public institutions of higher learning in Malaysia, 2009. He is currently a faculty member at the Department of Civil and Environmental Engineering, Universiti Teknologi PETRONAS (UTP) and coordinator of UTP’s Geospatial Analysis and Modelling Research (GAMR) Laboratory. He has over 10 years of teaching, research, consultancy, and industrial experience and has authored papers in peer reviewed journals and conference proceedings. He serves as an Associate Editor of the Handbook of Extreme Weather and Climate Events (Springer). He specializes in the application of geospatial and machine learning techniques in geo-hazard management, smart and sustainable cities, disaster management and risk reduction, and climate change modelling and adaptation.

2. Dr. Junaid Shuja  (UTP)

Dr. Junaid Shuja 

COUNTDOWN

REGISTRATION FEES

PROFESSIONALS

MYR4,200*

*fee quoted does not include SST, HRDF service fee, GST/VAT or withholding tax (if applicable).

EARLY BIRD/ GROUP/ STUDENT

MYR3,780*

*fee quoted does not include SST, HRDF service fee, GST/VAT or withholding tax (if applicable).

OUR LOCATION

Centre for Advanced & Professional Education (CAPE)

 Level 8, Permata Sapura, Kuala Lumpur City Centre, 50088 Kuala Lumpur​

CALL US

+605 - 368 7558 /

+605 - 368 8485

DROP US AN EMAIL

cape@utp.edu.my