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

Career Mudhra Logo

Big Data Hadoop & Spark

The demand for Big Data Hadoop professionals is increasing across the globe and it’s a great opportunity for the IT professionals to move into the most sought technology in the present-day world.

by Career Mudhra [Claim Listing ]
  • Price
  • Start Date
  • Duration
Palmeto Logo

Microsoft Power BI

Microsoft Power BI course is offered by Palmeto. We help organizations train and build the skills to transform their performance. Our training deliverables built on years of unique relationships with leading organizations, lets us help you build skills in the very latest techniques.

by Palmeto [Claim Listing ]
Baudhyantram Coding Trainers And Developers Logo

Tableau

Tableau is a powerful and widely-used data visualization tool that allows users to create interactive and visually appealing dashboards, reports, and visualizations from various data sources. It enables users to analyze, visualize, and share insights from data in a user-friendly.

by Baudhyantram Coding Trainers And Developers [Claim Listing ]
NINT Logo

Hadoop (Big Data)

The Apache Hadoop software package library could be a framework that permits for the distributed process of enormous knowledge sets across clusters of computers victimization straightforward programming models.

by NINT [Claim Listing ]
4C Training Logo

Data Analytics

Data Analytics training is offered by 4C Training. 4C Training targets to design & deliver the right training programs for the growth of participants. We intend to become one of the well-known, respected, and preferred training partners for clients for all verticals. 

by 4C Training [Claim Listing ]

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