Overview:

DATA ANALYTICS WITH PYTHON AND POWER BI

With 3.5 months of intensive training, this course focuses on building a solid Data Analytics mindset, preparing you to confidently tackle any challenge and apply for fresher or junior Data Analyst/Business Intelligence Analyst positions. Led by the favorite mentor Dũng Pop and Hải Nguyễn, Senior Data Analyst at Optus, this course promises to be an exciting and comprehensive learning journey.

🌺 So why does Career Mentor offer another Data Analytics Intensive course with solid skillsets in SQL, Excel, and Tableau? Isn’t Tableau and Power BI both Data Visualization tools with transferable skills?

🍊 Absolutely right! But now, you’ll have more options, especially for those living in states where Microsoft’s tech stack dominates, and 9 out of 10 companies use Power BI. With this course, you’ll be EXCEPTIONALLY WELL-PREPARED with the exact skills employers need.

🥝 For those who enjoy something more technical and want to boost their skills, this course’s Python module will be a satisfying addition. It gives you the ability to process clean data smoothly while letting you feel like a “cool dev” as you type away at your code.

🥝 Schedule:
The course lasts approximately 3.5 months (14 weeks).

There’s a “+” here because if the content isn’t fully covered, mentors will keep teaching until everything is done.

If you’ve taken a course at Career Mentor before, you’ll know how some classes run for 4+ hours without signs of stopping—teachers keep teaching, and students stay eager to learn.

Classes take place every Monday and Thursday, 8:00 – 10:00 PM (Sydney/Melbourne time).

đź“– COURSE SCHEDULE

WEEK COURSE CONTENT
WEEK 1
  • SQL – Introduction to SQL
  • SQL – Aggregation in SQL
  • WEEK 2
  • SQL – Joins & Unions
  • SQL – Subqueries
  • WEEK 3
  • SQL – Functions
  • WEEK 4
  • SQL – CASE statements
  • SQL - CTEs
  • WEEK 5
  • SQL - Database Design Fundamentals
  • WEEK 6
  • PYTHON - EDA Process, Python libraries for EDA
  • PYTHON - Data exploration & validation
  • PYTHON - Statistics
  • PYTHON - Data quality issues
  • PYTHON - Data summarisation
  • WEEK 7
  • PYTHON - Data manipulation/ transformation/ engineer
  • PYTHON - Missing/ duplicated values
  • PYTHON - Outliers
  • PYTHON - Scaling/Normalisation
  • WEEK 8
  • PYTHON - Relationship in data
  • PYTHON - Correlation matrix
  • PYTHON - Heatmap
  • PYTHON - Time series
  • WEEK 9
  • PYTHON - Personal project
  • WEEK 10
  • POWER BI - Introduction to Power BI and its use
  • POWER BI - Building blocks and navigate Power BI
  • POWER BI - Data transformation with Power Query
  • POWER BI - Data modeling and relationship
  • WEEK 11
  • POWER BI - DAX calculations
  • WEEK 12
  • POWER BI - Visual best practices and building
  • WEEK 13
  • POWER BI - Visual control and interaction
  • POWER BI - Personal project
  • WEEK 14
  • POWER BI - Personal project
  • WEEK 15
  • Effective Resume
  • Job Interview (technical/ behavioural) - How to impress your recruiter
  • Mentor

    Dung Nguyen

    IT

    Dung, a dedicated professional with over 8 years of expertise as a Java Backend Engineer and Career Mentor. As a Java Backend instructor at Career Mentor, Dung combines his deep industry knowledge with a passion for mentoring, guiding students to confidently and clearly achieve their career goals.

    Background
    Mentor @Career Mentor
    Java Analyst @NAB

    Specializations

    Dung offers a range of comprehensive coaching services tailored to individual needs:

    • Career Advising: Personalized guidance for roles in Software Engineering.
    • Career Coaching: In-depth support in building standout resumes and mastering interview skills for Software Engineer positions.

    Hai Nguyen

    Data

    Hai Nguyen, a data expert with extensive expertise and hands-on experience in various roles at leading corporations in Australia. As a passionate mentor and a trusted companion to many students at Career Mentor, Hai has helped countless individuals achieve success in securing data analyst roles at prestigious organizations such as ABS, ACS, Bendigo Bank, and Mantel Group.

    Background

    • Mentor @Career Mentor
    • Senior Data Analyst @Optus
    • Senior Data Analyst | Data Scientist @KPMG
    • Business Systems Engineer @Nexon Australia

    Specializations

    • Data Expertise Training: Providing in-depth knowledge and practical skills in the field of data.
    • Career Advising: Personalized guidance for roles in the data field, including resume building and interview preparation to excel in the recruitment process.

    Tuition Fee

    3000 A$

    For a 3.5 months program

    Cover all aspects of the topic 3.000A$

    Closed

    Want more information about tuition & financing in your area?

    Our Team is here to help. Contact Us

    Register now

    Our Upcoming Class Will Open On 09/01/2025

    Currently, this course has no opening schedule

    Thank you
    for registering
    An email with payment instructions will be sent to you shortly. If you do not see the email in your inbox, please check your spam or junk folder. In case you haven’t received the email within 24 hours, feel free to contact our admin team via the Career Mentor Fanpage for assistance.

    Continue