Scribd
Upload
5 views2 pages

Data Analyst - Assessment

The document outlines an assessment task involving the creation of an end-to-end analytics solution using Python, MySQL, and a BI tool like Power BI or Tableau. It requires the analysis of a multi-sheet Excel dataset related to e-commerce operations, with a focus on generating actionable insights for leadership. Deliverables include a Python notebook, MySQL dump file, BI dashboard, and a summary report detailing problem statements, analysis approaches, key insights, and business recommendations.

Uploaded by

ashishkumarswain000
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views2 pages

Data Analyst - Assessment

The document outlines an assessment task involving the creation of an end-to-end analytics solution using Python, MySQL, and a BI tool like Power BI or Tableau. It requires the analysis of a multi-sheet Excel dataset related to e-commerce operations, with a focus on generating actionable insights for leadership. Deliverables include a Python notebook, MySQL dump file, BI dashboard, and a summary report detailing problem statements, analysis approaches, key insights, and business recommendations.

Uploaded by

ashishkumarswain000
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

ASSESSMENT

OBJECTIVE

You are provided with a multi-sheet Excel dataset: Sales_Analytics.xlsx.

Your task is to build an end-to-end analytics solution using:


• Python for all data cleaning, transformations, joins, and exploratory analysis
• MySQL to store the final cleaned and analysis-ready tables
• Power BI or Tableau to build the final dashboard connected directly to MySQL

You must also define your own problem statements based on patterns you discover in the dataset and
generate actionable, data-driven insights -the type of insights leadership would use for decision-making

DATASET OVERVIEW

The Excel file contains multiple sheets, including:


• Sales_Transactions
• Sales_by_Month_Wide
• Customer_Accounts
• Inventory_Log
• Campaign_Metrics
• Customer_Feedback
• Supplier_Data
• Employee_Performance
• Regional_Performance
• Purchase_History

Each sheet covers different aspects of e-commerce operations, giving you the scope to explore sales,
customer behavior, inventory movement, campaign impact, employee performance, and more.

MANDATORY WORKFLOW

1. Python
Complete data cleaning, preprocessing, transformations, joins
Exploratory data analysis
All analytical queries must be performed in Python
2. MySQL
Load only the final cleaned and analysis-ready data frames as tables
These MySQL tables will act as the data source for your BI dashboard

3. Dashboard (Power BI / Tableau / Looker Studio)


Build a dashboard connected directly to MySQL
Insights should be crafted at a level appropriate for executive leadership

DELIVERABLES

1. Python notebook (.ipynb)


2. MYSQL Dump file(.sql)- Must include ONLY the final analytical tables (not raw data).
3. Power BI (.pbix) or Tableau (.twbx) or Looker studio Public Link
4. Summary Report (PDF)
Include:
· Problem statements
· Analysis approach
· Key insights
· High-level business recommendations (suitable for leadership)

SUBMISSION FORMAT
Submission folder should include

• notebook/
• python_scripts/
• sql/
• bi_dashboard/
• reports/

Submit the entire folder as a ZIP file: YourName_KidventoAnalyticsAssignment.zip

You might also like