CERTIFIED DATA INTELLIGENCE PROFESSIONAL (CDIP)
Available Dates & Locations
COURSE OVERVIEW
Leveraging and developing your Data Analysis competencies, nowadays, are crucial to this day enabling businesses to maximize the value of their data assets. As a subject matter expert, Certified Data Intelligence Professionals are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations. CDIPs also collaborate with key stakeholders across verticals to deliver relevant insights based on identified business requirements. This certification was designed to allow professionals to master the main pillars of Data Analysis covering Pivot Tables, Power Pivots, Data Models, Advanced Expressions, PowerQuery, Visualizations, and PowerBI.
COURSE OBJECTIVES
By completely attending this course, participants will be able to:
- Master PivotTables and prepare enhanced reporting models. This objective includes three important building blocks of PivotTables; Design, Analyze, Report
- Acquire new knowledge is working with PowerPivot including Data Models, Measures, Relationships, Multiple Sources, DAX
- Learn how to use PowerQuery as one of the most important tools for transforming data from different sources and design different measures
- Practice the use of PowerBI to plan, design, and produce industry-standard Reports and Dashboards
Note
This course requires the use of laptops with Excel 2019/365 and Microsoft Power BI Desktop.
TARGET COMPETENCIES
- 19 Rules of Pivot Tables
- 3 Building Blocks of Pivot Tables
- Extract, Transform, and Load (ETL) using PowerQuery
- Design and Prepare Superior Reports and Analysis
- Visualize the data
- PowerBI
The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.
This is a hands-on course with about 20% on design and structure and 80% uses Excel and Power BI as a commanding tool to consume and transform data, Model and visualize data, Configure dashboards, reports, and apps in the Power BI Service. Individuals will be required to complete exercises, case studies, and projects on a daily basis.
