WEBINAROUTLINE

Data Import and Connectivity

• Connecting to Excel and other data sources
• Understanding datasets and data models

Data Transformation using Power Query

• Cleaning and shaping raw data
• Key transformations:

       o  Date Functions (extracting year, month, day)

       o  Text Functions (splitting, merging, formatting text)

       o  Number Functions (rounding, calculations)

• Removing errors, handling missing values

Data Visualization and Reporting

• Creating visuals in Report View:

        o  Charts (bar, line, pie)

       o  Tables and matrices

• Customizing visuals:

        o  Formatting, labels, and themes

        o  Applying filters and slicers for interactivity