Facebook Pixel

Data Analytics with Power BI

Unlock your data potential with our hands-on Data Analytics with Power BI course. Designed for beginners, this practical program covers Excel, SQL, Power BI, and AI tools to help you transform raw data into actionable business insights. Through real-world projects, you’ll learn data cleaning, visualization, dashboard creation, and business intelligence strategies to boost your career in data analytics.

Class - 20
Duration - 2.5 months
Projects - 0
Joined - 10299
Data Analytics with Power BI

800012000

800012000

Details About the course

This comprehensive course is designed to transform aspiring data professionals into skilled data analysts by equipping them with actionable knowledge of Excel, SQL, Power BI, and AI-powered analytics. Through a hands-on, project-based learning approach, students will master core data handling, business intelligence, and visualization techniques, crucial for real-world business decision-making.

Starting with the fundamentals of data analytics and Excel operations, the course delves into advanced formula integrations, dynamic pivot tables, Power Pivot data modeling, and DAX calculations. Learners will also gain expertise in data cleaning using Power Query, building interactive business dashboards, and leveraging SQL for data extraction and analysis.

As the program progresses, participants will be introduced to cutting-edge AI features in Excel and Power BI, preparing them for the future of data analytics. By the end of the course, learners will be confident in transforming raw data into actionable insights, presenting professional dashboards, and contributing to data-driven business strategies.

Prerequisite

Basic Computer Skills: Familiarity with operating systems (Windows/Mac), file management, and internet usage.Fundamental Understanding of Spreadsheets (Optional but Helpful): Some experience with Microsoft Excel or Google Sheets will be helpful but not mandatory.

Logical Thinking and Problem-Solving Skills: A willingness to approach problems methodically and think critically.

No Prior Experience with SQL, Power BI, or Data Analytics Required: This course is designed to take you from beginner to professional level, step-by-step.

Learning Outcome:

By the end of this course, you will be able to:

-Understand the fundamentals of data analytics.

-Master Excel for advanced data handling and business formulas.

-Perform data cleaning, transformation, and modeling with Power Query and Power Pivot.

-Build dynamic dashboards and reports using Excel and Power BI.

-Write SQL queries for data extraction and analysis

Course Modules

Module-1 : Excel: Actionable Usage of Excel
Class - 2
Quiz - 0
Assignment - 1
Part 1:
  • Introduction to Data Analytics

  • Component of Data Analytics

  • Tools need to be a Data analyst

  • Scope of a Data Analyst

  • Why Data Analyst

  • Cell formatting: Copy, Cut and Paste

  • Formatting Shortcut

  • Text function (Join and Split)

  • Freezing Panes

Part 2:
  • Cell referencing (Relative vs absolute)

  • Self-Finance handle in Excel

  • Conditional formatting

  • Data Structure: Shorting and Filtering

  • Customizing header and footer
  • Using Print area and print related tutorial
Module-2 : Excel Formula in Business Integration
Class - 2
Quiz - 1
Assignment - 1
Part 1:
  • Logical Function (Filter, IF, And, OR)

  • Carefulness of VLOOKUP, HLOOKUP

  • Using SUMIF, COINTIF, SUMIFS, COUNTIFS, COUNTA, INDEX & MATCH function

  • MAXIFS, MINIFS, AVERAGEIFS

Part 2:
  • What if analysis

  • Inserting calculated filed and calculated items

  • Shorting and filtering technique with pivot table

  • Slicer in Pivot table (creating, changing and formatting)
  • Dynamic pivot table using slicer
Module-3 : Power Pivot, Dax & Data Modeling
Class - 4
Quiz - 2
Assignment - 2
Part 1:
  • Understand table structure

  • Understand various relationships

  • Understand primary key and foreign key

Part 2:
  • Using Measure in power pivot

  • Data Analysis with Power pivot
  • Dax in power pivot
Module-4 : Data Cleaning Wizard: Power Query
Class - 5
Quiz - 2
Assignment - 3
Part 1:
  • What is power query

  • Understand the table structure

Part 2:
  • Creating data model

Data analysis with PowerPivot Business Dashboard
Part 1:
  • Using power query | Power Pivot| Web scrapping data | Dax

SQL for Data Modeling and visualization
Part 1:
  • Understand SQL and Data Models

  • Basic SQL syntax and Structure

  • SELECT statement: Receiving data from table

  • Filtering Data with WHERE clause

  • Usage Of GROUP BY

  • Shorting Data with Order by clause

Part 2:
  • Introduction to SQL in Data Analytics

  • SQL queries for Data Extraction

  • Working with INNER, LEFT, RIGHT, FULL JOINS

  • Usage of CASE statement
  • Hands of Activity: Business case analysis using SQL
Module-5 : Power BI Essentials: Setup, Data Transformation & Cleaning
Class - 4
Quiz - 1
Assignment - 2
Part 1:
  • Overview of Power BI and its ecosystem

  • Installing and setting Up Power BI Desktop

  • Power BI interface basics: Panes, ribbons, views

  • Overview of data sources compatible with power bi

  • Hands on activity connecting to simple dataset and importing data

Part 2:
  • Introduction to Power Query editor

  • Data transformation basic: filtering, merging and appending tables

  • Data cleaning technique

  • Data modeling, Basic data scrapping

  • Data Shaping pivoting and unpivoting
  • Using Power query to clean and transform raw data

What you will learn

Excel

Excel

Power BI

Power BI

SQL

SQL

Course Instructor

Kazi Jubair Radin

Kazi Jubair Radin

Data Analytics Faculty

Student Feedback

❌ কোনো Student Feedback পাওয়া যায়নি।

Frequently Asked Questions

প্রশ্ন-1 : কেমন সময় দেয়া লাগবে এ প্রোগ্রামে?
এটা তো আসলে ব্যক্তিবিশেষে আলাদা – কারো কম সময় লাগবে, কারো বেশি সময় লাগবে! তবে আশা করা যায়ঃ প্রতি সপ্তাহে গড়ে ১০-১৫ ঘণ্টা করে সময় দিলে আপনি পুরো সিলেবাস শিখে ফেলতে পারবেন।
প্রশ্ন-2 : কোর্স কোন সময় করবো? নির্দিষ্ট কোনো সময়ে ক্লাস হবে কি না?
আমাদের প্রতিটা কোর্সের আপকামিং সিডিউল দেওয়া আছে। আপকামিং সিডিউল দেখে আপনি ভর্তি কনফার্ম করতে পারেন অথবা আপনার ফ্লেক্সিবিলিটি অনুযায়ী কোর্স করতে পারবেন।
প্রশ্ন-3 : শিক্ষাগত যোগ্যতা? নন-টেকনিক্যাল ব্যাকগ্রাউন্ডের মানুষ এটি করতে পারবে?
নির্দিষ্ট কোনো ডিগ্রি রিকোয়্যারমেন্ট নেই। তবে কমপক্ষে এইচএসসি বা সমমানের যোগ্যতা থাকা উচিত। এছাড়া, STEM (Science, Technology, Engineering, Mathematics) ব্যাকগ্রাউন্ডের শিক্ষার্থীদের জন্য এ কোর্স তুলনামূলকভাবে সহজ হবে। অবশ্য নন-টেকনিক্যাল (যেমন, কমার্স কিংবা আর্টস) ব্যাকগ্রাউন্ডের মানুষরাও এ কোর্স করতে পারবে। পাশাপাশি কয়েকটি বেসিক বিষয় জানতে হবে। যেমন, Basic Algebra সম্পর্কে ভাল ধারণা থাকা। আবার কম্পিউটার চালানো এবং ইন্টারনেট ব্রাউজার ব্যবহারে কমফোর্টেবল হতে হবে। এছাড়া, গুগলে সার্চ করে কোনো টপিক ঘেঁটে দেখার মতো অভ্যাস থাকা উচিত।
প্রশ্ন-4 : কোর্স শেষে কি কোন চাকরির সহযোগিতা পাওয়া যায়?
হ্যাঁ, PeopleNTech থেকে Job Placement ও Freelancing Support প্রদান করা হয়, যার মাধ্যমে দেশ-বিদেশে চাকরির সুযোগ পাওয়া যায়।

Course Certificate

Get Course Completion and Assessment Certificate at the end of the course

Can add to your CV

You can share directly on your LinkedIn profile

You can share on Facebook with one click

Any more query?

Call For Any Information Regarding The Course. Our team is always ready to assist you with guidance, support, and detailed course information.

+880179-944-6655

09 AM to 09 PM

Course Features

20 Classes with Recorded Videos

20 Classes with Recorded Videos

Assessment, Project & Certification

Assessment, Project & Certification

CV & Portfolio Development

CV & Portfolio Development

Internship Opportunities

Internship Opportunities

Job Placement Support

Job Placement Support

Online and Offline Mentoring Support

Online and Offline Mentoring Support

Project & Practical-Based Training

Project & Practical-Based Training

Tools, Templates, and Book Suggestions

Tools, Templates, and Book Suggestions

Total Hours: 40 & Duration: 2.5 Months

Total Hours: 40 & Duration: 2.5 Months

image

আমাদের প্ল্যাটফর্মে রয়েছে বেশ কিছু ফ্রী কোর্স মডিউল!

image

Download the Guidelines for FREE!

কোর্সটি সম্পর্কে বিস্তারিত জানতে

ফোন করুন (0179-944-6655)

blur shape

Copyright © 2025 – PeopleNTech Institute of IT. All Rights Reserved

Data Analytics with Power BI