เรียน Power BI รวมคอร์สเต็ม Data Viz Cleaning Joining DAX

Learn Power BI: Data Visualization, Cleaning, Joining & DAX - Zero to Hero

This comprehensive Power BI course is designed for beginners – no prior experience is necessary! Master data visualization, data cleaning, data joining, and DAX to unlock valuable data insights for your business. This Power BI training offers a hands-on, workshop-based approach to take you from a complete novice to a confident Power BI user.

What You'll Learn:

• Power BI Fundamentals: Get started with the Power BI program and learn how to create impactful data visualizations.
• Data Visualization & Analytics: Transform raw data into compelling visuals to uncover hidden trends and gain actionable insights.

Course Modules:

1. Power BI Introduction & Basic Visualization

• Workshop 1: Comparison Charts: Learn to create various comparison charts, including Bar Charts, Column Charts, and Line Charts, and customize them for clear communication. Includes adjustments for X-Y Axis, Data Labels, Colors, and Legends.
• Workshop 2: Relationship Charts: Build Relationship Charts like Stacked Column Charts and Line Charts to analyze data relationships. Customize Legends, Colors, and Data Labels for enhanced clarity.
• Workshop 3: Composition Charts: Master Pie Charts, Donut Charts, Card Visuals, and Tree Maps to represent parts of a whole. Customize Category Labels and Colors.
• Workshop 4: Distribution Charts: Create Scatter Charts to visualize data distributions and identify correlations.
• Workshop 5: Dynamic Dashboards: Build interactive dashboards to tell data stories and effectively present your findings using Power BI Service.

2. Sales Dashboard Creation

• Workshop 6: Sales Dashboard (Bar Charts): Develop powerful Sales Dashboards using various Bar Chart types – Horizontal Bar, Grouped Bar, Vertical Gradient Bar – and utilize Slicers for data filtering.
• Workshop 7: Sales Dashboard (Line Charts): Create insightful Sales Dashboards with Line Charts, including Multiple Line Charts, Trend Lines, Stacked Area Charts, and Small Multiple Line Charts.
• Workshop 8: Sales Dashboard (Combo Charts): Combine Column Charts and Line Charts in Combo Charts to visualize different data sets effectively.
• Workshop 9: Sales Dashboard (Pie Charts): Further explore Pie Charts, Donut Charts, Card Visuals, and Tree Maps for comprehensive sales analysis.
• Workshop 10: Sales Dashboard (Maps): Visualize sales data geographically using Maps in Power BI.

3. Data Cleaning with Power BI

• Workshop 1: Data Cleaning from Websites: Learn to import, rename, and clean data directly from websites. Focuses on data cleaning techniques like removing unwanted rows/columns and identifying top-ranking data.
• Workshop 2: Data Cleaning from Files: Master data cleaning techniques for data imported from various file types. Covers importing, changing data types, trimming text, replacing values, adding columns, removing columns, merging columns, and grouping data.
• Workshop 3: Advanced Data Cleaning: Explore advanced data cleaning methods like pivot/unpivot operations and data visualization techniques for identifying data inconsistencies.

4. Data Joining in Power BI

• Workshop 1: Data Joining: Learn to join data from multiple tables in Power BI, edit relationships, and merge queries for a unified data model.
• Workshop 2: Data Joining: Reinforce data joining skills with more complex scenarios, including editing relationships, merging queries, and appending data.
• Workshop 3: Data Joining & Visualization: Practice data joining with scatter plots and create new data sets for enhanced analysis.

5. DAX for Data Analysis & KPIs

• Workshop 1: DAX Aggregate Functions: Master essential DAX aggregate functions like SUM, AVG, MIN, MAX, COUNT, and COUNT DISTINCT.
• Workshop 2: DAX Calculation & Measures: Learn to create custom DAX calculations and measures for calculating Gross Profit Margin, Cost, and other key metrics.
• Workshop 3: DAX Conditional Statements: Utilize DAX conditional statements (logical and value-based) to create dynamic calculations and