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

DATA ANALYST TRACK

 


1) SPREADSHEETs SKILLs

DATA IMPORT ( CSV / JSON / REVERSE ETL / ODBC )
WEB DATA SCRAPING ( CHROME / GOOGLE SHEET / REGEX )
DATA CLEANING / PREPARATION ( EXCEL / GOOGLE SHEET )
DATA FORMATING

2) DATABASES AND SQL CONCEPTS

SELECT CLUASES
WHERE CLAUSES
JOIN CLAUSES
GROUP BY CLAUSES

3) DATA ANALYTICS AND BI TOOLs

DATA MODELING ( STAR SCHEMAs, ERDs )
DATA CALCULATIONs
DATA VISSUALIZATION ( POWER BI / TABLEAU PUBLIC / GOOGLE LOOKER STUDIO / QLIK )

4) BUSSINESS MATHEMATICS AND STATISTICS

ACCOUNTING AND FINANCE BASICS
BASIC STATISTICS ( TYPE OF CHARTs / AGGREGATIONs )
HYPOTHESIS TESTING ( DRAW CONCLUSIONS FROM SAMPLE DATA )
BUSSINESS MODELING ( B2B , B2C etc )

5) CODING SKILLs

PYTHON AND R ( POSIT.CLOUD )
DATA CLEANUP BY SQL ( GOOGLE BIGQUERY  CLOUD SQL )   VIDEO LINK - 1  |  VIDEO LINK - 2
STATISTICAL CALCULATIONs
MACHINE LEARNING  LIBRARIES AND DATA VISSUALIZATION

6) BUSSINESS APPLICATIONs

EMAIL CLIENTs for MARKETTING ( MS OUTLOOK / SLACK )
PRESENTATIONs ( MS POWERPOINT / GOOGLE SLIDES / BLOGs / UI / UX )
CONTENTs SHARING  ( MS SHAREPOINT / ONE DRIVE / GOOGLE DRIVE )
PROJECT MANAGEMENTs ( GITHUB / ZOHO / MS PROJECT )
AUTOMATION TOOLs for CUSTOMER SERVICES ( HUBSPOT / ZOHO / SALESFORCE )

7) AI TOOLs

OPENAI CHATGPT
MS COPILOT
GOOGLE VERTEX AI







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