Data Analytics

SK IT Software Solution provides Data Analytics Online Course.

$599

  • What is BI?
  • Why we need BI
  • What is Power BI?
  • Installation of Power BI
  • Components of Power BI Desktop
  • Types of Data Loading
  • Import Mode
  • Direct Query Mode
  • Import vs Direct Query Mode
  • Composite Models
  • Most Commonly Used Data Sources
  • Excel
  • Text / CSV
  • SQL Server /Oracle
  • SSAS (Analysis Service)
  • SharePoint List / Online / Folder
  • Folder
  • Other Data Sources
  • Remove Columns
  • First Row Header
  • Duplicate Columns
  • Split Columns
  • Remove Duplicate
  • Replace Value
  • Change Data Type
  • Group BY
  • Formatting data
  • Add Custom Columns
  • Invoke Function
  • Append Queries
  • Merge Queries
  • Combine Files(Folder)
  • Parameter
  • Introduction to Data Modeling
  • 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
  • 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
  • Categorical and Trends Data Together (Combo)
  • Geographical Data and Maps
  • Filters
  • Bidirectional filters
  • What is Power BI SERVICE?
  • 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
  • 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
  • Aggregated Functions
  • Relate Functions
  • Iterative Functions
  • Variables
  • Logical functions
  • Table Functions
  • Handling Blanks
  • Rank Functions
  • Date Functions
  • Calendar Functions
  • Time Intelligence functions
  • SEMI ADDITIVE
  • Download and Install Tableau
  • Load Data from Excel
  • User Interface of Tableau
  • Dimensions vs. Measures
  • Application of Discrete and Continuous Fields
  • Bar Chart
  • Stacked Bar Chart
  • Line Chart
  • Scatter Plot
  • Dual-Axis Charts
  • Combined-Axis Charts
  • Funnel Chart
  • Cross Tabs
  • Highlight Tables
  • Maps
  • Measure Names and Measure Values
  • Filters in Tableau
  • Filters in Tableau
  • Dimension Filter
  • Date Filter
  • Measure Filter
  • Visual filter
  • Interactive Filter
  • Data Source Filter
  • Context Filter
  • Dashboards in Tableau
  • Dashboard
  • Working with Layout
  • Objects in Dashboard
  • Making Dashboards Interactive
  • Story
  • Level of Details
  • Introduction to Level of Detail (LODs)
  • Fixed LOD
  • Include LOD
  • Exclude LOD
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:00AM 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]