Data Science with Power BI & R

Excel Courses - The Excel.TV Academy
Data Science with Power BI & R

ONLY FOR MEMBERS

Advanced

Video

Power BI

57 Lessons

0% Not started

Ready?

Data Science with Power BI & R

Installing R

7 Lessons

ONLY FOR MEMBERS

Installing R – CRAN and MRAN

ONLY FOR MEMBERS

Installing MRO – DEMO

ONLY FOR MEMBERS

Setting Up The IDE

ONLY FOR MEMBERS

Installing RTVS – DEMO

ONLY FOR MEMBERS

RTVS Settings – DEMO

ONLY FOR MEMBERS

Solutions and Projects in RTVS: DEMO

ONLY FOR MEMBERS

Configuring Power BI To Work With R

R Primer

5 Lessons

ONLY FOR MEMBERS

Important R Objects

ONLY FOR MEMBERS

Atomic Vectors

ONLY FOR MEMBERS

Augmented Vectors

ONLY FOR MEMBERS

Lists

ONLY FOR MEMBERS

Data Frames

Reading Data

7 Lessons

ONLY FOR MEMBERS

Methods To Read Data Into Power BI Using R

ONLY FOR MEMBERS

Readr and Readxl Packages To Bring Data Into PowerBI – DEMO

ONLY FOR MEMBERS

PREVIEW: String Manipulations In R – DEMO

ONLY FOR MEMBERS

RODBC Package To Bring data Into PowerBI DEMO

ONLY FOR MEMBERS

Data.Table and Purr Packages To Combine Data Files DEMO

ONLY FOR MEMBERS

Combining Multiple Files Using Magrittr Package DEMO

ONLY FOR MEMBERS

Combining Excel Worksheets with ReadXL Package DEMO

Dplyr

7 Lessons

ONLY FOR MEMBERS

Dplyr Introduction

ONLY FOR MEMBERS

Inner And Left Joins

ONLY FOR MEMBERS

Joining Data With Different Column Names DEMO

ONLY FOR MEMBERS

Filtering Data in R DEMO

ONLY FOR MEMBERS

Selecting Columns From A Data Frame in R DEMO

ONLY FOR MEMBERS

Summarizing Data in R DEMO

ONLY FOR MEMBERS

Mutate Verb to Create New Columns in R DEMO

Making your data tidy for PowerBI

2 Lessons

ONLY FOR MEMBERS

TIDY Data Introduction

ONLY FOR MEMBERS

TIDY Data DEMO

Cleansing Data with StringR

5 Lessons

ONLY FOR MEMBERS

StringR Introduction

ONLY FOR MEMBERS

Count Words Within A Text String DEMO

ONLY FOR MEMBERS

Identify Valid Email Addresses DEMO

ONLY FOR MEMBERS

Remove Numbers From A String DEMO

ONLY FOR MEMBERS

Conditional Replacements DEMO

Using Functions for Advanced Calculations

4 Lessons

ONLY FOR MEMBERS

Overview Of Functions In R

ONLY FOR MEMBERS

ReScaling Data DEMO

ONLY FOR MEMBERS

Calculate Distance Using A Custom Function

ONLY FOR MEMBERS

Calculate Distance Using Geosphere Package DEMO

Data Visualizations

8 Lessons

ONLY FOR MEMBERS

Create Custom Visualizations with GGPLOT2

ONLY FOR MEMBERS

Simple Chart Using GGPLOT2

ONLY FOR MEMBERS

Additional Components

ONLY FOR MEMBERS

Chart Scales and Labels in R – DEMO

ONLY FOR MEMBERS

Available Graphing Options

ONLY FOR MEMBERS

Why Facet Charts are Beneficial

ONLY FOR MEMBERS

Create Facet Charts in R – DEMO

ONLY FOR MEMBERS

Pretty Up Your Facet Charts In R – DEMO

Data Science

12 Lessons

ONLY FOR MEMBERS

CRISP-DM

ONLY FOR MEMBERS

Popular Algorithms

ONLY FOR MEMBERS

Text Analytics

ONLY FOR MEMBERS

Introduction To Demos

ONLY FOR MEMBERS

Logistic Regression Model in R – DEMO

ONLY FOR MEMBERS

Testing Your Model In PowerBI – DEMO

ONLY FOR MEMBERS

Big Data with R and SQL Server – DEMO

ONLY FOR MEMBERS

Scoring Data with SQL Server – DEMO

ONLY FOR MEMBERS

Using Tools in SQL Server for Larger Data Sets

ONLY FOR MEMBERS

Stored Procedure Using Native Scoring – DEMO

ONLY FOR MEMBERS

Native Scoring – DEMO

ONLY FOR MEMBERS

Cognitive Services DEMO

Follow

About the teacher

Ryan Wade

Ryan is a Power BI & R consultant that regularly speaks at Analytics conferences. He is the author of the book 'Advanced Analytics in Power BI with R & Python: Ingesting, Transforming, Visualizing'