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

Quastech Logo

Big Data Engineering Course

Big data Engineering refers to the process of designing, building, and maintaining large-scale data processing systems that can handle massive volumes of data in various formats, such as structured, semi-structured, and unstructured data.

by Quastech [Claim Listing ]
Shine Computer Education Logo

Tableau

Tableau course is offered by Shine Computer Education.  We have been providing quality computer teaching for more than 6 years. Our aim is to provide expertise computer education to our students in their interested field. We have expert and experienced faculties for particular courses and subjec...

by Shine Computer Education [Claim Listing ]
Radical Technologies Logo

Power BI Training

Power BI course is offered by Radical Technologies for all skill levels. Radical Technologies is a recognized leader in training of Administrative and Software Development courses since 1995 to empower IT individuals with competitive advantage of exploiting untapped jobs in IT sector.

by Radical Technologies [Claim Listing ]
Learning 360 Academy Logo

Data Analytics Certification Course

Data Analytics is the systematic computational analysis of data or statistics. It is used for the discovery, interpretation, and communication of meaningful patterns in data. It also entails applying data patterns toward effective decision-making.

by Learning 360 Academy [Claim Listing ]
Institute for Technical Education Logo

Bigdata/Hadoop

The Big Data Hadoop course has been designed to impart an in-depth knowledge of Big Data processing using Hadoop. The course is packed with real-life projects and case studies to be executed in the Cloud Lab.

by Institute for Technical Education [Claim Listing ]

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