Excel Data Science With Power Bi & R

Power BI and R

What you'll learn

Learn to combine Power BI's visualization with R's advanced statistical analysis for powerful data insights and decision-making in any business environment.

Master Power BI's dashboards and R’s statistical techniques to analyze trends, forecast outcomes, and drive data-driven decisions for business success.

Discover how to integrate Power BI and R for dynamic visualizations, advanced analytics, and actionable insights to enhance your data analysis skills.

Elevate your data skills by learning how to merge Power BI’s visual tools with R’s statistical power to create impactful insights for business decisions.

Requirements

Basic Knowledge of Power BI: Familiarity with Power BI’s interface and basic data visualization techniques is recommended.

Understanding of R or Programming Basics: Prior experience with R or a general understanding of programming and data manipulation is helpful, but not mandatory.

Foundational Data Analysis Skills: Basic knowledge of data analysis concepts, such as working with datasets, interpreting data, and creating simple reports, is ideal.

Access to Power BI and R: Ensure you have access to both Power BI and R installed on your system to follow along with the exercises.

No prior advanced experience in Power BI or R is required, as the course will guide you through their integration step by step.

Description

Excel TV is excited to offer our premium course, Data Science with Power BI & R, led by renowned data science expert, Ryan Wade. This course is designed to equip professionals with the skills to harness the full potential of Power BI's advanced visualization features and the robust statistical computing power of R.In today’s data-driven world, businesses are increasingly relying on insights gleaned from vast datasets. Power BI, with its intuitive and dynamic dashboards, allows users to visualize and interpret data with ease. However, to gain deeper, more complex insights, R’s statistical computing capabilities are indispensable. This course brings together the best of both worlds, teaching you how to seamlessly integrate these two powerful tools for comprehensive data analysis.Under Ryan Wade's expert guidance, you’ll not only learn how to create compelling visual reports using Power BI, but also how to implement advanced statistical techniques with R to analyze trends, forecast outcomes, and derive actionable insights. Whether you’re a business analyst, data scientist, or aspiring professional, this course will empower you to take your data analysis skills to the next level.By the end of the course, you’ll have mastered the ability to generate impactful, data-driven insights that can drive strategic decision-making within any organization. Don’t miss this opportunity to elevate your data science expertise with Excel TV’s Data Science with Power BI & R course!

Overview

Section 1: Installing R

Lecture 1 Installing R – CRAN and MRAN

Lecture 2 Installing MRO – DEMO

Lecture 3 Setting Up The IDE

Lecture 4 Installing RTVS – DEMO

Lecture 5 RTVS Settings – DEMO

Lecture 6 Solutions and Projects in RTVS: DEMO

Lecture 7 Configuring Power BI To Work With R

Section 2: R Primer

Lecture 8 Important R Objects

Lecture 9 Atomic Vectors

Lecture 10 Augmented Vectors

Lecture 11 Lists

Lecture 12 Data Frames

Section 3: Reading Data

Lecture 13 Methods To Read Data Into Power BI Using R

Lecture 14 Readr and Readxl Packages To Bring Data Into PowerBI – DEMO

Lecture 15 PREVIEW: String Manipulations In R – DEMO

Lecture 16 RODBC Package To Bring data Into PowerBI DEMO

Lecture 17 Data.Table and Purr Packages To Combine Data Files DEMO

Lecture 18 Combining Multiple Files Using Magrittr Package DEMO

Lecture 19 Combining Excel Worksheets with ReadXL Package DEMO

Section 4: Dplyr

Lecture 20 Dplyr Introduction

Lecture 21 Inner And Left Joins

Lecture 22 Joining Data With Different Column Names DEMO

Lecture 23 Filtering Data in R DEMO

Lecture 24 Selecting Columns From A Data Frame in R DEMO

Lecture 25 Summarizing Data in R DEMO

Lecture 26 Mutate Verb to Create New Columns in R DEMO

Section 5: Making your data tidy for PowerBI

Lecture 27 TIDY Data Introduction

Lecture 28 TIDY Data DEMO

Section 6: Cleansing Data with StringR

Lecture 29 StringR Introduction

Lecture 30 Count Words Within A Text String DEMO

Lecture 31 Identify Valid Email Addresses DEMO

Lecture 32 Remove Numbers From A String DEMO

Lecture 33 Conditional Replacements DEMO

Lecture 0 Overview Of Functions In R

Lecture 0 ReScaling Data DEMO

Lecture 0 Calculate Distance Using A Custom Function

Lecture 0 Calculate Distance Using Geosphere Package DEMO

Lecture 0 Create Custom Visualizations with GGPLOT2

Lecture 0 Simple Chart Using GGPLOT2

Lecture 0 Additional Components

Lecture 0 Chart Scales and Labels in R – DEMO

Lecture 0 Available Graphing Options

Lecture 0 Why Facet Charts are Beneficial

Lecture 0 Create Facet Charts in R – DEMO

Lecture 0 Pretty Up Your Facet Charts In R – DEMO

Lecture 0 CRISP-DM

Lecture 0 Popular Algorithms

Lecture 0 Text Analytics

Lecture 0 Logistic Regression Model in R – DEMO

Lecture 0 Testing Your Model In PowerBI – DEMO

Lecture 0 Introduction To Demos

Lecture 0 Big Data with R and SQL Server – DEMO

Lecture 0 Scoring Data with SQL Server – DEMO

Lecture 0 Using Tools in SQL Server for Larger Data Sets

Lecture 0 Stored Procedure Using Native Scoring – DEMO

Lecture 0 Native Scoring – DEMO

Lecture 0 Cognitive Services DEMO

Business Analysts: Professionals looking to enhance their data analysis skills by integrating Power BI’s visualization with R’s advanced statistical capabilities.,Data Scientists: Individuals who want to leverage Power BI for interactive dashboards while applying R for deeper statistical analysis and forecasting.,Aspiring Data Professionals: Those seeking to enter the data science field, looking to gain practical knowledge in using both Power BI and R for comprehensive data insights.,Decision Makers and Strategists: Executives and managers who want to better understand how to drive data-driven decisions using advanced analytics and visualization.,Power BI Users: Current Power BI users interested in expanding their skills by incorporating R’s robust data manipulation and analysis techniques.