PrepMajor

Data Analysis

Kickstart a future-proof career in one of the fastest-growing fields with BlueSky Citadel’s Data Analysis Training Program. This program provides ... Show more
Growth Image 7
Instructor
Emilia
0
0 reviews
Course details
Level : Beginner
  • Description
  • Reviews

🚀BLUESKY CITADEL IT ONLINE TRAINING! 🚀

Looking to land a remote IT job? This is your opportunity to gain the skills you need!

📌 What you’ll get:
✅ Expert-led IT courses
✅ Hands-on training & real-world projects
✅ Remote job preparation
✅ Supportive learning community

💡 Interested or know someone who might be?

For those who are interested in the February Cohort, only a few slots are available so register early and share with your friends and loved ones:

3- Month Programme: https://buy.stripe.com/5kQeVdgs5ctg1VTb2ad7q07 

3Month with 9month follow on programme with Life Membership: https://buy.stripe.com/dRm6oH6RvctgfMJ4DMd7q06

Thank you. 

RemoteJobs #LearnTech #EmpowerOthers #SpreadTheLight

Basic info

Key Learning Outcomes 

  • Understand the full data analysis lifecycle 

  • Clean, transform, and analyse data using Excel, SQL, and Power BI 

  • Build dashboards and interactive reports 

  • Apply statistical techniques to interpret trends 

  • Use Power Query, DAX, and relational data models 

  • Extract and manipulate data using SQL 

  • Present insights using data storytelling techniques 

  • Build a complete analytics portfolio 

Course requirements

Module 1: Introduction to Data Analysis 

  • Understanding the role of a Data Analyst 

  • Data types and structures 

  • Overview of analytics tools 

Module 2: Excel for Data Analysis 

  • Data cleaning and transformation 

  • Pivot tables, formulas, and lookups 

  • Charts and dashboards 

Module 3: SQL for Data Extraction 

  • Database fundamentals 

  • SELECT, JOIN, GROUP BY queries 

  • Extracting and combining data 

Module 4: Power BI for Business Intelligence 

  • Connecting to data sources 

  • Power Query transformations 

  • Data modelling and relationships 

  • DAX formulas 

  • Dashboard design 

Module 5: Data Storytelling & Visual Communication 

  • Presenting insights clearly 

  • Creating compelling data visuals 

Module 6: Real-World Projects 

  • Practical case studies 

  • SQL project challenges 

  • Building Power BI dashboards 

  • Portfolio development 

Module 7: Career Development 

  • CV review 

  • LinkedIn optimization 

  • Interview preparation 

Intended audience
 
  • Beginners in tech 

  • Career changers 

  • Professionals needing data skills 

  • Students and graduates 

Career Opportunities & Salary Scale 

  • Data Analyst 

  • Reporting Analyst 

  • Power BI Analyst 

  • Junior Data Scientist 

  • Salary range: £28,000–£75,000+