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

Ethans Tech Solutions LLP Logo

Data Analytics Course

In this course, you will learn the latest tools, and techniques with respect to SQL, Excel, Python, Data Handling techniques, Tableau, Power BI, Alteryx, and data visualization and how to handle the situation with the help of different tools in data analytics in a business environment.

by Ethans Tech Solutions LLP [Claim Listing ]
Trainocate India Logo

Enterprise Big Data Analyst

The Enterprise Big Data Analyst (EBDA) course discusses advanced techniques for the analysis of Big Data. In this course, you will learn how you can obtain value from data through statistical and machine learning techniques and how this analysis should be presented in a reproductible manner.

by Trainocate India [Claim Listing ]
Logic Computer Education Centre Logo

Data Analytics

Data Analytics course is offered by Logic Computer Education Centre. Our comprehensive curriculum, offered in both classroom and online formats, equips students with essential computer skills, from basic operations to advanced IT knowledge.

by Logic Computer Education Centre [Claim Listing ]
Excellence Academy (EA) Logo

Data Analytics Training

Dive into the realm of  Excellence Academy‘s Best Data Analytics Training & Certification in Chandigarh. Immerse yourself in 100% practical learning on live projects from global clients.

by Excellence Academy (EA) [Claim Listing ]
Web Brains Logo

Power BI Training

Power BI gives you a platform to be productive or creative with the reports and analytics. Power BI is easy because of the fact that it has a drag and drop interface and this feature helps in performing tasks like sorting, comparing and analyzing.

by Web Brains [Claim Listing ]

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