Posts

Showing posts from 2023

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

BANKING BASICS

Image
  BANKING BASICS FOR DATA ANALYTICS TYPE OF BANKS: Retail Banks Retail banks offer their services to the general public and usually have branch offices as well as main offices for the convenience of their customers. They provide a range of services such as checking and savings accounts , loan and mortgage services , financing for automobiles, and short-term loans such as overdraft protection . Many also offer credit cards . They also offer access to investments. The larger retail banks also cater to high-net-worth individuals with specialty services such as  Private banking  [ high-net-worth individual ( HNWI ) ] Wealth management services. Example : Citibank . Commercial or Corporate Banks Commercial or corporate banks tailor their services to business clients , from small business owners to large, corporate entities. Along with day-to-day business banking, these banks also offer credit services, cash management, commercial real estate services , employer services, and trade finance

STOCK MARKET ANALYSIS WEBSITES and TERMINOLOGIES

Image
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

INTERACTIVE DASHBOARDS FOR DATA ANALYTICS

Image
a { text-decoration: none; color: black; } Analytics dashboards are visualization tools that give you an overview of key metrics.  Makes it much easier to extract insights from analysis compared to looking at mere numbers. Analytics dashboards are tools for visualizing key metrics in your business. A  great analytics   dashboard is clear, customizable, intuitive. Looker Studio Visualizations and Template s Looker Studio Templates BYMARKETERS.CO DASHBOARDS SAMPLES: Smart Finance Dashboard v.3.3 | Powered by TillerHQ AIRLINE ANALYSIS BANKING ANALYTICS - 1 WORLD CITIES POPULATION - 1 PAKISTAN BANKING SECTOR "ADVANCES" REPORT FROM 2002 TO 2022 BANKING SECTOR STOCK ANALYSIS LOOKER STUDIO DASHBAORD DESIGN SAMPLES IN GOOGLE DRIVE NOVYPRO https://www.novypro.com/all_dashboards https://www.novypro.com/project/revenue-margin-analysis-maillis https://www.novypro.com/project/canadian-store-dashboard-power-bi https://www.novypro.com/project/b

KPIs FOR DASHBOARDS

Image
KPIs FOR DASHBOARDs KPI Examples for Finance Revenue Profit margin Cash flow Return on investment (ROI) Current ratio (liquidity) Debt-to-equity ratio Working capital efficiency Budget-to-actual performance Accounting costs Accounts payable turnover Accounts receivable collection period Accounts receivable turnover Actual expenses Amount due (per customer) Average customer receivable Average monetary value of invoices outstanding Average monetary value of overdue invoices Average number of trackbacks per post Budget variance for each key metric Budgeted expenses Capital expenditures Cash conversion cycle (CCC) Cash flow return on investments (CFROI) Cost of goods sold (COGS) Cash dividends paid Cost per pay slip issued Creditor days Current receivables Cumulative annual growth rate (CAGR) Cycle time for expense reimbursements Cycle time to process payroll Cycle time to resolve an invoice error Cycle time to resolve payroll errors Days payable Debtor days Direct cost Discounted cash flo

Study Aid

Image