Power BI Training

by Pramanicus Academy Claim Listing

In this course, you'll start by setting up Power BI in your system. Then you'll learn about connecting and shaping data, followed by creating Data Model. Next you will learn how to add calculated fields with Data analysis Expressions (DAX).

₹15950

Contact the Institutes

Fill this form

Advertisement

Pramanicus Academy Logo

img Duration

6 Weeks

Course Details

In this course, you'll start by setting up Power BI in your system. Then you'll learn about connecting and shaping data, followed by creating Data Model. Next you will learn how to add calculated fields with Data analysis Expressions (DAX).

You will then learn Visualizing Data with reports. By the end of the course student will be able to load data from different sources and create Data models and achieve expertise in business analytics.

 

What You Will Learn:

  • Chapter 1
  • Introducing Power BI Desktop
  • Introduction
  • Downloading Power BI & Adjusting Settings
  • Regional Settings
  • Exploring the Power BI Desktop Interface & Workflow
  • Chapter 2
  • Connecting and Shaping Data
  • Types of Data Connectors in Power BI Desktop
  • The Power BI Query Editor
  • Basic Table Transformations in Power BI, Editing Rows
  • Understanding Append Queries, Editing Columns, Replacing Values
  • Formatting Data, Pivoting and Unpivoting Columns
  • Splitting Columns, Creating a New Group, Introducing the Star Schema
  • Duplicating and Referencing Queries, Entering Data Manually
  • Merging Queries, Creating an Index Column, Creating Conditional Columns
  • Performing Basic Mathematical Operations, Working with Text Tools
  • Working with Numerical Values, Working with Date & Time
  • Creating a Rolling Calendar, Grouping & Aggregating Records
  • Configuring Power BI Data Source Settings
  • Chapter 3
  • Creating a Data Model
  • What is a "Data Model"?, Principles of Database Normalization
  • Understanding Data Tables vs. Lookup Tables
  • Understanding Table Relationships vs Merged Tables
  • Creating Table Relationships, Snowflake" Schemas in Power BI
  • Managing & Editing Table Relationships in Power BI Desktop
  • Managing Active vs. Inactive Relationships, Understanding Relationship Cardinality
  • Connecting Multiple Data Tables, Understanding Filter Flow
  • Two-Way Filters in Power BI Desktop (USE WITH CAUTION!)
  • Hiding Fields from the Power BI Report View, Power BI Data Model Best Practices
  • Chapter 4
  • Adding Calculated Fields with DAX
  • Meet Data Analysis Expressions (DAX)
  • Intro to DAX Calculated Columns, Intro to DAX Measures
  • Calculated Columns vs. DAX Measures, Implicit vs. Explicit DAX Measures
  • Filter Context Examples, Step-by-Step DAX Measure Calculation
  • Understanding DAX Syntax & Operators, Common DAX Function Categories
  • Basic Date & Time Functions, Conditional & Logical Functions (IF/AND/OR)
  • Common Text Functions, Joining Data with RELATED, Basic Math & Stats Functions
  • COUNT Functions (COUNTA,DISTINCTCOUNT, COUNTROWS)
  • Order Line Items, CALCULATE, CALCULATE & ALL, CALCULATE & FILTER
  • Iterator Functions (SUMX, RANKX), Time Intelligence Formulas
  • DAX Best Practices in Power BI Desktop
  • Chapter 5
  • Visualizing Data with Reports
  • Exploring the "Report" View in Power BI Desktop
  • Adding Simple Objects to the Power BI Report Canvas
  • Inserting Basic Charts & Visuals in Power BI
  • Power BI Report Formatting Options, Power BI Report Filtering Options
  • Exploring Data with Matrix Visuals, Filtering with Date Slicers
  • Showing Key Metrics with Cards & KPI Visuals, Inserting Text Cards
  • Visualizing Geospatial Data with Maps, Visualizing Data with Treemaps
  • Showing Trends with Line & Area Charts, Adding Trend Lines & Forecasts
  • Goal Pacing with Gauge Charts, Editing Power BI Report Interactions
  • Adding Drill through Filters, Using Power BI Report Bookmarks
  • Testing Scenarios with "What-If" Parameters
  • Managing & Viewing Roles in Power BI Desktop
  • Custom Power BI Visuals (Log-in Required)
  • Designing for Phone vs. Desktop Report Viewers
  • Publishing to Power BI Service, Power BI Data Visualization Best Practices
  • Hyderabad Branch

    3-8-117/NR, Nehru Nagar, Hyderabad

Check out more Power BI courses in India

iFuture Technologies Logo

Data Analyst Course

iFuture Technologies is thrilled to present our Data Analyst Course, your gateway to mastering the art of data analytics and unlocking your potential in the realm of data-driven decision-making.

by iFuture Technologies [Claim Listing ]
Engineers 3D Logo

Big Data (Hadoop) Training

The Big Data (Hadoop) course is designed according to industry standards. Engineers 3d offers detailed training in Big Data (Hadoop) courses. We are the best in the industry. At Engineers 3d the course is taught by experienced professionals. 

by Engineers 3D [Claim Listing ]
DAAC (Doomshell Academy of Advance Computing) Logo

Certification In Big Data (Advance)

DAAC provides Big Data training in Jaipur, DAAC has industries best trainer who provides training to students in a professional manner according to industry requirements.

by DAAC (Doomshell Academy of Advance Computing) [Claim Listing ]
Aimore Technologies Logo

Data Analytics Course

Have you heard Of Data Analytics getting popular nowadays?… More and more students are opting to take these courses. However, given the diverse range of options, finding the right course that fits your needs and schedule can be difficult. 

by Aimore Technologies [Claim Listing ]
Alter Institute Logo

Big Data And Hadoop Course

Big Data refers to vast sets of structured and unstructured data that traditional processing methods struggle to handle. Hadoop is an open-source framework designed to store, process, and analyze Big Data.

by Alter Institute [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy