Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
- Survey of Data Analytics with Python in Power BI
- Overview of Python scripting within Power BI
- Installation of necessary Python packages for Power BI
- Establishing connections between Power BI and various data sources
Data Preparation with Python
- Loading and transforming data via Python scripts
- Techniques for data cleaning and preprocessing
- Managing missing data using Python in Power BI
Data Visualization with Python
- Constructing fundamental visualizations with Python
- Customizing charts and graphs through Python scripts
- Implementing interactive data visualizations with Python
Advanced Data Analysis with Python
- Introduction to Pandas for data manipulation
- Executing complex data analysis tasks using Python
- Aggregating and summarizing data with Python scripts
Time Series Analysis with Python
- Analyzing time series data in Power BI with Python
- Performing time-based calculations and forecasting using Python
- Visualizing trends in time series data
Statistical Analysis with Python
- Statistical analysis methods utilizing Python in Power BI
- Hypothesis testing and A/B testing
- Incorporating statistical outcomes into reports
Machine Learning Integration in Power BI
- Introduction to machine learning capabilities in Power BI
- Building and deploying machine learning models with Python
- Utilizing Python libraries such as scikit-learn for predictive analytics
Geospatial Analysis with Python
- Visualizing and mapping geographic data
- Conducting geospatial analysis using Python
- Generating custom maps and location-based insights
Integration with External APIs and Web Data
- Retrieving data from external APIs using Python
- Web scraping and data extraction
- Incorporating external data sources into Power BI reports
Summary and Next Steps
Requirements
- Fundamental understanding of data analysis principles
- Proficiency in using Microsoft Power BI
Target Audience
- Data analysts
- Information coordinators
- Information analysts
- Administrative information assistants
28 Hours
Testimonials (2)
Method of training.
Ineshia Bilankulu - National Transmission Company South Africa
Course - Power BI: Basics to Advanced
- Building dashboards - Learning the counts and SUMs and SWITCH -
