Analyzing Data with Excel
€1640, aangeboden door Master it Training
Het hoofddoel van deze training is om Business Intelligence (BI) kennis toe te kunnen passen op normale Excel data analyses. Deze training gaat verder dan alleen tabellen en grafieken en gebruikt draaitabellen, het Excel Data Model en Power BI.Na het volgen van de training kun je: Het Excel Dashboard gebruiken en uitbreiden Een Excel data model gebruiken en uitbreiden Een .csv file preformatteren en importeren Data uit een SQL Server database importeren Data uit een rapport importeren Metingen maken met gebruik van geavanceerde DAX functies Data visualisaties maken in Excel Een Power BI dashboard maken in Excel
Let op. Deze training is exclusief het examen.
Doelgroep
Deze cursus is bedoeld voor iedereen die verantwoordelijk is voor het analyseren van data in Excel. Daarnaast kan deze cursus gevolgd worden door mensen die SQL Server rapporten maken, en die geïnteresseerd zijn in alternatieve methoden om hun data te presenteren.
Voorkennis voor de Analyzing Data with Excel training
Voor het volgen van deze training is de volgende voorkennis nodig: Basiskennis over het Microsoft Windows besturingssysteem en zijn hoofdfunctionaliteiten Kennis over Excel spreadsheets, functies en grafieken.
Onderwerpen in de Analyzing Data with Excel training
Module 1: Data Analysis in ExcelThis module looks at the classic Excel dashboard and at ways to extend it.Lessons Classic Data Analysis with Excel Excel Pivot Tables Limitations of Classic Data AnalysisLab : Building a Classic Excel Dashboard Filtering and Formatting Data Building a Pivot Table Building a Pivot Chart Building a DashboardAfter completing this module, students will be able to: Describe classic data analysis with Excel Describe Excel pivot tables Describe the limitations of classic data analysis with Excel Module 2: The Excel Data ModelThis module looks at the classic Excel data model and at ways to extend it.Lessons Using an Excel Data Model DAXLab : Explore an Excel Data Model Create Calculated Columns Format Data Model Data Create Measures Analyze the DataAfter completing this module, students will be able to: Describe an Excel data model View data within an Excel data table Describe DAX Module 3: Importing Data from FilesThis module looks at preformatting and importing CSV files.Lessons Importing Data into Excel Shaping and Transforming Data Loading DataLab : Importing Data from a CSV File Import and Transform Data from a CSV File Add Data from a FolderAfter completing this module, students will be able to: Import data into excel. Shape and transform data. Load data. Module 4: Importing Data from DatabasesThis module looks at how to import data into Excel from a SQL Server database.Lessons Available Data Sources Previewing, Shaping, and Transforming Data Table Relationships and Hierarchies Loading DataLab : Import Data from Multiple Sources Import Data from SQL Server Import Data from a CSV File Create a Data TableAfter completing this module, students will be able to: Identify available data sources. Preview, shape, and transform data. Explain table relationships and hierarchies. Load data from various sources. Module 5: Importing Data from Excel ReportsThis module describes how to import data from a report.Lessons Importing Data from Excel Reports Transforming Excel report DataLab : Importing Data from a Report Import Data from Excel Transform the Excel Data Load the Data into an Excel Data ModelAfter completing this module, students will be able to: Import data from Excel reports. Transform Excel report data. Module 6: Creating and Formatting MeasuresThis module describes how to create and format measures.Lessons DAX Measures Advanced DAX FunctionsLab : Creating Measures using Advanced DAX Functions Last year comparison Year to date Market ShareAfter completing this module, students will be able to: Explain what DAX is and when to use it. Describe a measure. Use some of the advanced functions within DAX. Module 7: Visualizing Data in ExcelThis module describes how to visualize data in Excel.Lessons Pivot Charts Cube Functions Charts for Cube FunctionsLab : Data Visualization in Excel Create a Tabular Report Create a Pivot Chart Add Slicers to ChartsAfter completing this module, students will be able to: Create and refine a pivot chart. Describe cube functions and when to use them. Describe a number of charts for use with cube functions. Module 8: Using Excel with Power BIThis module describes how to use Excel with Power BI.Lessons Power BI Uploading Excel Data to Power BI Power BI Mobile AppLab : Creating a Power BI Dashboard with Excel Uploading Excel Data Creating a Power BI DashboardAfter completing this module, students will be able to: Describe Power Bi and the various versions available. Upload Excel data to Power BI. Describe the Power BI App.