• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
11/19/2018 11/21/2018
  • VLT
Live Online
12/17/2018 12/19/2018
  • VLT
Live Online

About the Course 

The primary motivation behind the course is to give understudies the capacity to add BI methods to Excel information investigation. The course goes past the abilities of tables and outlines and uses Pivot Charts, the Excel Data Model, and Power BI. 

Audience Profile

20779: Analyzing Data with Excel course is proposed for understudies who are knowledgeable about investigating information with Excel and who wish to include BI procedures. 

The course will probably be gone to by SQL Server report makers who are occupied with elective techniques for introducing information. 

At Course Completion

In the wake of finishing 20779: Analyzing Data with Excel course, understudies will have the capacity to: 

  • Investigate and expand a great Excel dashboard. 
  • Investigate and expand an Excel information display. 
  • Pre-arrangement and import a .CSV record. 
  • Import information from a SQL Server database 
  • Import information from a report. 
  • Make measures utilizing progressed DAX capacities. 
  • Make information perceptions in Excel. 
  • Make a Power BI dashboard with Excel. 
  • Course subtle elements 

Module 1: Data Analysis in Excel 

This module takes a gander at the great Excel dashboard and at approaches to expand it. 

Lessons 

  • Great Data Analysis with Excel 
  • Exceed expectations Pivot Tables 
  • Confinements of Classic Data Analysis 

Lab : Building a Classic Excel Dashboard 

  • Sifting and Formatting Data 
  • Building a Pivot Table 
  • Building a Pivot Chart 
  • Building a Dashboard 

In the wake of finishing this module, understudies will have the capacity to: 

  • Portray exemplary information examination with Excel 
  • Portray Excel rotate tables 
  • Portray the impediments of exemplary information examination with Excel 

Module 2: The Excel Data Model 

20779: Analyzing Data with Excel module takes a gander at the exemplary Excel information demonstrate and at approaches to expand it. 

Lessons 

  • Utilizing an Excel Data Model 
  • DAX 

Lab : Explore an Excel Data Model 

  • Make Calculated Columns 
  • Organization Data Model Data 
  • Make Measures 
  • Dissect the Data 

In the wake of finishing this module, understudies will have the capacity to: 

  • Portray an Excel information demonstrate 
  • View information inside an Excel information table 
  • Portray DAX 

Module 3: Importing Data from Files 

20779: Analyzing Data with Excel module takes a gander at pre-arranging and bringing in CSV documents. 

Lessons 

  • Bringing in Data into Excel 
  • Molding and Transforming Data 
  • Stacking Data 

Lab : Importing Data from a CSV File 

  • Import and Transform Data from a CSV File 
  • Include Data from a Folder 

In the wake of finishing this module, understudies will have the capacity to: 

  • Import information into exceed expectations. 
  • Shape and change information. 
  • Load information. 

Module 4: Importing Data from Databases 

20779: Analyzing Data with Excel module takes a gander at how to import information into Excel from a SQL Server database. 

Lessons 

  • Accessible Data Sources 
  • Seeing, Shaping, and Transforming Data 
  • Table Relationships and Hierarchies 
  • Stacking Data 

Lab : Import Data from Multiple Sources 

  • Import Data from SQL Server 
  • Import Data from a CSV File 
  • Make a Data Table 

In the wake of finishing this module, understudies will have the capacity to: 

  • Recognize accessible information sources. 
  • See, shape, and change information. 
  • Clarify table connections and chains of command. 
  • Load information from different sources. 

Module 5: Importing Data from Excel Reports 

20779: Analyzing Data with Excel module depicts how to import information from a report. 

Lessons 

  • Bringing in Data from Excel Reports 
  • Changing Excel report Data 

Lab : Importing Data from a Report 

  • Import Data from Excel 
  • Change the Excel Data 
  • Load the Data into an Excel Data Model 

In the wake of finishing this module, understudies will have the capacity to: 

  • Import information from Excel reports. 
  • Change Excel report information. 

Module 6: Creating and Formatting Measures 

20779: Analyzing Data with Excel module portrays how to make and configuration measures. 

Lessons 

  • DAX 
  • Measures 
  • Progressed DAX Functions 

Lab : Creating Measures utilizing Advanced DAX Functions 

  • A year ago correlation 
  • Year to date 
  • Piece of the overall industry 

In the wake of finishing this module, understudies will have the capacity to: 

  • Clarify what DAX is and when to utilize it. 
  • Portray a measure. 
  • Utilize a portion of the propelled capacities inside DAX. 

Module 7: Visualizing Data in Excel 

20779: Analyzing Data with Excel  module portrays how to envision information in Excel. 

Lessons 

  • Rotate Charts 
  • 3D shape Functions 
  • Graphs for Cube Functions 

Lab : Data Visualization in Excel 

  • Make a Tabular Report 
  • Make a Pivot Chart 
  • Add Slicers to Charts 

In the wake of finishing this module, understudies will have the capacity to: 

  • Make and refine a rotate diagram. 
  • Portray block capacities and when to utilize them. 
  • Depict various graphs for use with solid shape capacities. 

Module 8: Using Excel with Power BI 

20779: Analyzing Data with Excel module depicts how to utilize Excel with Power BI. 

Lessons 

  • Power BI 
  • Transferring Excel Data to Power BI 
  • Power BI Mobile App 

Lab : Creating a Power BI Dashboard with Excel 

  • Transferring Excel Data 
  • Making a Power BI Dashboard 

In the wake of finishing this module, understudies will have the capacity to: 

  • Portray Power Bi and the different forms accessible. 
  • Transfer Excel information to Power BI. 
  • Depict the Power BI App.

Before going to 20779: Analyzing Data with Excel course, understudies must have: 

  • Fundamental learning of the Microsoft Windows working framework and its center usefulness. 
  • Working information of social databases. 
  • Broad information of Excel spreadsheets including recipes, graphs, sifting, arranging, and sub-sums. 
  • Essential learning of information investigation proportional to having gone to course 10994.

Awards