• LOGIN
  • No products in the cart.

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 amounts of information and transforming those into meaningful insights requires a 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.

Learning Outcome:
  1. Learn the Management of Big Data
  2. Transform your Database in Power Query
  3. Automate Complex Calculations
  4. Connect multiple files / worksheets and Analyze large data with Power  Query
  5. Modifying Query, Handling Errors & Null Values in Power Query
  6. Work with Conditional Column, Dynamic Data Grouping and Unpivot Data
  7. Data & Time Transformations
  8. Connect Data from Web and Update in Real-time
  9. Create Fully Automated Dashboard / Business Intelligence Report
Target Audience:
  1. Senior Leaders of an Organization
  2. Managers maintaining a team
  3. Specialists working with Data and Analytics
  4. Business Persons
  5. Students who have a keen interest in Data Analysis & Presentation

Who is the instructor

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 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.

এছাড়া কোর্সটি শেষ করার পর আপনি কোর্স কমপ্লিশন সার্টিফিকেটও পেয়ে যাবেন।

কিভাবে জয়েন করবো কোর্সটিতে?

‘Take This Course’ বাটনে ক্লিক করুন। আপনি লার্নিং বাংলাদেশ প্ল্যাটফর্মের পেমেন্ট গেটওয়ে ভিসা/মাস্টারকার্ড বা মোবাইল ওয়ালেট বিকাশ/রকেটের মাধ্যমে পেমেন্ট করতে পারবেন।

এর পাশাপাশি যদি আপনি টেকনিক্যাল ইস্যু ফেইস করে থাকেন তাহলে আমাদের পার্সোনাল বিকাশ, নগদ কিংবা রকেটে কোর্স ফি সেন্ড মানি করতে পারেন আপনার মোবাইল নাম্বার রেফারেন্সে উল্লেখ করে।

বিকাশ: +8801711283732  ।  নগদ: +8801711283732  ।  রকেট: +88017112837329

তবে এভাবে ম্যানুয়ালি পেমেন্ট করলে আপনাকে অবশ্যই এই ফর্ম টি পূরণ করতে হবে সঠিক তথ্য দিয়ে।
ফর্ম এ যেতে এখানে ক্লিক করুন – পারসোনালি টাকা পাঠানোর পরবর্তী ফর্ম

আমরা ফিরতি কলে আপনার কাছ থেকে বিস্তারিত জেনে এনরোল করিয়ে দিব।

বিস্তারিত জানতে কল করুন

01780588739 | 01711283732

Bangladesh Lockdown - Develop Skill in This Free Time
ডিসকাউন্ট কুপন LOCKDOWN60​
Share on facebook
Facebook
Share on whatsapp
WhatsApp
Share on linkedin
LinkedIn

Course Curriculum

Introduction
What are the Uses of Power Query 00:05:00
Important: Excel Versions, Expectations & Course Pathways 00:10:00
Understand the Enormous Ability of Power Query to Handle Big Data
What is a Big Data? 00:06:00
What is a Proper Data Set? 00:10:00
Analyze Big Data Quickly! Pivot Table or Power Query? 00:10:00
Power Query Overview: Import Large Data from Another File 00:05:00
Power Query Editor & Basic Transformation 00:07:00
Quick Insights on Data Quality & Distribution 00:09:00
Formula Bar, Applied Steps & M Code 00:09:00
Close & Load Destinations 00:07:00
Refresh Data & PQ Refresh Options 00:08:00
Import CSV File & Extract Text Based on Pattern 00:06:00
Merge Data with Another File (Pivot Table from Multiple Files) 00:04:00
Things that would Help to Efficiently Use Power Query
Uploading Data From Excel 00:05:00
The Hidden Table Method 00:09:00
Handling Changes to Source 00:05:00
Data Types 00:07:00
Data Types vs. Formatting & Null Values 00:09:00
Power Query Navigation Shortcuts (Pro Tip) 00:08:00
Finding & Correcting Errors in Data 00:09:00
More Data Views: Duplicate OR Reference Query? 00:09:00
Query Dependencies 00:00:08
Delete, Manage, Copy Queries & Backup Results (Pro Tip) 00:10:00
Effective Power Query Transformations
Text Transformations 00:06:00
Merging Columns & What to Watch Out For 00:05:00
Fill & Replace Values to Create Proper Datasets 00:07:00
Sort Data including Multiple Levels 00:14:00
Remove Duplicates including Multiple Columns 00:09:00
Number Transformations & What to Watch Out For 00:05:00
Working with Filter (AND & OR Conditions) 00:09:00
Change Type & Remove Columns Trap (Pro Tip) 00:08:00
Powerful Power Query Transformations
Column From Examples – Extract Patterns Quickly 00:06:00
Allocate Data to Groups (Pro Tip) 00:06:00
Conditional Columns in Power Query 00:07:00
Aggregating (Grouping) Data on Multiple Levels 00:07:00
Group By for All Rows (Pro Tip) 00:08:00
Unpivot Columns – Basics 00:08:00
Unpivot & How to Overcome Common Errors (Pro Tip) 00:12:00
Pivot Columns – Basics 00:11:00
Problem with Split by Delimiter (watch out!) 00:14:00
Split Column by Rows instead of Columns (Pro Tip) 00:10:00
Date & Time Transformations
Date Transformations (Extract Age, Weekday etc.) 00:08:00
Creating Dates from Text or Columns (Pro Tip) 00:10:00
Time Transformations (Calculating Hours worked) 00:07:00
Date & Number Errors When Importing Data (Locale) 00:08:00
Custom Column & Understand Basic M Code Manipulation
Important Basic Power Query M Logic 00:10:00
Why Use Custom Columns 00:10:00
Introduction to ‘Add Custom Column’ 00:17:00
Custom Columns Type Compatibility & Intrinsic Functions 00:10:00
Skipping Steps in Power Query (Pro Tip) 00:09:00
Adjusting FILTER & Conditional Columns to Reference a Dynamic Variable 00:10:00
Drill-Down in Power Query 00:14:00
Custom Formulas for Template Creation (Hidden Tip) 00:09:00
PROJECT – HR Report
Test Your PQ Knowledge by Completing This Project 00:09:00
Calculate Years Worked in Each Position 00:04:00
Calculate Years Worked in the Company 00:14:00
Split First, Last & Middle Names to Separate Columns 00:08:00
Merge Options (Different Joints in PQ)
Overview of Merge Options and Join Kinds 00:09:00
Left Outer Join & Right Outer Join 00:09:00
Merge Based on Multiple Columns (Pro Tip) 00:06:00
Can You Find the Mistake? Merging Text Columns 00:05:00
Merge Data to Get Multiple Match Results & Bonus Tip 00:07:00
Inner & Full Join in Power Query 00:09:00
Left & Right Anti Join when Merging in Power Query 00:04:00
How to Use Fuzzy Match in Power Query 00:01:00
Fuzzy Match with Transformation Table (Hidden Feature) 00:08:00
When to Use Power Pivot & Load to Data Model
When to Load Data to the Data Model 00:09:00
Availability of Power Pivot 00:04:00
Pivot Table from Multiple Excel Tables 00:14:00
Power Pivot Table with Data Model & Power Query 00:05:00
Create a Calendar Table in Power Pivot 00:07:00
Pivot Slicers & TimeLine with Power Pivot & Power Query (Pro Tip) 00:08:00
Next Steps
সার্টিফিকেট কিভাবে পেতে পারি? FREE 00:06:00
কীভাবে আরো স্কিল ডেভলপ করতে পারবো? 00:05:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
2 STUDENTS ENROLLED

লার্নিং বাংলাদেশ

 

আমাদের ই-লার্নিং প্ল্যাটফর্ম থেকে ১০ হাজারের বেশী লার্নার প্রফেশনাল স্কিল অর্জন করে ফ্রীল্যান্সিং ক্যারিয়ার ও নিজের অনলাইন বিজনেস সফলভাবে গড়ে তুলছেন। আমাদের ৩০+ অনলাইন কোর্স আপনি বাংলাদেশের যেকোনো প্রান্তে বসে করতে পারবেন, প্রতিটি কোর্সের জন্য আলাদা আলাদা ফেইসবুক গ্রুপে প্রশ্ন করতে পারবেন এবং উক্ত বিষয়ে দক্ষ হয়ে উঠবেন। আর সেই দক্ষতা কাজে লাগিয়ে সহজেই অনলাইন মার্কেটপ্লেস থেকে উপার্জন শুরু করতে পারবেন। যেকোনো প্রয়োজনে কল করুন
01780588739 🙂

সর্বশেষ যারা অনলাইনে কোর্স করছেন

Profile picture of Partha Mondal
Profile picture of Mohi UDDIN
Profile picture of Shaima Afrin
Profile picture of Mehedi Hasan shohag
Profile picture of MD. ABU SAYEED
Profile picture of Md. Raihan Sheikh
Profile picture of Md. Naime Mir
Profile picture of Charemra Marma
Profile picture of Durjoy Kuri
Profile picture of afzal Hossain
Profile picture of JAHIDUL ISLAM
Profile picture of najia ahmed
Profile picture of Syed Abdullah Al-Mahfuz
Profile picture of Saiful Islam
Profile picture of Md. Symmon Hassan Mehdi

শীঘ্রই রিলিজ হচ্ছে

googleplay
googleplay

Internship Opportunity
Terms and Conditions
Return, Refund & Exchange
Instructor Registration

Office Address:
84/Ma, 3rd Floor, Proticchobi, Merul Badda, Dhaka
top
X