GRC-104FT: Intensive Data Modeling For Microsoft Power BI Creators [Fastrack]

Name: GRC-104FT: Intensive Data Modeling For Microsoft Power BI Creators [Fastrack]
Brand: GemRain
Price: 3000 MYR
Availability: InStock

RM 3,000.00

Data Modeling is one of the features used to connect multiple data sources in BI tool using a relationship. A relationship defines how data sources are connected with each other and you can create interesting data visualizations on multiple data sources.

With the data modeling for Microsoft Power BI feature, you can build custom calculations on the existing tables and these columns can be directly presented into Power BI visualizations. This allows businesses to define new metrics and to perform custom calculations for those metrics.

Training Duration: 2 Days

Certificate Of Completion Available
Group Private Class
VILT Class Available
SBL-Khas Claimable

Download Course Outline

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.
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?

Lab 01 – Basic data modeling

Module 2: Header / Detail Tables

Introduction to header / detail schemas

Bidirectional filtering is not the way!

Denormalizing the discount

Back to star schema

Lab 02 – Header / detail

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

Lab 03 – Working with date and time

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

Lab 04 – Snapshots

Module 5: Analyzing 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

Lab 05 – Date and time interval

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

Lab 06 – Many-to-many relationships

Module 7: Working with 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?

Lab 07 – Granularity

Frequently Asked Questions

What is Generative AI for Content Creation?

Generative AI for Content Creation refers to using AI tools to generate or enhance content such as images, videos, voiceovers, music, narration, and other creative assets from prompts and reference materials.

How can Generative AI help with content creation?

Generative AI can accelerate ideation and production by helping users create images, video concepts, voiceovers, music, and other content assets. It can also automate repetitive production workflows and generate multiple content variations.

Can beginners learn AI content creation without technical skills?

Yes. The course is designed for content creators, marketing teams, designers, social media managers, and business professionals, with practical exercises focused on prompting, creative production, and workflow automation rather than traditional programming.

Can Generative AI create videos and voiceovers?

Yes. The course covers prompt-to-video, image-to-video, AI voiceover, narration, music, sound design, voice cloning, and multilingual dubbing. Participants also learn about the current limitations of AI-generated video and audio.

What tools are used in this Generative AI content creation course?

The course introduces platforms and tools including Figma Weave, Krea, OpenArt, AI image and video models, and dedicated audio tools. Examples covered include ChatGPT Images, Nano Banana, Imagen, Veo, Seedance, Kling, ElevenLabs, and Minimax.

Is AI-generated content safe to use commercially?

AI-generated content may involve copyright, attribution, licensing, privacy, and confidentiality considerations. The course teaches participants how to identify these risks and apply responsible practices when creating content for commercial use.

Is this course HRDC Claimable?

Yes, the course can be offered as an HRDC claimable training programme, subject to applicable HRDC requirements, approval, and the employer's eligibility.

Can this Generative AI content creation course be customized?

Yes. The course can be customized around an organization's content requirements, brand guidelines, target audiences, preferred AI tools, and real-world content production workflows.

GRC-104FT: Intensive Data Modeling For Microsoft Power BI Creators [Fastrack]

WHAT WILL YOU LEARN

OBJECTIVES

PREREQUISITES

COURSE MODULE

Frequently Asked Questions

Contact Us