Power BI Training

SK IT Software Solution provides 100% job-oriented instructor led real-time Power BI course online training by subject matter experienced professionals with latest updates in business analysis in relevant domain and real time scenarios.

$499

  • What is Visualization?
  • What is BI?
  • Why we need BI
  • What is Power BI?
  • Power BI Architecture
  • Installation of Power BI
  • Components of Power BI
    Types of Data Loading
  • Import Mode
  • Direct Query Mode
  • Import vs Direct Query Mode
  • Composite Models
    Most Commonly Used Data Sources
  • Excel
  • Text / CSV
  • MS Access
  • Web Link
  • PDF
  • SQL Server /Oracle
  • SSAS (Analysis Service)
  • SharePoint List / Online / Folder
  • Folder
  • Other Data Sources
    TRANSFORMS
  • Remove Columns
  • First Row Header
  • Duplicate Columns
  • Split Columns
  • Remove Duplicate
  • Replace Value
  • Change Data Type
  • Group BY
  • Pivot and Unpivot
  • Formatting data
  • Add Custom Columns
  • Invoke Function
  • Append Queries
  • Merge Queries
  • Combine Files(Folder)
  • Parameters
  • Other Query Features
  • Introduction to Data Modeling
  • Deployment Cycle
  • Data Model Engine
  • What is Data Model
  • Relationships in Power BI - One to One, One to Many, Many to Many
  • Tables and Relationship
  • Grouping / Binning
  • Drill Through Reports
  • What IF Parameter
  • Bidirectional filters
  • Overview
  • Best Practice
  • Visualization types
  • Custom visuals
  • Creating power BI Visuals
  • Bar Chart and Line Chart
  • Combining charts
  • Adding slicers for filters
  • Tabular data /Matrix
  • Cards / Multi Cards
  • Categorical data
  • Data Trends
  • Categorical and Trends Data Together (Combo)
  • Geographical Data and Maps
  • Filters
  • Report Level
  • Page Level
  • Visual Level
  • Bidirectional filters
  • Synonyms
  • Custom Colors, Color Picker
  • What is Power BI SERVICE?
  • Licensing (Free Vs Pro Vs Premium)
  • App workspace
  • What is Report Server
  • Power BI Q&A
  • Bookmarks
  • Deploying/Publishing Power BI Report
  • Creating and sharing dashboard
  • Setting up APP workspace
  • Subscription and Alerts
  • Analyze Excel Integration
  • Usage Metrics Report
  • Quick Insights
  • Data Security (RLS)
  • Export and Embed Option
  • Refreshing Data Overview
  • Installing the Data Gateway
  • Enterprise vs Personal Gateway
  • Scheduling the Data Refresh
  • Power BI Admin Role
  • Power BI Updates
  • Installing SQL Server with Tabular Mode
  • Installing Visual Studio
  • Installing SSDT
  • Creating a new Tabular Model
  • Data Modelling in SSAS Tabular
  • Deploy the Model
  • Processing Tabular Model
  • Schedule Processing (SQL Server Agent & SSIS)
  • Power BI Desktop vs SSAS Tabular
  • Mobile Power BI Overview
  • Designing the reports and Dashboard for Mobile
  • Interacting with Mobile Power BI App
  • Introduction to DAX
  • Calculated Columns
  • Calculated Tables
  • Calculated Measures
  • Calculated Columns vs Measures
  • Evaluation Contexts (ROW & FILTER Contexts)
  • Aggregated Functions (SUM,MIN,MAX,AVG,COUNT)
  • Relate Functions (RELATED & RELATED TABLE)
  • Iterative Functions (SUMX, AVGX, COUNTX)
  • Variables (VAR)
  • Logical functions (IF, SWITCH)
  • Table Functions (ALL, ALLEXCEPT,VALUES,FILTER,CALCUILATETABLE) o FORMAT FUNCTION, FIND, SEARCH, SUBSTITUE, VALUE, CALCULATE,UNION,ROW,ADDCOLUMNS,SUMMARIZE
  • Handling Blanks (ISBLANK,NOTISBLANK)
  • Rank Functions (RANKX)
  • 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)
  • Dynamic Measures, Dynamic Filters & Dynamic chart Axis
  • After the completion you will have 3 real time projects to practice
  • To hands on and explore Power BI Service options and features of real time
Date Day Time in Easter Time Zone(EST) Registration Link
Weekday Batch Every weekday 9:00 AM to 10:00 AM Register Now
Weekday Batch Every weekday 8:00 PM to 9:00 PM Register Now
Weekend Batch Every Saturday & Sunday 9:00 AM to 11:00 AM Register Now

Certification

  • SK IT Software Solutions Will Provide Certificate After successfully Complete The Course.

Projects

  • Real Time Project work done by Student
  • Guidance on Interview and Resume Preparation.

FAQ

Please register for the Free demo with your contact details to attend the free demo.
Yes, all our courses are “Pay One Time, Access LifeTime ”. Student can rejoin live classes up to 12 months and training videos are for lifetime access.
Log in to https://skitsolutions.org/101121, or talk to us on +1 470-691-2510 or send us an email at info@skitsolutions.org
We provide course materials, vidoes, interview questions, practicals and resume preparation.
Yes, Assignments are from real projects. Assignments are key to understand the course.
All the classes are Instructor-led, Live Online classes where you will have face-to-face interaction with your Instructor.
At the end of the course, students will receive course completion certificates based on their Graded Assignments and feedback from the instructor.

Reviews

[product_reviews_with_form]