New user? Register as member

Data Visualization through Power BI - Intermediate Level

Power BI is a Data Visualization and Business Intelligence tool that converts data from different data sources to interactive dashboards and BI reports. Power BI suite provides multiple software, connector, and services - Power BI desktop, Power BI service based on Saas, and mobile Power BI apps available for different platforms. These set of services are used by business users to consume data and build BI reports.

You can download power BI free of charge here

Objective

This tutorial has been prepared for beginners to help them understand the basic concepts of Power BI. This tutorial will give you enough understanding on Power BI, from where you can take yourself to a higher level of expertise.

Outline

Introduction to Power BI
Installing Power BI
Understanding Power BI Interface
Architecture of Power BI
Difference between Power BI, Tableau, Qliksense and ORANGE

Learning about connection with different data sources
Importing data through multiple excel Files,
Importing data through text files,
What and how to use Direct Query, Imported Query
Online source
Load data from Multiple Data Sources

Get to know features of Power BI
Add, Delete, Rename, Duplicate pages
Add delete, rename and split Columns and Rows
Basic and Advanced Filtering in Power BI
Page Level vs Report Level Filters
Using Slicers
Sorting Data

Data Modelling
How to import data
Create reports
How to create relationships in data sources
Combining Multiple Tables
Use calculated table to create connection between two tables
Formatting Dates Hierarchies and Joins

Understanding DAX Language
Explaining most commonly used formulas and functions
Creating Calculated Columns
Calculated Measures
Calculated Tables
Calculated Columns

Creating Power BI Charts
Introduction to Charts
Creating following charts:
Area Chart
Bar Chart
Column Chart
Line Chart
Pie Chart
Additional Chart functionalities
Modifying and customizing Charts properties

Sharing Power BI dashboards
Report Sharing in Power BI Dashboard
Printing Power BI Dashboards
Publishing Report internally
Publishing reports to the web

Who should attend

The training is ideal for all corporate professionals who deal with humongous datasets and are willing to have an edge in the industry by analyzing their data through advanced Business Intelligence tools and learn advanced Data Visualization techniques

Methodology

Prerequisites
Before proceeding with this tutorial, you should be familiar with Microsoft Excel

Testimonials

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)