Data Analytics for Financial Management
Overview
- Skilled Data Analysts are one of the most sought-after professionals in the world.
- Financial Controllers & Decision makes need Timely ,Accurate & Reliable information.
- Up-Skill with latest data analytics & visualization techniques.
- Get hands on experience of developing KPIs, Reports & Dashboards, which are frequently used for Financial Management.
- Commerce Graduates ,PG, MBAs etc. who are perusing for career in MIS/ Data Analytics.
- Finance Controllers & Accounts executives- for upskilling their Data Analytics , Financial Reporting & Dashboarding skills .
Course contains 3 Modules & Real-life Projects:-
- MS Excel-
Basic Concepts– Formulas, Relative & Absolute References.
Most commonly used Functions- Financial, Data & Time, Logical, Lookup etc.
Importing or Connecting Data from various sources.
Data manipulation- Filter, Sort, Group etc.
Data Presentation & Visualization- Charts, Conditional Formatting, Pivot Tables.
Practical cases studies- Financial Modelling, Payroll Processing, Dashboards.
- Power BI-
Data Transformation- Basic Transformation, Date, Text, Numeric tools, grouping, conditional columns, Data cleaning, Merge & Append Queries.
Creating Data Models- Data (“Fact”) Tables vs. Lookup (“Dimension”) Tables.
Creating Power BI Table Relationships, Connecting Multiple Data Tables.
Adding Calculated Fields & understanding DAX.
Creating Interactive visuals & Dashboards.
AI tools like- Smart Narratives, Q&A Visuals, Key Influencers, Decomposition Tree.
Practical Projects.
- SQL-
How to extract data by writing SQL queries.
Understanding Normalization, Primary & Foreign Keys, Writing Nested Queries.
Practical Projects.
- Projects-
Cash Flow Analysis- Interactive & Drilldown Cashflow statement, Planning ,Budget Vs Actual
Profit & Loss Analysis-Interactive & Drilldown Income statement ,Ratios & Trends ,Budget Vs Actual.
Balance Sheet- Interactive & Drilldown Balance Sheet ,Ratios & Trends ,Budget Vs Actual.
- To get hands-on expertise in MIS reporting using MS Excel, Power BI or SQL
- To prepare interactive MIS dashboard for any organization.
- On successful completion, participants will receive a certificate from Acecom Skills Development.
-
Upload your Resume & Get Free benefit of our Job Assistance program.