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)
Kontennya sulit tetapi usaha ekstra yang harus saya lakukan membantu saya mengingat dan memahami Power BI dengan lebih baik.
Melvin - TLI Group
Course - Power BI DAX Fundamentals
Machine Translated
Fakta memiliki lebih banyak latihan praktis menggunakan data yang lebih mirip dengan apa yang kami gunakan dalam proyek kami (gambar satelit dalam format raster)
Matthieu - CS Group
Course - Scaling Data Analysis with Python and Dask
Machine Translated
Materinya runut dan mencakup hal2 umum terkait powerbi untuk pemula
Angel - 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