By the end of this course, you will be able to
How to deal with challenges related to the differences between data analysis and business intelligence by defining them in detail, the steps needed to implement a successful business intelligence strategy in your company, and how to deal with reports from different data sources.
How to create a dashboard appropriately using Power BI, how to determine the questions that should be directed to the data to build a professional report with the storytelling style, and how to use the DAX language to calculate the required key performance indicators (KPIs).
How to connect to the data source Excel Workbook and review its content, how to link tables together to create connections between them to make the required equations and employ them in the report, and how to create Tool Tip and Drill Through pages to show additional data for basic graphs.
Course details
- 4 h 52 m/50 lessons
- Last updated: 13/6/2021
- 7 learning resources
- Course completion certificate
Course Content
Course Overview
Introduction to Business Intelligence
Data to Wisdom
Data Collection: Challenges & Improvements
Cloud vs. On-premise
Course Overview
Introduction to Business Intelligence
Data to Wisdom
Data Collection: Challenges & Improvements
Cloud vs. On-premise
Data Analysis Process Steps I
Data Analysis Process Steps II
Data Source Mapping
Data Quality Dimensions
Data Tidiness
Data Storytelling
Data Storytelling Rules
Program Overview
Program Architecture
Program's Other Products
Downloading the Program
Extract, Transform & Load Process (ETL)
Extraction Process
Importing Data
Importing a Model
Visualization
Data Mapping
Adding Filters
Connecting Folders
Connecting to a Sequel Server
Data Transformation I
Data Transformation II
Merging and Appending
AdventureWorks Samples
Designing Reports
Modeling
Data Analysis Expression (DAX)
Practice (DAX)
SumX and AverageX Functions
Calculating Function
Summarizing and Adding Columns Functions
Variables Function
Uploading Reports
Customer Service KPIs I
Customer Service KPIs II
Customer Service KPIs III
Customer Service KPIs IV
Customer Service KPIs V
Customer Service KPIs VI
Supply Chain I
Supply Chain II
Supply Chain III
Medical Case Study - Covid 19
Power BI Certification DA-100
Wrap Up
About this course
Business Intelligence helps businesses make better decisions through data. The course will help you learn how to use BI Tools which are suites of business analytics tools to analyze data and share insights. You will learn how to use your data to increase your business's profit and identify areas of improvement. Using the BI tools will allow you to access your business's dashboards and get answers quickly that will help you make accurate decisions almost instantly. The course will use Microsoft Power BI in which is the leading platform in the Business Intelligence field.
Course requirements and prerequisites
This course has many English terminologies, so an intermediate English proficiency is preferred.
MS Power PI literacy is required.
It is preferable to have some business experience before starting this course.
Mentor
Ahmed Hashem
Process Improvement and Business Intelligence Consultant
1,942 Learners
2 Course