We are excited to offer a special deal of 50% off from our list price to continue your learning journey. Don't miss this opportunity to explore more and enhance your skills.

Importance of Learning An Analytical Journey with Microsoft Power BI Course

In the current business landscape, where data plays a crucial role in decision-making, having a strong command over Microsoft Power BI can prove to be immensely beneficial in transforming data into actionable insights. The training course "An Analytical Journey with Microsoft Power BI" is designed to equip you with a comprehensive set of skills that are essential to leverage this powerful tool effectively and efficiently. By enrolling in this course, you can gain a deeper understanding of the nuances of Microsoft Power BI and learn how to harness its full potential to drive business growth success.

Benefits of Learning Microsoft Power BI

his course offers a deep dive into all aspects of Power BI, from connecting and transforming data to creating insightful visualizations. By learning how to manage data sources, cleanse and format data, and utilize DAX for calculations, you gain a robust foundation for any data analysis task.

Microsoft Power BI Public Class

GRC-103FT Microsoft Power Platform End-To-End Discovery Workshop (Fastrack).png

ILT/VILT

GRC-101FT: An Analytical Journey with Microsoft Power BI [Fastrack]

Date:

25/7/2024 - 26/7/2024

Normal Price:

Payment via Website:

RM 3,000

RM 1,500

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.

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

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

ILT/VILT

Professional Certificate in Data Analytics with Microsoft Power BI

Date

Topic 1:

29/7/2024 - 30/7/2024

Topic 2:

12/8/2024 - 14/8/2024

Topic 3:

26/8/2024 - 27/8/2024

Topic 4:

28/8/2024

Normal Price:

Payment via Website:

RM 12,920

RM 6,460

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.

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.

Each module is designed not just to impart knowledge but to ensure its practical application, with a strong emphasis on real-world scenarios. Upon successful completion of the final assessments, candidates will be awarded the "Professional Certificate in Data Analytics with Microsoft Power BI," signifying their readiness to meet the industry's demands for data-savvy professionals.

Professional Certificate by USM Graduate School of Business
Certificate of Completion by GemRain Consulting
Power BI Data Analyst Associate Certificate by Microsoft
2 hours of exam preparation (We will notify you of the exam preparation date)

The Common Challenges

Integrating data from various sources can be daunting. The course covers how to connect Power BI with different data sources, including Excel and databases, ensuring a seamless data integration process

Data Integration Challenges

Ensuring data quality is crucial for accurate analysis. Participants learn to cleanse, format, and transform data using Power Query, which helps in handling inconsistencies and preparing data for analysis efficiently

Data Cleansing and Transformation

Many struggle with presenting data in a way that is both understandable and impactful. The course teaches you how to use Power BI's visualization tools to create interactive and insightful reports and dashboards.

Creating Effective Visualizations

Do you have a Private In-House class?

Yes, we have and the minimum to have a Private In-House class starts from 5 participants and the maximum participants per session is 25. The training venue can be at your premise or at our training center at Jaya One.

Request for In-house Quotation

Importance of Learning An Analytical Journey with Microsoft Power BI Course

Benefits of Learning Microsoft Power BI

Microsoft Power BI Public Class

GRC-101FT: An Analytical Journey with Microsoft Power BI [Fastrack]

Professional Certificate in Data Analytics with Microsoft Power BI

I want to register for this training!

The Common Challenges

Do you have a Private In-House class?