#No.1 online platform for trending courses!
Data Analytics Training
SK, LLC provides services in complete Software Development Life Cycle (SDLC) starting from requirement gathering, analysis as per client need, the design, technical documentation, coding, testing and ongoing support. SK has a team of subject knowledge experts working in the industry with trending technical skills like Service now, Selenium, QA, Tableau, Power BI and Industry standards like ITIL setup knowledge. We partner with companies and individuals to address their unique needs, providing training and coaching that helps everyone to achieve their career goals.
Course Prerequisites
About Course
Designed to meet the industry benchmarks, Data Analytics Training is curated by top industry experts. This course is created to help you gain expertise in the Data Analytics. You will also master the about the skills and responsibilities of a data analyst and hear from several data experts sharing their tips & advice to start a career. Enroll now to become a Data Analyst expert with SK IT Software Solutions.
Curriculum
124 Lessons
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
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
Project 1: Comparative Study of Countries
Project 2: Sales Performance Analysis
Project 3: Customer Analysis
Project 4: Product Analysis
Project 5: Sales Dashboard