Προαπαιτούμενα:
- Βασικές γνώσεις του λειτουργικού συστήματος Microsoft Windows και βασική λειτουργικότητά του
- Εκτεταμένη γνώση υπολογιστικών φύλλων του Excel, συμπεριλαμβανομένων τύπων, διαγραμμάτων, φιλτραρίσματος, διαλογής και υποσύνολα
- Γνώσεις εργασίας σχεσιακών βάσεων δεδομένων
1. Data Analysis in Excel
- Classic Data Analysis with Excel
- Excel Pivot Tables
- Limitations of Classic Data Analysis
- Building a Classic Excel Dashboard
- Formatting Data
- Building a Pivot Table
- Adding pivot charts and a slicer
2. The Excel Data Model
- Using an Excel Data Model
- DAX
- Explore an Excel Data Model
- Create Calculated Columns
- Format Data Model Data
- Create Measures
- Analyze the Data
3. Importing Data from Files
- Importing Data into Excel
- Shaping and Transforming Data
- Loading Data
- Importing Data from a CSV File
- Import and Transform Data from a CSV File
- Add Data from a Folder
4.Importing Data from Databases
- Available Data Sources
- Previewing, Shaping, and Transforming Data
- Table Relationships and Hierarchies
- Loading Data
- Import Data from Multiple Sources
- Import Data from SQL Server
- Import Data from a CSV File
- Create a Data Table
5. Importing Data from Excel Reports
- Importing Data from Excel Reports
- Transforming Excel report Data
- Importing Data from a Report
- Import Data from Excel
- Transform the Excel Data
- Load the Data into an Excel Data Model
6. Creating and Formatting Measures
- DAX
- Measures
- Advanced DAX Functions
- Creating Measures using Advanced DAX Functions
- Last year comparison
- Year to date
- Market Share
7. Visualizing Data in Excel
- Pivot Charts
- Cube Functions
- Charts for Cube Functions
- Data Visualization in Excel
- Create a Tabular Report
- Create a Pivot Chart
- Add Slicers to Charts
8. Using Excel with Power BI
- Power BI
- Uploading Excel Data to Power BI
- Power BI Mobile App
- Creating a Power BI Dashboard with Excel
- Uploading Excel Data
- Creating a Power BI Dashboard
- Using Power BI desktop