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
- Overview of data analytics capabilities with Python in Power BI for government applications
- Overview of Python scripting functionality within Power BI
- Installation procedures for Python packages compatible with Power BI
- Establishing connections between Power BI and various data sources
Data Preparation with Python
- Loading and transforming data using Python scripts
- Data cleaning and preprocessing methodologies
- Managing missing data values with Python in Power BI
Data Visualization with Python
- Generating fundamental visualizations via Python
- Customizing charts and graphs through Python scripting
- Implementing interactive data visualizations using Python
Advanced Data Analysis with Python
- Introduction to the Pandas library for data manipulation
- Executing advanced analytical tasks using Python
- Aggregating and summarizing data through Python scripts
Time Series Analysis with Python
- Analyzing time series datasets in Power BI with Python
- Performing time-based calculations and forecasting using Python
- Visualizing trends within time series data
Statistical Analysis with Python
- Applying statistical analysis techniques using Python in Power BI
- Conducting hypothesis testing and A/B testing
- Integrating statistical findings into official reports for government use
Machine Learning Integration in Power BI
- Overview of machine learning capabilities in Power BI
- Developing and deploying machine learning models using Python
- Leveraging Python libraries such as scikit-learn for predictive analytics
Geospatial Analysis with Python
- Visualizing geographic data and creating maps
- Performing geospatial analysis using Python
- Developing custom maps and deriving location-based insights
Integration with External APIs and Web Data
- Retrieving data from external APIs via Python
- Web scraping and data extraction methods
- Incorporating external data sources into Power BI reports for government operations
Summary and Next Steps
Requirements
- Foundational knowledge of data analysis principles
- Proficiency with Microsoft Power BI tools
Target Audience
- Data analysts
- Information coordinators
- Information analysts
- Administrative support staff for information services
28 Hours
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
The basic structure of Power BI, its main functions, as well as some advanced functions
