Home

/

Courses

/PB 11 Power bi Nov 2024

PB 11 Power bi Nov 2024

Learn with TNA

15 modules

Lifetime access

Master Power BI for effective data analysis and visualization

Overview

This course is designed to provide a comprehensive understanding of Power BI, a business analytics tool by Microsoft. Participants will learn how to create interactive visualizations and reports to derive insights from data. The course will cover topics such as data modeling, DAX functions, data visualization best practices, and more. By the end of the course, students will have the skills to leverage Power BI for data analysis and decision-making.

Key Highlights

Interactive visualizations

Data modeling

DAX functions

Data visualization best practices

What you will learn

Enhanced Data Analysis Skills

Learn to create interactive visualizations and reports for data analysis using Power BI.

Data Modeling Techniques

Understand data modeling concepts to structure data effectively for analysis.

Advanced DAX Functions

Master DAX functions to perform calculations and data manipulations in Power BI.

Visual Best Practices

Explore data visualization best practices and techniques for effective storytelling.

Modules

Demo Session

1 attachment • 1 hrs

Powerbi Demo

Session 1

1 attachment • 54 mins

Power Bi_ Session 1

Session 2

1 attachment • 46 mins

Power Bi _ Session 2

Session 3

1 attachment • 53 mins

Power bi _ Session 3

5th Nov

3 attachments

Recording

Merging of Queries in Power Query Editor, Import from Folder, Unpivoting/Pivoting, Examples, Parameters, Parameters as text/date filters

Class 5

7th Nov

3 attachments

Usage of parameters to dynamically change the datasource/environments, Creating DimDate Table, Custom Columns, Column by examples, Using group By functionality to create Aggregate tables, Include in report refresh, Enable/disable load.

Class 6

Query Folding, How Query folding improves the performance of the PBI model. Index Columns, Conditional columns

8th Nov

11th Nov

1 attachment

Data modeling and warehousing concepts: Facts, Dimensions, Normalization, Multi dimensional model. Hierarchy and Granularity

12th Nov

1 attachment

Cardinlities : One to many/Many to One, One to One, Many to Many, Bridge Table. Filter flow directions.

13th Nov

2 attachments

Introduction to DAX: DAX Syntax, DAX operators, Calculated Columns, Row Context. DAX Functions: IF, DIVIDE, MOD, INT

Class 12

14th Nov

2 attachments

Class 13

Nested IF, Switch() Function, Handling Blanks : ISBLANK, COALESCE. Reason for not using AND, OR & CONCATENATE functions and using respective Operators (&&, ||,&) instead. Text Functions : LEFT

18th Nov

2 attachments

Class 14

Text Functions: LEFT, FIND, SEARCH, SUBSTITUTE. DATE Functions: YEAR,MONTH,FORMAT,WEEKDAY,WEEKNUM,QUARTER. Creating Date Dimension Table

19th Nov

2 attachments

Measures, Filter Functions, Usage of measures to create Aggregates, Difference between Measures and Calculated Columns, DAX Functions: COUNTROWS, SUM, AVERAGE, MAX, MIN

Class 15

20th Nov

2 attachments

Class 16

Implicit and Explicit Measures, CALCULATE Function, SUMX,AVERAGEX, MAXX, MINX. Difference between SUM and SUMX, RELATED function, LOOKUPVALUE Function.

22nd Nov

FAQs

How can I enrol in a course?

Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.

Can I access the course materials on any device?

Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.

How can I access the course materials?

Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.

Can I interact with the instructor during the course?

Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.

About the creator

About the creator

Learn with TNA

Training

Rate this Course

₹ 3000.00

×

Order ID:

This course is in your library

What are you waiting for? It’s time to start learning!

Illustration | Payment success

Share this course

https://undefined/courses/PB-11-Power-bi-Nov-2024-6728b7b53f93842510acea3c

or

×

Wait up!

We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?

Illustration | Already enrolled in course