WHO SHOULD ATTEND
This training is invaluable for Business Analysts, Data Analysts, Finance and Accounting Professionals, Marketing Analysts, Managers and Executives, IT Professionals, and aspiring individuals.
Training Overview
In today’s fast-paced and ever-evolving technological landscape, data has become a cornerstone for businesses seeking to make strategic, forward-thinking decisions. As we navigate our daily tasks, we are constantly exposed to various forms of raw data. However, transforming this data into actionable insights through analysis, report preparation, and visualization can be a daunting task. The sheer volume and complexity of data can often create barriers to efficient decision-making if not managed and interpreted correctly.
Power BI, a powerful business analytics tool from Microsoft, helps users visualize data and share insights across teams. It enables the creation of visual representations and interactive dashboards, making it easier to uncover insights hidden within complex datasets.
This training on Power BI will equip learners with essential techniques needed to utilize the tool effectively for data analysis and visualization. By mastering these skills, participants will be better positioned to transform raw data into valuable insights, enhancing their ability to make informed, data-driven decisions within their organizations.
Course Content
This comprehensive training offers aspiring individuals the skills and knowledge needed to transform raw data into actionable insights using Power BI analytics tools. The topics covered in the sessions are:
Day 1:
- Get Power BI Desktop
- Getting Started with Power BI Desktop
- Data Sources in Power BI Desktop
- Import Excel Workbooks
- Data Type in Power BI Desktop
- Data Import from Folder
Day 2:
- Introduction to visualization
- Creating formatting a first visualization
- Visualization Metrics and bar charts
- Bar chart, Column Chart, Line Chart, Pie Chart, Scatter Chart, Waterfall Chart, tree map etc
Day 3:
- Adding more control on visualization (adding text box, images, shapes, filers, advanced filtering, slicer, drill through etc)
- Mapping
Day 4:
- Append multiple files
- Transforming data
- Joins
- Merging Queries
- Refresh the data
Methodology of Training
- Virtual Session presentation by Trainer
- Polls and Q/A sessions at the end of session to make it more interactive
- Engaging
Mr. Binod Bhattarai
(Chartered Accountant (CA))
Resource Person
Mr. Binod Bhattarai is a Chartered Accountant (CA) and a member of the Institute of Chartered Accountants of Nepal (ICAN). In addition to his CA qualification, he holds an MBS degree from Shanker Dev Campus, Tribhuvan University, and has completed certification in Data Science with Python Programming.
With over 6-7 years of experience in the banking and insurance sectors, Mr. Bhattarai is currently working at Nepal Life Insurance Company Limited, where he brings his expertise in financial analysis and risk management. He is also a skilled trainer, conducting sessions in Power BI, Python Programming, Financial Modeling, AML/CFT Compliance & Risk Management, and Technical Analysis. Mr. Bhattarai actively contributes as a resource person at the Association of Chartered Accountants of Nepal (ACAN), where he trains professionals in Power BI.
His extensive knowledge and hands-on experience make him an invaluable resource for professionals looking to advance their skills in Power BI analytics and data visualization technology.