img
img

Data Analysis with Ms Power BI - SQL and Excel Inclusive

The art of data analysis using Power BI, SQL, and Excel. Gain hands-on experience in visualizing data, building reports,

Enrolled (453) Beginner
N 8,500.00 N 12,500.00

453

Start Course Now

Course Info

Course Start Date : 1/14/2025
Course Level : Beginner
Course Duration : 12 Hours

Keywords

Search Classes

My Students' Testimonials Below

Course Description

Data Analysis with MS Power BI – SQL and Excel Inclusive
Unlock the full potential of your data by mastering Microsoft Power BI alongside SQL and Excel in this comprehensive course. Whether you're a beginner or looking to enhance your data skills, this training will equip you with the tools to transform raw data into actionable insights.

In this course, you will learn:

  1. How to create dynamic reports and dashboards using Power BI.
  2. Essential SQL skills for querying and manipulating databases.
  3. Advanced Excel techniques for data analysis and automation.
  4. Best practices for data visualization and reporting.

By the end of this course, you will be confident in using Power BI, SQL, and Excel to analyze and visualize data, empowering you to make informed business decisions. Sign up now on the PacersHub Learning Portal and take your data analysis skills to the next level!

Course Curriculum

ID Item
1 Course introduction
2 Installing SQL | Create Tables | Where Statement | Group By Order By Statements
3 Inner/Outer Joins | Use Cases | Unions | Union Operator | Case Statement | Use Cases
4 Having Clause | Updating | Deleting Data
5 Aliasing | Partition By | CTE | Temp Tables
6 String Functions | Subqueries | Stored Procedures | Use Cases
7 Data Analyst Portfolio Project | SQL Data Exploration
8 Data Analyst Portfolio Project | Data Cleaning in SQL
9 Pivot Tables in Excel
10 Formulas in Excel
11 XLOOKUP and VLOOPUP in Excel
12 Conditional Formatting in Excel
13 Charts in Excel
14 Cleaning Data in Excel
15 Full Project in Excel
16 Installing Power BI and Building First Visualization
17 How to use Power Query in Power BI
18 How to Create and Manage Relationships
19 How to use DAX in Power BI
20 How to use Drill Down
21 How to use Conditional Formatting
22 How to use Bins and Lists
23 Popular Visualizations in Power BI
24 Full Power BI Guided Project

Instructor

user

Adeleke Samuel

 Member Since December 2022

Am a seasoned programmer with over a decade of hands-on experience in the field of software development. With a passion for code and a commitment to excellence, Adeleke has honed expertise in a wide range of programming languages, technologies, and domains. Adeleke's dedication to programming excellence, coupled with a commitment to continuous learning, has not only enriched their own skill set but has also contributed to the growth and development of aspiring programmers through training and mentorship. Adeleke's deep industry knowledge and practical experience make them a valuable asset in the world of software development.

Contact Info

Comments And Reviews

64x64

Edward

Dec 21st 16.35 UK

I like the course, its very simple and i can understand it very well.

Leave your comments
* Data Analysis with Ms Power BI - SQL and Excel Inclusive *

Subscribe

Subscribe to our newsletter or follow PacersHub on Instagram for latest update.