Dieser 3-Tages-Kurs zeigt Ihnen wie man BI Techniken zu Excel Daten Analysen addiert. Diese Schulung geht durch die Kapazität der Tabellen und Charts und macht sich Pivot Charts, Excel Data Model und Power BI zu Nutze.

• SQL Server | Data Management Bildungswege
• Microsoft 365 Bildungswege
• Office & Office 365 Bildungswege
• Cloud & Microsoft Azure Bildungswege

Folgende Kenntnisse wären erforderlich:

• Basis-Wissen von Windows
• Wissen von relationalen Datenbanken
• Wissen von Excel Tabellen mit Formeln, Chartes, Filtern, Sortierung
• Basiswissen von Daten-Analysen in Excel wie z.B. aus unseren Kursen:
  • Optimierung von Geschäftsprozessen mit Microsoft Excel "Erweiterte Funktionen und Features zur Effizienzschaffung" (EXCF)
  • Produktivitätssteigerung mit Microsoft Excel "Gezieltes Analysieren und Auswerten in Excel" (EXCF1)
  • Microsoft PowerBI (POBI)
  • Data Analyis Fundamentals using Excel (MS10994)

• Module 1: Data Analysis in Excel
• Module 2: The Excel Data Model
• Module 3: Importing Data from Files
• Module 4: Importing Data from Databases
• Module 5: Importing Data from Excel Reports
• Module 6: Creating and Formatting Measures
• Module 7: Visualizing Data in Excel
• Module 8: Using Excel with Power BI

Prüfungs-Nummer

• 70-779 Analyzing Data with Microsoft Excel

• Analyzing Data with Power BI (MS20778)
• Data Analysis Fundamentals using Excel (MS10994)
• Analyzing Data with SQL Server Reporting Services (MS10990)
• Analyzing Big Data with Microsoft R (MS20773)
• Perform Cloud Data Science with Azure Machine Learning (MS20774)
• Microsoft Azure Big Data Analytics Solutions (MS552241)
• Operationalize Cloud Analytics Solutions with Microsoft Azure (MS552242)
• Performing Data Engineering on Microsoft HD Insight (MS20775)
• Data Driven Marketing: Big Data gezielt nutzen (BDDM)
• Analyzing Data with Excel (MS20779)
• Microsoft Cloud Workshop: Big Data & Visualization (MS40502)
• Cleveres Zusammenarbeiten mit Microsoft Teams unter Office 365 (OFFT)
• Office 365 Administration und Troubleshooting (MS10997)
• Microsoft 365 Fundamentals (MS-900T01)

Microsoft 365 Certified: Teamwork Administrator Associate

• Manage SharePoint and OneDrive in Microsoft 365, MS-040 (MS-040T00)
• SharePoint Hybrid Deployment and Migration, MS-050 (MS-050T00)
• Intensivkurs (Bootcamp) zum Microsoft 365 Certified Teamwork Administrator Associate MS-040 & MS-050 (MS-TEAMSI)
• Bundle: Microsoft 365 Certified Teamwork Administrator Associate MS-040 & MS-050 (Paketpreis) (MS-TeamsBD)

Microsoft 365 Certified: Modern Desktop Administrator Associate

• Windows 10, MD-100 (MSMD-100T00)
• Managing Modern Desktops, MD-101 (MSMD-101T00)
• Intensivkurs (Bootcamp) zum Microsoft 365 Certified Modern Desktop Administrator MD-100 & MD-101 (MSMD-ADMINI)
• Bundle: Microsoft 365 Certified Modern Desktop Administrator Associate MD-100 & MD-101 (MSMD-ADMINBD)

Microsoft 365 Certified: Security Administrator Associate

• Microsoft 365 Security Administration, MS-500 (MS-500T00)

Microsoft 365 Certified: Messaging Administrator Associate

• Microsoft 365 Messaging, MS-203 (MS-203T00)

Microsoft 365 Certified Enterprise Administrator

• Microsoft 365 Identity and Services, MS-100 (MS-100T00)
• Microsoft 365 Mobility and Security, MS-101 (MS-101T00)
• Bundle: Microsoft 365 Certified Enterprise Administrator MS-100 & MS-101 (MS-365CEAEBD)
• Intensivkurs (Bootcamp) zum Microsoft 365 Certified Enterprise Administrator MS-100 & MS-101 (MS-365CEAEI)
• Berufsbegleitender Lehrgang zum Microsoft 365 Certified Enterprise Administrator MS-100 & MS-101 (MS-365CEAEBB)

Microsoft Azure Administrator:

• Microsoft Azure Administrator AZ-104 (MSAZ-104T00)

Microsoft Azure Developer:

• Developing Sulutions for Microsoft Azure AZ-204 (MSAZ-204T00)

Microsoft Azure Solutions Architect:

• Microsoft Azure Architect Technologies, AZ-303 (MSAZ-303T00)
• Microsoft Azure Architect Design, AZ-304 (MSAZ-304T00)
• Bundle: Microsoft Azure Architect AZ-303 & AZ-304 (MSAZ-ARCHBD)
• Intensivkurs (Bootcamp) zum Microsoft Azure Architect AZ-303 & AZ-304 (MSAZ-ARCHI)
• Berufsbegleitender Lehrgang zum Microsoft Azure Architect AZ-303 & AZ-304 (MSAZ-ARCHBB)

Workshops:

• Microsoft Cloud Workshop: Big Data & Visualization (MS40502)
• Microsoft Cloud Workshop: Enterprise Ready Cloud (MS40503)
• Microsoft Cloud Workshop: Intelligent Vending Machines (MS40504)
• Microsoft Cloud Workshop: Internet of Things (MS40505)
• Microsoft Cloud Workshop: Lift and Shift/Azure Resource Manager (MS40506)
• Microsoft Cloud Workshop: Microservices & Serverless Architecture (MS40507-1)
• Microsoft Cloud Workshop: Microservices & Serverless Architecture (MS40507-2)
• Microsoft Cloud Workshop: Modern Cloud Apps (MS40508)
• Microsoft Cloud Workshop: OSS DevOps (MS40509)
• Microsoft Cloud Workshop: SQL Server Hybrid Cloud (MS40510)
• Microsoft Cloud Workshop: Intelligent Analytics (MS40516)
• Microsoft Cloud Workshop: Azure Security, Privacy, and Compliance (MS40527)
• Microsoft Cloud Workshop: Serverless Archtiecture (MS40535)
• Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack (MSAZ-600T00)
• Windows Server 2019 Bildungswege
• Microsoft Exchange Server Bildungswege
• Cloud & Microsoft Azure Bildungswege
• Microsoft 365 Bildungswege
• Office & Office 365 Bildungswege
• SQL Server | Data Management Bildungswege
• Sicherheit & Datenschutz Bildungswege
  
• Digitalisierung Bildungswege
• Microsoft Windows 10 Bildungswege
• Windows Server 2016 Bildungswege
• Microsoft Server Bildungswege
• Microsoft Exchange Server Bildungswege
• Microsoft Skype for Business Bildungswege
• SharePoint Bildungswege
• Development Bildungswege
• Apple Bildungswege
• CompTIA Bildungswege
• Eidg. ICT Fachausweise Bildungswege
• ITIL® Bildungsweg
• Publishing | Adobe | Web Technologien Bildungswege
• Projekt-Management Bildungswege
• Management | Führung Bildungswege
• Digitales Marketing | SEO Bildungswege