Business Intelligence Toolkit Overview - Microsoft Power BI and R

Explore an overview of the Business Intelligence toolkit, focusing on Microsoft Power BI and R in this hour-long conference talk from PASS Data Community Summit. Gain insights into the importance of people and processes in BI, alongside technical implementation. Delve into data visualization theory and scientific evidence, examining the Power BI suite of tools and R's analytical capabilities. Learn about various technologies in an end-to-end environment, including R, Power Pivot, Power Query, Power View, Power Map, and Excel. Discover how to create effective dashboards using Power BI tools and Excel. Acquire a broad understanding of data visualization, underpinned by cognitive psychology theory, and see its practical application in Microsoft Power BI functionality.

Introduction
Questions
PASS Summit
Speaker Introduction
Microsoft Data Analysts Toolkit
Correlation
spurious correlation
drowning in data
stages of data analysis
data types
R vs Power BI
Why use R
Strategy for using statistics
Rejecting the null hypothesis
Data visualization
Harmony and balance
Presentation dashboards
Visualisation
Chart Templates
Data Analyst Demo
Our Studio Overview
Examples
Using Charts
Visualization