Share Description
In this course, you will :
- Demonstrates existing AI and machine learning capabilities that are directly available in Power BI functionalities.
- Helen Wall, a data analytics and business analysis expert, provides an overview of Power BI before delving into the steps to configure Power Query and your data model.
- Helen walks you through the process of analysing single variables and demonstrates the tools and techniques for measuring relationships between variables.
- shows you how to use visuals in Power BI to pose and answer questions, explains useful techniques for improving your time series data analysis, and walks you through some best practises for sharing your analysis.
Syllabus :
1. Configuring Power Query and the Data Model
- 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
2. Analyzing a Single Variable
- Configuring aggregations and dimensionality
- Filtering options
- Calculating DAX measures
- Calculating rolling averages
- Utilizing binning to create histograms
- Summarizing statistics
- Splitting a category with small multiples
- Leveraging violin plots
3. Measuring Relationships between Variables
- 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
4. Utilizing AI Visuals to Ask What-If Questions
- 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
5. Analyzing Time Series Data
- 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
6. Creating and Sharing Analysis
- Designing a consolidated view for sharing
- Uploading and sharing in the Power BI service
- Configuring quick insights
