Udemyintermediatepl

Wszystko co chcesz wiedzieć o tabelach przestawnych

Boost productivity & analyze data! Learn how to shorten work hours and leverage powerful analytics tools. Discover efficiency secrets now.

4.7(116)
640students
6h 2m
Certificate
Norbert Waszak
Norbert WaszakTworzę Ekspertów z ciekawości

Course Content

Wszystko co chcesz wiedzieć o tabelach przestawnych is an intermediate-level Udemy course taught by Norbert Waszak. It runs 6h 2m, is taught in Polish, and includes a certificate of completion. Learners rate it 4.7 out of 5 from 116 reviews, with 640 students enrolled. It is a paid course, first published March 2020.

  • Data Preparation & Data Structures: Learn the essential steps for preparing your data for analysis. Understand different data structures and explore various data sources, including how TP utilizes data.

  • Pivot Table Design: Master the art of creating powerful pivot tables. We'll cover best practices for designing effective pivot tables to extract meaningful insights.

    • Understanding the Difference: Table vs. Range - Clarify the distinction between using a table and a range as your data source.
    • Working with Dates in Excel - Get a solid grasp of how to handle and manipulate dates within your pivot tables.
  • Data Analysis with Pivot Tables: Unlock the power of pivot tables for in-depth data analysis.

    • Transforming Functions: Discover how to modify functions within your pivot tables to tailor your analysis.
    • Calculating Percentages: Easily display data as percentages to highlight key trends.
    • Quantity vs. Quality: Analyze the relationship between quantity and quality within your datasets.
    • Pivot Table Formatting: Learn to format your pivot tables for clear and impactful presentation.
    • Drilling Down for Details: Explore how to quickly access detailed information within your pivot tables.
    • Report Filter Pages: Understand and utilize report filter pages for dynamic data exploration.
    • Time Series Analysis: Master date grouping techniques for analyzing data over time.
      • Grouping by Week: Group data by week for weekly trend analysis.
      • Grouping Numerical Values: Group numerical data for aggregated insights.
      • Identifying Top Performers Over Time: Determine who has the highest average performance over a specified period.
      • Year-over-Year Comparison (% Difference): Calculate and interpret year-over-year growth or decline percentages.
    • Calculated Fields: Create custom calculated fields to derive new metrics from your existing data.
    • Using the "Get Data" Function: Leverage the "Get Data" function for advanced data manipulation.
    • Multiple Filters in One Field: Apply multiple filters to a single field for refined data filtering.
  • Pivot Charts: Visualize your data effectively with pivot charts.

    • Why Use Pivot Charts? Understand the benefits of using pivot charts compared to standard charts.
    • Dual-Axis Charts: Learn when and how to use charts with two axes for complex data representation.
    • Line Charts: Create compelling line charts to illustrate trends and patterns.
    • Visualizing Trends (Spikes & Dips): Identify significant spikes and dips in your data through visual representation.
  • Power Pivot: Elevate your data analysis with Power Pivot.

    • The Importance of Relationships: Understand the foundational role of relationships in Power Pivot.
    • Data Sources Across Multiple Sheets: Connect data from multiple sheets within a single Excel workbook.
    • Data Sources from Various Files: Import data from diverse files, including different formats and sources.
    • Measures in Power Pivot: Create powerful measures to perform complex calculations.
$ whoami — the devs behind tutorialsearch.io

Want AI in your product? Hire the team behind TutorialSearch.io

LLM features, RAG, agents and automation wired into a real product — built by the devs who shipped this site.

3.9(6)
2h 57m
beginner
5.0(7)
5h 48m
all

Bachata Men Styling

by Dawid Gnatowski

5.0(47)
1h 11m
all
5.0(52)
1h 58m
all

Jak Zostać Sołtysem

by Michał Kata

5.0(1)
2h 38m
all