Excel Data Science with Power BI & R

Focused View

6:55:15

0 View

1 - Installing R

1 -Installing R CRAN and MRAN.mp4

04:20

2 -Installing MRO DEMO.mp4

01:03

3 -Setting Up The IDE.mp4

00:39

4 -Installing RTVS DEMO.mp4

02:28

5 -RTVS Settings DEMO.mp4

09:28

6 -Solutions and Projects in RTVS DEMO.mp4

12:42

7 -Configuring Power BI To Work With R.mp4

00:45

2 - R Primer

1 -Important R Objects.mp4

00:26

2 -Atomic Vectors.mp4

10:29

3 -Augmented Vectors.mp4

05:58

4 -Lists.mp4

03:32

5 -Data Frames.mp4

08:44

3 - Reading Data

1 -Methods To Read Data Into Power BI Using R.mp4

02:11

2 -Readr and Readxl Packages To Bring Data Into PowerBI DEMO.mp4

12:39

3 -PREVIEW String Manipulations In R DEMO.mp4

05:15

4 -RODBC Package To Bring data Into PowerBI DEMO.mp4

09:55

5 -Data.Table and Purr Packages To Combine Data Files DEMO.mp4

09:34

6 -Combining Multiple Files Using Magrittr Package DEMO.mp4

14:29

7 -Combining Excel Worksheets with ReadXL Package DEMO.mp4

10:28

4 - Dplyr

1 -Dplyr Introduction.mp4

04:50

2 -Inner And Left Joins.mp4

08:35

3 -Joining Data With Different Column Names DEMO.mp4

02:08

4 -Filtering Data in R DEMO.mp4

06:04

5 -Selecting Columns From A Data Frame in R DEMO.mp4

10:05

6 -Summarizing Data in R DEMO.mp4

06:10

7 -Mutate Verb to Create New Columns in R DEMO.mp4

04:05

5 - Making your data tidy for PowerBI

1 -TIDY Data Introduction.mp4

02:58

2 -TIDY Data DEMO.mp4

07:17

6 - Cleansing Data with StringR

1 -StringR Introduction.mp4

03:32

2 -Count Words Within A Text String DEMO.mp4

08:58

3 -Identify Valid Email Addresses DEMO.mp4

13:55

4 -Remove Numbers From A String DEMO.mp4

11:45

5 -Conditional Replacements DEMO.mp4

07:13

6 -Overview Of Functions In R.mp4

02:33

7 -ReScaling Data DEMO.mp4

06:06

8 -Calculate Distance Using A Custom Function.mp4

05:36

9 -Calculate Distance Using Geosphere Package DEMO.mp4

06:17

10 -Create Custom Visualizations with GGPLOT2.mp4

02:26

11 -Simple Chart Using GGPLOT2.mp4

10:20

12 -Additional Components.mp4

01:15

13 -Chart Scales and Labels in R DEMO.mp4

07:13

14 -Available Graphing Options.mp4

03:01

15 -Why Facet Charts are Beneficial.mp4

03:40

16 -Create Facet Charts in R DEMO.mp4

05:32

17 -Pretty Up Your Facet Charts In R DEMO.mp4

03:59

18 -CRISP-DM.mp4

02:54

19 -Popular Algorithms.mp4

10:54

20 -Text Analytics.mp4

02:11

21 -Logistic Regression Model in R DEMO.mp4

36:29

22 -Testing Your Model In PowerBI DEMO.mp4

10:57

23 -Introduction To Demos.mp4

02:55

24 -Big Data with R and SQL Server DEMO.mp4

16:59

25 -Scoring Data with SQL Server DEMO.mp4

10:46

26 -Using Tools in SQL Server for Larger Data Sets.mp4

13:37

27 -Stored Procedure Using Native Scoring DEMO.mp4

01:41

28 -Native Scoring DEMO.mp4

10:37

29 -Cognitive Services DEMO.mp4

14:37

Description

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.

Who is this for?

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.

What You Need to Know?

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.

More details

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!
Who this course is for:
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.

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.