Power Pivot - Big Data, Data Modeling, DAX & Dashboards
Aprenda a modelar dados, criar fórmulas DAX e construir dashboards usando Power Pivot. Importe dados SQL, crie tabelas de datas e explore recursos avançados para análise de negócios eficiente no Excel.
Data Modeling - VLOOKUP, Power Query or Power Pivot?
Learn data modeling techniques using VLOOKUP, Power Query, and Power Pivot for efficient data analysis in Excel. Explore methods for handling multiple tables and creating effective PivotTable reports.
Power BI Desktop Comprehensive Introduction - Power Query, DAX, Dashboards, Publishing
Comprehensive Power BI Desktop tutorial covering data import, DAX formulas, dashboard creation, and report publishing. Master essential skills for effective data analysis and visualization.
Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions
Comprehensive guide to Excel Power Pivot, DAX formulas, and functions. Learn data modeling, building relationships, and creating advanced calculations for powerful business intelligence dashboards.
Power Query Introduction - Importing & Transformation Data in Excel & Power BI Desktop
Comprehensive introduction to Power Query for data importing, cleaning, and transformation in Excel and Power BI Desktop, with practical examples and hands-on exercises.
Data Analysis Business Intelligence Terms - Microsoft Power Tools for Data Analysis Class
Comprehensive overview of data analysis and business intelligence concepts, including data types, models, and database structures for effective data management and analysis.
Power Query Power BI - Transform 2 Fact Tables to Star Schema Data Model - Invoice Data
Transform invoice data into a star schema using Power Query, creating a single fact table for improved reporting and analysis in Power BI Desktop.
Ctrl - Shift - Enter- Excel Array Formulas - Formulas to Extract Records With Criteria
Master advanced Excel array formulas for efficient data extraction, including AND/OR criteria, INDEX, SMALL, and AGGREGATE functions. Optimize spreadsheet performance with practical examples and timing comparisons.
Ctrl - Shift - Enter - Excel Array Formulas - Review Formula Basics
Comprehensive tutorial on Excel array formulas, covering formula basics, advanced functions, and practical applications for efficient data analysis and problem-solving.
Create Ad Flyer in Word - Create PDF and Web Page Files with Save As
Learn to create professional ad flyers in Word, including formatting, images, borders, and exporting to PDF and web formats. Master essential Word skills for effective document creation.
Hack Data Model, Date Table & DAX Measures Without Buying Power Pivot
Master advanced Excel techniques: build data models, create DAX measures, and use functions like CALCULATE and TOTALYTD. Learn to optimize PivotTables and implement variables for efficient data analysis.
Introduction to Databases & Access
Comprehensive introduction to databases and Microsoft Access, covering key concepts, objects, data management, and comparison with Excel for effective data analysis and organization.
C++ Tutorial for Beginners - Learn C++ in 1 Hour
Comprehensive introduction to C++ programming, covering basics like variables, data types, and console I/O. Ideal for beginners seeking a quick start in C++ development.
Python Django Tutorial for Beginners
Learn Django for backend development: create projects, apps, views, and data models. Master debugging tools and build production-grade web applications with Python.
Docker Tutorial for Beginners
Learn Docker essentials for software and DevOps engineering careers. Covers architecture, installation, workflow, Linux basics, and practical implementation for effective application packaging and deployment.
HTML Tutorial for Beginners - HTML Crash Course
Comprehensive beginner's guide to HTML, covering essential concepts and practical skills for web development, from basic structure to hyperlinks and images.
Python Machine Learning Tutorial - Data Science
Learn to predict music preferences using Python and machine learning. Covers data preparation, model training, accuracy calculation, and decision tree visualization in a hands-on tutorial.
Git Tutorial for Beginners - Learn Git in 1 Hour
Comprehensive introduction to Git version control, covering installation, configuration, basic commands, and best practices for effective project management and collaboration.
React Native Tutorial for Beginners - Build a React Native App
Learn to build cross-platform mobile apps for iOS and Android using React Native. Covers fundamental concepts, debugging, layouts, and practical exercises for creating functional user interfaces.
Learn Redux from Scratch
Learn Redux from scratch: functional programming concepts, Redux architecture, and building your first Redux application with practical examples and exercises.
Design Patterns in Plain English - Mosh Hamedani
Learn design patterns through real-world examples and simple explanations. Covers essential concepts, Memento and State patterns, and potential pitfalls in pattern usage.