Submitted to,

The Learning and Development Unit

Human Resources Department

WORKSHOP ON

POWER BI
(BUSINESS INTELLIGENCE)

General Details
Batch: 7th
Date and Time: Nepal Standard Time
December 23, 24 & 26, 27 | Time: 7:00 AM to 9:00 AM (Online)
December 28 | Time: 8:30 AM - 5:00 PM [Physical]
Duration: 16 hours
Venue for Physical Session (28 Dec): Hotel Crystal Pashupati, Kathmandu
Fee/ Investment: NPR 20,000/- (Excluding VAT)
Targeted Audience: Finance, MIS, IT, HR, Administration, Account, Analyst,
Business Development. No need to have previous knowledge of tools or
specific department to learn Power BI for this batch. Working experience with
MS Excel will be beneficial.
INTRODUCTION
For any company, data is the dominant component. Managing the data with analytical
skills is the elemental factor. Every company from BFIs to Corporate houses holds
Database Management System.
In today’s world of emerging technology, Excel has appeared to be many of a company’s
prior. Now the spreadsheet of Microsoft Company has taken over the show with a new
platform of Business Intelligence (BI) which has expertise the professionals as well as
non-professionals to a greater level of analysis and visualization. Power BI is the future of
Excel granting users with analytical tools like Power Pivot, Power Queries, and Power
Maps that can maintain multiple data from diverse sources granting you cloud-based
service and desktop interference. Power BI is not exactly a tool but it’s a platform to
create business Intelligence capabilities for preparing powerful reports and interactive
dashboards that formulate effective plans and policies in every business and company.

OBJECTIVES
Power BI is a business analytics solution that lets you visualize your data and share
insights across your organization, or embed them in your app or website, connect to
hundreds of data sources and bring your data to life with live dashboards and reports.
Here are the objectives of Power BI training;
Learn how to connect Power BI Desktop to various data sources, including
databases, spreadsheets, and online services.
Understand how to use the Query Editor to manipulate and transform data to suit
reporting needs.
Gain proficiency in creating visually appealing reports and visualizations using the
datasets built in Power BI Desktop.
Explore the functionality of live dashboards and how to effectively share insights
across an organization or embed them into applications or websites.
Master the process of publishing reports created in Power BI Desktop for wider
consumption and collaboration within your team or organization.

LEARNING OUTCOMES
This course offers comprehensive training in Power BI, focusing on designing compelling
visualizations, generating actionable insights, and crafting advanced reports and
dashboards from scratch. Participants will delve into advanced DAX calculations, KPI
visualization, and data exploration techniques. By mastering Power BI's latest features
and best practices, individuals can effectively analyze data, drive informed decision-
making, and enhance organizational performance through impactful data visualization
and reporting. Here are some of the outcomes outlined below;

1
 Design visuals like charts, graphs that provide a clear representation of data
Generate valuable insights for yourself and your company
Create stunning reports and dashboards with all the latest features of Power BI right
for, scratch
Create advanced DAX measures and calculated columns for complex calculations
Create Power BI Dashboards in no time
Explore data visualization
Understand the importance of visualization & how they can benefit an organization in
visualizing
Design and maintain stunning Power BI reports
Write Powerful advanced DAX calculations in Microsoft Power BI
Create and publish reports
This course gives a planned and functional understanding for the company along with
presenting data in a visual form.

PRE-REQUISITES
In order to participate in the Power BI session, the following pre-requisites must be
fulfilled.
Working with Microsoft products e.g. excel is an advantage but not compulsion
Anyone who is familiar with MS Office applications and needs to work with data to be
able to connect, process and analyze the data to produce suitable output at all level
within an organization.

COURSE CONTENT
Module 1: Introduction to Power BI
Download latest Power BI software
Install Power BI
Overview on Power BI

Module 2: Get Data into Power BI (Excel, CSV, Folder, Database)

Types of Data Sources
Get data from Excel, CSV and Folder
Get data from Database (My Sql, Sql Server)
Introduction to Canvas, Visualizations, Fields, Formatting
Create table and matrix visuals
Data refresh

2
Module 3: Data Transformation using Power Query
Transpose, Header Row Promotion
Data Type Changes & Detection
PIVOT
UNPIVOT
Merge
Append
Move Column and Split Column
Extract, Format and Numbers
Date & Time Transformations
Deriving Year, Quarter, Month, Day

Module 4: Data Modelling

Introduction to Entity Relation diagram
Normalization
Data Mapping
Relationship
One to One
One to Many
Many to One
Many to Many

Module 5: Data Analysis with DAX

DAX : Importance in Real-time
Real-world usage of Excel, DAX
DAX Architecture, Entity Sets
DAX Data Types, Syntax Rules
DAX Measures and Calculations
ROW Context and Filter Context
DAX Operators, Special Characters
DAX Functions, Types in Real-time
Vertipaq Engine, DAX Cheat Sheet
Creating, Using Measures with DAX
Creating, Using Columns with DAX
Quick Measures and Summaries
Validation Errors, Runtime Errors
SUM, AVERAGEX, KEEPFILTERS
Dynamic Expressions, IF in DAX

3
Module 6: Preparing Power BI Dashboard
Introduction to Visualization in Power BI Desktop
Branding (Size, Header, Spacing, Footer)
Insert Image, Shape, Text Box
Design Thinking
Prepare a Power BI Dashboard
Stacked Charts and Clustered Charts
Line Charts, Area Charts, Bar Charts
100% Stacked Bar & Column Charts
Map Visuals: Tree, Filled, Bubble
Cards, Funnel, Table, Matrix
Scatter Chart : Play Axis, Labels
Nepal map in Power BI

Module 7: Publish and Sharing Power BI Reports

Why Power Bi Service?
Comparison Power BI Free & Premium
Logging into Power BI Service
Interface overview
Importing data from Desktop to Service
Working on reports
Workspace & Gateways
Installing Gateways - Personal & On-premise
Working alone or collaborating with colleagues
Collaborating in App Workspace

Module 8: Real-Time Project

Project Requirement Analysis
Requirement Gathering
PBIX Report Design
Visualizations, Properties
Analytics and Formatting
Data Modeling, Power Query
DAX Requirements, Analysis
Preparing Dashboard
Sharing report with the team

Note: Delegates are required to have their own laptop or desktop

4
FACILITATOR/S PROFILE

Mr. Dipu Maharjan

BI Solution Architect | Data Analyst | Programmer

Professional Summary
With over 14 years of experience, Dipu Maharjan is a highly skilled professional
specializing in data analytics, business intelligence, database programming, and solution
architecture. Dipu has successfully led cross-functional teams and managed complex
projects from conception to deployment. His expertise spans database programming,
ETL pipelines, data visualization, and cloud technologies, demonstrating a deep
commitment to delivering data-driven solutions that drive business growth.

Key Skills
SQL, PL/SQL, T-SQL (SQL Server)
ETL Tools (ODI, Apache Airflow, Azure Data Pipeline)
Programming: Python
BI Tools: Power BI, Tableau, Oracle BI Publisher
Cloud Platforms: AWS, Snowflake
Scrum Roles: Product Owner, Scrum Master, Tech Lead
Advanced Excel and VBA
Data Analytics and Automation

Professional Experience
Dipu has held prominent positions such as;
Lead Consultant - Logic Information Systems (Oct 2024 – Present)
Leading BI projects, building ETL pipelines, and managing batch processing with
Apache Airflow.
Principal Software Engineer - LIS Nepal Pvt. Ltd. (Dec 2023 – Sep 2024)
Developed dashboards, optimized T-SQL scripts, and designed ETL processes.
Manager – BI & Data Analytics - Advantmed India (Dec 2020 – Sep 2022)
Administered Power BI platforms and architected enterprise data workflows.
Principal Software Engineer, Cotiviti Nepal Pvt. Ltd. (Nov 2017 – Nov 2020)
Developed database programming scripts in Oracle and SQL Server.
Migrated legacy client scripts to Oracle Data Integrator and optimized scripts for
performance, managed Scrum team activities, including PI planning and sprint
reviews.

5
TARGETED AUDIENCE
Targeted Audience: Finance, MIS, IT, HR, Administration, Account, Analyst, Business
Development. No need to have previous knowledge of tools or specific department to
learn Power BI for this batch. Working experience with MS Excel will be beneficial.

ABOUT US
SKILL BEST is an ISO 9001:2015 Certified Company and Member of Multilateral
Recognition Arrangement - IAF for Banking, Finance and Insurance consulting, learning
& development, BPO, Certification programs, and human resources management with
the motto of ‘be skilled be independent’.
We research, design, and deliver market-oriented consulting services as well as training
programs and organize various events and seminars/webinars. We have been working
with Banking and Financial Institutions, Multinational Companies, Non-Government
Organizations, International Non-Government Organizations, Government Agencies,
United Nation Houses, Colleges/Universities, and IT companies. We have worked with
more than 95 national and international institutions. The training we have organized is all
over Nepal and internationally which includes India, Pakistan, Ethiopia, and Bahrain. The
trainers, and consultants at Skill Best are national to international, are highly experienced
and knowledgeable.

6
 TRUSTED BY
COMMERCIAL BANKS FINANCE & MICRO-FINANCE

CENTRAL BANK
DEVELOPMENT BANKS

MERCHANT BANKS

IT & COMMUNICATION

INSURANCE

CORPORATE

GOVERNMENT ORGANIZATIONS

COLLEGE & SCHOOLS INGOS & NGOS

7
THANK YOU
We assure you the best learning experience at Skill Best!

Contact Us
+977 9849416342
[email protected]
www.skillbest.com.np
Baneshwor, Kathmandu, Nepal