Data Analyst Vs Business Analyst Vs Data Engineer Vs BI Specialist

Image
  Data Science - Complete Track • Step 1 - Identify the business problem/value addition/question – ( Data Insights ) this has to be the starting point. • Step 2 - Data availability ( Data Governance ) - Have the structure of your data set defined – The real challenge starts here-                o Do we have the data?                o Do we have access to the required data? • Step 3 -Getting Data ( Data Mining / Data Pipeline ) – How to collect the data from different sources in the system • Step 4 - Data preparation (ETL / ELT) – Once you have data there will be lot of cleaning and preparation required, reduce/increase/combine/split the predictors, determine and eliminate outliers, populate missing values convert few categorical variables into numerical etc. • Step 5 –Exploratory Data Analysis (EDA) – In this step we do descriptive and diagnostic analysis of the existing data. We build multiple graphs that give us direction towards the next steps of predictive analytics. We migh
Post a Comment

STOCK MARKET ANALYSIS WEBSITES and TERMINOLOGIES

STOCK MARKET ANALYSIS WEBSITES and TERMINOLOGIES


Types of Stocks



Growth Stocks

As their name suggests, growth stocks refer to equities expected to grow at a faster rate compared to the broader market.

Value Stock

Value stocks trade at a discount to what a company's performance might otherwise indicate, typically having more attractive valuations than the broader market.

Income Stocks

Income stocks are equities that provide regular income by distributing a company's profits, or excess cash, through dividends that are higher than the market average.

Blue-Chip Stocks

Blue-chip stocks are well-established companies that have a large market capitalization. They have a long successful track record of generating dependable earnings and leading within their industry or sector.

Cyclical Stocks

Cyclical stocks are directly affected by the economy's performance and typically follow economic cycles of expansion, peak, recession, and recovery.

Non-Cyclical Stocks

Non-cyclical stocks operate in "recession-proof" industries that tend to perform reasonably well irrespective of the economy

Defensive Stocks

Defensive stocks generally provide consistent returns in most economic conditions and stock market environments.

IPO Stock

When a company goes public, it issues stock through an initial public offering (IPO).

IPO stock typically gets allocated at a discount before the company's stock lists on the stock exchange.


What Are Shares Outstanding?

Issued shares: the number of shares company-issued or the sum of all outstanding shares

Treasury shares: a company's holdings of shares in its own treasury

Authorized share capital: the maximum amount of capital that a company can issue to its shareholders

Floating stock: the total number of outstanding shares that are available for public purchase

Restricted stock: unregistered shares of ownership in a corporation issued to executives and directors


Formulas for calculating shares outstanding

Shares outstanding = Floating stock + Restricted shares

Shares outstanding = Shares issued - Shares repurchased

Shares outstanding = Authorized shares - Treasury stock


STOCK MARKET ANALYSIS WEBSITES

STOCKANALYSIS

TRADINGVIEW

SCREENER

TRENDLYNE

STOCKEDGE

INVESTING


HOW TO SCRAPE STOCKs DATA INTO GOOGLE SHEET?

=IMPORTHTML("https://stockanalysis.com/stocks/", "table", 1)

GOOGLE FINANCE FUNCTION IN GOOGLE SHEET

=GOOGLEFINANCE(A2,"price")

=GOOGLEFINANCE(A2,"priceyest")

=GOOGLEFINANCE(A2,"close")

=GOOGLEFINANCE(A2,"volume")

=GOOGLEFINANCE(A2,"eps")

=GOOGLEFINANCE(A2,"pe")







Comments

Post a Comment

Popular Post

Covid 19 Rapid Antigen Test Kit

Image
  Antibody tests are useful to help track the spread of a contagious disease , disease that is readily spread. It can be very useful to identify those who should be vaccinated urgently, and to select the donors for convalescent plasma therapy. Antigens are molecules capable of stimulating or encouraging an immune system response. Each antigen has distinct surface features or structures called epitopes, generating specific responses. What are Antibody and Antigen ? An antibody (Ab), also known as an immunoglobulin (Ig), is a large, Y-shaped protein used by the immune system to identify and remove foreign objects such as pathogenic bacteria and viruses.  These antibodies are produced by B cells of the immune system due to exposure to antigens. Each antibody contains a paratope which recognizes a specific 'epitope' on an antigen, acting like a lock and key binding mechanism. This binding makes possible to eliminate antigens from the body, either by direct neutralization or by ‘tag
Read more

Portable Pulse Oximeter

Image
  Portable Pulse Oximeter Portable Pulse Oximeter is a noninvasive and painless device to measures oxygen saturation level, or the oxygen levels in blood. It can rapidly detect even small changes in how efficiently oxygen is being carried  to all of its cells, tissues, and organs. Portable Pulse Oximeter can be used to measure oxygen saturation levels along with heart rate. Portable Pulse oximeter can be used to monitor the health of a person with any type of condition that can affect blood oxygen levels. These conditions include: 1 . chronic obstructive pulmonary disease 2 . asthma 3 . pneumonia 4 . lung cancer 5 . anemia 6 . heart attack or heart failure 7 . congenital heart defects How Portable Oximeter Works To measure oxygen level, a probe that looks like a bag clip is placed onto fingertip, toe, or earlobe. Light beams pass through the blood, measuring the amount of oxygen gas. It does this by measuring changes of light absorption in oxygenated blood containing high oxygen l
Read more

NVIDIA DGX B200

Image
  Nvidia turns up the AI heat with 1,200W Blackwell GPUs AI's power and thermal demands hit home Nvidia doubles up on GPU compute with second-gen Superchips According to Nvidia its DGX B200 chassis with eight B200 GPUs will consume roughly 14.3kW – something that's going to require roughly 60kW of rack power and thermal headroom to handle. Blackwell's full potential will require switching over to liquid cooling. In a liquid-cooled configuration, Nvidia says the chip can output 1,200W of thermal energy when pumping out the full 20 petaFLOPS of FP4. While Nvidia may dominate the AI infrastructure market, it's hardly the only name out there. Heavy hitters like Intel and AMD are rolling out Gaudi and Instinct accelerators. The B200 "Blackwell" is the largest chip physically possible using existing foundry tech, according to its makers. The chip is an astonishing 208 billion transistors , and is made up of two chiplets, which by themselves are the largest
Read more

KEY PERFORMANCE METRICS FOR BANKS

Image
Leadership starts with access to the right information to make intelligent decisions and drive a  data culture . The average bank spends an excessive number of hours per month assembling financial performance reports, then updating, distributing, and  interpreting data . Bank should consider a  performance management tool  designed to automate the entire process, empowering to do less administrative work compiling data and reports, and more time making  data-driven decisions  that impact bottom-line success. Impactful strategic decisions  then start with understanding current performance strengths and areas of improvement by tracking the right mix of key performance metrics for banks metrics and bank KPIs. METRICS: 1. LDR Loans/Deposits Ratio (LDR) – Expressed as a percentage, LDR is used to assess a bank's liquidity by comparing a bank's total loans to its total deposits for the same period. If the ratio is too high, it means that the bank may not have enough liquidity to
Read more

DATA ENGINEER CERTIFICATIONS

Image
a { text-decoration: none; color: black; }   WHAT DATA ENGINEERs DO? Data engineers work in a variety of settings to build systems that: Collect, Manage, and Convert Raw Data into usable information for Data Scientists and Business Analysts to Interpret. RECOMMENDED CERTIFICATIONs FUNDAMENTALS AND CAREER CERTIFICATION from IBM ETL and Data Pipelines with Shell, Airflow and Kafka from IBM TECHNOLOGY CERTIFICATIONs: Microsoft Certified: Azure Fundamentals PRE-REQUISITES: Infrastructure management. Database management. Software development. AWS Certified Data Engineer Associate 2024 - Hands On! from UDEMY AWS Certified Data Engineer - Associate AWS RECOMMENDS: 2-3 years of experience in data engineering 1-2 years of hands-on experience with AWS services
Read more

Essentials You Need to Know Before Investing in Stocks

Image
  COMPANY FUNDAMENTALs information such as  PROFITABILITY, REVENUE, ASSETS, LIABILITIES, DEBT, AND GROWTH POTENTIAL are considered fundamentals COMPANY FINANCIALs CURRENT RATIO = CURRENT ASSETS / CURRENT LIABILITIES DEBT RATIO = TOTAL LIABILITIES / TOTAL ASSETS RETURN ON ASSETS RATIO = NET INCOME / TOTAL ASSETS RETURN ON EQUITY RATIO = NET INCOME / SHAREHOLDER’S EQUITY DIVIDEND YIELD RATIO = DIVIDEND PER SHARE / SHARE PRICE EPS = EARNINGS PER SHARE RATIO = NET EARNINGS / TOTAL SHARES OUTSTANDING PE = PRICE-EARNINGS RATIO = SHARE PRICE / EARNINGS PER SHARE COMPANY PAYOUTs DIVIDEND, BONUS, RIGHTS A payout is the share of profits that a listed company will pay its shareholders. If the payout set out in the company’s shareholder remuneration policy is 50%, the company will distribute half of its net profits among its shareholders.  A dividend is cash paid to shareholders for their share in the company's profits.  A share buyback and the subsequent cancellation of shares are w
Read more

Comparison between COVID-19 Vaccines

Image
  CLICK ON IMAGE TO ZOOM CLICK ON IMAGE TO ZOOM Mixing COVID Vaccine Brands Appears Safer, in some cases is Likely to Cause Side Effects. But not Severe. Using two different vaccines will provide greater effectiveness because they work in differently. CLICK ON IMAGE TO ZOOM CLICK ON IMAGE TO ZOOM CLICK ON IMAGE TO ZOOM Recommendations: Monitor Antigens with the help of Rapid Antigen Test   Monitor Oxygen Saturation Level with the help of Oximeters
Read more