Classroom/ Online: Yes/ Yes
Scheduling Date(s):
1) Apr 30, 2025 (classroom)
2) Jun 20, 2025 (classroom)
3) Aug 12, 2025 (classroom)
4) Sep 11, 2025 (classroom)
5) Nov 10, 2025 (classroom)
Note: Please click specific date for detailed venue and course fee etc.
Data Visualization and Creating Dashboards through Power BI - Advanced Course
Power BI is a Data Visualization and Business Intelligence tool that converts data from different data sources to interactive dashboards and BI reports. These sets of services are used by business users to consume data and build BI reports.
This course will help participants learn lots of advanced functions in Power BI and create informative and meaningful dashboards to further enhance their productively and make strategic decisions
You can download power BI free of charge here
This course will help participants learn lots of advanced functions in Power BI and create informative and meaningful dashboards to further enhance their productively and make strategic decisions
You can download power BI free of charge here
Objective
The training is ideal for all experienced corporate professionals who deal with big and complex datasets and calculations and are involved in creating multiple analysis and informed decisions based on the available data.
It is meant for all CXO's, Directors, Partners, managers and decision-makers who would like to generate insights and efficient decision-making by making use of data at their fingertips through advanced Data Visualization capabilities
It is meant for all CXO's, Directors, Partners, managers and decision-makers who would like to generate insights and efficient decision-making by making use of data at their fingertips through advanced Data Visualization capabilities
Outline
Data Modelling and Hierarchy building
- How to create relationships in data sources
- Combining Multiple Tables
- Creating Hierarchies and Joins
- Explaining most commonly used formulas and functions
- Aggregate Functions
- Counting Functions
- Logical Functions
- Text Functions
- Date Functions
- Math Functions
- String Information functions
- Creating Calculated Columns
- Calculated Measures
- Introduction to Charts
- Creating following charts:
Area Chart
Bar Chart
Column Chart
Doughnut Chart
Heat map
Line Chart
Combo chart
Pie Chart
Waterfall Chart
Geographical Chart - Navigation across different sheet tables after creating report summaries (tabular representations, charts, pivots, etc)
- Modifying Charts properties
- Inserting Objects and Graphics
- Introduction to Power BI Dashboards
- Adding reports to dashboards
- Adding images and test to dashboards
- Formatting Dashboard Titles
- Dashboard Settings
- Upload Excel Files and workbooks in Dashboard and rename it
- Creating a Power BI Dashboard
- Drill up and Drill down Reports
- Adding Data bars to the table
- Difference between Power BI Dashboard and Power BI Visualization
- Creating Data Visualization
- Explaining data visualization properties
- Creating statistical trends in reports/dashboards
- Generating insights of reports
- Generating insights of Datasets
- Pinning a chart or dashboard
- Introduction to Power Pivots
- Linking source tables
- Uploading multiple tables and reports in one view
- Adding calculated columns
- Sorting and filtering in pivot
- Create a Power pivot
Who should attend
The training is ideal for those (such as Directors, Heads, Leaders, Managers, executives and self-employed across all industries and all professionals) who deal with a large volume of data in their day-to-day work for creating reporting solutions, data mining and need to grow from excel and use Business intelligence tools.
This course has been structured to help them understand the advanced features of Power BI.
This course has been structured to help them understand the advanced features of Power BI.
Profile of Divya Arora Hans
Expert Speaker, Business Consultant with almost 20yrs experience in field of Artificial Intelligence, Data Science, Gen AI, Machine Learning, Digitalization, Data & Predictive Analytics, Creating Interactive Dashboards, Data Storytelling, Data Visualizations, Creating automated reports for real time reporting, Data & Visual Analytics using Excel and business intelligence tools like Power BI and Tableau.
In addition Divya also specializes in Academic and Corporate and Government Trainings and consulting engagements, Insights generation, decision making, driving efficiency in processes, Process Automations and creating roadmap for use of Artificial Intelligence and automation for organizations to enhance data driven decision making.
She has excellence in her oration and has been responsible for conducting CEO round tables and training Faculty members, Students and staff of prestigious Academic institutions and Leadership teams across public sector , corporates,
Government and SME’s both in Singapore and Globally
Key Experience
• National University of Singapore (NUS)
• Nanyang Technological University (NTU) – Training Adult Learners
• Singapore Management University (SMU)
• Singapore University of Social Sciences (SUSS)
• Ministry of Foreign Affairs Singapore– Trained across 25 countries
• Ministry of Defence (MINDEF)
• Institute of Singapore Charted Accountants (ISCA)
• 1FSS
• Agency for Integrated Care- Ministry of Health
• UWCSEA – United world college South east Asia
• Murdoch University – Australian university
• Association of Chartered Certified Accountants (ACCA)
Sector Experience
• Academia
• Universities
• Education Sector
• Finance and Accounting
• Government Sector – Multiple Ministries across Singapore
• Public sector
• FMCG
• Healthcare
Key Trainings conducted across above sectors
• Artificial Intelligence & Generative AI
• Data Visuaization
• Power BI and Tableau Trainings
• Data Analytics & Machine Learning
• Data Visualization and Big Data
• Creating Data Dashboards & Excel Expertise
Professional and Technical qualifications
• Masters in Business Economics
• Masters in Business Administration
• a certified Green Belt Six sigma professional.
• Economics (Hons)
