Executive Assistant (m/f/d): Data analysis for corporate management & reporting with SQL, Azure & Power BI

Smart Future Campus GmbH

The Smart Future Campus is an important provider of further education and training in the fields of IT, Industry 4.0, AI, Unity and digital transformation.

Our focus is primarily on innovative technologies such as automation technology, robotics, ML, but also software development and system administration.

With practical courses and recognized certificates, we support the professional future of our participants.

You will learn this with us

This 7-month advanced training program offers practical upskilling for anyone who wants to use data analysis effectively for management reporting and corporate governance. You will expand your existing professional profile with the skills to reliably support decision-makers: defining key performance indicators (KPIs), systematically evaluating data sources, clearly visualizing relationships, and presenting results as relevant reports and dashboards. This will enable you to effectively support data-driven decisions in daily operations and at the management level – significantly increasing your chances of a successful return to the workforce.

The training is divided into three practical modules:

SQL & Microsoft Azure: Building a data foundation for management decisions (11 weeks)

You will learn how data is generated within companies and which structures are crucial for analysis and management (e.g., KPIs, ETL, data quality). With SQL, you will develop the skills to thoroughly examine, evaluate, and prepare data so that it serves as a reliable basis for reports. Data modeling (e.g., star schema) and advanced SQL topics ensure practical application in everyday work. Additionally, you will gain insights into Azure database services and data warehousing – essential for understanding modern data landscapes within a company.

Contents:

• Data in companies, KPIs, ETL, SQL vs. NoSQL, Big Data
• SQL basics to advanced (JOINs, data integrity, timestamps, RegEx, JSON, stored procedures)
• Data modeling (e.g., star schema), administration & data quality
• Azure-Datenbanken, Cosmos DB, Data Warehousing & Administration
• Final project (teamwork & presentation)

Power BI Data Analyst: Control-relevant dashboards and reports for management (10 weeks)

In this module, you will learn how to prepare analysis results so they are truly usable for management: clear visuals, reliable key performance indicators (KPIs), and understandable storylines. You will transform data with Power Query, model it in a structured way, and develop meaningful measures with DAX (e.g., variances, trends, time comparisons). Additionally, you will learn dashboard design, performance optimization, and professional operation of the Power BI service, including role and permission concepts as well as row-level security.

Contents:

• Power BI basics, data understanding, soft skills
• Data import, cleansing, modeling, relationships & hierarchies
• Visuals, DAX-Measures, Drillthrough, Advanced Analytics & KI
• Dashboard design, best practices, paginated reports, performance
• Power BI Service: Workspaces, Administration, Roles & Permissions, RLS
• Team final project + exam preparation Microsoft Power BI

JobReady: Apply project methods and demonstrate results as a contribution to management (8 weeks)

Finally, you will apply your new skills to a realistic project context: You will learn project management (traditional and agile, e.g., Scrum), strengthen your application materials, and implement a practical project in a team with partner companies. This will result in presentable outcomes—such as a dashboard set or an analysis case—that concretely demonstrate your ability to manage a company using data. Preparation for the Chamber of Industry and Commerce (IHK) exam will also be provided.

Contents:

• Job market preparation: Application documents & application training
• Project management: traditional & agile (Scrum)
• Practical project with partner companies
• Exam preparation (Chamber of Industry and Commerce)

Your profile

• Language skills: German B1/B2, basic English skills are an advantage.
• Skills: IT affinity, logical thinking skills, motivation to take your career to the next level. Prior IT experience is a plus, but not required. Career changers are very welcome.
• Features: Stable internet – we provide everything else!

Your benefits

• 100% funding: With the education voucher from the employment agency or job center.
• 100% Remote: Learn comfortably from home - without travel time or wasted time!
• Career Boost: We actively support you in your job search.

Sign up now for a free consultation!