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.

Value Added:
After completing this program, audiences will be able to:

Create and format measures and KPIs.
Create PivotCharts, use cube functions, and construct graphs that can summarize the information retrieved by using cube functions.
Build Excel Data Analysis Model, connect to databases, transform the data into a convenient form, and load the data into Excel tables or into the Business Data Model.
Transform formatted Excel reports into usable data to perform further analysis.
Describe the trends in Business Intelligence (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 the 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 Excel® and other files, and Software as a Service (SaaS) providers such as Microsoft Bing®, Facebook, and MailChimp.
Advance beyond the scenes of the visualizations, and explore the techniques and features on offer to streamline and enhance their abilities to gain insights, create valuable reports, while helping to manage the ever-evolving volumes of data.

Data Analysis Using Excel and Power BI
Part 1: Data Analysis Using Excel
Course Outline
1 - DATA ANALYSIS IN EXCEL
? Classic Data Analysis with Excel
? Excel Pivot Tables
? Limitations of Classic Data Analysis
2 - THE EXCEL DATA MODEL
? Create Calculated Columns
? Format Data Model Data
? Create Measures
? Analyze the Data
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
? Table Relationships and Hierarchies
? Loading Data
5 - IMPORTING DATA FROM EXCEL REPORTS
? Importing Data from Excel Reports
? Transforming Excel report Data
6 - CREATING AND FORMATTING MEASURES
? DAX
? Measures
? Advanced DAX Functions
7 - VISUALIZING DATA IN EXCEL
? Pivot Charts
? Cube Functions
? Charts for Cube Functions
8 - USING EXCEL WITH POWER BI
? Power BI
? Uploading Excel Data to Power BI
? Power BI Mobile App

Part 2: Analyzing Data with Power BI
1 - Introduction to Self-Service BI Solutions
? Introduction to business intelligence
? Introduction to data analysis
? Introduction to data visualization
? Overview of self-service BI
? Considerations for self-service BI
? Microsoft tools for self-service BI
? Lab : Exploring an Enterprise BI solution
? Viewing reports
? Creating a Power BI report
? Creating a Power BI dashboard
2 - Introducing Power BI
? This module introduces Power BI desktop, and explores the features that enable the rapid creation and publication of sophisticated data visualizations.
? Power BI
? The Power BI service
? Connecting to Power BI data
? Create a Power BI dashboard
3 - Power BI
? Using Excel as a data source for Power BI
? The Power BI data model
? Using databases as a data source for Power BI
? The Power BI service
? Importing Excel files into Power BI
? Viewing reports from Excel files
4 - Shaping and Combining Data
? Power BI desktop queries
? Shaping data
? Combining data
? Shape power BI data
? Combine Power BI data
5 - Modeling data
? Relationships
? DAX queries
? Calculations and measures
? Create relationships
? Calculations
6 - Interactive Data Visualizations
? Creating Power BI reports
? Managing a Power BI solution
? Connecting to Power BI data
? Building Power BI reports
? Creating a Power BI dashboard