Course
Online
DATA ANALYSIS FROM SCRATCH WITH EXCEL, POWER BI 1, AND ARTIFICIAL INTELLIGENCE
Mechatronics
Program Summary
Master the most demanded tools in business data analysis. This comprehensive course will take you from the basics of advanced Excel to the creation of interactive dashboards with Power BI, incorporating Artificial Intelligence techniques for data-driven decision making.
What will you learn?
Mastering advanced formulas and pivot tables in Excel
Designing and publishing interactive dashboards in Power BI
Mastering advanced formulas and pivot tables in Excel
Designing and publishing interactive dashboards in Power BI
Mastering advanced formulas and pivot tables in Excel
Designing and publishing interactive dashboards in Power BI
Curriculum
Advanced Excel
Matrix and LAMBDA formulas
Advanced pivot tables
Power Query for ETL
Macros and basic VBA
Power BI Fundamental
Data modeling
DAX and calculated measurements
Customized visualizations
Publishing in Power BI Service
Requirements
- Basic knowledge of Excel (intermediate level)
- Computer with Windows 10 or higher
- Stable internet connection for synchronous classes
- Microsoft account (educational license will be provided)
Aimed at
- Administration and Finance Professionals
- Junior and mid-level data analysts
- Entrepreneurs looking to make data-driven decisions
- Students in the last semesters of related careers