About
The course is a comprehensive 3-month (12 weeks) program, with 5 weekly sessions lasting an hour each, totalling 60 hours. It covers both Power BI and Excel 365, providing a thorough understanding of data analysis, visualization, and business intelligence. Course Overview: The curriculum emphasizes Power BI and Excel proficiency, with key topics including: • Data Connectivity and Integration • Data Modeling and DAX (Data Analysis Expressions) • Data Visualization and Reporting • Advanced Analytics and Power BI Service Collaboration. Learning Outcomes: Participants will gain skills in using Power BI and Excel 365 to analyze and visualize data, perform advanced reporting, and utilize business intelligence tools. Prerequisites: Basic computer and internet knowledge is required, along with English proficiency. Familiarity with cloud-based apps and BI concepts is recommended but not essential. Certification: Upon successful completion of the course and capstone project, participants will receive a certification, enhancing career prospects and boosting resumes and LinkedIn profiles. Career Opportunities: The course opens doors to careers in administration, finance, marketing, project management, data analysis, and IT. Course Modules: 1. Microsoft Excel 365 (6 Weeks): Covers topics from beginner to advanced, such as: o Excel interface, cloud functionality, and collaboration o Basic and intermediate functions (e.g., SUM, VLOOKUP, Pivot Tables) o Data analysis tools and macros o Industry-specific applications 2. Power BI (6 Weeks): Focuses on leveraging Power BI for data analysis and reporting, including: o Introduction to Power BI tools (Desktop, Service, Mobile) o Connecting to various data sources (Excel, SQL, cloud services) o Data preparation, modelling, and DAX functions o Creating dashboards, visuals, and reports o Power BI Mobile and Service usage Projects and Assessments: Assessment will be done on the basis of 2 Real world (HR & Finance) project.