Overview
-
Find out how you can give end users the capability to explore AI and machine learning in Power BI.
Syllabus
-
Introduction
- The power of Power BI
- What you should know
- Overviewing AI and machine learning types
- Defining dimensionality
- Utilizing the Power BI ecosystem and Azure
- Configuring R in Power BI Desktop
- Introducing the course project
- Utilizing AI in the ETL framework
- Configuring parameters
- Analyzing dataset statistics and distributions
- Configuring separate error logs for existing datasets
- Running Vision algorithms
- Utilizing Text Analytics algorithms
- Leveraging AI and the star schema
- Adjusting DateTime fields for lags
- Configuring aggregations and dimensionality
- Filtering options
- Calculating DAX measures
- Challenge: Single variable
- Calculating rolling averages
- Utilizing binning to create histograms
- Summarizing statistics
- Splitting a category with small multiples
- Leveraging violin plots
- Solution: Single variable
- Visualizing relationships with scatter plots
- Accessing the Analytics pane
- Calculating correlations
- Visualizing correlations
- Adding clustering to existing visuals
- Calculating best fit line
- Utilizing the outlier detection visual
- Calculating outliers
- Contextualizing outliers
- Challenge: Multiple variables
- Solution: Multiple variables
- Determining key drivers with decomposition tree visual
- Leveraging the Q&A visual
- Discovering key insights with the Key Influencer visual
- Utilizing parameters to model what-if scenarios
- Challenge: AI visuals
- Solution: AI visuals
- Organizing time series analysis
- Adding forecasting from the Analytics pane
- Leveraging anomaly detection
- Utilizing ARIMA forecasting
- Incorporating seasonality through TBATS forecasting
- Analyzing predictions vs. actuals
- Challenge: Time series analysis
- Solution: Time series analysis
- Designing a consolidated view for sharing
- Uploading and sharing in the Power BI service
- Configuring quick insights
- Challenge: Shared view
- Solution: Shared view
- How to learn ML and AI in Power BI
