Fun with Data Analysis and BI

Fun with Data Analysis and BI teaches you how to turn raw data into actionable insights using business intelligence tools. It equips you with essential skills to make data-driven decisions and effectively communicate findings.

This book is designed to guide you through learning SQL from the ground up. Starting with installation and environment setup, it covers everything from building databases and creating tables to mastering SQL queries. Alongside theoretical concepts, you will engage in hands-on projects that demonstrate practical applications, including market analysis using Python to track stock trends and churn analysis to understand customer behavior. Each chapter concludes with MCQs to test your knowledge. The book also introduces you to Tableau, a powerful tool for creating visualizations without writing code, with step-by-step instructions on how to use it for your data projects.

By the end of this book, you will be equipped with the skills to extract valuable insights from complex datasets, visualize data in compelling ways, and make data-driven decisions that positively impact your organization.

KEY FEATURES

* In-depth coverage of SQL, Python, ML, and Tableau for all skill levels.
* Hands-on projects to transform raw information into valuable data insights.
* Practical examples and end-to-end solutions for mastering data science concepts.

WHAT YOU WILL LEARN

* Install and set up SQL environments, create databases, develop tables, and write effective SQL queries.
* Use Python to analyze stock market data, create clusters, and support data-driven decisions.
* Apply ML to understand consumer behavior, predict churn, and improve retention.
* Design striking data visuals with Tableau, enhancing data presentation skills without coding.
* Gain hands-on experience by working on complete projects, from data preparation to final output.

WHO THIS BOOK IS FOR

Whether you are a business analyst, data scientist, or aspiring data professional, this book provides the essential knowledge and practical guidance to excel in the field of data analysis.

1. E-Ticket Booking
2. Creating Games on Python
3. Introduction to Sentiment Analysis
4. Sentiment Analysis on E-Commerce: Product Reviews
5. Sentiment Analysis on X
6. Stroke Prediction
7. Movie Review Sentiment Analysis
8. Stock Market Data Analysis
9. Customer Data Analysis
10. Analyzing Sports Data in Tableau
11. Office Supplies Dashboard Using Tableau
12. COVID Dashboard Using Tableau

Nitin Sethi is a data analytics leader, expert in machine learning, NLP, and business intelligence, and a mentor and educator.

With over 17 years of experience in data science, analytics, and strategy planning across various industries, he specializes in transforming complex data into actionable insights that drive strategic business decisions. His expertise spans a wide array of tools and technologies, including Python, SQL, Tableau, Alteryx, and advanced machine learning techniques such as deep learning, and supervised and unsupervised learning.

In his current role as a Data Analytics Lead at Rio Tinto, he leads a global team focused on reporting, analytics, automation, and tool development. He has successfully developed and deployed large-scale machine learning models using AWS services and Google Cloud, applying advanced experimentation techniques to validate business impact.
Previously, he spent a decade at McKinsey & Co., where he honed his skills in managing Data Analytics, conducting sentiment analysis using deep learning, and generating key performance indicators for diverse geographies and demographics.

Beyond his professional work, he has over a decade of experience teaching data analytics, machine learning, and artificial intelligence, with teaching roles at prestigious institutions like UT Austin and MIT. He is passionate about mentoring the next generation of data professionals and fostering a culture of data-driven decision-making.