Course Outline
Introduction
- Overview of Data Analytics with Python in Power BI
- Introduction to Python scripting in Power BI
- Installing Python packages for Power BI
- Connecting Power BI to data sources
Data Preparation with Python
- Data loading and transformation using Python scripts
- Data cleaning and preprocessing techniques
- Handling missing data with Python in Power BI
Data Visualization with Python
- Creating basic visualizations with Python
- Customizing charts and graphs using Python scripts
- Interactive data visualization with Python
Advanced Data Analysis with Python
- Introduction to Pandas for data manipulation
- Performing advanced 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
- Time-based calculations and forecasting using Python
- Visualizing time series data trends
Statistical Analysis with Python
- Statistical analysis techniques using Python in Power BI
- Hypothesis testing and A/B testing
- Incorporating statistical results into reports
Machine Learning Integration in Power BI
- Introduction to machine learning in Power BI
- Building and deploying machine learning models with Python
- Using Python libraries like scikit-learn for predictive analytics
Geospatial Analysis with Python
- Geographic data visualization and mapping
- Performing geospatial analysis using Python
- Creating custom maps and location-based insights
Integration with External APIs and Web Data
- Fetching data from external APIs using Python
- Web scraping and data extraction
- Incorporating external data sources into Power BI reports
Summary and Next Steps
Requirements
- Basic understanding of data analysis concepts
- Familiarity with Microsoft Power BI
Audience
- Data analyst
- Information coordinator
- Information analyst
- Information administrative assistant
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €9120 online delivery, based on a group of 2 delegates, €2880 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (1)
- Building dashboards - Learning the counts and SUMs and SWITCH -
