Fundamental analysis Crash Course
What you'll learn
Understand the role of a Business Analyst
About tools and techniques you can use as a Business Analyst
Key concepts in Business Analysis
How to kick-start your career as a Business Analyst
How to gather, group, prioritize and validate requirements
Where to find job opportunities as a BA and how much a BA earns
How to continue learning about Business Analysis
-30%
Investment Analysis Portfolio Management Course
What you'll learn
Calculate stock returns manually as well as on Excel and Google Sheets, using real-world data obtained from free sources.
Estimate the Expected Returns of Stocks using the Mean Method, State Contingent Weighted Probabilities, as well as Asset Pricing Models.
Calculate the total risk, market risk, and firm-specific risk of stocks from scratch, and explore how the different risks interact.
Understand why the math works, and why equations work the way they do - even if your math is weak and if math freaks you out.
Witness the power of diversification and how the risk of your portfolio can be lower than the individual assets that make up the portfolio!
Measure your investment portfolio's performance by calculating portfolio returns and risks.
Optimize your investment portfolios by maximizing your returns while minimizing your risk.
Decompose Diversification so you understand why it actually works (hint: it's the mathematical "magic" of Rho)
Research Analyst Course
What you'll learn
Introduction to Research Analyst profession
Introduction to securities market
Fundamentals of research
Economic analysis
Industry analysis
Company Analysis – Qualitative dimensions
Company Analysis – Quantitative dimensions
Valuation Principles
Fundamentals of risk and return
Qualities of a good research report
Diploma in Financial Market Management Course
What you'll learn
A market maker's perspective
FX transaction process and pricing trades
Technical Analysis best practices that can be used in any market
Money management strategies - stop loss and take profit strategies
Tableau Course
What you'll learn
Create and use Groups
Understand the difference between Groups and Sets
Create and use Static Sets
Create and use Dynamic Sets
Combine Sets into more Sets
Use Sets as filters
Create Sets via Formulas
Control Sets with Parameters
Control Reference Lines with Parameters
Use multiple fields in the colour property
Create highly interactive Dashboards
Develop an intrinsic understanding of how table calculations work
Use Quick Table calculations
Write your own Table calculations
Combine multiple layers of Table Calculations
Use Table Calculations as filters
Use trendlines to interrogate data
Perform Data Mining in Tableau
Create powerful storylines for presentation to Executives
Create powerful storylines for presentation to Executives
Understand Level Of Details
Implement Advanced Mapping Techniques
MIS Training – Advance Excel + Macro + Access + SQL
What you'll learn
Advance Level Excel
Expertise in Using Text Function
Expertise in Using Logical Function
Expertise in Using Math Function
Expertise in Using Lookup & Reference Function
Expertise in Using Date and Time Function
Expertise in Using Pivot Table and Chart
Expertise in Power Pivot and Power Map
Expertise in Using What If Analysis Tools
Many Others Excel Tools
MS Access Knowledge on Table, Form, Queries and Reports
SQL Queries
Macro Recording
Excel VBA Object Handling with practical Project
Excel VBA Variable with practical Project
Excel VBA IF & Case with practical Project
3 Types of Loop with practical Project
Create your own Function
Events in VBA
FSO in Excel VBA
Userform in Excel VBA
Automate Pivot and Outlook in Macro
Many More Macro Topics and Projects
SAS Course
What you'll learn
This course is suitable for the SAS BASE certifications including SAS Certified Specialist and SAS Certified Associate (Exam ID A00-231, A00-233, A00-215)
All critical and essential SAS BASE Data manipulation and data preparation skills
Handle Error by identify and solve SAS errors
Combine, merge and restructure data sets
SAS Statistical Procedures
Reports generating
SAS advanced topic: Proc SQL Essentials
SAS advanced topic: SAS Macros Essentials
R Programming Course
What you'll learn
Installing R and R Studio
Manipulating R Vectors, Arrays and Matrixes
Manipulating R Data Frames
Plotting Data Using R
Analyzing Real Datasets using R
Organizing your Code in R
Develop your own Functions in R
Summarizing Data with R
Load Excel Files with R
Compute Basic Statistics about a Dataset
Install External Libraries to Power up R
Aggregate and Sort Data
Subset Data
Power BI Course
What you'll learn
Build professional-quality business intelligence reports from the ground up
Blend and transform raw data into beautiful interactive dashboards
Design and implement the same B.I. tools used by professional analysts and data scientists
Showcase your skills with two full-scale course projects (with step-by-step solutions)
Understand the business intelligence workflow from end-to-end
Learn from a best-selling instructor and professional BI developer
- 1
- 2
