Kursbeskrivning
Unlock the full potential of Microsoft Excel with our immersive three-day course. Join us on a journey to master the Excel Power Tools, including Power Query, Power Pivot, and Data Modeling. Discover how to seamlessly integrate these powerful tools into your Excel workflow and supercharge your data analysis. Gain the skills to create dynamic PivotTables and captivating PivotCharts that will transform the way you work with data. Get ready to excel like never before!
Topics Day 1: Excel Data Analysis Fundamentals
Module 1: Data Analysis in Excel
Introduction to data analysis in Excel o Basic Excel functions and formulas for data analysis
Data cleaning and preparation techniques
Short exercises on data cleaning and basic analysis
Module 2: The Excel Data Model
Understanding data models in Excel
Relational databases vs. Excel data models
Creating relationships between tables
Hands-on practice in building a simple data model
Day 2: Data Import and Transformation
Module 3: Importing Data from Files
How to import data from various file formats (e.g., CSV, text, XML)
Data transformation using Power Query
Combining and appending data from multiple files
Practical exercises on importing and transforming external data
Module 4: Importing Data from Databases
Connecting to external databases (e.g., SQL Server, Access)
Querying and importing data o Data refresh and updates
Hands-on experience with database connections
Module 5: Importing Data from Excel Reports
Extracting data from Excel reports and workbooks
Handling structured and unstructured data
Transforming report data into usable formats
Practical examples of Excel report data extraction
Day 3: Advanced Data Modeling and Visualization
Module 6: Creating and Formatting Measures
Introduction to DAX (Data Analysis Expressions) for creating measures
Building custom calculations and metrics
Formatting and optimizing DAX measures
Hands-on exercises in creating measures
Module 7: Visualizing Data in Excel o Creating PivotTables and PivotCharts
Designing interactive dashboards
Tips for effective data visualization
Practical session on building dynamic reports
Module 8: Using Excel with Power BI
Overview of Power BI and its integration with Excel
Importing Excel data into Power BI o Building interactive reports and dashboards in Power BI
Demonstrations of Power BI integration with Excel
Kommande kursstarter
Intresseanmälan
Informator är utbildningsföretaget som stärker din konkurrenskraft genom att underhålla, uppdatera och tillföra relevant kunskap inom IT och management där och när du behöver det. Vi har vuxit tillsammans med svensk mjukvaruindustris ledande företag och utbildat utvecklare, tekniker, projektledare och chefer sedan...