تفاصيل الدورة
Business Intelligence with Excel 2013
Excel 2013 is a game changer for any Excel user. Excel 2013 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 Excel 2013.
In this course we learn the following:
Power Query
- Cleaning up Data
- Merging Data
- Appending Data
- Grouping Data
- Loading data to PowerPivot
Power Pivot
- Create relationships between Tables
- Manage millions of rows of data
- Custom Calculations, Key Metrics and KPIs
- Analyzing Data with Pivot Tables
- Analyzing Date data
Power View
- Creating Tables and Cards
- Visualizing data with Graphs
- Creating Interactive dashboards
- Filter and Ask Questions of your Data
- Powerful data analysis with ScatterPlots and BubblePlots
- Visualize Geographical data and maps
Power Map
- Mapping Data with Power Map
- Changing the Method of Visualization
- Changing the Method of Aggregation
- Mapping Data over Time
- Creating Tours
This course will provide you with an easy to follow step by step approach to using the new Business Intelligence technology in Excel 2013.
تحديث بتاريخ 19 March, 2018- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoon1,449 درهممدة الدورة التدريبية: Upto 30 Hours
- Microsoft Excel & Accounting StudyHub49 درهم
955 درهممدة الدورة التدريبية: Upto 18 Hours - Microsoft Excel 2016 Beginners Level Alpha Academy95 درهم
1,028 درهممدة الدورة التدريبية: Upto 18 Hours