Excel Power Business Intelligence (Power BI) For Productivity
EXCEL POWER BUSINESS INTELLIGENCE (POWER BI) FOR PRODUCTIVITY
Course Duration: 2 DaysINTRODUCTION
This course provides you the knowledge and skills that you need to analyze data with Power Business Intelligence to maximize your productivity in workplace.
AUDIENCE
This course is suitable for professionals who need to analyze data by utlizing Power BI, technically proficient business users.
PRE-REQUISITES
- Basic knowledge of Microsoft Windows operating system and it's core functionality
- Basic knowledge of data warehouse scheme topology (including star and snowflakes schemas)
- Some exposure to basic programming concepts
- An awareness of key business priorities
- Familiar with Microsoft Excel
COURSE OBJECTIVES
- Able to describe key features of self-service business intelligence solutions
- Describe Power BI and it's data source
- Model, shape and combine data
- Describe Power BI Data Visualizations
KEY CONTENT
Module 1: Introduction to Self-Service Business Intelligence Solutions
- Introduction to Business Intelligence
- Introduction to Data Analysis
- Introduction to Data Visualization
- Overview of Self-Service Business Intelligence
- Microsoft Tools for Self-Service Business Intelligence
Module 2: Introducing Power Business Intelligence
- Power Business Intelligence
- Power Business Intelligence Service
- Power Business Intelligence Mobile Apps
Module 3: Power BI Data
- Using Excel as a Power BI Data Source
- Using Databases as Power BI Data Source
- The Power BI Service
Module 4: Shaping and Combining Data
- Power BI Desktop Queries
- Shaping data
- Combining data
Module 5: Modelling Data
- Relationships
- DAX Queries
- Calculations and measures
Module 6: Interactive Data Visualizations
- Creating Power BI Reports
- Managing a Power BI Solutions
Inquiry - Excel Power Business Intelligence (Power BI) For Productivity