Maxtrain.com - [email protected] - 513-322-8888 - 866-595-6863
The main purpose of the Analyzing Data with Excel course is to give students the ability to 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.
After completing this course, students will be able to:
Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Whether your data is a simple Excel spreadsheet, or a collection of data from different data sources, Power BI lets you easily connect to your data sources, visualize (or discover) what’s important, and share that with anyone or everyone you want.
A Power BI dashboard is a single page, often called a canvas, that uses visualizations to tell a story. Because it is limited to one page, a well-designed dashboard contains only the most-important elements of that story.
The visualizations you see on the dashboard are called tiles and are pinned to the dashboard by report designers. In most cases, selecting a tile takes you to the report page where the visualization was created.
Module 1: Data Analysis in Excel
This module looks at the classic Excel dashboard and at ways to extend it.
Lab : Building a Classic Excel Dashboard
After completing this module, students will be able to:
Module 2: The Excel Data Model
This module looks at the classic Excel data model and at ways to extend it.
Lab : Explore an Excel Data Model
Module 3: Importing Data from Files
This module looks at pre-formatting and importing CSV files.
Lab : Importing Data from a CSV File
Module 4: Importing Data from Databases
This module looks at how to import data into Excel from a SQL Server database.
Lab : Import Data from Multiple Sources
Module 5: Importing Data from Excel Reports
This module describes how to import data from a report.
Lab : Importing Data from a Report
Module 6: Creating and Formatting Measures
This module describes how to create and format measures.
Lab : Creating Measures using Advanced DAX Functions
Module 7: Visualizing Data in Excel
This module describes how to visualize data in Excel.
Lab : Data Visualization in Excel
Module 8: Using Excel with Power BI
This module describes how to use Excel with Power BI.
Lab : Creating a Power BI Dashboard with Excel
Before attending this course, students must have:
This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques.
The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.
3 Days Course