Analyzing Data with Excel
Analyzing Data with Excel

Analyzing Data with Excel

11.850,00 kr

## Beskrivelse

OBS: Dette kursus udgår d. 31/1 2021 til fordel for Microsofts nye Power BI kursus DA-100. Til dette nye kursus knytter sig en selvstændig Microsoft Role-based certificering.


På kurset lærer du at bruge Excel til mere avanceret dataanalyse med BI-teknikker. Du lærer bl.a. om Pivot Charts, Excel Data Model, og om hvordan man laver et Power BI dashboard med Excel. Efter du har været på dette kursus vil du være i stand til:

  • Undersøge og udvide et klassisk Excel dashboard
  • Undersøge og udvide en Excel data model
  • Transformere og importere .CSV filer
  • Importere data fra en SQL Server database
  • Importere data fra en report
  • Oprette measures ved hjælp af avancerede DAX funktioner
  • Oprette datavisualiseringer i Excel
  • Oprette et Power BI dashboard med Excel Kurserne MS-778 - Analyzing Data with Power BI og MS-779 - Analyzing Data with Excel kan tages i vilkårlig rækkefølge. Vi anbefaler dog at starte med MS-779.
...%%%

...

Indhold


Module 1: Data Analysis in Excel

  • This 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 Analysis
  • Lab : Building a Classic Excel Dashboard
  • Filtering and Formatting Data
  • Building a Pivot Table
  • Building a Pivot Chart
  • Building a Dashboard Module 2: The Excel Data Model
  • This module looks at the classic Excel data model and at ways to extend it.
  • Lessons
  • Using an Excel Data Model
  • DAX
  • Lab : Explore an Excel Data Model
  • Create Calculated Columns
  • Format Data Model Data
  • Create Measures
  • Analyze the Data Module 3: Importing Data from Files
  • This module looks at pre-formatting and importing CSV files.
  • Lessons
  • Importing Data into Excel
  • Shaping and Transforming Data
  • Loading Data
  • Lab : Importing Data from a CSV File
  • Import and Transform Data from a CSV File
  • Add Data from a Folder Module 4: Importing Data from Databases
  • This 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 Data
  • Lab : Import Data from Multiple Sources
  • Import Data from SQL Server
  • Import Data from a CSV File
  • Create a Data Table Module 5: Importing Data from Excel Reports
  • This module describes how to import data from a report.
  • Lessons
  • Importing Data from Excel Reports
  • Transforming Excel report Data
  • Lab : Importing Data from a Report
  • Import Data from Excel
  • Transform the Excel Data
  • Load the Data into an Excel Data Model Module 6: Creating and Formatting Measures
  • This module describes how to create and format measures.
  • Lessons
  • DAX
  • Measures
  • Advanced DAX Functions
  • Lab : Creating Measures using Advanced DAX Functions
  • Last year comparison
  • Year to date
  • Market Share Module 7: Visualizing Data in Excel
  • This module describes how to visualize data in Excel.
  • Lessons
  • Pivot Charts
  • Cube Functions
  • Charts for Cube Functions
  • Lab : Data Visualization in Excel
  • Create a Tabular Report
  • Create a Pivot Chart
  • Add Slicers to Charts Module 8: Using Excel with Power BI
  • This module describes how to use Excel with Power BI.
  • Lessons
  • Power BI
  • Uploading Excel Data to Power BI
  • Power BI Mobile App
  • Lab : Creating a Power BI Dashboard with Excel
  • Uploading Excel Data
  • Creating a Power BI Dashboard