In this course, you will be introduced to the key concepts in business intelligence (Bl), data analysis, and data visualization. Discover the capabilities of a self-service Bl solution and learn to create Power Bl Desktop queries and beautiful dashboards.
Introduction In this course, you will be introduced to the key concepts in business intelligence (Bl), data analysis, and data visualization. Discover the capabilities of a self-service Bl solution and learn to create Power Bl Desktop queries and beautiful dashboards.
Who Should attend? Data analysts, Business analysts, Business intelligence developers, SQL professionals Databases administrators, Data scientists and related professionals.
Class Activity Blocks Activity 1: Exploring an Enterprise Bl Solution
Activity 2: Importing data in Excel data model
Activity 3: Transforming data in Power Query
Activity 4: Using Power Pivot in excel
Activity 5: Import Data into Power Bl
Activity 6: Transforming data using Query Editor
Activity 7: Shaping and Combining Data
Activity 8: Modeling Data
Activity 9: Creating a Power Bl Report
Activity 10: Creating a Power Bl Dashboard
Activity 11: Direct Connectivity
Activity 12: Using the Developer API
What you'll learn
Connect directly to data stores Describe how to connect to Excel data Perform Power Bl desktop data transformation Describe Power Bl desktop modelling Create Power Bl desktop visualizations Implement the Power Bl service Describe how to collaborate with Power Bl data Setting up Gateways to automatically update Power Bl reports Describe the Power Bl developer API Describe the Power Bl mobile app Course Modules
Module 1: Introduction to Self-Service Bl Solutions
Module 2: Introducing Excel Bl (Power Query & Power Pivot)
Module 3: Importing data in Power Pivot data model
Module 4: Shaping and Combining Data using Power Query
Module 5: Data Visualizations using Power Pivot
Module 6: Introducing Power Bl
Module 7: Power Bl Data connections
Module 8: Shaping and Combining Data in Query Editor
Module 9: Modeling Data
Module 10: Interactive Data Visualizations
Module 11: Introducing Power Bl service (SaaS)
Module 12: Creating Dashboards in Power Bl Service
Module 13: Sharing Power Bl report within and outside your teams
Module 14: Direct Connectivity
Module 15: Developer API
Module 16: Power Bl mobile app
Prerequisites Basic knowledge of the Microsoft Windows OS and its core functionality An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable Familiarity with Microsoft Office applications (particularly Excel)
The 3 day course costs 450$ (280,500 FRW), Exclusive of a 16% V.A.T, The Cost includes all training fees, materials, lunch and refreshments as well as certificates and 6 month post training support.
Event Details Event Date 26-02-2020 8:30 am Event End Date 28-02-2020 4:00 pm Cut off date 17-02-2020 Individual Price 450$ (280,500 FRW) Location BCP Training Facilities, Kigali Rwanda.