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.
Duration 28 hours
Course Outline
Introduction
- Overview of Data Analytics with Python in Power BI
- Foundations of Python scripting in Power BI
- Installation of Python packages for Power BI
- Establishing connections between Power BI and data sources
Data Preparation using Python
- Executing data loading and transformation via Python scripts
- Techniques for data cleaning and preprocessing
- Managing missing data with Python in Power BI
Data Visualisation using Python
- Generating fundamental visualisations with Python
- Modifying charts and graphs through Python scripts
- Implementing interactive data visualisations with Python
Advanced Data Analysis using Python
- Overview of Pandas for data manipulation
- Carrying out complex data analysis tasks with Python
- Aggregating and summarising data using Python scripts
Time Series Analysis using Python
- Examining time series data in Power BI with Python
- Performing time-based calculations and forecasts using Python
- Visualising trends in time series data
Statistical Analysis using Python
- Applying statistical analysis techniques using Python in Power BI
- Conducting hypothesis testing and A/B testing
- Integrating statistical results into reports
Machine Learning Integration in Power BI
- Introduction to machine learning within Power BI
- Developing and deploying machine learning models with Python
- Leveraging Python libraries such as scikit-learn for predictive analytics
Geospatial Analysis using Python
- Visualising geographic data and creating maps
- Executing 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
- Performing web scraping and data extraction
- Incorporating external data sources into Power BI reports
Conclusion and Further Learning
Requirements
- Fundamental grasp of data analysis principles
- Proficiency with Microsoft Power BI
Target Audience
- Data Analysts
- Information Coordinators
- Information Analysts
- Information Administrative Assistants
Testimonials (2)
How to use relationships in Power BIand the differences between columns and measurements
LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
Method of training.
