Basic Excel Business Analytics - Clean & Transform Data - Formulas, Flash Fill, Power Query, Text To Columns
Aprenda técnicas avançadas para limpar e transformar dados no Excel, incluindo fórmulas, Flash Fill, Power Query e Text to Columns, preparando-os eficientemente para análise.
The Magic of Power Query to Import, Transform & Load Data
Learn to import, clean, and transform data using Power Query in Excel. Master techniques for efficient data handling, report creation, and automated updates.
Introduction to Power Query & Power Pivot Data Model in Excel 2016
Learn to clean data, create PivotTables, and use Power Query and Power Pivot in Excel 2016. Master data transformation, import large datasets, and build efficient data models for advanced analysis.
Power BI for Accountants - Complete Introduction to Power BI Desktop to Build Reports & Dashboards
Learn to create dynamic sales reports and dashboards using Power BI Desktop. Master data import, cleaning, transformation, and visualization techniques for effective financial analysis and monitoring.
Excel for Accountants - Power Query & PivotTables to Import & Clean Data and Build Reports
Learn to import, clean, and analyze data using Power Query and PivotTables. Master techniques for efficient data management, creating insightful reports, and optimizing file size in Excel for accounting purposes.
Excel Basics - Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set
Learn to use Power Query in Excel for data cleaning, transformation, and analysis. Master importing, combining, and refreshing data from various sources to create proper datasets and pivot tables.
Excel Power Query - Get & Transform
Simplify data transformation and analysis with Power Query. Learn to import, clean, and combine data from various sources, automate repetitive tasks, and create dynamic reports effortlessly.
NumPy Data Science Essential Training With Python 3
Master NumPy for data science: arrays, indexing, computation, visualization, and statistical analysis. Hands-on practice with Python 3 and Jupyter Notebook for real-world applications.
Read and Manipulate Text Files in Julia - Week 4 Lesson 2
Learn to process text files in Julia, transforming them into word arrays and analyzing content through word and phrase counting techniques.
Data Wrangling Techniques in Julia - Part 2 - Tom Kwong
Explore advanced data wrangling techniques in Julia, covering reading, cleaning, tidying, analyzing, and visualizing data using two sample datasets for practical application.
Ten Excel Tips That Are Easy to Learn - Part 2
Learn 10 essential Excel skills including macros, named ranges, page breaks, heat maps, and pie charts to enhance your spreadsheet proficiency and productivity.
Excel 2021 Expert Tutorial
Master advanced Excel 2021 features: nested functions, database operations, XLOOKUP, UNIQUE, SORT, FILTER, LET, data consolidation, and macros for enhanced productivity and data analysis skills.
Pivot Tables Excel - Detailed Beginners Pivot Table Tutorial
Comprehensive tutorial on creating and manipulating Pivot Tables in Excel, covering data preparation, table creation, field management, aggregation methods, and advanced formatting techniques.
Advanced Pivot Tables Tutorial in Excel
Comprehensive tutorial on advanced Excel pivot tables, covering data import, cleaning, manipulation, and formatting. Ideal for intermediate users seeking to enhance their data analysis skills.
Power BI Crash Course for Beginners
Learn to import, analyze, and visualize data using Power BI Desktop. Master data cleaning, DAX, Power Query, and create insightful visualizations for effective business intelligence.
Between the Spreadsheets - Classifying and Fixing Dirty Data for Data Science
Learn to identify, clean, and manage dirty data for accurate insights and decision-making. Discover real-life examples, quick Excel fixes, and best practices to elevate your data analysis skills.
Data Analysis in Excel - Important Excel Skills for Data Analysts
Master essential Excel skills for data analysis, including cleaning functions, pivot tables, and data visualization techniques to enhance your analytical capabilities.
Intermediate Microsoft Excel Tutorial - How to Use Power Query
Learn Power Query in Excel: Import, transform, and consolidate data efficiently. Master data cleaning, column manipulation, merging tables, and formula creation for streamlined data management.
Alteryx Advanced Training - Expert Course on Data Analysis Using Alteryx
Master advanced Alteryx techniques for data processing and analysis, including Calgary for large databases, cleaning, manipulation, and in-database operations. Enhance your skills with hands-on practice using downloadable files.
Introduction to Data Analysis with Excel
Learn Excel data analysis essentials: navigate, format, use formulas, import data, clean datasets, and apply functions. Hands-on exercises included for practical skill development.
Offene parlamentarische Daten – eine Schatzsuche
Entdecke die Herausforderungen und Lösungen bei der Suche nach maschinenlesbaren Daten deutscher Parlamente. Lerne praktische Techniken zur Datenextraktion und -analyse mit Python/Pandas.