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 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
28 Hours
Testimonials (5)
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
The second day as Power Bi is a really friendly tool, and clearly Costas knows it very well, it was really good to learn about that tool. Unfortunately we have to see Power pivot in excel first which is really not user friendly but definitely a must see first in order to understand how Power Bi works, and it makes Power Bi look super cool :)
Anne-Cecile Jacquot - Ameropa
Course - Excel to Power BI
The second day was very interesting. It was a good training to see some possibilities within Power BI; but mostly you learn then while you work with Power BI. Fact is also that the training base has all access rights and everything works, but as soon as you try to connect to the live system, it does not work and this makes the knowledge transfer a bit difficult.
