EXCEL NOTES FOR BBA ANALYTICS by JAMSHI J

Search This Blog

PRACTICAL_EXERCISE 5_SUMIF

on July 12, 2024

Get link
Facebook
X
Pinterest
Email
Other Apps

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

ANALYTICAL CYCLE

The Analytical Cycle: Transforming Data into Insights The analytical cycle is a foundational concept in Business Analytics (BA). It's an iterative process that guides you through transforming raw data into actionable insights to solve business problems. Here's a breakdown of each stage: 1. Identifying the Problem: This is the starting point. Clearly define the business challenge you want to address. What are you trying to understand or improve? Examples: High customer churn rate, declining sales in a specific region, and inefficiency in a production process. 2. Collecting Data: Identify relevant data sources that can shed light on your problem. This could involve internal data (sales figures, customer surveys) or external data (market research reports, industry trends). Ensure you gather sufficient data to draw reliable conclusions. 3. Cleaning Data: Raw data often contains errors, inconsistencies, and missing values. Data cleaning involves identifying and correcti...

3.HIERARCHY OF INFORMATION USERS IN BUSINESS ANALYTICS

Top (Strategic): CEOs, CFOs - Need high-level insights for strategic choices (overall performance, industry trends, long-term forecasts, ROI of data initiatives). Middle (Tactical): Department heads, managers - Use BA for informed decisions within their departments (operational efficiency, meeting departmental goals, identifying areas for improvement, campaign effectiveness). Lower (Information Consumers): Individual contributors - Reliant on BA reports and dashboards to understand their specific role and performance (daily/weekly metrics, customer feedback data, sales trends for their territory, task-relevant information). Bridge Role: Business Analysts - Translate complex data into actionable insights for information users. Data Specialists: Data Scientists - Build models, analyze large datasets, identify hidden patterns (may not directly interact with information users).

Practical's 1 : Formatting cells in Excel

Formatting cells in Excel allows you to control the appearance of your data, making it easier to read and understand. Here are some common formatting options: 1. Number formatting: - General - Number - Currency - Accounting - Date - Time - Percentage 2. Alignment: - Left - Center - Right - Justify - Top - Middle - Bottom 3. Font: - Font style (e.g., Arial, Calibri) - Font size - Bold - Italic - Underline 4. Border and shading: - Border style (e.g., solid, dashed) - Border color - Fill color 5. Protection: - Lock cells - Hide formulas 6. Conditional formatting: - Highlight cells based on conditions (e.g., values, formulas) -...

Powered by Blogger

PRACTICAL_EXERCISE 5_SUMIF

Comments

Post a Comment