Share this link via
Or copy link
Overview
Gain hands-on experience with Excel, Statistics, My SQL and Power BI to drive powerful analysis and communicate insights What you'll learn: Get hands-on experience with 4 groups of skills that needs each data analyst - Excel, SQL, Statistics, and Power BILearn MS Excel for cleaning, preparing, calculating and analysing data Learn how to write advanced Excel formulas by SUBTOTAL, SUMIFS, COUNTIFS, AVERAGEIFS, VLOOKUP, INDEX, MATCH and other 50+ functions Learn Pivot Tables so you can quickly get insights from your...
Syllabus
- Course Overview
- ----- PART 1. Exploring Data in MS Excel -----
- Cleaning and Preparing Tools
- Advanced Forumals and Functions
- Pivot Tables and Lookup Functions
- Part 1 Completed
- ----- PART 2. Statistical Analysis with Excel -----
- Data Analysis ToolPak
- Linear Regression Analysis
- A/B Testing
- Part 2 Completed
- ----- PART 3. Managing Data with MySQL -----
- Basic SQL Queries
- Intermediate Statements and Functions
- Advanced Tips and Tricks in MySQL
- Part 3 Completed
- ----- PART 4. Visualization with Power BI -----
- Data Connection and Preparation
- Charts and Visualization Techniques
- Extra Functionalities in Power BI
- Part 4 Completed
- ----- Congratulations -----
Instructor
Vardges Zardaryan
Reviews
No reviews yet. Be the first to review!
Alternative Courses
Introduction to AI Programming Welcome to the AI programming with...
Free
You must be logged in to submit a review.