Organizations generate large amounts of data every day, but raw data alone does not create business value. Professionals need the ability to prepare data, perform meaningful analysis, build reliable data models, and communicate insights clearly. Microsoft Power BI helps organizations transform complex datasets into interactive reports and dashboards that support more informed decision-making.
The Professional Certificate in Data Analytics with Microsoft Power BI is a comprehensive 5-day instructor-led training program designed to develop practical data analytics capabilities. The program follows a structured learning journey, progressing from Power BI fundamentals and data preparation to advanced DAX calculations, data modeling, dashboard design, and data storytelling.
Participants will learn to connect Power BI to different data sources, clean and transform datasets using Power Query, create calculations using Data Analysis Expressions (DAX), and develop accurate, sustainable data models. The program concludes with dashboard design principles that help learners present information clearly and communicate business insights effectively.
Training Duration: 5 Days
- Certificate Of Completion Available
- Group Private Class
- VILT Class Available
- SBL-Khas Claimable
FUNDAMENTALS OF DATA ANALYTICS USING MICROSOFT POWER BI
WHAT WILL YOU LEARN
This instructor-led adventurous workshop is designed for audiences to be equipped with the necessary knowledge and skills to kickstart their analytical journey with Microsoft Power BI. You will be guided from the stage of connecting data, transforming data, and visualizing your data.
OBJECTIVES
After completing this course, students will be able to:- Describe key features of Microsoft Power BI
- Understand how data are connected to
- Microsoft Power BI
- Massage, cleanse, format and transform data
- Visualizing data using reports and dashboards
PREREQUISITES
This course is for beginners and users with little or no exposure of basic programming concepts, little or no knowledge of data warehouse schema, an awareness of key business priorities such as
revenue, profitability, and financial accounting, and technically familiar with Microsoft Excel.
COURSE CONTENTS
Module 1: Microsoft Power BI as a Service- What is Power BI?
- The Power BI service and its ecosystem
- Product and subscription information
- Familiarizing with Microsoft Power BI app and
- service
Module 2: Getting to Know Your Data- Using Excel as a Power BI data source
- Using databases as a Power BI data source
- Understanding the Power BI dataset
- Importance of table relationships
Module 3: Data Transformations using Power Query- Power BI Desktop queries
- Cleansing data and transformations
- Consolidation of data through appends and
- merges
Module 4: Visualizing Your Data- Creating Power BI reports
- Creating Power BI dashboards
- Common visuals and their usage
Formative Assessments (60%):
- Quizzes at the end of each module to review key concepts of the Power BI service, data connection and transformation.
- Hands-On Labs using Power BI on sample datasets to apply the concepts of data connections and transformations.
Summative Assessments (40%):- Practical Test where students connect to a data source, transform the data using Power Query, and create a basic Power BI report and dashboard using a given dataset to showcase their understanding of the tool and data visualization principles.
MASTERING FORMULAS WITH DATA ANALYSIS EXPRESSIONS (DAX)
WHAT WILL YOU LEARN
This workshop delivers the essential, practical DAX needed to work confidently in Power BI. DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training focuses on the core language features and the calculation patterns used most often in real analytical work, based on DAX 2019.
OBJECTIVES
After completing this course, students will be able to:- Understand the essential features of the DAX language
- Write formulas for common and moderately advanced scenarios
PREREQUISITES
Attendees need to have a basic knowledge of the data modeling in Power Pivot for Excel, or Power BI Desktop, or Analysis Services Tabular modeling.
COURSE CONTENTS
Module 1: Introduction to DAX- What is DAX?
- DAX data types
- Calculated columns
- Measures
- Aggregation functions
- Counting values
- Conditional functions
- Handling errors
- Using variables
- Mathematical functions
- Relational functions
Module 2: Table Functions- Introduction to table functions
- Filtering a table
- Ignoring filters
- Mixing filters
- DISTINCT Function
- How many values for a column?
- ALLSELECTED function
- RELATEDTABLE function
- Tables and relationships
- Tables with one row and one column
- Table variables
Module 3: Evaluation Contexts- Introduction to evaluation contexts
- Filter context
- Row context
- Context errors
- Filtering a table
- Using RELATED in a row context
- Ranking by price
- Evaluation contexts and relationships
- Filters and relationships
Module 4: CALCULATE Function- Introduction to CALCULATE function
- CALCULATE function examples
- CALCULATE function recap
- What is a filter context?
- KEEPFILTERS function
- CALCULATE operators
- Use one column only in a compact syntax
- Variables and evaluation contexts
Module 5: Iterators- Working with iterators
- MINX and MAXX functions
- Useful iterators
- RANKX function
- ISINSCOPE function
Module 6: Time Intelligence in DAX- What is time intelligence?
- Time intelligence functions
- DATEADD function
- DATESINPERIOD function
- Running total
- Mixing time intelligence functions
- Semi-additive measures
- Calculation over weeks
Module 7: Hierarchies in DAX- What are hierarchies?
- FILTER and CROSSFILTER function
- Percentages over hierarchies
- Parent-child hierarchies
Formative Assessments (60%):- Hands-On Labs: A series of graded labs where students apply DAX functions to solve specific problems, like calculating average sales or working with time intelligence functions.
- In-Lecture Short Assignments: Short scenarios requiring the creation of DAX formulas to encourage continuous engagement and problem-solving.
Summative Assessments (40%):- Practical Test: A comprehensive test where students must demonstrate proficiency by writing and debugging DAX formulas within Power BI, incorporating multiple functions as a precursor to data modeling.
DATA MODELING ESSENTIALS IN MICROSOFT POWER BI WITH DAX
WHAT WILL YOU LEARN
This workshop teaches the core techniques for building the most optimal data models for your Power BI reports. Through real-world examples, participants learn to look at their reports the way experienced data modelers do, focusing on the schema patterns that matter most in practice.
OBJECTIVES
After completing this course, students will be able to:- Apply the essential techniques of shaping and building a correct data model to be used in Power BI.
- Understand the common challenges and mistakes that people have in creating a data model.
- Build sustainable, well-performing data models for Power BI reports.
PREREQUISITESAttendees preferably have a basic knowledge of data modeling in Power Pivot for Excel, or Power BI Desktop, and most importantly, DAX.
COURSE CONTENTS
Module 1: Introduction to Data Modeling- What is Data Modeling?
- Normalization and denormalization
- Facts and dimensions
- Introducing star schemas
- Chains of relationships
- How many dimensions?
- Why data modeling is useful
Module 2: Working with Date and Time- Date attributes in the fact table
- Building a date dimension
- CALENDARAUTO function
- The model with a date dimension
- Automatic date grouping in Power BI
- Disable automatic date columns
- Handling multiple dates
- Multiple relationships with date
- Computing with working days
- Create a holidays table
Module 3: Many-to-Many Relationships- What are many-to-many relationships?
- Possible solutions to this complex scenario
- Bidirectional filtering
- Using CROSSFILTER function
- Using expanded table filtering
- CROSSFILTER versus expanded tables
- Understanding non-additivity
- Cascading many-to-many
Module 4: Different Granularities- Dimensions define granularity
- Analyzing budget data
- Reduce granularity on all the tables
- Using DAX to move the filters
- Filtering through relationships
- Using the correct column to slice
- Leveraging relationships
- Checking granularity in the report
- Hiding or reallocating?
Formative Assessments (60%):- Hands-On Labs for each topic covered, such as creating star schemas, working with date and time functions, and managing many-to-many relationships.
- Chapter Reflections where students document their learning progress and insights from the labs and lectures.
Summative Assessments (40%):- Data Modeling Project: Students will be tasked to design a comprehensive data model for a given scenario, implementing techniques such as normalization, handling different granularities, and many-to-many relationships.
DATA VISUALIZATION & STORYTELLING WITH POWER BI DASHBOARDS
WHAT WILL YOU LEARN
Presenting data with Microsoft Power BI is simple as anyone can draw charts on the canvas and start visualizing numbers graphically. Unfortunately, it is not easy to design a good and appealing dashboard. This module is designed for Power BI creators who wish to learn how to create beautiful and effective dashboards, while avoiding all the common design pitfalls and mistakes.
OBJECTIVES
After completing this course, students will be able to:- Learn the 7 golden rules of dashboard design concepts in Microsoft Power BI.
- Obtain a visual chart reference for different types of dashboard objectives and use them in their day-to-day lives.
PREREQUISITES- Attendees preferably have a basic knowledge of using Microsoft Power BI Desktop to create reports and dashboards. It is also a good course for people who want to kickstart their Power BI reporting and dashboard ventures.
COURSE CONTENTS
Intro: Strategizing a Power BI Dashboard- What people think a dashboard is and what it really is.
- The 7 Golden Rules of dashboard design.
- Selections and Bookmarks as storytelling and navigation techniques.
Rule 1: Design for a Target- Design each dashboard for a single target person, group or specific goal.
Rule 2: Keep Everything at a Glance- Design each dashboard to present all information in a single non-scrollable screen.
Rule 3: Keep it Simple- The foundation of a good design is simplicity!
Rule 4: Align All Elements- Always align all elements on the dashboard.
Rule 5: Be Consistent in Your Design- Repetition means familiarity.
- Implement a pattern of design.
Rule 6: Highlight the Most Relevant Information- A good dashboard contains only information that is relevant to its scope.
Rule 7: Be Clear- A good dashboard should use simple terminology and explain all abbreviations.
Formative Assessments (60%):- Mini-Projects: Create a series of small dashboards focusing on different visualization techniques and the application of the 7 golden rules of dashboard design.
- Peer Feedback Sessions: Regular sessions where students present their dashboards and receive constructive feedback.
- Participation in Class Discussions: Active participation in forums discussing design strategies and problem-solving for common dashboard challenges.
Summative Assessments (40%):- Comprehensive Dashboard Project: A final project where students must design a full dashboard from scratch, applying all 7 golden rules, tailored for a specific business scenario provided by the instructor.
- Oral Examination: An oral exam where students present their dashboard to the class, justifying their design choices and the story their data tells.