Advanced Analytics in Power BI with R and Python: Ingesting, Transforming, Visualizing

Advanced Analytics in Power BI with R and Python: Ingesting, Transforming, Visualizing
PDF, ePUB
  • eBook:
    Advanced Analytics in Power BI with R and Python: Ingesting, Transforming, Visualizing
  • Author:
    Ryan Wade
  • Edition:
    1 edition
  • Categories:
  • Data:
    October 27, 2020
  • ISBN:
    1484258282
  • ISBN-13:
    9781484258286
  • Language:
    English
  • Pages:
    437 pages
  • Format:
    PDF, ePUB

Book Description
This easy-to-follow guide provides R and Python recipes to help you learn and apply the top languages in the field of data analytics to your work in Microsoft Power BI. Data analytics expert and author Ryan Wade shows you how to use R and Python to perform tasks that are extremely hard, if not impossible, to do using native Power BI tools. For example, you will learn to score Power BI data using custom data science models and powerful models from Microsoft Cognitive Services.
 
The R and Python languages are powerful complements to Power BI. They enable advanced data transformation techniques that are difficult to perform in Power BI in its default configuration but become easier by leveraging the capabilities of R and Python. If you are a business analyst, data analyst, or a data scientist who wants to push Power BI and transform it from being just a business intelligence tool into an advanced data analytics tool, then this is the book to help you do that.

 What You Will Learn
  • Create advanced data visualizations via R using the ggplot2 package
  • Ingest data using R and Python to overcome some limitations of Power Query
  • Apply machine learning models to your data using R and Python without the need of Power BI premium compacity
  • Incorporate advanced AI in Power BI without the need of Power BI premium compacity via Microsoft Cognitive Services, IBM Watson Natural Language Understanding, and pre-trained models in SQL Server Machine Learning Services
  • Perform advanced string manipulations not otherwise possible in Power BI using R and Python
Who This Book Is For
Power users, data analysts, and data scientists who want to go beyond Power BI’s built-in functionality to create advanced visualizations, transform data in ways not otherwise supported, and automate data ingestion from sources such as SQL Server and Excel in a more concise way

Content

Part I: Creating Custom Data Visualizations Using R
Chapter 1: The Grammar of Graphics
Chapter 2: Creating R Custom Visuals in Power BI Using ggplot2

Part II: Ingesting Data into the Power BI Data Model Using R and Python
Chapter 4: Reading Excel Files
Chapter 5: Reading SQL Server Data
Chapter 6: Reading Data into the Power BI Data Model via an API

Part III: Transforming Data Using R and Python
Chapter 7: Advanced String Manipulation and Pattern Matching
Chapter 8: Calculated Columns Using R and Python

Part IV: Machine Learning and AI in Power BI Using R and Python
Chapter 9: Applying Machine Learning and AI to Your Power BI Data Models
Chapter 10: Productionizing Data Science Models and Data Wrangling Scripts

Download Advanced Analytics in Power BI with R and Python: Ingesting, Transforming, Visualizing PDF or ePUB format free


Free sample

Download in .PDF format



Download in .ePUB format


Add comments
Прокомментировать
Введите код с картинки:*
Кликните на изображение чтобы обновить код, если он неразборчив
Copyright © 2019