Become a Data Analyst (Microsoft Excel & Power BI) - Daisy Tech Limited

Become a Data Analyst
(Microsoft Excel & Power BI)

FEE

₦40,000

DURATION

TWELVE (4) DAYS

100%

☆☆☆☆☆ 5/5

Rating

Share This Course:

Overview

Data analysis is a critical skill for professionals in various industries, as organizations rely on data to make informed decisions and drive business results. Microsoft Excel and Power BI are two powerful tools that are widely used for data analysis. Whether you’re an aspiring data analyst, business intelligence professional, or entrepreneur looking to make data-driven decisions, this comprehensive course will equip you with the skills you need to become a data analyst.

You will gain hands-on experience working with real-world data, and learn best practices for data analysis and storytelling. By the end of the course, you will have a comprehensive understanding of data analysis with Microsoft Excel and Power BI. So, sign up now and transform your career with the power of data analysis!

What you will learn

At the end of the Microsoft Excel Course, you should be able to

Navigate through the Microsoft excel tools.
Clean data to be of quality before analysis.
Create charts for Data Visualization
Perform HLOOkUP and VLOOKUP.
Create Pivot tables
Create Gantt charts for projects

At the end of the Power BI Course, you should be able to

Understand and implement the end-to-end process of turning raw data into insightful reports.
Address data quality issues using Power query to preprocess and filter data.
Create interactive visualisation for analysis.
Confidently create impressive reports.

COURSE DETAILS

Microsoft Excel Course outline

Navigate through MS Excel tools
Data Cleaning
Data Sorting
HLOOKUP and VLOOKUP
Create and work on the Pivot table
Create Charts
Create a Gantt Chart
Capstone project

Power BI Course outline

Introduction to Data Analysis
Understand Power BI and Power BI Desktop
Work with Query Editor
Calculate columns and measures using DAX
Perform Reporting and Visualization effectively
Create a Dashboard
Capstone project

WHO IS THIS COURSE FOR

Aspiring data analysts, business intelligence professionals, and data scientists
Professionals looking to upskill in data analysis
Entrepreneurs and small business owners looking to make data-driven decisions
Anyone interested in data analysis and its applications

WHY TAKE THIS COURSE

Master Microsoft Excel and Power BI for data analysis
Gain a comprehensive understanding of data analysis techniques and best practices
Acquire in-demand skills that are highly sought after by employers
Get hands-on experience working with real-world data
Boost your career potential and earning potential