| COURSE : CERTIFIED MIS REPORTING & AUTOMATION EXPERT - CMISRAE | |
|---|---|
| Course Overview | The Course will take you through a robust methodology for automating all your dashboards or reports.
The methodology will save you significant time in updating your routine reports. The Tool, when built will be fully autonomous requiring no Excel input from you; just dump your new data (transactions) into a designated folder and all your reports update like magic! This is not a Beginner Excel course, it assumes that students have a basic understanding of Excel especially as it relates to the topics listed below. Advance Excel Knowledge Entering Data into Excel Create and format Charts Pivot linking and auto reporting |
| Training Duration | Total Training Hours : 30 Hours Training Duration : 1 Week Total Training Days : 5 Working Days |
| Training Schedules | Weekdays (Sunday to Thursday) Regular Sessions : 6 Hrs Per day (9am to 2pm or 3.00pm to 9.00 pm) Food & refreshments Included WeekEnds (Friday & Saturday) Fast Track Sessions: 8 Hours per day (9am to 5pm) Food & refreshments Included |
| Certifications: | 1) Certificate from Laurels Training Institute, Attested by Knowledge & Human Development Authority (KHDA) government of Dubai, UAE OPTIONAL 2) Certificate from American Institute of Professional Studies (AIPS) from USA (After 15 Days of course Completion which will couriered to the attendees office address) |
| Tests | Yes |
| Learning Aids | Yes |
| Course Material | Hard & Soft Copies of Study Material |
| Language of Instruction | English |
| Instructor Helpline | Yes 1. Email 2. Social Media (For Emergency requirements) |
| Registration Requirements | 1. Passport Copy 2. Curriculum Vitae 3. Passport size photographs 4. Course Fee |
| Mode of Payment: | Cash / Cheque / Credit Card / Bank Transfer. |
| Eligibility Criteria (Who should attend this training) | All officers Analysts Admin MIS officers |
| Course Benefits | Understand the purpose of test automation save time Optimum utilization of time and resources Be able to identify the technical success factors of a test automation project Be able to identify the test automation requirements for the report Be able to evaluate and select the tools for the test automation Design for testability Understand how to create an environment to execute test automation Know the basics and advance automation skills Be familiar with data-driven test automation Be familiar with creating test automation framework Be familiar with automation maintenance / upgrade Be familiar with test automation reporting and metrics |
| Course Contents / Outline | Understand the purpose of test automation save time Optimum utilization of time and resources Be able to identify the technical success factors of a test automation project Be able to identify the test automation requirements for the report Be able to evaluate and select the tools for the test automation Design for testability Understand how to create an environment to execute test automation Know the basics and advance automation skills Be familiar with data-driven test automation Be familiar with creating test automation framework Be familiar with automation maintenance / upgrade Be familiar with test automation reporting and metrics" "The Report Automation Process The Report Automation Process Lab 06 - The Report Automation Process Automate your Report with the Controls Framework Create Report Headings & Labels with CONCATENATE Variance Analysis & Number Formatting Insert a Variance Analysis Chart Report Update with Power Query Visualising your Performance Reports Visualising your Performance Reports Lab 07 - Visualizing your Performance Reports Building a Rolling 12 Month Report Table Building a Rolling 12 Month Report Chart Build a Monthly Volatility Chart Insert Reference lines into a Chart MoM Change in Revenue vs Units Sold Chart MoM Change in Revenue vs Units Sold Report Building Blocks Report Building Blocks Lab 03 - Report Building Blocks Simple Report Template Identify your Report Criteria Automate with SUMIFS SUMIFS & the Date Criteria Hack Get Data with Power Query Get Data with Power Query Lab 02 - Get Data with Power Query Getting External Data into Excel Connect to Excel Files in a Folder Consolidate Excel Workbooks Transform Data Types Loading your Query to Excel" |