Our course is thoughfully designed in such a way that learner gets the Real Time Investment banking & Equity Research exposure. Learner is not necessarily be from finance background, as our course ensures that Basic finance & account concepts are covered in detail with real time examples.
It is 80% practical with industry used case studies.
Our assessment & presentation evaluations are similar to top investment banks & equity research firms Our expert trainers are on hand to help answer any questions you might have along the way.
Online support from our team for all your queries based on ticket based tracking system
Get 3 certifcations inone course financial modeling, equity research and advance excel. You can show them seperately in resume.
Live case studies for each financial topics to ensure that learner can understand it thoroughly.
Our expert will assist you in resume building and job portal updation.
You get lifetime access to the FINXL LMS which includes videos, excel spreadsheets, presentations, ebooks, quizzes and case studies.
Our career square forum is ths most dynamic platform to connect with expert across the globe.
LEARN HOW TO EXCEL IN BUSINESS INTELLIGENCE
BY CREATING ARTIFICIALLY INTELLIGENT
DASHBOARDS
USING MICROSOFT POWER BI,
ALL WITHOUT THE NEED FOR CODING OR PRIOR KNOWLEDGE
POWER BI COURSE CONTENT:
This course is intended
to provide the basic level curriculum. The idea of this course is conceptual
understanding and hands-on learning. At the end of this course, everyone must
feel they are at ease working with Power BI from basic to advanced areas.
Course duration: Intensive 24 Hrs.
MODULE 1: GET STARTED WITH MICROSOFT DATA ANALYTICS
Getting Started
Why Power BI
The interface of Power BI
Different Parts of Power BI
Components of Power BI
Power BI Workflow
MODULE 2: PREPARE DATA IN POWER BI
How to Import Tables and Ranges in Power BI?
How to Import CSV, PDF, and Web in Power BI?
Power BI output format?
MODULE 3: CLEAN, TRANSFORM AND LOAD DATA IN POWER QUERY
Functions using the menu:
Various text functions prepare data for data visualisation.
Various Date functions to prepare data for data visualisation.
Various functions prepare data for data visualization.
MODULE 4: DATA CLEANING TECHNIQUES
Transformation of data in Power Query without coding
Promote and Demote Headers
Add, Remove, Rename, Delete, Move Column
Ignore Top/Bottom Rows and extract relevant data in middle
Keep and Remove Top and Bottom Rows
Transpose, Pivot and Unpivot
Fill up and Fill down
Remove Duplicates, blank rows, null values, and errors
Collect and add data to a single file in Power Query
Appending Clean Data
Append Multiple CSV files from a folder in a fraction of second
Append Multiple Excel Tables
Append Multiple Excel files from the folder
Append Multiple PDF files from the folder
Merging data in Power Query – Without VLOOKUP
Merging data from two tables in Excel
Merging data from two Excel files
Merging data from two data sources
MODULE 5: MORE WITH POWER QUERY EDITOR
Creating Columns using Conditional Columns
Creating Custom Columns with M Functions
Creating Columns from Examples
Creating Index Column
Creating parameters and using them in custom functions
Creating Custom Functions and invoking them
MODULE 6: ADVANCED VISUALIZATION IN POWER BI
Getting data in Power BI Data Visualization
Bar chart, Area Chart, Stacked Area Chart, Line vs Column Chart
Creating Pie, Donut, Guage Chart, Funnel, Ribbon Chart
Creating a Maps
Creating a Single Card for text, date, and numbers
Creating multi-row card for text, date, and numbers
Creating a decomposition tree
Creating a Table and Matrix
Conditional formatting of Table and Matrix
MODULE 7: ENHANCE POWER BI REPORTS
How to format each element of charts like Legends, Title, Background, Border X Axis, Y Axis, Secondary Axis, Data Labels
Conditional formatting to charts
Customized Tooltip
Pre-Requisites
BASIC
COMPUTER SKILLS: You should have basic computer skills such as
using a mouse, and keyboard, and navigating around a computer. This includes file
management skills such as creating, saving, and opening files.
FAMILIARITY
WITH MICROSOFT OFFICE: Power BI is a Microsoft tool, so it's
helpful to have some experience with Microsoft Office tools such as Excel and
PowerPoint.
BASIC
DATA ANALYSIS SKILLS: Some basic knowledge of data analysis concepts
such as data types, data structures, and data visualization can be helpful.
BASIC
PROGRAMMING SKILLS: Some knowledge of programming concepts such as
loops, conditional statements, and variables can be helpful. However, this is
not always necessary for beginner courses.
A
WILLINGNESS TO LEARN: Most importantly, a willingness to learn and
practice is essential to successfully complete the course and become proficient
in Power BI.
Target Audience
Any commerce Graduates & Post Graduates (BBA, BCOM, BBM, MCOM),
Non-Commerce Graduate or Post Graduate (BSC, Engineers, B.E., B. Tech, M.E.,
After MBA or During MBA, CFA or any degree in Finance, MBA/CFA/CA Aspirants, CPAs,
ICWA, CS, Back office/operations working professionals, accounting working
professionals, KPOs/BPOs professionals, Financial Analysts, Business Analysts,
Startup founders, Bankers, Financial Controllers, CFOs, CEOs, Fund Managers, PE
Fund Managers, Account Receivables (AR), Accounts Payables (AP), Record To
Report (R2R), Reconciliation background professionals, housewives after a long
gap of marriage or kids to make a career in the Finance field, Businessman /
Entrepreneur.
Research Companies
.