Professional Certificate in Data Analytics with Microsoft Power BI

Name: Professional Certificate in Data Analytics with Microsoft Power BI
Brand: GemRain

RM12,500.00

Launch your data analytics career with a professional certificate program!

This program, offered by GemRain Consulting in partnership with Universiti Sains Malaysia, is designed to help you gain the skills you need to become a data analyst. You'll learn about data analytics fundamentals, Microsoft Power BI, and data visualization.

Whether you're looking to change careers or advance in your current role, this program can help you achieve your goals.

The data analytics field is growing rapidly, and there is a high demand for skilled professionals. This program is designed to help you gain the skills you need to enter this exciting field.

The program covers a wide range of topics, including:

Data analytics fundamentals: You'll learn about the basics of data analytics, including data collection, data cleaning, data analysis, and data visualization.
Microsoft Power BI: Power BI is a powerful business intelligence tool that can be used to create reports and dashboards. You'll learn how to use Power BI to analyze data and communicate your findings to others.
Data visualization: Data visualization is the art of creating visual representations of data. You'll learn how to create charts and graphs that are clear, concise, and informative.

In addition to the core curriculum, the program also includes hands-on projects that will allow you to apply your learning to real-world problems. By the end of the program, you'll have the skills and experience you need to start a successful career in data analytics.

Why take this program?

There are many reasons to take this program, including:

Gain in-demand skills: Data analytics is one of the most in-demand skills in today's job market. By taking this program, you'll gain the skills you need to land a high-paying job in data analytics.
Advance your career: If you're already working in a data-related field, this program can help you advance your career. You'll learn the latest data analytics techniques and tools, which will make you more valuable to your employer.
Change careers: If you're looking for a career change, data analytics is a great option. This program will give you the skills and experience you need to enter this exciting field.

Benefits of taking the program:

Learn from experienced instructors: The program is taught by experienced data analytics professionals who will share their knowledge and expertise with you.
Gain hands-on experience: The program includes hands-on projects that will allow you to apply your learning to real-world problems.
Earn a professional certificate: Upon successful completion of the program, you'll earn a professional certificate in data analytics from GemRain Consulting and Universiti Sains Malaysia.

This certificate will show potential employers that you have the skills and knowledge necessary to be a successful data analyst.

Training Duration: 8 Days

Certificate Of Completion Available
Group Private Class
VILT Class Available
SBL-Khas Claimable
FREE 2-hour Exam Prep if you include Power BI Data Analyst Associate Exam

Download Course Outline

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: Introduction to DAX

What is DAX?

Calculated columns vs. measures

What are quick measures?

Performing simple calculations

Module 5: Visualizing Your Data

Creating Power BI reports

Creating Power BI dashboards

Common visuals and their usage

Selections and Bookmarks

Formative Assessments (60%):

Quizzes at the end of each module to review key concepts.

Hands-On Labs using Power BI on sample datasets to apply the concepts of data connections and transformations.

Group Discussions on the potential impacts of data analytics in various industries.

Summative Assessments (40%):

Practical Test where students create a basic Power BI report and dashboard using a given dataset to showcase their understanding of the tool and data visualization principles.

Project where students must connect to a data source, transform the data using Power Query, and create a report that includes at least one measure calculated with DAX.
MASTERING FORMULAS WITH DATA ANALYSIS EXPRESSIONS (DAX)

WHAT WILL YOU LEARN
This workshop is a complete course about the DAX language. DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power BI, Power Pivot for Excel, and at Analysis Services developers that want to learn and master the DAX language. This course covers the latest version of DAX 2019.

OBJECTIVES
After completing this course, students will be able to:

Understand all the features of the DAX language

Write formulas for common and 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

Module 8: ALLSELECTED and Shadow Filter Contexts

ALLSELECTED function revisited

Shadow filter contexts

Module 9: Segmentation

Static segmentation

Circular dependency in calculated tables

Dynamic segmentation

Module 10: Many-to-many Relationships

How to handle many-to-many relationships

Bidirectional filtering

Expanded table filtering

Comparison of the different techniques

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.

Peer Reviews: Students review and critique each other’s DAX formulas, fostering collaboration and deeper understanding.

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.

Project: An end-of-module project where students create complex measures using DAX, incorporating multiple functions and demonstrating familiarity with data calculations as a precursor to data modeling.
DATA MODELING ESSENTIALS IN MICROSOFT POWER BI WITH DAX

WHAT WILL YOU LEARN
This workshop is a complete course about building the most optimal data models for your Power BI reports. It introduces the audience to the basic techniques of shaping data models in Power BI. It offers many real-world examples that will help you look at your reports in a different way – pretty much like experienced data modelers do.

OBJECTIVES
After completing this course, students will be able to:

Learn the vast 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.

Learn the most optimum way of building a sustainable data model for Power BI reports.

PREREQUISITES
Attendees 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?

Analytical limits

Increasing the analytical power

Introducing the facets of data modeling

Leveraging the data model

Normalization and denormalization

Facts and dimensions

Introducing star schemas

Chains of relationships

How many dimensions?

Why data modeling is useful?

Module 2: Header / Detail Tables

Introduction to header / detail schemas

Bidirectional filtering is not the way!

Denormalizing the discount

Back to star schema

Module 3: 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

Quick calculations in Power BI Desktop

Disable automatic date columns

Handling multiple dates

Multiple date tables

Multiple date tables with multiple fact tables

Multiple relationships with date

Handling date and time

Computing with working days

Create a holidays table (one country)

Create a holidays table (multiple countries)

Weekends are not always the same!

Handling special periods of the year

Non-overlapping periods in the model

Non-overlapping special periods

Overlapping period measure

Module 4: Using Snapshot Tables

What is a snapshot table?

Sales versus inventory in the same model

Non-additive measures

LASTDATE function does not work here!

Optimizing performance

Snapshots and granularity

Transition matrix

Parameter tables

Module 5: Date and Time Intervals

What are intervals?

Solving with DAX… too complex!

Changing granularity

Split hours AND amount!

Analyzing active events

Open orders: the starting model

Open orders with DAX

Open orders in a snapshot table

Events with different durations

Daily salary in DAX

Precompute the values

Module 6: 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 7: 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.

Group Workshops where students collaborate to solve common data modeling problems and present their solutions.

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.

Practical Test: A thorough examination that tests understanding of key data modeling concepts, best practices, and the application of DAX in data modeling
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 1-day course 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.

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.

Professional Certificate in Data Analytics with Microsoft Power BI

MODULE 1 (2 Days)

MODULE 2 (3 Days)

MODULE 3 (2 DAYS)

MODULE 4 (1 Day)

For a private in-house, please ask us for a quotation.

Get Ahead of the Competition with a FREE 1-Day Training for Your Company with our GRC-X Premium