DATA ANALYTICS
PROGRAM
CRASH COURSE FOCUSED ON POWER BI
Register Now!
Friday 04:00 PM to 07:00 PM (PST)
August 18, 2024
Saturday 02:00 PM to 05:00 PM (PST)
Online
44 hours
on Friday & Saturday for KSA
Microsoft Power BI (Power Query and DAX, Data Visualization & Story telling)
LEARNING OUTCOMES
• Building Dashboards and Data Transformation
• Analysis with DAX techniques
• Data Visualization, Storytelling and Analysis
An initiative of Digital Assurance and Accounting Board of ICAP
+92-301-5039776 [email protected]
DATA ANALYTICS TRAINING PROGRAM
CRASH COURSE FOCUSED ON POWER BI
The Institute of Chartered Accountants of Pakistan (ICAP) is a prestigious regulatory body with a proud
history of providing chartered accountancy qualifications and investing in the professional growth and
development of its members. ICAP by the Digital Assurance & Accounting Board (DAAB), in response to
challenges brought by emerging digital technology, introduced an extensive course focused on Data
Analytics in 2021. ICAP is now announcing a batch of Crash Course focused on the Power BI program for
KSA. The course is intended for professionals using data for finance, audit, and other business decisions. It
is aimed to provide the participants with the skillset, to understand and create dashboards and transform
data to have better insights for improved decision-making in a timely and efficient manner. It also
emphasizes on Analysis with DAX Techniques combined with data visualization, storytelling, and Analysis.
The course encompasses 44 hours and is designed to facilitate in exploring Power BI tools for data from
descriptive to predictive analytics. The course is followed by two hourly practice sessions. By the end of
the program, you will be able to learn below skills;
1. Building Dashboards and Data Transformation.
2. Analysis with DAX techniques
3. Data Visualization, Storytelling and Analysis
WHO SHOULD ATTEND?
This course is designed for ICAP affiliates, Chartered Accountants, Executive Management, and other
Finance Professionals seeking to enhance their competencies in Power BI.
WHY ATTEND?
Attending a crash course focused on Power BI provides the opportunity to acquire in-demand skills,
boost career prospects, and stay ahead in a rapidly evolving field while gaining hands-on experience
and expanding professional networks.
MICROSOFT POWER BI - INTRODUCTION
Microsoft Power BI is a powerful business intelligence and data visualization tool that allows users to
connect, analyze, and visualize data from multiple sources in a user-friendly interface. With Power BI,
users can create interactive reports, dashboards, and data visualizations to gain valuable insights and
make data-driven decisions. Its drag-and-drop functionality and extensive range of data connectors
make it accessible for users without coding or technical expertise, making it an ideal tool for businesses
of all sizes to unlock the value of their data.
POWER QUERY & DATA MODELING
Power Query is a data transformation tool that cleans and merges data from various sources. Data
modeling structures and organizes data within Power BI, enabling relationships and calculations for
accurate reporting and analysis.
Topics covered: Types of Joins, Append & Merge Data, Split Columns, Unpivot, create a Calendar,
GroupBy, Removing Errors and Duplicates, Data Format Types, Sorting, Custom, and Calculated Columns,
Normalization and Denormalization, Star Schema, Snow-Flake Schema, Fact & Dimension Tables,
Business entities.
DAX
DAX (Data Analysis Expressions) is a formula language used in Power BI, Excel, and SQL Server Analysis
Services for data modeling and calculations. It enables user to create custom calculations, define
relationships, and perform advanced calculations on data tables using functions and operators. With
DAX, users can unlock the full potential of their data and create powerful analytical solutions.
DATA VISUALIZATIONS & DATA STORYTELLING
Data visualizations bring data to life by presenting it in a visual and digestible format, while data
storytelling adds narrative and context to make the data more relatable and impactful, empowering
effective communication and decision-making based on data insights.
Topics covered: 15 Dashboard Design Rules, CRAP Rule, MVC Rule, Visualizations best practices,
Storytelling tips, how to select the right chart, Dashboard design checklist, Interactive Features of POWER
BI Desktop version includes Tooltip, Hyperlink & Bookmarks, Drill through, Visual, Page and Report level
filters, Colors formatting, Conditional formatting, exploring app source for more visuals from the
marketplace.
TRAINER PROFILE
Faizan Irshad is a highly accomplished professional with over 17
years of experience in financial reporting, audit, fraud
investigations, and risk management. He is a Fellow Chartered
Accountant (FCA) with experience of working in banking and
other sectors.
Faizan also holds an MS degree in Data Sciences from University
of Management & Technology. With this qualification, Faizan has
blended his domain knowledge and experience with Artificial
Intelligence technologies i.e. Machine Learning, Deep Learning
and Big Data to provide innovative solutions to complex business
problems using programming languages like Python and R.
Faizan also holds “UiPath” specialization in Robotic Process
Automation and certification in Microsoft Power Platform
including Power BI. Faizan has also experience of conducting
Mr. Faizan Irshad, FCA workshops and trainings at different forums for professionals in
Data Scientist the areas of AI & automation.
REGISTER NOW
FEE STRUCTURE
Member/Student/Affiliate Rs. 35,000 + Tax
Non-Member Rs. 45,000 + Tax
For Further Inquiry or Details
Ph: 021-111-000-422 Ext. 406
Whatsapp# 0301-5039776
email:
[email protected]
