About us, we are passionately curious about people and society. We deliver data and insights that make our complex world easier and faster to navigate and inspire our clients to make smarter decisions. By using innovative technologies and data science, we turn big...
Excel 2016 is a game changer for any Excel user. Excel 2016 provides new technologies and tools for the business user to easily analyze data to create powerful reports and dashboards in a fraction of the time of traditional spreadsheets. This course is for all business users who want to learn how to create management reports, analyze data and create interactive dashboards using the Power BI tools in Excel.
Our objective is for you to learn all the features in Power BI within Excel that allows you explore, experiment with, fix, prepare and present data easily, quickly, and beautifully.
Participants will learn how to use Power Query, Power Pivot, Power View and Power Map to create powerful reports and dashboards; Participants will be able to comfortably work with the different tools of the Power BI universe and know how the different tools work together.
At the completion of the course, participants will:
Learn the new Business Intelligence technologies in Excel
Analyze data and create reports in a fraction of the time of spreadsheets
Learn to manage millions of rows of data in Power Pivot
Create new powerful calculations, KPIs and Key Metrics
Create new table relationships for reporting and dashboards
Use Power View to create interactive dashboards and analyzing data
Learn to use Power Query to import, merge, clean and transform data
Use Power Map to visualize and analyze geographical data
Cleaning up Data
Merging & Appending Data
Loading data to PowerPivot
Create relationships between Tables
Manage millions of rows of data
Custom Calculations, Key Metrics/KPIs
Analyzing Data with Pivot Tables
Creating Tables and Cards
Visualizing data with Graphs
Creating Interactive dashboards
Filter and Ask Questions of your Data
Powerful data analysis with Scatter Plots and Bubble Plots
Visualize Geographical data and maps
Mapping Data with Power Map
Changing the Method of Aggregation
Mapping Data over Time
Before attending this course, participants must have: