Menu

Data Analytics for Business: AI-ML-PBI-SQL-R

Book

The book, Data Analytics for Business: AI-ML-PBI-SQL-R, offers current and essential topics relevant to analysts and managers. It introduces data analytics frameworks such as CRISP-DM and the KDD. The machine learning roadmap is provided, which is discussed in detail. This book is a hands-on introduction to tools such as Power BI, MySQL and RStudio. Power business intelligence (PBI) is used to create dashboards showing essential key performance indicators (KPIs) for businesses. Here, analytical concepts such as forecasts and key influencers are discussed. MySQL is one of the most popular database systems. The Structured Query Language (SQL) is used to extract, prepare and analyse data to gain business insights. The data science language R is used to gain an in-depth understanding of state-of-the-art machine learning concepts and algorithms. Additionally, the usage of ChatGPT within RStudio is demonstrated. Further, several artificial intelligence (AI) topics are introduced. The book even shows how to write a chess program.

Data

Here, we provide some data, which is used in the book and point to a collection of data sets.
  • Health Crisps - business data: BusinessData.xlsx (used in the Power BI crashcourse - see book above). The images are needed as well.
  • A collection of data sets from various sources.

Errata/Improvements

If you find any error (or improvement) in the book then please send me an email (page, section, error and suggested correction would be helpful). Below is a list of identified improvements.
Page Section Error / Needs update Correct / New
41 2.5.2 … but we know the order is   fixed. … but we know the order is   fixed, e.g. the InnoDB engine in MySQL reads rows using the insert index. So,   the default read order depends on the engine implementation and is generally   not guaranteed.
88 3.5 [Visualisationas >> …   >> Import a visual] from a file. [Visualizationas >> …   >> Import a visual from a file].
130 5.3 Figure 5.6 Figure 5.8
SMART Analytics