EGP6,193
Business intelligence (BI) term has become increasingly common over recent years. Along with big data, data mining and analysis, predictive analytics, data science, and data stewards, BI is now very much part of the business vocabulary. The main purpose of this program is to give audiences the ability to analyze their business data using BI techniques.
The program goes beyond the capabilities of tables and charts and uses PivotCharts, the Excel Data Model, and Power BI.
Besides rounds that are conducted in IMP head office in Egypt; IMP courses are also delivered LIVE with fully interactive sessions allowing for a highly engaging Q & A and assuring that you get the best ever learning experience.
Starting Date Days Time
Lecture 2.1
Visualizing Data Using Conditional Formatting
Lecture 2.2
Visualizing Data Using Sparkline
Lecture 2.3
Visualizing Data Using Slicer
Lecture 2.4
Using SUM & COUNT Function
Lecture 2.5
Using VLOOKUP Function
Lecture 2.6
Using Nested IF Function
Lecture 2.7
Perform What If Analysis
Lecture 2.8
Perform Goal Seeking
Lecture 4.1
Introducing to Power Query
Lecture 4.2
Connecting to Excel Workbook Files
Lecture 4.3
Connecting to CSV Files
Lecture 4.4
Connecting to TEXT Files
Lecture 4.5
Connecting to Access Files
Lecture 4.6
Connecting to Excel Sheets
Lecture 4.7
Connecting to Folders
Lecture 4.8
Transforming Data Using Power Query
Lecture 4.9
Loading Data to the Excel Data Model
Lecture 4.10
Working with Multiple Queries
Lecture 4.11
Custom Columns with M Calculations
Lecture 15.1
Creating Reports
Lecture 15.2
Report Filtering
Lecture 15.3
Create a Dashboard
Lecture 15.4
Drill-down
Lecture 15.5
Drill-Through
Lecture 15.6
Formatting Visualizations
Lecture 15.7
Apply conditional formatting
Lecture 15.8
Visual Interactions
Lecture 15.9
Slicers and Advance Card Visuals
Lecture 15.10
Bookmarks & Buttons
Lecture 15.11
Using Q & A
duration | 44 Hours |
---|---|
skill-level | Advanced |
language | English |
Copyright 2019 by IMP - Institute of Management Professionals