Business100% OFF

Excel Power Query 2 - Erweitere Transformationen von Daten

Udemy Instructor

0(1.6K students)

Self-paced

All Levels

About this course

Wenn du viel mit Excel arbeitest, wirst du von den phantastischen Funktionen von Power Query absolut begeistert sein. Power Query ist seit einigen Jahren in Excel fest integriert - und es ist eine der am meisten unterschätzten Funktionen in Excel!Du kannst eine Power Query Abfrage beispielsweise dazu verwenden, um die Werte aus Dutzenden Tabellen in Sekundenschnelle zusammenzufassen und die gesamten Dateien danach in einer einzigen Pivot-Tabelle zu verarbeiten. In der Unternehmensanalyse muss in der Lage sein, mit verschiedenen Datenquellen und Strukturen zu arbeiten, und hier kommen die Optionen Gruppieren, Pivotieren und Entpivotieren von Power Query ins Spiel.

So kannst du selbst schlecht angelieferte Daten vollautomatisch in ein angenehmes Format bringen, das von Menschen (und Pivot-Tabllen) leicht zu lesen ist.Erinnerst du dich noch daran, wie du das erste Mal ein Auto gefahren bist?Die Arbeit mit Power Query ist so einfach, dass du damit Excel quasi auf "Tempomat" stellst.Power Query ist der kleine Motor, der deine Arbeit mit Excel ab sofort antreibt. Mit Power Query kannst du Daten von überall her herunterladen, sie in eine Art Datenbank umwandeln und dann mit allen Funktionen von Excel analysieren. Jetzt ist Schluss mit Copy/Paste-Orgien und Zusatz-Spalten!Pivot-Tabellen sind ein unglaublich wichtiges Werkzeug für die Analyse von Daten, aber es kostet viel Zeit, sie richtig einzurichten, weil man die Daten in der richtigen Form benötigt.

Mit Power Query kannst du deine Daten auf eine kreative Weise automatisieren und schnell und einfach lesbar machen.Das Erlernen von Power Query wird deine Produktivität erheblich steigern und es dir ermöglichen, Daten-Tabellen in weniger als der 20% der Zeit zu erstellen, als dies bei der manuellen Erstellung der Fall wäre. Egal, ob es sich um ein paar Tage oder nur mehrere Stunden Arbeit handelt, Power Query spart dir jeden Tag eine Menge Zeit und Geld!Inhalt:Intro und Motivation zu Power QueryExtrahieren von Text-TeilenAlle Dateien eines Ordners zusammenfassenZur Erinnerung - Unterschied Tabellenblatt, Liste und definierte TabelleDaten aus dem Internet abrufen mit Power Query, zum Beispiel AktienkurseDer Grund für Verschiedene Formate von DatenFremdes Gebietsschema (z.B. Dezimalzahlen mit Punkt statt Komma) umwandelnFremdes Datumsformat in unser Format konvertierenManuelles Zerlegen von problematischen Werten (z.B.

aus SAP Download)Weitere Extrem nützliche Datum-FunktionenMotivation + Unterschied Transformieren und Spalte hinzufügen am Beispiel RundenBedingte Spalte mit WENN-Formel kinderleicht einfügenBerechnungen über Spalten, mit Spalten, zwischen Spalten in Excel mit Power QueryAuftakt Eine Pivottabelle mit Daten aus Power QueryDie einfachste Aggregierung ANZAHLAufsummieren wie bei einer Pivot Tabelle direkt beim ImportMehrere Spalten in die Berechnete Tabelle aufnehmenWeitere Merkmale in die Pivot-Tabelle einfügenDaten bei Bedarf transponieren (Zeilen und Spalten tauschen)So entstehen Pivotierte DatenDaten aus einer Pivot-Tabelle rekonstruieren (entpivotieren)

Skills you'll gain

Business Analytics & IntelligenceGerman

Available Coupons

Course Information

Level: All Levels

Suitable for learners at this level

Duration: Self-paced

Total course content

Instructor: Udemy Instructor

Expert course creator

This course includes:

📹Video lectures
📄Downloadable resources
📱Mobile & desktop access
🎓Certificate of completion
♾️Lifetime access

$0$80.99

Save $80.99 today!

Enroll Now - Free

Redirects to Udemy • Limited free enrollments

Share this course

https://freecourse.io/courses/excel-power-query-transformation-von-daten

This course contains the use of artificial intelligence.Duration: 21 weeks · 105 teaching daysAudience: Product Owners, Product Leaders, Business StakeholdersOutcome: Students develop AI judgment, not technical skillsAI Fundamentals for Business is a 21-week, 105-day course from School of AI designed for Product Owners, Product Leaders, and business professionals who need to understand AI without math, coding, or technical jargon. This course helps learners build practical AI judgment: the ability to know what AI can do, what it cannot do, when to use it, when not to use it, and how to lead AI initiatives responsibly.The course begins by demystifying AI and separating it from traditional software, automation, and science-fiction ideas of general intelligence. Learners explore why AI exists, how it creates business value, why it is probabilistic, and why many organizations confuse AI progress with hype. From there, the course develops clear mental models for how AI works conceptually: AI as pattern recognition, prediction, decision support, and a system shaped by data, people, workflows, and governance.A major focus of the course is helping Product Owners understand the limits of AI. Learners examine why AI lacks common sense, intent, true reasoning, and full contextual understanding. They also study common AI risks such as bias, overconfidence, automation bias, silent failures, poor data quality, and reputational damage. These lessons are grounded in product and business realities, not technical theory.The course also shows where AI performs well: forecasting, classification, recommendations, anomaly detection, repetitive judgment automation, search, personalization, fraud detection, operations, customer support, and decision support workflows. Learners explore how AI creates value through revenue growth, cost reduction, risk mitigation, speed, productivity, and improved customer experiences.Throughout the course, learners evaluate AI across real-world sectors including healthcare, finance, retail, HR, government, public services, and enterprise platforms. They learn how to assess vendors, avoid AI vaporware, understand lock-in risks, and measure AI value using meaningful business outcomes rather than vanity metrics.By the end of the course, learners will be able to ask better AI questions, identify weak AI ideas early, communicate AI limits to executives, evaluate AI readiness, and apply a practical AI judgment framework. This course prepares Product Owners to bridge business, technology, and governance with confidence. It is ideal for leaders who want to make smarter AI product decisions, avoid costly mistakes, and build AI systems that create trusted, measurable business value.

Master Enterprise Data Management: DAMA-DMBOK Framework

Udemy Instructor

Welcome to the ultimate guide to mastering enterprise data! In today’s digital economy, data is arguably the most valuable asset an organization possesses, but only if it is managed, protected, and utilized effectively. This comprehensive course is designed to take you from the fundamental principles of data management to the advanced strategies required to lead data initiatives. Grounded in industry best practices and the DAMA-DMBOK framework, this curriculum provides a step-by-step roadmap to understanding corporate data architecture, ensuring high-quality insights, and driving massive business value.We begin by establishing a strong foundation in data management, exploring exactly why data must be treated and valued as a tangible business asset. In this initial phase, you will gain a clear, high-level understanding of the industry-standard DAMA-DMBOK framework, which will serve as our structural guide throughout your learning journey.Next, we tackle the critical concepts of data governance and organizational control. You will learn how to establish the purpose and scope of a governance program, clearly define critical roles, policies, and decision rights, and build robust data stewardship and accountability models to keep your organization aligned.Moving into the technical design elements, we will explore enterprise data architecture. You will discover how to translate business requirements into conceptual, logical, and physical data models while adhering to strict, professional modeling principles and design standards.With the architecture mapped out, we will focus on data storage, warehousing, and integration. You will understand various storage technologies, differentiate between analytical stores like data warehouses and data lakes, and learn how to design seamless data flow architectures to integrate information across the enterprise.Because unreliable information costs businesses millions, we will thoroughly examine data quality management. You will learn to identify the key dimensions of data quality, assess the true impact and root causes of poor data, and implement proven quality management frameworks to permanently resolve those issues.We then dive into the crucial connective tissue of your data environment by exploring metadata, master data, and reference data. You will see how metadata provides essential business context, learn the fundamentals of Master Data Management (MDM) to create a single source of truth, and understand how to control reference data domains.Protecting your assets is paramount, which is why we thoroughly cover data security, privacy, and ethics. You will learn the core principles of data security through the CIA triad, navigate complex data privacy regulations, and establish corporate guidelines for responsible and ethical data usage.Beyond traditional rows and columns, we will address the massive digital footprint of document, content, and unstructured data. You will learn how to manage standard documents alongside complex unstructured data, successfully tracking the information lifecycle from creation to final archiving.We will then bridge the gap between backend data management and business-facing insights. You will learn exactly how strong data management practices serve as the vital, underlying engine powering accurate Business Intelligence (BI) and advanced analytics.To ensure your corporate initiatives are on the right track, we will look at maturity models and strategic alignment. You will learn how to assess your organization's current data management maturity and tightly align your ongoing data efforts with overarching business goals.From there, we focus on execution through strategy, planning, and operating models. You will learn how to draft a comprehensive data strategy, choose the most effective operating model for your data teams, and implement frameworks for continuous assessment and improvement.We also cover the essential defensive strategies of data risk and regulatory compliance. You will discover how to proactively identify and manage data-related business risks while ensuring your operational practices fully comply with evolving global regulations.Finally, we bring everything together by focusing on the cultural and future-facing aspects of the industry. You will learn the steps required to build a fully data-driven organization from the ground up, while exploring the emerging technologies that will dictate the future of data management.Whether you are an aspiring data steward, an experienced data architect, or a business leader looking to harness the power of your organization's information, this course provides the exact tools and practical knowledge you need. By the end of this journey, you will possess a complete, professional-grade understanding of enterprise data management ready to be applied in the real world. Enroll today to transform your data career!

Data Analytics Masters 2026 - From Basics To Advanced

Dr. Satyajit Pattnaik

Welcome to the Data Analytics Master's CourseCourse OverviewWelcome to your journey into the world of Data Analytics! This comprehensive course is designed to equip you with the essential skills and knowledge required to excel in the field of data analytics. Whether you are a beginner or looking to enhance your existing skill set, this course covers everything from foundational concepts to advanced applications.What You Will LearnThis course is structured into several modules, each focusing on a critical aspect of data analytics:Introduction to Generative AIExplore the latest advancements in AI tools like ChatGPT and Grok.Understand how these tools can help in your journey.Python for Data AnalysisLearn the basics of Python and its libraries, including Pandas, NumPy, and Matplotlib.Engage in hands-on exercises to manipulate and visualize data effectively.Exploratory Data Analysis (EDA)Understand the importance of EDA in data analytics.Gain skills in data cleaning, transformation, and visualization techniques.Statistics for Data AnalyticsExplore key statistical concepts and their applications in data analysis.Apply statistical methods using real-world datasets.SQL for Data ManagementLearn how to interact with databases using SQL.Develop skills to write complex queries and manage data effectively.Microsoft Excel for Data AnalysisMaster Excel's powerful features for data analysis.Use functions, pivot tables, and charts to derive insights.Data Visualization with Power BI and TableauCreate interactive dashboards and reports using Power BI and Tableau.Understand best practices for effective data visualization.Microsoft Fabric with Power BI Integration (NEW)Explore the capabilities of Microsoft Fabric as a powerful datasource for Power BI, enabling seamless data integration.Gain hands-on experience with lakehouse architecture and KQL to enhance your data analysis skills in a collaborative environment.Predictive AnalyticsDive into predictive modeling techniques.Learn to build and evaluate models using machine learning algorithms.ETLBasicsETLbasics, difference between ETLvs ELTData warehousing theoretical concepts.Interview GuidesPrepare for your job search with tailored interview guides.Learn common interview questions and strategies to present your skills effectively.Real-World Role Play Simulations for Analysts (NEW)Course StructureEnd-to-End Projects: Apply your knowledge in real-world scenarios with guided projects.Theory & Practicals: Each module combines theoretical knowledge with practical exercises to reinforce learning.Quizzes: Test your understanding and retention of the material with quizzes at the end of each module.RolePlay:Real-World Role Play Simulations for Analysts (NEW)Learning ExperienceThis course is designed to be interactive and engaging. You'll have access to:Video Lectures: Clear and concise video tutorials for each topic.Discussion Forums: Connect with fellow students and instructors to share insights and ask questions.Resources: Downloadable resources and additional reading materials to support your learning.Your Journey BeginsWe are excited to have you on board! This course aims to provide you with a well-rounded foundation in data analytics, preparing you for a successful career in this rapidly growing field. As you progress, remember to leverage the tools and techniques introduced, especially the innovative AI tools that can streamline your workflow and enhance your analytical capabilities.Get StartedDive into the first module and start your journey today! Your future in data analytics awaits.

5.0•16.4K•Self-paced

FREE$92.99

Enroll

Excel Power Query 2 - Erweitere Transformationen von Daten

About this course

Skills you'll gain

Available Coupons

Course Information

This course includes:

Share this course

You May Also Like

AI Fundamentals for Business

Master Enterprise Data Management: DAMA-DMBOK Framework

Data Analytics Masters 2026 - From Basics To Advanced

Excel Power Query 2 - Erweitere Transformationen von Daten

About this course

Skills you'll gain

Available Coupons

Course Information

This course includes:

Share this course

You May Also Like

AI Fundamentals for Business

Master Enterprise Data Management: DAMA-DMBOK Framework

Data Analytics Masters 2026 - From Basics To Advanced