Enterprise-Value-To-Ebitda-Ratio Time Series for Excel Force MSC Bhd. Excel Force MSC Berhad, together with its subsidiaries, develops, provides, and maintains software application solutions for the financial services industry in Malaysia. The company operates through Application Solutions, Maintenance Services, Application Services Provider, and Other segments. Its product portfolio includes CyberStock BTX, a bridging trader and exchange system platform that provides trading tools classes; and CyberStock ECOS, a stock broking solution which offers real time market information, place trades, and manage orders solution. In addition, the company provides CyberStock Mobile Trader, a mobile trading system that connects users smartphones to exchanges to manage trading activities; and CyberStock EDS, an exempt dealer system that provides advanced trading infrastructure and facilities for commercial banks. Further, it offers CyberStock SMF, a share margin financing system that enables financial institutions, brokerage firms, and banks to operate and manage margin financing services; and CyberStock CNS, a custodian and nominee system, which provides value-added services, such as trade settlement, cash balances investment, income collection, corporate actions processing, recordkeeping and reporting to custodian banks for domestic services. Additionally, the company provides CyberStock BOS, a back office system to manage enormous file and data; and offers network and security services. Excel Force MSC Berhad was founded in 1994 and is based in Petaling Jaya, Malaysia.

🚘 Electric Vehicle (EV) Sales Analysis & Forecasting

The Electric Vehicle (EV) Sales Analysis & Forecasting project explores India’s EV adoption trends from 2014 to 2024, combining BigQuery for data analytics and Power BI for visualization. This end-to-end data project demonstrates expertise in SQL-based data analysis, time-series forecasting using BigQuery ML (ARIMA+), and interactive dashboard design. This repository presents an in-depth data analysis and visualization of Electric Vehicle (EV) sales trends across India using Microsoft Excel, SQL, Python and Power BI.

The Electric Vehicle Sales Dashboard is an interactive and visual analytics solution built using Power BI, focused on analyzing EV adoption trends across India. It includes KPIs, comparative charts, and advanced metrics to assist stakeholders in understanding EV sales performance from 2014 to 2024.

⚙️ Tech Stack

Google BigQuery → Data storage, cleaning, and analysis using SQL

BigQuery ML (ARIMA_PLUS) → Time series forecasting for future EV sales prediction

Power BI → Interactive dashboard for visualization and storytelling

Pyhton → For eda and visualization

Excel / CSV → Initial dataset preparation and transformation

🔹 Key Features: ✅ Total EV Sales Trends: Year-over-year and month-over-month change

✅ State-wise EV Performance: Compare EV adoption across Indian states

✅ Vehicle Category Breakdown: 2W, 3W, 4W, Buses, Others

✅ Dynamic Filtering: Use slicers to filter by Year, Month, State.

✅ KPI Cards: Total Sales, Average Sales

📊 Dashboard Overview Components:

Section Description 🔹 KPI Cards Highlight key performance indicators like Total Sales, Average Sales. 📈 Trend Charts Year-wise and month-wise sales volume (bar/line charts) 🗺️ Geo Analysis State-wise sales with ranking and contribution 🚗 Vehicle Type Pie Distribution of sales by 2W, 3W, 4W, Bus, Others 📅 Time Series Filtering and Interactive slicers for Year, Month, and State. 📊 YOY / MOM Change Dedicated visual section with % growth/dip over time

Dashboard using Power BI

https://github.com/user-attachments/assets/eca3b9c3-b446-4447-a38a-d61f5572a712" alt="DashBoards">

Dashboard using Excel

https://github.com/user-attachments/assets/f7cc0949-4581-4cb3-b3ab-ea9242bce803" alt="Dashboard excel">

🗓️ Year-on-Year EV Sales (2014–2024) - EV sales have grown from 2.4K in 2014 to 1.5M in 2023. - Peak growth observed in: - 2021 → 2022: +209% YoY growth - 2020 → 2021: +165% YoY growth - 2024 saw a drop (as of current data): -90.61% https://github.com/user-attachments/assets/02965465-d6cf-45bf-b127-40feb6fe9963" alt="yoy">

📆 Month-on-Month (MoM) Analysis - Highest sales months: November, December, and January - Noticeable drop in February followed by recovery in March https://github.com/user-attachments/assets/83bce2dd-b2ae-43b9-bdb2-def5b9dbe37d" alt="mom">

📍 State-wise Performance - Top Performing States: - 🥇 Uttar Pradesh: ~730K units - 🥈 Maharashtra: ~400K units - 🥉 Karnataka: ~320K units - Lower adoption in northeastern and union territory regions - https://github.com/user-attachments/assets/1ee491b5-9016-4a1e-850f-34e8b9a9aab3" alt="state wise ev">

EV State wise Sale correlation https://github.com/user-attachments/assets/4c5fc55d-389d-4bed-a9bb-eebe8ce31a11" alt="EV corr">

Top 5 State KDE Plot https://github.com/user-attachments/assets/1b9e2f69-9ea0-4ac4-8c26-0350fb75bd75" alt="EV kde plot">

🚗 EV Sales by Vehicle Type - 2-Wheelers: 50.3% of total sales - 3-Wheelers: 45.1% - 4-Wheelers and Buses: Small but growing segment https://github.com/user-attachments/assets/2fc64426-4e3d-4a14-b058-f7c67040663b" alt="vtype wise ev">

📅 Year-wise EV Sales Trend EV adoption has grown significantly from 2,392 units in 2014 to over 1.5 million units in 2023

Fastest growth period: 2020–2022, with YoY gains of 165% and 209%

2024 shows a decline (-90.6%) due to possible data incompleteness https://github.com/user-attachments/assets/d60567fb-fc61-463f-b0e8-34ddd14f1b8d" alt="Year wise ev">

------------------------------...

Analyzing Coffee Shop Sales: Excel Insights 📈

In my first Data Analytics Project, I Discover the secrets of a fictional coffee shop's success with my data-driven analysis. By Analyzing a 5-sheet Excel dataset, I've uncovered valuable sales trends, customer preferences, and insights that can guide future business decisions. 📊☕

DATA CLEANING 🧹

• REMOVED DUPLICATES OR IRRELEVANT ENTRIES: Thoroughly eliminated duplicate records and irrelevant data to refine the dataset for analysis.

• FIXED STRUCTURAL ERRORS: Rectified any inconsistencies or structural issues within the data to ensure uniformity and accuracy.

• CHECKED FOR DATA CONSISTENCY: Verified the integrity and coherence of the dataset by identifying and resolving any inconsistencies or discrepancies.

DATA MANIPULATION 🛠️

• UTILIZED LOOKUPS: Used Excel's lookup functions for efficient data retrieval and analysis.

• IMPLEMENTED INDEX MATCH: Leveraged the Index Match function to perform advanced data searches and matches.

• APPLIED SUMIFS FUNCTIONS: Utilized SumIFs to calculate totals based on specified criteria.

• CALCULATED PROFITS: Used relevant formulas and techniques to determine profit margins and insights from the data.

PIVOTING THE DATA 𝄜

• CREATED PIVOT TABLES: Utilized Excel's PivotTable feature to pivot the data for in-depth analysis.

• FILTERED DATA: Utilized pivot tables to filter and analyze specific subsets of data, enabling focused insights. Specially used in “PEAK HOURS” and “TOP 3 PRODUCTS” charts.

VISUALIZATION 📊

• KEY INSIGHTS: Unveiled the grand total sales revenue while also analyzing the average bill per person, offering comprehensive insights into the coffee shop's performance and customer spending habits.

• SALES TREND ANALYSIS: Used Line chart to compute total sales across various time intervals, revealing valuable insights into evolving sales trends.

• PEAK HOUR ANALYSIS: Leveraged Clustered Column chart to identify peak sales hours, shedding light on optimal operating times and potential staffing needs.

• TOP 3 PRODUCTS IDENTIFICATION: Utilized Clustered Bar chart to determine the top three coffee types, facilitating strategic decisions regarding inventory management and marketing focus.

*I also used a Timeline to visualize chronological data trends and identify key patterns over specific times.

While it's a significant milestone for me, I recognize that there's always room for growth and improvement. Your feedback and insights are invaluable to me as I continue to refine my skills and tackle future projects. I'm eager to hear your thoughts and suggestions on how I can make my next endeavor even more impactful and insightful.

THANKS TO: WsCube Tech Mo Chen Alex Freberg

TOOLS USED: Microsoft Excel

DataAnalytics #DataAnalyst #ExcelProject #DataVisualization #BusinessIntelligence #SalesAnalysis #DataAnalysis #DataDrivenDecisions

Abstract

This dataset was supplied to the Bioregional Assessment Programme by a third party and is presented here as originally supplied. Metadata was not provided and has been compiled by the Bioregional Assessment Programme based on known details at the time of acquisition.

Mean monthly flow (ML/month) and Annual flow (ML/yr) data at key gauges in the Macalister Irrigation District (MID) as monitored by SRW. The data are provided in MS Excel format in worksheets and charts.

Data used to produce Time-series drainage volume data provided by a third party. Site information and monitoring drainage flow data provided by the Southern Rural Water are specific to the Macalister Irrigation District.

Time specific data in the range 23/07/1997 to 31/12/2013

Dataset History

This dialogue has been copied from a draft of the BA-GIP report.

A total of 197 river gauges were identified within the model area representing all of the major rivers. Daily gauge level data was sourced from the Victorian Department of Environment, Land, Water and Planning Water Measurement Information System (WMIS, 2015). A list of the river gauges is provided in the report for key river basins

Only main stems of the major rivers were included in the model. These river reaches were identified using the DEPI hydro25 spatial data set (DEPI, 2014). The river classification was used to vary river incision depth (depth below the ground surface as defined by the digital elevation model) and width attributes. In the absence of recorded stage height information, river classification was used to estimate river stage heights. A total of 22,573 river cells are included in the model. Fifty-one gauges were selected to calibrate the catchment modelling framework in unregulated catchments based on Base Flow Indexes and observed stream flows.

Drainage channels and man-made drainage features in the Macalister Irrigation District (MID) were included in the model based on available drainage network mapping. This information was sourced from Southern Rural Water (SRW) and the DEPI Corporate Spatial Data library. Drainage cells are assigned to the uppermost cells within the model to capture groundwater discharge processes. Drain cells in Modflow can only act as groundwater discharge points and as such those cells outside drainage channels will be characterised as having a bed elevation equivalent to ground surface elevation. A total of 410,504 drainage cells are incorporated in the model. Apart from 3 river gauges sourced from the WMIS, SRW also has 15 gauges monitored drainage from the MID. The measurements commenced between 1997 and 2005. Of the 15 gauges, six were selected to calibrate the catchment modelling framework based on observed discharge.

Dataset Citation

Victorian Department of Economic Development, Jobs, Transport and Resources (2015) Mean monthly flow & annual flow data - Macalister Irrigation District. Bioregional Assessment Source Dataset. Viewed 05 October 2018, http://data.bioregionalassessments.gov.au/dataset/6ba89d78-1e42-4e02-bd5c-a435ee15bef4.

Working-Capital-Turnover Time Series for Excel Force MSC Bhd. Excel Force MSC Berhad, together with its subsidiaries, develops, provides, and maintains software application solutions for the financial services industry in Malaysia. The company operates in four segments: Application Solutions, Maintenance Services, Application Services Provider, and Other segments. Its product portfolio includes CyberBroker Front Office for client-server, web, and mobile-based stock trading systems; CyberBroker Middle Office; CyberBroker Back Office, including custodian and nominee systems; StockBanking System comprising share margin financing systems; and fundamental analysis systems. The company also offers eForce One, a web trading platform that operates as an electronic client ordering system; Mobile Trade 3.5G, a mobile trading system; eForce Interactive X-Chart, a charting tool; eForce EmPower, a back-office system; and Cyberstock, a dealer and remisier system. In addition, it provides investment advisory services. Excel Force MSC Berhad was founded in 1994 and is based in Petaling Jaya, Malaysia.

Other-Non-Cash-Items Time Series for Excel Force MSC Bhd. Excel Force MSC Berhad, together with its subsidiaries, develops, provides, and maintains software application solutions for the financial services industry in Malaysia. The company operates in four segments: Application Solutions, Maintenance Services, Application Services Provider, and Other segments. Its product portfolio includes CyberBroker Front Office for client-server, web, and mobile-based stock trading systems; CyberBroker Middle Office; CyberBroker Back Office, including custodian and nominee systems; StockBanking System comprising share margin financing systems; and fundamental analysis systems. The company also offers eForce One, a web trading platform that operates as an electronic client ordering system; Mobile Trade 3.5G, a mobile trading system; eForce Interactive X-Chart, a charting tool; eForce EmPower, a back-office system; and Cyberstock, a dealer and remisier system. In addition, it provides investment advisory services. Excel Force MSC Berhad was founded in 1994 and is based in Petaling Jaya, Malaysia.

Days-of-Sales-Outstanding Time Series for Excel Force MSC Bhd. Excel Force MSC Berhad, together with its subsidiaries, develops, provides, and maintains software application solutions for the financial services industry in Malaysia. The company operates through Application Solutions, Maintenance Services, Application Services Provider, and Other segments. Its product portfolio includes CyberStock BTX, a bridging trader and exchange system platform that provides trading tools classes; and CyberStock ECOS, a stock broking solution which offers real time market information, place trades, and manage orders solution. In addition, the company provides CyberStock Mobile Trader, a mobile trading system that connects users smartphones to exchanges to manage trading activities; and CyberStock EDS, an exempt dealer system that provides advanced trading infrastructure and facilities for commercial banks. Further, it offers CyberStock SMF, a share margin financing system that enables financial institutions, brokerage firms, and banks to operate and manage margin financing services; and CyberStock CNS, a custodian and nominee system, which provides value-added services, such as trade settlement, cash balances investment, income collection, corporate actions processing, recordkeeping and reporting to custodian banks for domestic services. Additionally, the company provides CyberStock BOS, a back office system to manage enormous file and data; and offers network and security services. Excel Force MSC Berhad was founded in 1994 and is based in Petaling Jaya, Malaysia.

Net-Income-From-Continuing-Operations Time Series for Excel Force MSC Bhd. Excel Force MSC Berhad, together with its subsidiaries, develops, provides, and maintains software application solutions for the financial services industry in Malaysia. The company operates through Application Solutions, Maintenance Services, Application Services Provider, and Other segments. Its product portfolio includes CyberStock BTX, a bridging trader and exchange system platform that provides trading tools classes; and CyberStock ECOS, a stock broking solution which offers real time market information, place trades, and manage orders solution. In addition, the company provides CyberStock Mobile Trader, a mobile trading system that connects users smartphones to exchanges to manage trading activities; and CyberStock EDS, an exempt dealer system that provides advanced trading infrastructure and facilities for commercial banks. Further, it offers CyberStock SMF, a share margin financing system that enables financial institutions, brokerage firms, and banks to operate and manage margin financing services; and CyberStock CNS, a custodian and nominee system, which provides value-added services, such as trade settlement, cash balances investment, income collection, corporate actions processing, recordkeeping and reporting to custodian banks for domestic services. Additionally, the company provides CyberStock BOS, a back office system to manage enormous file and data; and offers network and security services. Excel Force MSC Berhad was founded in 1994 and is based in Petaling Jaya, Malaysia.

Number-of-Days-of-Payables Time Series for Excel Force MSC Bhd. Excel Force MSC Berhad, together with its subsidiaries, develops, provides, and maintains software application solutions for the financial services industry in Malaysia. The company operates through Application Solutions, Maintenance Services, Application Services Provider, and Other segments. Its product portfolio includes CyberStock BTX, a bridging trader and exchange system platform that provides trading tools classes; and CyberStock ECOS, a stock broking solution which offers real time market information, place trades, and manage orders solution. In addition, the company provides CyberStock Mobile Trader, a mobile trading system that connects users smartphones to exchanges to manage trading activities; and CyberStock EDS, an exempt dealer system that provides advanced trading infrastructure and facilities for commercial banks. Further, it offers CyberStock SMF, a share margin financing system that enables financial institutions, brokerage firms, and banks to operate and manage margin financing services; and CyberStock CNS, a custodian and nominee system, which provides value-added services, such as trade settlement, cash balances investment, income collection, corporate actions processing, recordkeeping and reporting to custodian banks for domestic services. Additionally, the company provides CyberStock BOS, a back office system to manage enormous file and data; and offers network and security services. Excel Force MSC Berhad was founded in 1994 and is based in Petaling Jaya, Malaysia.

Short-Term-Debt Time Series for Excel Force MSC Bhd. Excel Force MSC Berhad, together with its subsidiaries, develops, provides, and maintains software application solutions for the financial services industry in Malaysia. The company operates in four segments: Application Solutions, Maintenance Services, Application Services Provider, and Other segments. Its product portfolio includes CyberBroker Front Office for client-server, web, and mobile-based stock trading systems; CyberBroker Middle Office; CyberBroker Back Office, including custodian and nominee systems; StockBanking System comprising share margin financing systems; and fundamental analysis systems. The company also offers eForce One, a web trading platform that operates as an electronic client ordering system; Mobile Trade 3.5G, a mobile trading system; eForce Interactive X-Chart, a charting tool; eForce EmPower, a back-office system; and Cyberstock, a dealer and remisier system. In addition, it provides investment advisory services. Excel Force MSC Berhad was founded in 1994 and is based in Petaling Jaya, Malaysia.