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
Testimonials (5)
The content was tough but that extra effort I had to put helped me remember and understand power BI better.
Melvin - TLI Group
Course - Power BI DAX Fundamentals
The fact of having more practical exercises using more similar data to what we use in our projects (satellite images in raster format)
Matthieu - CS Group
Course - Scaling Data Analysis with Python and Dask
Discussing about our issues
Rr Dwi Putri Periska Sari - PT. Becton Dickinson Indonesia
Course - Power BI for Developers
Very good preparation and expertise of a trainer, perfect communication in English. The course was practical (exercises + sharing examples of use cases)
Monika - Procter & Gamble Polska Sp. z o.o.
Course - Developing APIs with Python and FastAPI
What I liked the most was the coach's openness regarding the change in content as well as the approach that was previously prepared to accommodate our real needs