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.
SMART Analytics