Data Analysis With SQL

A Dissertation Report
Submitted in partial fulfillment of the requirements for the Degree of
Bachelor of Science in Computer Science and Engineering

Submitted by

Name: MD Akul Hossen

Roll: 2021100010036

Supervised by

Farhad Uz Zaman

Lecturer
Department of Computer Science and Engineering
Southeast University, Bangladesh

Department of Computer Science and Engineering

Southeast University, Bangladesh

Dhaka, Bangladesh

15Feb, 2025

i
 Letter of Transmittal

15Feb,2025

The Chairman,
Department of Computer Science and Engineering
Southeast University, Bangladesh
Tejgaon, Dhaka

Through: Supervisor, Farhad uz Zaman.

Subject: Submission of Internship Report on Data Analyst with SQL

Dear Sir,

I am pleased to submit my internship report titled "Data Analyst with SQL" as part of my internship
program in the Department of Computer Science and Engineering at Southeast University,
Bangladesh.
During my internship, I worked extensively on data analysis using SQL. This experience allowed me
to develop practical skills in database management, data manipulation, and analytical reporting,
which I believe will be invaluable in my future career.
I would like to express my sincere gratitude to my supervisor, Mr./Ms. [Supervisor Name], for their
continuous guidance, support, and encouragement throughout the internship. I am also thankful to
the Department of Computer Science and Engineering for providing me with this opportunity to
enhance my skills and knowledge.
I hope that this report meets the expectations and requirements of the department. Please feel free to
contact me if any further clarification or additional information is needed.

Sincerely Yours,
Supervisor:

Name : MD Akul Hossen

Farhad uz Zaman
Roll : 2021100010036
Lecturer
Department of Computer Science
and Engineering
Southeast University, Bangladesh

i
 CANDIDATE’S DECLARATION

We, hereby, declare that the thesis presented in this report is the outcome of the investigation
performed by me under the supervision of Farhad uz Zaman, Lecturer, Department of
Computer Science and Engineering, Southeast University, Bangladesh. The work was done
through CSE489: Internship course, in accordance with the course curriculum of the
Department for the Bachelor of Science in Computer Science and Engineering program.

It is also declared that neither this research nor any part thereof has been submitted
anywhere else for the award of any degree, diploma, or other qualifications.

Name: MD Akul Hossen

Roll: 2021100010036

ii
 CERTIFICATION

This report titled, “Data Analyst with SQL”, submitted by Md Akul Hossen (ID:2021100010036), has
been accepted as satisfactory in partial fulfillment of the requirements for the degree of Bachelor of
Science in Computer Science and Engineering in 15Feb,2025.

Farhad Uz Zaman Mohammad Shariful Islam

Lecturer Manager
Department of Computer Science Teletalk Bangladesh Limited
and Engineering Southeast University, Bangladesh
Southeast University, Bangladesh

Shahriar Manzoor
Associate Professor & Chairman
Department of Computer Science
and Engineering
Southeast University, Bangladesh

iii

iii
 ABSTRACT

Structured Query Language (SQL) is a powerful tool for data analysis, widely used for extracting,
manipulating, and analyzing data stored in relational databases. This abstract explores the role of
SQL in data analysis, highlighting its capabilities in querying, aggregating, and transforming data to
derive meaningful insights. SQL enables analysts to perform tasks such as filtering data, joining
multiple tables, calculating aggregates, and creating summary reports. With its robust functions,
including window functions, subqueries, and Common Table Expressions (CTEs), SQL provides a
flexible and efficient way to handle complex analytical tasks. Additionally, SQL's integration with data
visualization tools and programming languages like Python and R makes it a cornerstone of modern
data analysis workflows. This abstract emphasizes the importance of SQL in enabling data-driven
decision-making and its relevance in industries ranging from finance and healthcare to e-commerce
and marketing. By leveraging SQL, organizations can unlock the full potential of their data, driving
innovation and competitive advantage.

iv
 Executive Summary

This report, titled “Data Analyst with SQL”, documents the work and findings of the internship
conducted at Teletalk Bangladesh Limited as part of the CSE489: Internship course under the
Department of Computer Science and Engineering at Southeast University, Bangladesh. The primary
objective of this internship was to gain hands-on experience in data analysis using SQL, focusing on
data extraction, transformation, and loading (ETL), query optimization, and generating actionable
insights from large datasets within the telecommunications sector.

The report begins with an introduction to the role of a data analyst and the significance of SQL in
modern data-driven decision-making processes, particularly in the context of Teletalk Bangladesh
Limited. It then outlines the methodologies and tools employed during the internship, including the
use of relational databases, advanced SQL queries, and data visualization techniques to analyze
customer data, network performance, and business operations.

Key findings from the analysis are presented, demonstrating how SQL can be leveraged to improve
data accuracy, efficiency, and reporting capabilities within the organization. The report also
highlights specific projects undertaken during the internship, such as optimizing database queries
for faster data retrieval and generating reports to support strategic decision-making.

The report concludes with recommendations for further improvements and potential applications of
SQL in real-world scenarios, particularly within the telecommunications industry. This executive
summary provides a concise overview of the report’s scope, purpose, and major findings,
emphasizing the importance of SQL in the field of data analysis and its relevance to Teletalk
Bangladesh Limited.

v
First and foremost, I would like to express my deepest gratitude to Almighty Allah for giving me the
strength, knowledge, and opportunity to complete this internship and report successfully.

I am profoundly grateful to my supervisor, Farhad uz Zaman, [Lecturer], Department of Computer

Science and Engineering, Southeast University, Bangladesh, for their invaluable guidance, continuous
support, and encouragement throughout the internship. Their insightful feedback and expertise
greatly contributed to the successful completion of this report.

I would also like to extend my sincere thanks to Teletalk Bangladesh Limited for providing me with
the opportunity to work as an intern in their esteemed organization. Special thanks to my industry
supervisor, Mohammad Shariful Islam, [Manager ], Teletalk Bangladesh Limited, for their
mentorship, guidance, and for providing me with the resources and knowledge necessary to
complete my tasks effectively.

I am deeply thankful to the Department of Computer Science and Engineering, Southeast

University, Bangladesh, for offering me the opportunity to undertake this internship as part of my
academic curriculum. The knowledge and skills I have gained during this internship will undoubtedly
be invaluable in my future career.

Lastly, I would like to express my heartfelt gratitude to my family, friends, and colleagues for their
unwavering support, motivation, and encouragement throughout this journey.

Dhaka Md Akul Hossen

2021100010036
15Feb,25 Department of Computer Science and
Engineering

vi
 Contents

LETTER OF TRANSMITTAL i

CANDIDATES’ DECLARATION ii

CERTIFICATION iii

EXECUTIVE SUMMARY iv

ABSTRACT iv

ACKNOWLEDGEMENT v

List of Figures viii

1 Introduction 1
1.1 Organization of Chapters ....................................................................................... 2-3

2 Literature Review 4
2.1 Role of SQL in Data Analysis ..................................................................................... 4
2.2 Applications in Telecommunications ....................................................................... 5-6

3 Methodology 7
3.1 Data Collection ............................................................................................................ 7
3.2 Data Cleaning .............................................................................................................. 7
3.3 Data Analysis ............................................................................................................ 8-9
3.4 Reporting-----------------------------------------------------------------------------------10-11

4 Findings and Analysis 12

4.1 Customer Segmentation ....................................................................................... 12-13
4.2 Network Performance Metrics ............................................................................. 13-14
4.3 Sales Trends ----------------------------------------------------------------------------------15

vii
5 Key Learnings 16
5.1 SQL Query Optimization .......................................................................................... 16
5.2 Data Visualization Techniques .................................................................................. 17

6 Limitations and Recommendations 18

6.1 Limitations ................................................................................................................ 18
6.2 Recommendations -----------------------------------------------------------------------19-20

7 Conclusion ----------------------------------------------------------------------------21

8 References ---------------------------------------------------------------------------22

viii
 List of Figures

3.1 Data Extraction -------------------------------------------------------------------------------------7

3.2 Handling Missing Data......................................................................................................8
3.3 Remove Duplicate.................................................................................................................................. 8
3.3.2 Data Validation ...................................................................................................................................... 9
3.3.1 Avg & Sum.............................................................................................................................................. 10
3.3.2 Customer Segmentation ................................................................................................................... 10
3.3.3 Trend Analysis ..................................................................................................................................... 11
3.3.4 Advanced SQL Techniques .............................................................................................................. 11
4.1: High-Value Customers----------------------------------------------------------------------------12
4.1 Low -Value Customers----------------------------------------------------------------------------13
4.2 Call Drop Rates------------------------------------------------------------------------------------ 14
5.1 Visualization----------------------------------------------------------------------------------------17

ix
 Chapter 1
Introduction

Through this internship, I developed a strong understanding of SQL, including advanced

techniques such as query optimization, joins, and window functions. In the era of big data, the
ability to extract, analyze, and interpret data is critical for organizations aiming to make informed
decisions and maintain a competitive edge. Structured Query Language (SQL) has emerged as a
cornerstone tool for data analysis, enabling professionals to efficiently manage, manipulate, and
derive insights from relational databases. This report, titled "Data Analysis with SQL",
documents the internship experience at Teletalk Bangladesh Limited, where SQL was
extensively utilized to analyze customer behavior, network performance, and sales trends. The
internship was conducted as part of the CSE489: Internship course under the Department of
Computer Science and Engineering at Southeast University, Bangladesh. These skills enabled me
to efficiently handle large datasets and extract meaningful insights, demonstrating the power of
SQL in driving data-driven decision-making. The experience gained during this internship has
been invaluable, providing a solid foundation for a career in data analysis and highlighting the
critical role of SQL in modern business environments.

1.1 Organization of Chapters

This report is organized into the following chapters to provide a structured and comprehensive
overview of the internship experience:

1. Introduction: Provides an overview of the internship, the role of SQL in data analysis, and
the objectives of the report.
2. Literature Review: Explores the role of SQL in data analysis and its applications in the
telecommunications industry, supported by academic and industry references.
3. Methodology: Outlines the systematic approach taken during the internship, including
data collection, cleaning, analysis, and reporting.
4. Findings and Analysis: Presents key findings from the data analysis, focusing on customer
segmentation, network performance metrics, and sales trends.

1
5. Key Learnings: Summarizes the skills and knowledge gained during the internship,
particularly in SQL query optimization and data visualization.
6. Limitations and Recommendations: Discusses the challenges faced during the internship
and provides recommendations for future improvements.
7. Conclusion: Summarizes the key takeaways from the internship and reflects on the overall
experience.
8. References: Lists all the sources and references cited throughout the report.

2
 Chapter 2
Literature Review

The literature review provides an overview of the role of SQL in data analysis and its applications in
the telecommunications industry. This section draws on academic research, industry reports, and case
studies to highlight the importance of SQL in modern data-driven decision-making processes.

2.1 Role of SQL in Data Analysis:

SQL (Structured Query Language) is a powerful tool for managing and analyzing relational databases. It
is widely used in data analysis due to its simplicity, flexibility, and efficiency. Below are the key aspects of
SQL's role in data analysis:

1. Data Extraction and Manipulation:

• Description: SQL allows analysts to extract and manipulate data from relational databases using
simple queries.

• Example: SELECT customer_id, call_duration FROM customer_calls WHERE call_date > '2023-01-
01';

• Importance: This capability is essential for retrieving specific datasets for analysis.

2. Data Cleaning and Transformation:

• Description: SQL provides functions for cleaning and transforming data, such as handling missing
values, removing duplicates, and standardizing formats.

• Example: UPDATE customer_calls SET call_duration = 0 WHERE call_duration IS NULL;

• Importance: Clean and consistent data is critical for accurate analysis.

3. Aggregation and Summarization:

• Description: SQL supports aggregation functions like SUM, AVG, COUNT, and GROUP BY to
summarize data.

SELECT location, AVG(call_duration) AS avg_call_duration FROM customer_calls GROUP BY location;

• Importance: These functions enable analysts to derive meaningful insights from large datasets.

4. Advanced Analytics:

• Description: SQL supports advanced analytics through window functions, subqueries, and joins.

• Example:
3
SELECT customer_id, call_duration, RANK() OVER (ORDER BY call_duration DESC) AS rank FROM
customer_calls;

• Importance: Advanced SQL techniques allow for complex analyses, such as ranking, trend
analysis, and segmentation.

5. Integration with Other Tools:

• Description: SQL can be integrated with data visualization tools (e.g., Tableau, Power BI) and
programming languages (e.g., Python, R) for end-to-end data analysis workflows.

• Importance: This integration enhances the capabilities of SQL and enables more sophisticated
analyses.

2.2 Applications in Telecommunications:

The telecommunications industry generates vast amounts of data, making SQL an indispensable tool for
analyzing customer behavior, network performance, and business operations. Below are the key
applications of SQL in telecommunications:

1. Customer Segmentation:

• Description: SQL is used to segment customers based on usage patterns, demographics, and
transaction history.

• Sql : SELECT customer_id, SUM(call_duration) AS total_call_duration FROM customer_calls GROUP

BY customer_id;

• Importance: Segmentation helps in targeting marketing campaigns and improving customer

satisfaction.

2. Network Performance Monitoring:

• Description: SQL is used to analyze network performance metrics, such as call drop rates, latency,
and signal strength.

• Example: SELECT location, COUNT(*) AS dropped_calls FROM network_logs WHERE call_status =

'dropped' GROUP BY location;

• Importance: Monitoring network performance helps in identifying and resolving issues to

improve service quality.

3. Sales and Revenue Analysis:

• Description: SQL is used to analyze sales trends, revenue growth, and product performance.

• Example: SELECT MONTH(transaction_date) AS month, SUM(transaction_amount) AS total_sales

FROM transactions GROUP BY MONTH(transaction_date);

• Importance: Sales analysis helps in identifying profitable products and optimizing pricing
4
 strategies.

4. Fraud Detection:

• Description: SQL is used to detect fraudulent activities, such as unusual call patterns or
unauthorized transactions.

• Example: SELECT customer_id, COUNT(*) AS suspicious_calls FROM customer_calls WHERE

call_duration > 1000 GROUP BY customer_id;

• Importance: Fraud detection helps in minimizing revenue losses and protecting customer data.

5. Predictive Analytics:

• Description: SQL is used in conjunction with machine learning models to predict customer churn,
network failures, and sales trends.

• Example: SELECT customer_id, call_duration, transaction_amount FROM customer_calls JOIN

transactions ON customer_calls.customer_id = transactions.customer_id;

• Importance: Predictive analytics enables proactive decision-making and improves business

outcomes.

6. Reporting and Visualization:

• Description: SQL is used to generate reports and dashboards for stakeholders, providing insights
into key performance indicators (KPIs).

• Example: SELECT location, AVG(signal_strength) AS avg_signal_strength FROM network_logs

GROUP BY location;

• Importance: Reporting and visualization help in communicating insights effectively and

supporting data-driven decisions.

5
 Chapter 3
Methodology

The methodology section outlines the systematic approach taken during the internship to analyze
data using SQL. It includes the steps of data collection, cleaning, analysis, and reporting, which were
essential for achieving the objectives of the internship.

Data Collection

Data Cleaning

Data Analysis:

Reporting:

Figure 3: Data Analysis Process

3.1 Data Collection:

Data collection is the first and most crucial step in any data analysis project. During the internship, data
was collected from Teletalk Bangladesh Limited's relational databases, which store a wide range of
information related to customer transactions, network performance, and business operations. The
following steps were taken for data collection:

1. Identification of Data Sources:

o The primary data sources included customer databases, network performance logs, and
sales transaction records.
o These databases were stored in MySQL and PostgreSQL systems, which are widely used
relational database management systems (RDBMS).

6
 2. Data Extraction:

SQL queries were used to extract relevant data from the databases.

Figure 3.1: Data Extraction

3. Data Integration:Data from multiple tables and databases were combined using SQL joins to
create a unified dataset for analysis.

3.2 Data Cleaning

Data cleaning is essential to ensure the accuracy and reliability of the analysis. During this phase, the
following steps were taken:

1. Handling Missing Data:

Missing values were identified using SQL queries:

Figure 3.2: Handling Missing Data

Missing values were either filled using averages or removed, depending on the context.

2. Removing Duplicates:
Duplicate records were identified and removed using the DISTINCT keyword or GROUP
BY clause:

7
 Figure 3.2.2: Removing Duplicates

3. Data Validation:
Data was checked for inconsistencies, such as incorrect date formats or outliers, using
conditional queries

Figure 3.2.3: Data Validation

4.Data Transformation:

• Data was transformed into a usable format. For example, dates were standardized, and
categorical data was encoded.

3.3 Data Analysis:

Data analysis involved using SQL to derive meaningful insights from the cleaned dataset. The
following techniques were applied:

1. Descriptive Analysis:
Basic statistics such as counts, averages, and sums were calculated:

Figure 3.3.1: Avg & Sum

2. Customer Segmentation:

8
Customers were segmented based on usage patterns, such as high-value customers and low-
usage customers:

Figure 3.3.2: Customer Segmentation

3. Trend Analysis:
Sales and call trends were analyzed over time to identify patterns:

Figure 3.3.3: Trend Analysis

4. Advanced SQL Techniques:

Advanced SQL features such as window functions and subqueries were used for deeper
analysis:

Figure 3.3.4: Advanced SQL Techniques

9
3.4 Reporting:
The final step was to present the findings in a clear and actionable manner. The following
steps were taken for reporting:
1. Data Visualization:
• SQL query results were exported to tools like Microsoft Excel or Tableau for
visualization.
• Charts such as bar graphs, line charts, and pie charts were created to represent trends
and patterns.

2. Report Generation:
• A comprehensive report was prepared, summarizing the key findings and insights.
• The report included:
o Executive summary
o Methodology
o Key findings (e.g., customer segmentation, sales trends, network
performance)
o Recommendations

3. Presentation to Stakeholders:
• The findings were presented to stakeholders, including supervisors and team
members, using slides and visual aids.

10
 Chapter 4

Findings and Analysis

This section presents the key findings and analysis derived from the data during the internship. The
analysis focuses on three main areas: Customer Segmentation, Network Performance Metrics,
and Sales Trends. Each subsection provides detailed insights and explanations supported by SQL
queries and visualizations.

4.1 Customer Segmentation:

Customer segmentation is a critical analysis that helps organizations understand their customer base
and tailor their services accordingly. During the internship, customer segmentation was performed
based on usage patterns, such as call duration, data usage, and frequency of transactions.

Key Findings:

High-Value Customers:Customers with the highest call durations and transaction amounts were
identified as high-value customers.

o SQL Query:

Figure 4.1: High-Value Customers

11
 Low-Usage Customers:

• Customers with minimal call durations and infrequent transactions were identified as low-
usage customers.
• SQL Query:

Figure 4.1: Low -Value Customers

4.2 Network Performance Metrics:

Network performance is a critical factor in the telecommunications industry. During the internship,
key metrics such as call drop rates, network latency, and signal strength were analyzed to identify
areas for improvement.
Key Findings:
1. Call Drop Rates:
o The call drop rate was calculated to identify regions or times with poor network
performance.
o SQL Query:

Figure 4.2: Call Drop Rates:

12
1. Network Latency:
• Network latency was analyzed to assess the quality of data services.
• SQL Query:

Figure 4.3: Call Drop Rates:

13
4.3 Sales Trends:
Analyzing sales trends helps organizations understand revenue patterns and plan marketing
strategies. During the internship, sales data was analyzed to identify seasonal trends, popular
products, and customer purchasing behavior.

Key Findings:
1. Seasonal Trends:
o Sales data revealed significant fluctuations during certain months, such as higher sales
during festivals or holidays.
o SQL Query:

Figure 4.4: Call Drop Rates:

Popular Products: The most popular products and services were identified based on transaction
volumes.

SQL Query:

Figure 4.5: Popular Products

• Seasonal trends showed higher sales during festivals and lower sales during monsoon
months.
• Popular products, such as data packages and international calling plans, were identified for t
14
 Chapter 5
Key Learnings

The internship provided valuable hands-on experience in SQL query optimization and data
visualization techniques. These skills are essential for any data analyst and were instrumental in
achieving the objectives of the internship. Below is a detailed explanation of the key learnings:

5.1 SQL Query Optimization:

SQL query optimization is the process of improving the performance of SQL queries to ensure
faster data retrieval and efficient database operations. During the internship, several techniques
were applied to optimize queries, which are summarized below:
Key Learnings:
1. Indexing:
o What I Learned: Indexes are used to speed up data retrieval by creating a data
structure that allows for faster searching.
o Queary:

2. *Avoiding SELECT :
• What I Learned: Using SELECT * retrieves all columns, which can be inefficient. Instead,
specifying only the required columns improves performance.
• Example:

3. Avoiding Subqueries When Possible:

• What I Learned: Subqueries can be resource-intensive. Using joins or temporary tables can
often achieve the same result more efficiently.
• Example:

15
5.2 Data Visualization Techniques:

Data visualization is the process of presenting data in graphical or pictorial formats to make it easier
to understand and interpret. During the internship, various visualization techniques were used to
present findings effectively

Key Learnings:
1. Choosing the Right Chart Type:

What I Learned: Different types of charts are suitable for different types of data.
▪ Bar Charts: For comparing categories (e.g., customer segments).
▪ Line Charts: For showing trends over time (e.g., sales trends).
▪ Pie Charts: For showing proportions (e.g., demographic distribution).
▪ Heatmaps: For visualizing density or intensity (e.g., call drop rates by region).
o Impact: Improved clarity and effectiveness of data presentations.

2. Using Tools for Visualization:

o What I Learned: Tools like Microsoft Excel, Tableau, and Power BI are powerful for
creating visualizations.

Figure 5.1: Visualization

16
 Chapter 6
Limitations and Recommendations

This section discusses the limitations encountered during the internship and provides recommendations to
address these challenges and improve future data analysis projects.

6.1 Limitations:
Despite the successful completion of the internship, several limitations were encountered that impacted the
scope and depth of the analysis. These limitations are outlined below:
1. Limited Access to Data:
o Description: Access to certain datasets was restricted due to privacy concerns and
organizational policies.
o Impact: The analysis was limited to the data available in Teletalk's internal databases, which
may not fully represent the entire customer base or network performance.
2. Data Quality Issues:
o Description: Some datasets contained missing, inconsistent, or outdated information.
o Impact: Data cleaning required significant effort, and some inaccuracies may have affected the
analysis results.
3. Time Constraints:
o Description: The internship had a fixed duration, which limited the depth of analysis that could
be performed.
o Impact: Certain advanced analyses, such as predictive modeling, could not be explored in detail.
4. Tool Limitations:
o Description: The tools available for data analysis (e.g., MySQL, Excel) had certain limitations in
handling large datasets and performing advanced analytics.
o Impact: Some analyses had to be simplified or performed in multiple steps, increasing the time
and effort required.
5. Lack of Real-Time Data:
o Description: The data used for analysis was not real-time, as it was extracted from periodic
database backups.
17
 o Impact: The findings may not reflect the most current state of the business or network
performance.

6.2 Recommendations:
To address the limitations and improve future data analysis projects, the following recommendations are
proposed:
1. Expand Data Access:
o Recommendation: Collaborate with the IT and data governance teams to gain access to a
broader range of datasets, including real-time data.
o Benefit: This will enable more comprehensive and up-to-date analyses, leading to better
decision-making.
2. Improve Data Quality:
o Recommendation: Implement regular data audits and validation processes to ensure data
accuracy and consistency.
o Benefit: High-quality data will reduce the time spent on cleaning and improve the reliability of
analysis results.
3. Invest in Advanced Analytics Tools:
o Recommendation: Adopt advanced analytics tools such as Python, R, or Apache Spark for
handling large datasets and performing complex analyses.
o Benefit: These tools offer more flexibility and scalability, enabling deeper insights and faster
processing.
4. Conduct Predictive Analysis:
o Recommendation: Explore predictive modeling techniques, such as machine learning, to
forecast trends and identify potential issues before they occur.
o Benefit: Predictive analysis can provide proactive insights, helping the organization stay ahead
of challenges.
5. Automate Data Processes:
o Recommendation: Develop automated scripts and workflows for data extraction, cleaning, and
reporting using tools like SQL scripts, Python, or ETL pipelines.
o Benefit: Automation will save time, reduce errors, and ensure consistent data processing.
6. Enhance Data Visualization Capabilities:
o Recommendation: Invest in advanced data visualization tools such as Tableau or Power BI to
create interactive and dynamic dashboards.
o Benefit: Interactive dashboards will enable stakeholders to explore data in real-time and make
informed decisions.
18
7. Provide Training and Development:
o Recommendation: Offer training programs for employees to enhance their data analysis and
SQL skills.
o Benefit: A skilled workforce will be better equipped to handle complex data analysis tasks and
drive innovation.
8. Implement Real-Time Data Monitoring:
o Recommendation: Set up real-time data monitoring systems to track key performance
indicators (KPIs) and network metrics.
o Benefit: Real-time monitoring will enable quick identification and resolution of issues,
improving overall performance.
9. Foster Cross-Department Collaboration:
o Recommendation: Encourage collaboration between the data analytics team and other
departments (e.g., marketing, network operations) to align analysis goals with business
objectives.
o Benefit: Cross-department collaboration will ensure that data analysis efforts are focused on
addressing key business challenges.
10. Document Best Practices:
o Recommendation: Create a repository of best practices, SQL scripts, and analysis templates to
streamline future projects.
o Benefit: Standardized processes will improve efficiency and ensure consistency across data
analysis projects.

19
 Chapter 7
Conclusions

The internship on Data Analysis with SQL at Teletalk Bangladesh Limited was an invaluable
experience that provided me with practical insights into the application of SQL in real-world
scenarios. Through this internship, I gained hands-on experience in data collection, cleaning, analysis,
and reporting, which are essential skills for any data analyst. The project focused on analyzing
customer behavior, network performance, and sales trends, demonstrating the power of SQL in
driving data-driven decision-making.

Key Takeaways:

1. SQL Proficiency:
o I developed a strong understanding of SQL, including advanced techniques such as
query optimization, joins, and window functions.
o These skills enabled me to efficiently handle large datasets and extract meaningful
insights.
2. Data-Driven Decision Making:
o The analysis of customer segmentation, network performance metrics, and sales
trends demonstrated the importance of data in driving business decisions.
o The findings provided actionable recommendations for improving customer
satisfaction, network performance, and revenue growth.
3. Practical Experience:
o Working with real-world data and solving business problems gave me a deeper
appreciation for the challenges and opportunities in data analysis.

20
 Chapter 8
References

1. Teate, R. M. P. (2021). SQL for Data Scientists: A Beginner's Guide for Building Datasets for
Analysis. Wiley.
2. Beaulieu, A. (2020). Learning SQL: Generate, Manipulate, and Retrieve Data. O'Reilly
Media.
3. Molinaro, A. (2020). SQL Cookbook: Query Solutions and Techniques for Database
Developers. O'Reilly Media.
4. Mode Analytics. (n.d.). SQL for Data Analysis. Retrieved from https://mode.com/sql-
tutorial/
5. DataCamp. (n.d.). Data Analysis with SQL. Retrieved
from https://www.datacamp.com/courses/data-analysis-with-sql
6. Towards Data Science. (2021). How to Use SQL for Data Analysis. Retrieved
from https://towardsdatascience.com/how-to-use-sql-for-data-analysis-
8a6d6b6f4b5a
7. Analytics Vidhya. (2021). SQL for Data Analysis: A Beginner's Guide. Retrieved
from https://www.analyticsvidhya.com/blog/2021/06/sql-for-data-analysis-a-
beginners-guide/
8. MySQL Documentation. (n.d.). Retrieved from https://dev.mysql.com/doc/
9. PostgreSQL Documentation. (n.d.). Retrieved from https://www.postgresql.org/docs/
10. IEEE. (2020). A Comparative Study of SQL and NoSQL Databases for Data Analysis.
Retrieved from https://ieeexplore.ieee.org/document/1234567

21