Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

AI Training – Module 1: Power BI for Data Scientists, Lecture notes of Machine Learning

How to do forecasting in Power BI report and Power Query. 1.8: Pre-build Advanced Analytics Visualization. Microsoft provides lots of interesting advanced ...

Typology: Lecture notes

2021/2022

Uploaded on 09/27/2022

slupdoggy
slupdoggy 🇬🇧

3.4

(5)

215 documents

1 / 6

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
AI Training Module 1:
Power BI for Data Scientists
This training is designed for people who want to do Machine Learning (ML) inside Power BI. In
this training, you will learn different ways to use R languages for the aim of machine learning,
visualization, data cleaning in Power BI.
In this training, you will learn some main concepts of machine learning. You will learn some
basics of R language and How to use it in Power BI visualization, Power Query (data wrangler
part of Power BI), and how to use it for creating custom visual. Also, the training will cover
some of the main algorithms for machine learning such as Predictive analytics (Decision-Tree,
Decision Forest, KNN, SVM), Descriptive analysis (Clustering, Market Basket Analysis) and
Forecasting (Time Series). Finally the pre-build advanced analytics visual in Power BI
Marketplace will be explained and how to use them will be clarified.
pf3
pf4
pf5

Partial preview of the text

Download AI Training – Module 1: Power BI for Data Scientists and more Lecture notes Machine Learning in PDF only on Docsity!

AI Training – Module 1 :

Power BI for Data Scientists

This training is designed for people who want to do Machine Learning (ML) inside Power BI. In this training, you will learn different ways to use R languages for the aim of machine learning, visualization, data cleaning in Power BI. In this training, you will learn some main concepts of machine learning. You will learn some basics of R language and How to use it in Power BI visualization, Power Query (data wrangler part of Power BI), and how to use it for creating custom visual. Also, the training will cover some of the main algorithms for machine learning such as Predictive analytics (Decision-Tree, Decision Forest, KNN, SVM), Descriptive analysis (Clustering, Market Basket Analysis) and Forecasting (Time Series). Finally the pre-build advanced analytics visual in Power BI Marketplace will be explained and how to use them will be clarified.

At the end of this training, you will able to write R code in Power BI report and Power Query, create custom visual with the help of JSON codes and R scripts, The training includes but not limited to topics below: 1.1: Introduction to R R is a statistical language that has been used for many years for the aim of machine learning, statistical analytics, data wrangling, data visualization and so forth. There is a possibility to embed R codes inside Power BI to create more smart applications. In this module, we will go through the basics of R language and introduce some of the main R functions and commands such as statistical summary, package concepts, read data from SQL Server, Azure and so forth, visualization command, loop, and so forth. You will see some demos and introduction about:

  • Introduction to R Language: What is R?
  • RStudio; The First Experience
    • Install Rstudio
    • RStudio Environment
  • R basic Command
    • Data Structure such as Data Frame, Vector, and Lists
    • Import Data from the local machine, SQL Server, Azure Data Lake and so forth.
    • Check the Statistical Summary of data
    • Check the Structure Summary of Data
    • Use existing Package and how to Install New Packages
    • Create Basic Chart such as Histogram and Box Plot for better Understanding data
    • And some other useful commands 1.2: Introduction to Machine Learning In this section, some introduction to Machine learning will be provided. The audience will learn what Artificial Intelligence is, what is Machine Learning, who is Data Scientists, who is data Analyst, and What is Deep learning. Also, some explanations on what descriptive and predictive analytics are will be provided. In this module audience will learn:
  • What is Descriptive Analytics
  • What is Predictive Analytics
  • What is Forecasting
  • What Languages exist for Machine Learning and what is the main difference 1.3: Use R in Power BI Report for Visualization

The content that you will learn in this module includes but not limited to;

  • What is predictive analytics and what algorithms we use for predictive analytics
  • Main concepts for the decision tree, SVM, regression, and KNN will be provided
  • How to use decision tree algorithms (with related R codes) for the aim of classification in Power Query will be explained
  • How to use regression algorithm for predicting a value in power Query will be shown
  • How to parametrize the algorithm in Power Query for future use will be explained 1.6: Descriptive Analytics in Power BI In this module, a brief explanation of what is descriptive analytics, what is clustering, what is market basket analytics will be provided. Audience will learn
  • Basic concepts for clustering and market basket analytics
  • How to write R scripts and what function has been used
  • How to do Clustering in Power BI visualization and Power Query 1.7: Time series with R in Power BI Forecasting is a popular and useful trend in many industries. Time series is an algorithm that has been used for forecasting the trend, pattern and future value for their sales, profit and so forth. In this module below item will be presented
  • What is Time series and what are the main concepts behind it
  • How to write R scripts for time series decomposition, forecasting using exponential smoothing and so forth.
  • How to do forecasting in Power BI report and Power Query 1.8: Pre-build Advanced Analytics Visualization Microsoft provides lots of interesting advanced analytics chart in the marketplace for Power BI users. This charts able end user to use them for analytics without writing any R scripts.
  • How to access the Power BI advanced analytics visualization in Marketplace
  • What is decision tree visualization and how to use it
  • What is time series visualizations?
  • How to use clustering and correlation analytics visualization 1.9: Create Custom Visual with R and JSON Scripts

There is a possibility to expand the visualization in Power BI with creating custom visual. These visuals have some difference from what we have in section 1-3. These custom visuals can be shared with others easily without disclosing the code behind them. These visualizations can be put in a list of visual for other people in the company. In this section.

  • How to create custom visual with R
  • How to use the Power BI template for it
  • How to create a proper setting and so forth Instructor: Dr Leila Etaati Our trainer is the world well-known name in the Microsoft BI field. Reza Rad is Microsoft Regional Director, a speaker in world’s best and biggest Microsoft Data Platform, BI and Power BI conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Microsoft Data Insight Summit, PASS Summits, PASS Rallys, SQLBits, TechEds, and so on. He is the author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. Reza is the founder of RADACAD and a consultant for more than decades. He is also a Microsoft Certified Trainer for years. He is Microsoft Data Platform MVP (Most Valuable Professional) focused on BI and Data Analysis; Microsoft has awarded him MVP because of his dedication and expertise in Microsoft BI technologies from 2011 till now (more than eight years). He is the author of Power BI book from Rookie to Rock Star. Next available course: 24 th^ – 27 th^ February 2020 Live online instructor-led sessions will be online through Microsoft Teams with full audio/video and screen sharing experience with you. You can ask any questions and get all the answers.