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 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
Best practices for building a data model and best practices for visual elements in a report not covered in official materials. Many examples from projects.
Abc Xyz
Course - Microsoft Power BI Data Analyst (szkolenie autoryzowane PL-300)
Machine Translated
There are many fields and functions which I haven't recognized or I haven't been familiar with. It was really good that I could get such knowledge or skills for self-development and for database creation for company.