Excel TV

Academy course

Data Science with Power BI & R

57 lessons across 9 modules · Ryan Wade

Data Science with Power BI & R

What’s in this course

Installing R

  • Installing R – CRAN and MRAN
  • Installing MRO – DEMO
  • Setting Up The IDE
  • Installing RTVS – DEMO
  • RTVS Settings – DEMO
  • Solutions and Projects in RTVS: DEMO
  • Configuring Power BI To Work With R

R Primer

  • Important R Objects
  • Atomic Vectors
  • Augmented Vectors
  • Lists
  • Data Frames

Reading Data

  • Methods To Read Data Into Power BI Using R
  • Readr and Readxl Packages To Bring Data Into PowerBI – DEMO
  • PREVIEW: String Manipulations In R – DEMO
  • RODBC Package To Bring data Into PowerBI DEMO
  • Data.Table and Purr Packages To Combine Data Files DEMO
  • Combining Multiple Files Using Magrittr Package DEMO
  • Combining Excel Worksheets with ReadXL Package DEMO

Dplyr

  • Dplyr Introduction
  • Inner And Left Joins
  • Joining Data With Different Column Names DEMO
  • Filtering Data in R DEMO
  • Selecting Columns From A Data Frame in R DEMO
  • Summarizing Data in R DEMO
  • Mutate Verb to Create New Columns in R DEMO

Making your data tidy for PowerBI

  • TIDY Data Introduction
  • TIDY Data DEMO

Cleansing Data with StringR

  • StringR Introduction
  • Count Words Within A Text String DEMO
  • Identify Valid Email Addresses DEMO
  • Remove Numbers From A String DEMO
  • Conditional Replacements DEMO

Using Functions for Advanced Calculations

  • Overview Of Functions In R
  • ReScaling Data DEMO
  • Calculate Distance Using A Custom Function
  • Calculate Distance Using Geosphere Package DEMO

Data Visualizations

  • Create Custom Visualizations with GGPLOT2
  • Simple Chart Using GGPLOT2
  • Additional Components
  • Chart Scales and Labels in R – DEMO
  • Available Graphing Options
  • Why Facet Charts are Beneficial
  • Create Facet Charts in R – DEMO
  • Pretty Up Your Facet Charts In R – DEMO

Data Science

  • CRISP-DM
  • Popular Algorithms
  • Text Analytics
  • Introduction To Demos
  • Logistic Regression Model in R – DEMO
  • Testing Your Model In PowerBI – DEMO
  • Big Data with R and SQL Server – DEMO
  • Scoring Data with SQL Server – DEMO
  • Using Tools in SQL Server for Larger Data Sets
  • Stored Procedure Using Native Scoring – DEMO
  • Native Scoring – DEMO
  • Cognitive Services DEMO

Curriculum

Installing R 7 lessons
  1. 1. Installing R – CRAN and MRAN
  2. 2. Installing MRO – DEMO
  3. 3. Setting Up The IDE
  4. 4. Installing RTVS – DEMO
  5. 5. RTVS Settings – DEMO
  6. 6. Solutions and Projects in RTVS: DEMO
  7. 7. Configuring Power BI To Work With R
R Primer 5 lessons
  1. 1. Important R Objects
  2. 2. Atomic Vectors
  3. 3. Augmented Vectors
  4. 4. Lists
  5. 5. Data Frames
Reading Data 7 lessons
  1. 1. Methods To Read Data Into Power BI Using R
  2. 2. Readr and Readxl Packages To Bring Data Into PowerBI – DEMO
  3. 3. PREVIEW: String Manipulations In R – DEMO
  4. 4. RODBC Package To Bring data Into PowerBI DEMO
  5. 5. Data.Table and Purr Packages To Combine Data Files DEMO
  6. 6. Combining Multiple Files Using Magrittr Package DEMO
  7. 7. Combining Excel Worksheets with ReadXL Package DEMO
Dplyr 7 lessons
  1. 1. Dplyr Introduction
  2. 2. Inner And Left Joins
  3. 3. Joining Data With Different Column Names DEMO
  4. 4. Filtering Data in R DEMO
  5. 5. Selecting Columns From A Data Frame in R DEMO
  6. 6. Summarizing Data in R DEMO
  7. 7. Mutate Verb to Create New Columns in R DEMO
Making your data tidy for PowerBI 2 lessons
  1. 1. TIDY Data Introduction
  2. 2. TIDY Data DEMO
Cleansing Data with StringR 5 lessons
  1. 1. StringR Introduction
  2. 2. Count Words Within A Text String DEMO
  3. 3. Identify Valid Email Addresses DEMO
  4. 4. Remove Numbers From A String DEMO
  5. 5. Conditional Replacements DEMO
Using Functions for Advanced Calculations 4 lessons
  1. 1. Overview Of Functions In R
  2. 2. ReScaling Data DEMO
  3. 3. Calculate Distance Using A Custom Function
  4. 4. Calculate Distance Using Geosphere Package DEMO
Data Visualizations 8 lessons
  1. 1. Create Custom Visualizations with GGPLOT2
  2. 2. Simple Chart Using GGPLOT2
  3. 3. Additional Components
  4. 4. Chart Scales and Labels in R – DEMO
  5. 5. Available Graphing Options
  6. 6. Why Facet Charts are Beneficial
  7. 7. Create Facet Charts in R – DEMO
  8. 8. Pretty Up Your Facet Charts In R – DEMO
Data Science 12 lessons
  1. 1. CRISP-DM
  2. 2. Popular Algorithms
  3. 3. Text Analytics
  4. 4. Introduction To Demos
  5. 5. Logistic Regression Model in R – DEMO
  6. 6. Testing Your Model In PowerBI – DEMO
  7. 7. Big Data with R and SQL Server – DEMO
  8. 8. Scoring Data with SQL Server – DEMO
  9. 9. Using Tools in SQL Server for Larger Data Sets
  10. 10. Stored Procedure Using Native Scoring – DEMO
  11. 11. Native Scoring – DEMO
  12. 12. Cognitive Services DEMO
Member access: Lesson videos and downloadable resources require academy login. Existing members get the same access they had on academy.excel.tv.