| COURSE : CERTIFIED BUSINESS DATA ANALYSIS AND MIS PROFESSIONAL CBDAP OR CMISP | |
|---|---|
| Course Overview | This training is going to focus on making you highly proficient in the use of Excel and Power BI for business data analysis, dashboard creation and reporting the professional way. And most of this would be achieved through lots of samples that will be similar to what you'll need at work. |
| 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) | ANALYSTS MIS OFFICERS & PROFESSIONALS ACCOUNTANTS |
| Course Benefits | Constantly being updated with new content and covering more areas of business data analysis. Be more productive and creative in their use of Microsoft Excel and Power BI for business and reporting Become proficient in using PivotTables for analyzing a large data Become proficient in the use of VLOOKUP, HLOOK, LOOKUP to get last item, INDEX and MATCH to make automated dynamic dashboards/reports. Learn how to use Sorting in more advanced ways: multi-level sorting, sorting left to right. Learn how to create professional and great looking charts in Excel and understand when to use a chart type. Learn creative uses of Excel and a lot of keyboard shortcuts that saves analysis time Be introduced to Excel, shown how to create a macro by clicking a button twice. Make a sample Excel user form that gets data from user and input into a table in Excel Learn Power BI and other new interesting business data analysis tools by Microsoft |
| Course Contents / Outline | Data Manipulation in Excel and setting the foundation. Charts Creative Excel Use and Tips Business Data Analysis Live Session on Advanced Filtering, Custom List, Data Validation, Charts... Power BI Excel VBA Difference Between Data Analysis, Business Analysis, BI and Big Data Demonstration of Pivot Table vs Power Pivot vs PowerMacros Master Macros System Automation Future development |