Automated Data Analysis With Power Query

User Avatar
Md. Mehanazuddin Rupom

Please fill following information

Automaed Data anaylsis

The business world is transforming rapidly and to cope up with the rapid transformation, we need to be super fast. The more you grow your business, the more information you have. Processing these huge amount information and transforming those to meaningful insights requires Powerful Analysis tool. Microsoft Excel has a built-in Business Intelligence Tool that is dynamic, powerful and automated. Learning power Query will not only save your time but enhance the pace of your business growth by providing intelligent insights transformed from business data. If you want to automate your business reporting, this is the right training for you.

Outline:

Power Query & Dashboard

  • Understand the Enormous Ability of Power Query to Handle Big Data
  • Things that would Help to Efficiently Use Power Query
  • Effective Power Query Transformations
  • Powerful Power Query Transformations
  • Date & Time Transformations
  • Custom Column & Understand Basic M Code Manipulation
  • Merge Options (Different Joints in PQ)
  • Conduct a Demo Project

Learning Outcome:

  • Learn the Management of Big Data
  • Transform your Database in Power Query
  • Automate Complex Calculations
  • Connect multiple files / worksheets and Analyze large data with Power Query
  • Work with Conditional Column, Dynamic Data Grouping and Unpivot Data
  • Data & Time Transformations
  • Connect Data from Web and Update in Real-time
  • Create Fully Automated Dashboard / Business Intelligence Report

Target Audience:

  • Senior Leaders of an Organization
  • Managers maintaining a team
  • Specialists working with Data and Analytics
  • Business Persons
  • Students who has keen interest in Data Analysis & Presentation

Training Deliverables:

  • Exercise Files for practice
  • Full Video recording of the training
  • Certificate of Participation

Pre-requisites to Participate:

  • Should have Basic knowledge about Excel.
  • Use Microsoft Office 2016 or higher. Office 365 is best suited.

Course Information

  • Reg. Ends 21 April, 2022
  • Start Date 22 April, 2022
  • End Date 23 April, 2022
  • Class Schedule 7:00 PM To 10:00 PM
  • Total Hours 6 Hours
  • Venue Title Online Live Training
  • Venue Address www.sudoksho.com/class-room
author avatar
Md. Mehanazuddin Rupom

Microsoft Certified Excel Trainer

    Md. Mehanazuddin Rupom is a seasoned HR Professional who possesses expertise of handling both local and international HR Projects in his 10+ years of professional journey. He is also Microsoft Certified Trainer, Microsoft Office Specialist – Excel Expert and Certified Microsoft Innovative Educator.

    He currently leads the HR & Administration functions of Bangladesh unit for one of the top multinational international sewing thread dyeing & finishing company named AMANN Group headquartered in Germany. He joined AMANN in August 2015 and then on contributed significantly to develop a sustainable business for AMANN in Bangladesh with the management of HR & Admin activities. For his outstanding contribution for setting up the HR & Admin functions in Bangladesh, company has awarded him with the responsibilities of New HR Projects in Asia and also made the Employee Engagement Survey Project Lead – Asia back in 2018. Prior to AMANN, Rupom worked in a HRBP Role for Manufacturing Team of Lafarge Surma Cement Limited that was a French Multinational Cement Manufacturing Company. He was also key member of Lafarge’s Asian Technical Development Team. Before Lafarge, he was with one of the biggest LLC’s in Bangladesh named Beximco Pharma. He started his HR career for this company back in 2011. However, he stepped into the professional world with British American Tobacco back in 2010 when he was recruited in there Trade Marketing & Distribution – TM&D team.

    Apart from his professional commitment, he also conducts training on Microsoft Excel & PowerPoint in both online & offline form 2012. He has also established himself as a key profile internationally in the field of Microsoft Excel. He also conducted several trainings on HR & Management Skills topics in the organizations where he had worked. His key interest areas in this trades are Team Building, Communication Skills, Business Etiquettes, Talent Management, Performance Management, Training & Development and Organization Development.

    During the Corona Pandemic that has started to expand from April 2020 in Bangladesh till now, he has conducted 50+ webinars in Excel with over 2,500 students from around the world.

    Book Your Seat

      Book Your Seat

      Please fill following information

      You May Like

      Leave A Reply

      Your email address will not be published. Required fields are marked *

      16 − five =

      Message modal