Power Up Excel Report with Power Pivot & Power Query
Webinar Topic: PowerUp Excel Report with Power Pivot & Power Query! Webinar Outline: This is a Webinar for Big Data Lovers! Power Pivot is an Excel feature that enables the import, manipulation, and analysis of big data without loss of speed/functionality. Power Pivot tables are pivot tables that allow the user to mix data from different tables, affording them powerful filter chaining when working on multiple tables. 1. Data Management in the PivotTable Report 2. Transform Cross-Tabulated Table in to “Proper Data Set” 3. Convert Over 1 Million Data from Simple Text Files to Power Pivot 4. Create a New …
Curriculum
Overview
Webinar Topic:
PowerUp Excel Report with Power Pivot & Power Query!
Webinar Outline:
This is a Webinar for Big Data Lovers! Power Pivot is an Excel feature that enables the import, manipulation, and analysis of big data without loss of speed/functionality. Power Pivot tables are pivot tables that allow the user to mix data from different tables, affording them powerful filter chaining when working on multiple tables.
1. Data Management in the PivotTable Report
2. Transform Cross-Tabulated Table in to “Proper Data Set”
3. Convert Over 1 Million Data from Simple Text Files to Power Pivot
4. Create a New Data Model Pivot Table
Note:
- All participants will get a digital certificate from Thriving Skills Limited.
- Must fill up your first name and last name before complete this webinar your for certificate.
- If you click on the “FINISH COURSE” button then the webinar will be finished, you will unable to complete the next lessons or parts of this webinar and a Certificate will be generated.
Webinar Instructor:
Md. Mehanazuddin Rupom
Md. Mehanazuddin Rupom is one of the very succinct architects in the field of Data Management and Presentation. He has been helping organizations with his expertise for more than 7 years. By profession, he is the Country Human Resources Manager of AMANN Bangladesh Limited, a German-based multination company in the Textile industry. He is also responsible as Employee Engagement Survey Lead – Asia from AMANN Group, Germany. He is also currently working as a Course Author of Thriving Skills. Prior to his current assignments, he worked with very reputed Local and Multinational companies like Lafarge Surma Cement Limited, Beximco Pharma, and British American Tobacco in various Marketing & Human Resources roles. In addition to his professional commitment to the organization, he works as a professional Trainer in the field of Microsoft Office and Human Capital Development since 2012.
His area of expertise includes Professional Reporting with MS Excel, Excel Analytics, Dashboard Preparation, Shop-floor Data Management with MS Excel, Office Productivity with MS Excel, Business reporting with Pivot Table, and Excel Charting, Power Presentation with MS PowerPoint, Training Need Analysis and Competency-based Talent Management.
Courses of this Instructor: