Collect & Transform Data Using Power Query in Excel & Power BI ISI-1522

Upcoming dates

See every class on the schedule

About this class

What you'll be able to do

• Describe classic data analysis with Excel
• Describe Excel pivot tables
• Describe the limitations of classic data analysis with Excel
• 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
• Describe an Excel data model
• View data within an Excel data table
• Describe DAX
• 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 : Impor ting Data from a CSV File
• Import and Transform Data from a CSV File
• Add Data from a Folder
• Import data into excel.
• Shape and transform data.
• Load data.
• 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
• 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 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
• Import data from Excel reports.
• Transform Excel report data.
• Module 6: Creating and Formatting Measures
• This module describes how to create and format measures.
• Lessons
• DAX
• Meas ures
• Advanced DAX Functions
• Lab : Creating Measures using Advanced DAX Functions
• Last year comparison
• Year to date
• Market Share
• 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 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
• 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 E xcel 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
• Upload Excel data to Power BI.
• Describe the Power BI App.
• Course ISI-1522 3 Days Instructor -led, Hands on
• Course Information
• The main purpose of this three-day, instructor -
• with Power BI
• add BI techniques to Excel data analysis. The course goes beyond the capabilities of
• tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.
• This course is intended for students who are experienced with analyzing data with Excel
• to add BI techniques.
• The course will likely be attended by SQL Server report creators who are interested in
• alternative methods of presenting data.
• Explore and extend a classic E xcel dashboard.
• Explore and extend an Excel data model.
• Pre -format and import a .CSV file.
• Import data from a SQL Server database

Course outline

Before you attend