R For Power BI Users - Part 1
Amplify your Power BI visualizations with R's comprehensive statistical analysis and graphics language. R as a programming language provides for an in-depth statistical computing and advanced data visualization. These functionalities, when combined with Power BI, can significantly enhance your data analysis and reporting visuals.
Here's What You'll Get
With The Course
Over 3 hours of intensive training videos
Five resource pack
Amplify Your Power BI Visualizations with R
- Provides in-depth statistical computing and advanced data visualization.
- Teaches you how to integrate R in Power BI and use its functions appropriately.
Details Of What You Will Learn
During This Course
- Discover - the use cases of R to understand when to use it in Power BI
- Complement - Power BI with R
- Create - statistical analysis and data visualizations
This Course Module is Tailored for:
Data Analysts
Reporting Managers
Excel Users
Participants of this module must be familiar with variable types, descriptive statistics, inferential statistics.
LEARN HOW TO
Utilize the key features within the R for
Power BI Users
- Familiarity with variable types
- Descriptive statistics
- Inferential statistics
- No prior coding knowledge assumed
Course Curriculum
1. Introduction to R in Power BI
- Introduction to R in Power BI - Resource Pack
- Welcome and Prerequisites
- Why R in Power BI?
- Download R and Rstudio
- First steps in RStudio
- Configure R with Power BI
- How R talks with Power BI
2. Fundamentals of R Programming
- Fundamentals of R Programming - Resource Pack
- Working with objects
- Object classes
- Working with vectors
- Working with data frames
- Working with factors
- Working with packages
- Locating helpful packages
- Column operations in dplyr
- Row operations in dplyr
- Pipe operations in dplyr
3. Data Visualization in R
- Data Visualization in R - Resource Pack
- Intro to ggplot2
- Plotting ggplot2 with esquisse
- Bivariate visualizations
- Labels, colors and theme
4. Capstone: R Enhanced Power BI
- Capstone: R Enhanced Power BI - Resource Pack
- Capstone introduction
- Building the histogram
- Building the t-test
- Building the Power BI report
5. Conclusion and Next Steps
- Conclusion and Next Steps - Resource Pack
- Troubleshooting R
- Making a reprex
- Learning resources
- Thank you and what's next
Your Instructor
George Mount
- Over ten years of analytics experience ranging from retail to healthcare.
- Author of the O'Reilly book Advancing into Analytics: From Excel to Python and R
- Manages a popular data analytics blog at [Stringfest Analytics](http://stringfestanalytics.com/blog/)
- Focuses on statistical programming and general analytics literacy
Frequently Asked Questions
- How long do I have access to the course? You have access to this course as long as you have Enterprise DNA Membership Subscription.
- Can I purchase a single course instead of the full Enterprise DNA membership? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full membership here.
- Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA Membership or CoE access to receive support.
- What if I need to train my team? We recommend exploring Enterprise DNA Center of Excellence platform. To learn more, see here.
Get full access to unparalleled training
& skill-building resourcess
For Individuals
Enterprise DNA
Membership
Empowering the most valuable Power BI users to expand their analytical thinking and insight generation possibilities
For Teams
Enterprise DNA
Center of Excellence