In this training, you will learn learn how to directly import data from SQL and relate tables in the back-end of Power BI. You'll also understand the importance of subquerying, views, and variables in SQL data analysis as well as the importance of stored procedures.
Become A Certified Data Analyst with SQL & Power Bi
Time before the price increases:
Why You Should Take This Course
Data Analysis Is One Of The Most In Demand Skills In The World Today
The average salary of a data analyst in the US is ranging between $66k-$100k (N76,230,000-N115,500,000).
With this training, you will have all the skills, knowledge, techniques and tools that will make it super easy for you to get jobs in data analytics. Guaranteed.
With this training, you will have all the skills, knowledge, techniques and tools that will make it super easy for you to get jobs in data analytics. Guaranteed.
Watch what a Student said about us
Experts-Led Training
Our Instructors are among the best I.T Trainers and Consultants in Nigeria.
100% Practical Training
This program is designed to hold you by the hand and show you all the tools, trick and techniques practically. You will learn all these by DEMONSTRATION. No theory.
Internships & Jobs Guaranteed
Four (4) weeks into the Course, you will begin your Internships with 2 among the global top 5 consulting firms where you will build and apply your knowledge and skills to real world business problems. Upon course completion, we will support you through your job search and you will get exclusive access to our dedicated job group to apply for relevant jobs.
Skills You'll Learn
In this course, you'll learn the most effective ways to go about studying data, using professional and complex datasets, and developing fundamental data skills and knowledge.
Introduction to Data Analytics & Visualization Journey
In this module, you will be introduce to SQL and Power BI.
Core SQL (Microsoft SQL Server)
This module involves core SQL. You’ll learn the introduction to SQL, how to create your database, how to import your data, data types, the SELECT and FROM statement, Filtering data, INTO statement, ORDER BY statement, HAVING statement, CASE statement, ‘UNION’ and ‘UNION ALL’, JOIN statement .
You’ll also learn SQL management and Housekeeping, Core SQL Wrap Up.
Intermediate SQL
Here, you’ll learn how to import your data, deal with NULL value, Test your knowledge: Dealing with NULL Values, Data Type Conversion: The ‘CAST’ and ‘CONVERT’ Functions, Test your knowledge: Converting Data Types, Data Cleansing, Test your knowledge: Data Cleansing, Window Functions, Test your knowledge: Window Functions, Running Totals, Test your knowledge: Running Totals, Subqueries, Test your knowledge: Subqueries,
You’ll also learn Views: Virtual Tables, Test your knowledge: Views / Virtual Tables, deal With Duplicate Values, Test your knowledge: Checking For / Dealing With Duplicate Values, Using Variables, Test your knowledge: Using Variables, Stored Procedures, Test your knowledge: Stored Procedure, Intermediate SQL: Wrap Up.
SQL Query Walkthrough and Guide & Linking SQL to Excel
Here, you’ll learn The SQL Query Walkthrough Guide, How to Pull Tables from SQL Databases Into Excel.
Power BI
In this unit you’ll learn the introduction to Power BI, Power BI Installation, What is Data Visualisation, Applying Data Concepts, Backend of Power BI, Data Preparation Part A, The First Dashboard: Salary Insights, Data Preparation Part B, The Second Dashboard: Property Market Analysis, Data Preparation Part C, The Third Dashboard: Revenue Analysis, Power BI Dashboard Navigation.
Bonus 1: A Mentorship Session with a Top Data Analyst
In this segment, you will have a Ask-Me-Anything session with a top data analyst to guide you further.
Bonus 2: How To Make $1,000 Monthly Working Remotely As a Data Analyst
In this segment, a top freelancer will share with you a blueprint that guarantees you to make at least $1,000 Monthly working Remotely As A Data Analyst… Even if you know nothing about remote work.
Bonus 3: A Step-by-Step Guide On How To Relocate to the UK from Nigeria with a Skilled Worker Visa & Tech Nation Visa.
The Skilled Worker visa allows qualifying individuals to come to the UK to work for an approved sponsor in an eligible role. We will give you a Guide on How To Apply for Skilled Worker Visa and Tech Nation Visa.
Training Details
No need to quit your job or school, you can enhance your professional and earning potential with our weekday, weekend and online sessions.
Weekday Session (Classroom)
Day: Monday, Wednesday & Friday
Time: 10 AM - 1 PM
Duration: 6 Weeks
Start Date: 16th April 2024
Weekday Session (Online)
Day: Tuesday & Thursday
Time: 7PM - 9PM
Duration: 6 Weeks
Start Date: 1st April 2024
Weekend Session (Saturday & Sunday)
Saturday Time: 1PM-4PM
Sunday Time: 1PM-4PM
Duration: 8 Weeks
Start Date: 6th April 2024
Venue
SkillBoost Limited: Fonte House, 1 Temple Ejekwu Close, First Artillery Junction, Aba Road, Port Harcourt, Rivers State.
Training Fee
Early Bird*: Pay N80,000 Instead of N100,000
Meet Your Instructors & Mentors
To deliver excellent training, we work with the very best talents.
Testimonials
99% of our previous students rated us 5 stars.
Don’t take our word, just read what some of them have to say.
Read More
My first impression was that it was too cheap to be real, took my chance and not regretting anything about it.
Great value indeed.
Read More
I must confess that this is the platform for learning. They're real and transparent. You get 10 times the value of your money.
Read More
Skillboost Limited is a top-notch company. The best and number one. My experiences with Skillboost Limited so far has been tremendous and smooth. I recommend them 100% for all who seek for services concerning their business scope.
Read More
Skillboost is indeed skill booster. Their mode of teaching is top notch and world-class. Always ditching out valuable contents. If you're looking for a place to get value for your learning investment, look no further, Skillboost is the place.
If there is another star after 5 stars I would gladly give it.
Read More
SkillBoost Training programs are one of the very best I have come across over the years.
The Instructor is very good at what he does and has a special way of passing across Technical Information in very simple ways that makes learning easy and enjoyable even for a non Technical audience.
Previous
Next
Frequently Asked Questions
01. Can I make payment in Installment?
Yes. We’re happy to work with you on a payment plan. If you’d like to speak with a member of staff about possible payment options, you may reach us at 07030163486 via WhatsApp.
02. What Are The Requirements for Taking This Course?
No previous knowledge of Data Analysis or experience is required. However, you must be familiar with using computer efficiently. Our instructional style is geared toward beginners. We will begin from the start and guide you to become an expert.
03. Who Are The Key Skills That I Will Learn In This Training?
- Communication and Presentation Skills.
- Identifying data uses in everyday life and business.
- Data Gathering and Exploration
- Organizing data for data analysis.
- Problem Definition and Solving
- Step-by-Step process of Data Analysis
04. Who Is This Training For?
- We designed this training for those seeking the practical skills in Excel to perform data analysis and visualization.
- Professionals who need to upskill their skills in data analysis and visualisation.
- Anyone aspiring to become a Professional Data Analyst
- Business Owners who want to make sense of their business numbers.
- Business Consultant and Coach.
05. Why Should I Choose SkillBoost Over Other Training Centres?
People prefer SkillBoost over others because our trainings are:
- Experts Led: Some of our trainers and Mentors work with some of the biggest Tech Companies in the World (Google, Facebook, etc)
- Projects-Based Training: We build our students confidence with in-depth live projects.
- Job Recommendation: We connect our students to top employers within and outside Nigeria.
- We offer FREE Career Guidance and mentoring.
- FREE Access to Support & Jobs Community.
- Recognized Certificate: Our certificates are recognized globally.
- Flexible Timing (In-Class, Online & Weekend).
- Flexible Payment Plan
06. Do I Need To Have My Own Computer Before I Enroll For This Training?
Yes. it is recommended you come with your own laptop as it will help you to practice whatever you are learning easily. However, we provide laptop that can be used only within our premises if need be.
07. What Type of Jobs Would I Qualify For If I Take This Course?
Generally, Microsoft Excel and Power Bi are the most-widely used data analysis tool of all the hundreds of data analysis tools in the world. There are hundreds roles available on job websites and other platforms in need of a Data Analyst. We will should you how to get hundreds of these jobs.
08. When Does Your Next Data Analysis Training Start?
Our I.T classes are on a rolling basis. It’s not like schools when you can only start in September or January. Call us on 07030163486 and we will fill you in on all the details.
© 2023 SkillBoost Limited
