After completing this course, you will be able to explore and extend a classic Excel dashboard, Explore and extend an Excel data model and Pre-format and import a .CSV file.
Your course package is designed to provide maximum learning and convenience. This is included in the price of your course:
Your expert instructor will get you ready for the following exam and certification, which are included in your course package and covered by the Certification guarantee.
You´ll have the perfect starting point for your training with these prerequisites:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of relational databases.
- Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.
- Basic knowledge of data analytics.
Using our engaging learning methodology including a variety of tools, we’ll cover the entire curriculum.
Course 20779A: Analyzing Data with Excel
Module 1: Data Analysis in Excel
This module looks at the classic Excel dashboard and at ways to extend it.
- Classic Data Analysis with Excel
- Excel Pivot Tables
- Limitations of Classic Data Analysis
Module 2: The Excel Data Model
This module looks at the classic Excel data model and at ways to extend it.
- Using an Excel Data Model
Module 3: Importing Data from Files
This module looks at pre-formatting and importing CSV files.
- Importing Data into Excel
- Shaping and Transforming Data
- Loading Data
Module 4: Importing Data from Databases
This module looks at how to import data into Excel from a SQL Server database.
- Available Data Sources
- Previewing, Shaping, and Transforming Data
- Table Relationships and Hierarchies
- Loading Data
Module 5: Importing Data from Excel Reports
This module describes how to import data from a report.
- Importing Data from Excel Reports
- Transforming Excel report Data
Module 6: Creating and Formatting Measures
This module describes how to create and format measures.
- Advanced DAX Functions
Module 7: Visualizing Data in Excel
This module describes how to visualize data in Excel.
- Pivot Charts
- Cube Functions
- Charts for Cube Functions
Module 8: Using Excel with Power BI
This module describes how to use Excel with Power BI.
- Power BI
- Uploading Excel Data to Power BI
- Power BI Mobile App
The Virtual Classroom is an online room, where you will join your instructor and fellow classmates in real time. Everything happens live and you can interact freely, discuss, ask questions, and watch your instructor present on a whiteboard, discuss the courseware and slides, work with labs, and review.
Your prereading is available for you in your personal space at readynez.com: My Readynez. Simply log in, find your course and start your preparations.
Your exam voucher is usually included in your virtual training package. When you´re ready to sit your exam, you just book it with the exam provider. You can sit most exams from home or at a local test centre. We’re here to help you with that process.
Yes, you can sit exams from all the major Vendors like Microsoft, Cisco etc from the comfort of your home or office.
Your Readynez Course package includes the exam voucher for Microsoft exams, AWS exams, ISO Exams and almost every other exam.
With Readynez you do any course form the comfort of your home or office. Readynez provides support and best practices for your at-home classroom and you can enjoy learning with minimal impact on your day-to-day life. Plus you'll save the cost and the environmental burden of travelling.
Well, learning is limitless, when you are motivated, but you need the right path to achieve what you want. Readynez consultants have many years of experience customizing learner paths and we can design one for you too. We are always available with help and guidance, and you can reach us on the chat or write us at firstname.lastname@example.org.