Location

Community Services & Continuing Education - Cairo

Objectives

• Our training courses are designed and delivered by subject experts who are competent in providing solutions that are applicable to today’s business challenges. 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 Pivot Charts, Excel Data Model, and Power BI Business Intelligence (BI) is a term that has become increasingly common over recent years. Along with big data, data mining, predictive analytics, data science, and data stewards, BI is now very much part of business vocabulary.

Outcomes

Upon completing this program, audiences will be able to: • Create and format measures and KPIs. • Create Pivot Charts, use cube functions, and construct graphs that can summarize the information retrieved by using cube functions. • Build Excel Data Model, connect to databases, transform the data into a convenient form, and load the data into Excel tables or into the data model. • Transform formatted Excel reports into usable data to perform further analysis. • Describe the trends in BI, describe the process of data analysis in Power BI. • Use the key visualizations in Power BI and describe the rationale for self-service BI. • Use Q&A to ask questions in natural query language, and create content packs and groups. • Use the Microsoft Power BI suite of tools to connect to a wide variety of data sources. These include the main industry-standard databases, Microsoft cloud-based services—Microsoft Azure SQL Database, Azure Data Lake, and Azure Machine Learning— alongside Microsoft

Course Contents

Contents: 1. Data Analysis in Excel • Basic Excel functions & formulas (Task Based). • Classic data analysis with Excel. • Excel PivotTables. • Limitations of classic data analysis. 2. The Excel Data Model • Using an Excel data model. • Data Analysis Expressions (DAX). 3. Importing Data from Files • Importing data into Excel.• Shaping and transforming data. • Loading data. 4. Importing Data from Databases • Available data sources. • Previewing, shaping, and transforming data. • Loading data. • Table relationships and hierarchies. 5. Importing Data from Excel Reports • Importing data from Excel reports. • Transforming Excel reports data. 6. Creating and Formatting Measures • Data Analysis Expressions (DAX). • Measures and KPIs. • Advanced DAX functions.7. Visualizing Data in Excel • Using Pivot Charts. • Using Cube functions. • Creating charts for cube functions. 8. Using Excel with Power BI • Introduction to Power BI • Using Excel as a Data Source for Pow