Microsoft Power BI

Power BI is an analytical tool that make visualized story to your unstructured Data. Learn Power BI from industry experts and help your business or organization to ask the right questions and receive actionable insights when using large data. With us you can get expertize in Power BI Desktop, Power BI DAX, Power BI Q&A, Power BI Content packs, Power BI Custom Visuals, Power BI Integrations with Azure Machine Learning and SQL Services.


Curriculum:

Module 1: Introduction to Power BI

  • Introduction to Visualization
  • Why Business Intelligence
  • Introduction to Power BI
  • Power BI Architecture
  • Components of Power BI
  • Power BI Flow
  • Introduction of Power BI Desktop
  • Power BI Licensing (Free vs Pro vs Premium)
  • Power BI Desktop Installation
  • Power BI Desktop User Interface and Views

Module 2: Data Loading in Power BI

  • Types of Data Sources in Power BI
  • Data Loading Modes and Advantages

Module 3: Data Transformation 1

  • First Row Header
  • Duplicate Columns
  • Split Columns
  • Remove Duplicate/Columns
  • Replace Value
  • Change Data Type
  • Group BY

Module 4: Data Transformation 2

  • Pivot and Unpivot
  • Formatting data
  • Add Custom Columns
  • Invoke Function
  • Append Queries
  • Join Merge Queries
  • Combine Files (Folder)
  • Parameters
  • Other Query Features

Module 5: Data Modeling 1

  • Components of Data Modeling
  • Introduction to Data Models
  • Data Model Engine
  • Types of Data Model (Flat, Star & Snowflake)
  • Granularity of Data & multiple fact tables
  • Data Modeling Relationships
  • One to One
  • One to Many
  • Many to Many

Module 6: Data Modeling 2

  • Roll Playing Tables
  • Sorting/Renaming/Hiding Tables
  • Hierarchy Creation
  • Formatting & Data Category
  • Grouping / Binning
  • Drill Through Reports
  • What IF Parameter

Module 7: Power BI Visualization 1

  • Designer Options
  • Power BI Visualization Types
  • Custom Visualization
  • Best Practices
  • Choosing Colors
  • Types of Charts and Usage
  • Slicers / Filters
  • Creating Complete Visualization Report (Practical)

Module 8: Power BI Visualization 3

  • Continue Creating Complete Visualization Report (Practical)
  • Story Telling with the created Report
  • Bookmarks / Selection Pane
  • Spotlight
  • Drill Through
  • Additional Features

Module 9: Power BI Service 1

  • Publishing / Deploying Reports
  • Apps Workspace & Roles
  • Creating Dashboard
  • Q&A
  • Quick Insights
  • Dashboard Options
  • Subscription
  • Alerts

Module 10: Power BI Service 2

  • Export Options (Embed, Web, Power Point…etc.)
  • Excel Integration
  • Row Level Security
  • Data Refresh Concept
  • Gateway and Installation
  • Power BI Mobile Service
  • Power BI Admins Roles
  • Audit Logs

Module 11: DAX 1

  • Introduction DAX
  • DAX Data Types
  • Calculated Columns
  • Calculated Tables
  • Calculated Measures
  • Calculated Columns vs Measures
  • Aggregated Functions (SUM, MIN, MAX, AVG, COUNT)
  • Relate Functions (RELATED & RELATED TABLE)
  • Iterative Functions (SUMX, AVGX, COUNTX)
  • Variables (VAR)
  • Logical functions (AND, OR, IF, SWITCH)
  • Table Functions (VALUES, FILTER, CALCUILATETABLE)
  • FORMAT FUNCTION, FIND, SEARCH, SUBSTITUE, VALUE, UNION, ROW, ADDCOLUMNS, SUMMARIZE
  • Handling Blanks (ISBLANK, NOTISBLANK)
  • Rank Functions (RANKX)

Module 12: DAX Date and Time Intelligence

  • CALCULATE (ALL, ALLEXCEPT, ALLSELECTED)
  • Understand Row & Table level Filter Context
  • Date Functions (DATEADD, DATEDIFF, TODAY Required Date Formats)
  • Calendar Functions (CALENDAR, CALENDAT AUTO)
  • Time Intelligence functions (TOTALMTD, TOTALQTD, TOTALYTD, PARALLELPERIOD, SAMEPERIODLASTYEAR, PARALLELPERIOD, RUNING TOTAL)
  • SEMI ADDITIVE (OPENING BALANCE, CLOSING BALANCE, LAST DATE, FIRST DATE, LASTNONBLANK, FIRSTNONBLANK)

Module 13: Project & Discussion (Q&A)

  • Project 1
  • Project 2

Course Highlights


        No. of hours: 45 hours

        Star Rating: (4)

       Trainer:
        No. of learners: 49


Recommended courses

Core Python

Enroll Now

Java Programming

Enroll Now

Data Science with Python

Enroll Now

Linux Administration

Enroll Now

Tally ERP 9 with GST

Enroll Now



Fee:

Online Virtual Class Room

Enroll in any above batch and attend live class at scheduled time

10000      


Offline Class Room

Visit our centre and enrol for the course, The course Fee will vary as per the Metro/ Non Metro or locality.

10000      




Upcoming Batches:



FAQ:

1. Who can learn this course?
Anyone who is interested and having prior computer knowledge can learn Power BI.
2. What are the prerequisites for this course?
No prerequisite as such, if you have computer knowledge you can learn Power BI.
3. What are career opportunities from this course?
You can apply for jobs like Power BI Developer, BI Developer, BI Architecture after covering this course.
4. How long this course will take?
This course will take 25 hours practical live class. After that you can practice as much as you can.
5. Will you provide soft copy material?
Yes, we will share the Power Point soft copy material and we will provide recording of our live classes
6. I am working on Microsoft Excel can I learn Power BI to enhance my skills?
Yes, you can learn, and it will be added advantage to enhance your career as a Developer.
7. I don’t have any technical education; can I apply for this course?
Yes, this is more on GUI interface and easy to lean. No technical background is required.
8. Will you start this course from scratch?
Yes. We will start this course from scratch.
9. Do you provide a license for Power BI Service?
Yes, we do provide 2 months trail Pro License to practice and explore all the Power BI Service
10. Do you provide projects to work on?
Yes, after completion of course you will to work on 2 or 3 projects to work. It will hand on experience to clear the interviews confidently.


Reviews:



Sep-14-2023

abhishek kumar

I appreciated the flexibility of this class. The instructor offered both in-person and online options, which made it accessible to everyone. The online materials were well-structured, and I could go at my own pace. It made learning data analytics convenient

Jan-06-2021

Laksh Kumar

This course is awesome! It really makes you see the important things about teaching in higher education and shows you a lot of examples for every topic!

Jan-06-2021

Pawan Kumar

Thank you for this course. I can definitely show of the new things I've learned. Looking forward to the follow up; if an advanced course could be orgainsed it would be highly appreciated.

Jun-20-2020

Laksh Kumar

Great course! Specific, clear, informative videos, illustrative tasks and very interesting information. Many thanks to the creators!

Contact us

Phone: +91-9999468662 +91-9999468661

Email: info@wifilearning.com

Enquiry
+91-9999468662 +91-9999468661       info@wifilearning.com
Contact on WhatsApp