Назад в каталог
Курс от Coursera
courseraАнализ данных
Financial Data Analysis with Excel, Python and Power BI
Курс от CourseraО курсе
Clean, transform, analyze, and visualize financial data using Excel, Python, R, and Power BI. In this course, you’ll develop practical data analysis skills used by financial analysts to turn raw data into clear business insights. You’ll start by building structured financial budgets in Excel using advanced formulas and lookup tools. Then, you’ll clean and transform datasets using Python and apply statistical summaries in R. You’ll learn how to import and reshape structured and semi-structured data, including JSON files. Finally, you’ll design interactive Power BI dashboards, apply star-schema modeling, and implement row-level security for controlled reporting. What makes this course unique is its multi-tool approach. You won’t rely on one platform—you’ll learn how Excel, Python, R, and Power BI work together in real finance workflows. The course concludes with a portfolio-ready project where you transform retail financial data and build a performance dashboard for business reporting.
Навыки, которые вы освоите
Power BIData CleansingData TransformationExcel FormulasData Import/ExportPandas (Python Package)Dashboard CreationFinancial AnalysisMicrosoft ExcelData ManipulationData PreprocessingData AnalysisDescriptive StatisticsData Analysis SoftwareData QualityStatistical AnalysisFinancial DataStatistical ReportingData WranglingDashboard
Программа курса
15 модулей · 99 учебных материалов
01Excel: Build Financial Budgets Fast: Formula Foundations8 материалов
Formula Foundations — Getting It Right the First Time
Course OverviewDIALOGUEIntroduction and WelcomeВидеоOverall Formula Syntax StructureВидеоCommon Formula Mistakes and How to Fix ThemЧтениеУчитесь у экспертов
Professionals from the Industry
Преподаватель курса