ABOUT
FITA ACADEMY
FITA is a leading Skill development
and Placement company
managed by IT veterans with
more than two decades of experience
in leading MNC companies. We
GREAT
are known for our practical
approach towards trainings that FUTURE
enable students to gain real-time
exposure on competitive technologies
& Foreign Languages.
STARTS
Transforming Students & IT
Professionals into FROM
Industry-Ready Workforce
since 2012!
HERE
Since
2
120+ 75,000+
COURSES STUDENTS
1000+
EXPERT
TRAINERS
0 PLACEMENT
SUPPORT
100%
1500+
1 15+
PLACEMENT
TIEUPS 2
Classroom Locations
BRANCHES*
Chennai Bangalore Coimbatore Madurai Pondicherry
*Includes all the group companies
300+ Corporate Clients
OUR STUDENTS
WORKS AT:
Why Learn Data Analytics - Sql Power BI at FITA Academy:
Live Capstone Projects
Real time Industry Experts as Trainers
Placement Support till you get your Dream Job offer!
Free Interview Clearing Workshops
Free Resume Preparation & Aptitude Workshops
Students at Placement Workshop:
DATA ANALYTICS - SQL & POWER BI
Data Analytics Fundamentals:
What is Data Analytics?
Data Analytics vs Data Science vs AI?
Why is Data Analytics Important?
Where is Data Analytics used
Future of Data Analytics
Opportunities in Data Analytics
Popular Tools for Data Analytics - Tableau, Power BI and
FITA Academy
Other data analytics tools
Role of SQL in Data Analytics
Importance of Statistics
Structured Query Language:
SQL Introduction
SQL Basic Overview
Query Language
SQL Server
MySQL
Oracle Database
SQL Database User
SQL*Plus
Connect with System User
Create a new Database User
Log into new User
SQL Database
Create Database
Delete or Drop Database
Use Database
FITA Academy
Create Database in SQL Server
Rename Database
SQL Table
Create table
Create Table in SQL Server
Delete or Drop table
Insert Data into table
Select Distinct
Select Top
Where Clause
Aliases
Update Table
AND, OR, NOT
IN
Between
Order By
Group By
Rank
Dense_Rank
Having
Exists
ANY and ALL
CASE Statement
Select Into
Alter Table
FITA Academy
Order of execution of a Query
SQL Constraints
Constraints Introduction
Not Null
Unique
Primary Key
Foreign Key
Check
Default
Index
Auto Increment Field
Cascading referential integrity constraint
Identity Column in SQL Server
SQL Keywords
Keywords Introduction
SQL Data Types
Data Types Introduction
SQL Operators
Operators Introduction
SQL Wildcard Characters
Wildcard Introduction
Like
FITA Academy
SQL Joins
Joins Introduction
Inner Join
Left Join
Right Join
Full Join
Self Join
Union
Cross Join
Advanced Join
SQL Aggregate Function
Introduction
Min
Max
Count
Avg
Sum
SQL Views
Views Introduction
Advantages of View
Updateable Views
Limitations of views
SQL Dates
Dates Introduction
SQL Stored Procedures
Stored Procedures Introduction
FITA Academy
SQL Functions
Functions Introduction
Table Valued Functions
Scalar Valued Functions
Stored Procedure VS Function
Multi-Statement Table Valued Functions
Function WITH ENCRYPTION
Function WITH SCHEMABINDING
String Functions in SQL Server
Ascii()
Char()
Ltrim()
Rtrim()
Lower()
Upper()
Reverse()
Len()
Left()
Right()
CharIndex()
Replace()
Stuff()
SQL Server Date Functions
ISDATE()
DAY()
FITA Academy
MONTH()
YEAR()
DATENAME()
DATEPART()
DATEADD ()
DATEDIFF()
Real time Example
Other Functions in SQL Server
Cast()
Convert()
Mathematical Functions in SQL Server
Mathematical Functions
Backup and Restore
Backup in SQL Server
Database Restore
Mastering POWER BI
INTRODUCTION TO POWER BI
Why Use Power BI?
Power BI Desktop Power BI Pro vs. Free
Explanation of ETL process (Extract, Transform, Load)
Data Types
CREATING POWER BI REPORTS, AUTO FILTERS
Report Design with Database Tables
Understanding Power BI Report Designer
FITA Academy
Report Canvas, Report Pages: Creation, Renames
Report Visuals, Fields and UI Options
Experimenting Visual Interactions, Advantages
Reports with Multiple Pages and Advantages
Pages with Multiple Visualizations.
Data Access PUBLISH Options and Report Verification in Cloud
"GET DATA" Options and Report Fields, Filters
Report View Options: Full, Fit Page, Width Scale
Stacked bar chart, Stacked column chart Clustered bar
chart, Clustered column chart
Adding Report Titles. Report Format Options
Focus Mode, Explore and Export Settings
REPORT VISUALIZATIONS and PROPERTIES
Power BI Design: Canvas, Visualizations and Fields
Import Data Options with Power BI Model, Advantages
Data Fields and Filters with Visualizations
Visualization Filters, Page Filters, Report Filters
Conditional Filters and Clearing. Testing Sets
Creating Customized Tables with Power BI Editor
General Properties, Sizing, Dimensions, and Positions
Alternate Text and Tiles. Header (Column, Row) Properties
FITA Academy
Grid Properties (Vertical, Horizontal) and Styles
Table Styles & Alternate Row Colors - Static, Dynamic
Sparse, Flashy Rows, Condensed Table Reports. Focus Mode
Total Computations, Background. Borders Properties
Column Headers, Column Formatting, Value Properties
Conditional Formatting Options - Color Scale
Page Level Filters and Report Level Filters
Visual-Level Filters and Format Options
Report Fields, Formats and Analytics
Page-Level Filters and Column Formatting, Filters
Background Properties, Borders and Lock Aspect
CHART AND MAP REPORT PROPERTIES
Chart report types and properties
Stacked bar chart, stacked column chart
Clustered bar chart, clustered column chart
100% stacked bar chart, 100% stacked column chart
Line charts, area charts, stacked area charts
Line and stacked row charts line and stacked column charts
waterfall chart, scatter chart, pie chart
Field Properties: Axis, Legend, Value, Tooltip
FITA Academy
Field Properties: Color Saturation, Filters Types
Formats: Legend, Axis, Data Labels, Plot Area
Data Labels: Visibility, Color and Display Units
Data Labels: Precision, Position, Text Options
Analytics: Constant Line, Position, Labels
Working with Waterfall Charts and Default Values
Modifying Legends and Visual Filters - Options
Map Reports: Working with Map Reports
Hierarchies: Grouping Multiple Report Fields
Hierarchy Levels and Usages in Visualizations
Pre Ordered Attribute Collection - Advantages
Using Field Hierarchies with Chart Reports
HIERARCHIES and DRILLDOWN REPORTS
Hierarchies and Drill Down Options
Hierarchy Levels and Drill Modes - Usage
Drill-thru Options with Tree Map and Pie Chart
Higher Levels and Next Level Navigation Options
Aggregates with Bottom/Up Navigations. Rules
Multi Field Aggregations and Hierarchies in Power BI
EXTRACTING & TRANSFORMING DATA
Extracting data from various sources: Text/CSV files,
FITA Academy
Excel worksheets, Multiple Files in a Folder, and more
Transforming data using the Power Query Editor:
ETL = Extract, Transform, Load
ELT = Extract, Load, Transform
DATA TRANSFORMATIONS
Use First Row as Headers
Remove Empty rows (null data)
Split Column By Delimiter
Applied Steps
Merge Queries
Append Queries
Fill Down
Transpose
Pivot
Column profiling for data quality check
Query Dependencies
RELATIONSHIPS
Relationship importance
Understanding types of relationship
Creating relationships
Cross filter relation: Single or Both
BUILDING/DESIGN A REPORT
Adding a Title
FITA Academy
Adding a Logo
Adding a Background (Solid Color or Photo)
DAX & MEASURES
Create Measures
Using Measures in a Data Visualization
Calculated Columns
Using DAX to create a Calculated Column
Navigating Related Tables using DAX
SLICERS
What Slicers Are
Adding & Using a Slicer
CAPSTONE PROJECT - 1
Retail Sales Analysis and Forecasting Using Python,
SQL, and Power BI
Project Description:
This capstone project aims to provide hands-on experience
in data analytics by combining the power of Python, SQL,
and Power BI to analyze and forecast retail sales. The
project will cover the entire analytics lifecycle, from data
extraction and preprocessing to advanced analysis,
visualization, and predictive modeling.
FITA Academy
Part 1: Data Extraction and Preparation
1. Project Overview and Data Understanding
Introduction to the retail sales dataset, which includes
sales transactions, product information, and customer
data.
Objectives: To analyze sales trends, identify key drivers
of sales, and forecast future sales.
2. Data Extraction with SQL
Task: Connect to the retail database using SQL Server.
Practical Session: Write SQL queries to extract data
from various tables (e.g., sales, products, customers).
3. Data Cleaning and Transformation with Python
Task: Clean and preprocess the extracted data
using Python.
Practical Session: Use Pandas for data cleaning
(handling missing values, data type conversion, and
normalization).
Part 2: Data Analysis and Visualization
1. Exploratory Data Analysis (EDA) with Python
Task: Perform EDA to understand sales trends
FITA Academy
and patterns.
Practical Session: Use Matplotlib and Seaborn to
visualize sales trends, seasonal patterns, and outliers.
2. Data Loading into SQL Database
Task: Load the cleaned data back into the SQL
database.
Practical Session: Use SQLAlchemy to facilitate the
data transfer from Python to SQL.
3. Advanced SQL Queries for Analysis
Task: Write advanced SQL queries to derive insights
from the data.
Practical Session: Use GROUP BY, JOIN, and subqueries
to analyze sales by region, product category, and
customer segment.
4. Creating Interactive Dashboards with Power BI
Task: Import the processed data from SQL Server
into Power BI.
Practical Session:
Connect Power BI to the SQL database.
Create interactive dashboards to visualize sales
performance, product trends, and customer
behavior.
Use various Power BI features like slicers, filters,
and drill-through functionalities.
FITA Academy
Part 3: Predictive Modeling and Forecasting
1. Sales Forecasting with Python
Task: Develop a sales forecasting model using
historical sales data.
Practical Session:
Use time series analysis and machine learning
techniques (e.g., ARIMA, Prophet, or LSTM) to
predict future sales.
Evaluate model performance using metrics such
as MAE and RMSE.
2. Integrating Forecasting Results into Power BI
Task: Visualize the forecasting results in Power BI.
Practical Session:
Import the forecasting results from Python into
Power BI.
Create a new dashboard to display the sales
forecasts alongside historical sales data.
Final Project: Comprehensive Retail Sales
Analysis Report
1. Compilation of Insights
FITA Academy
Task: Summarize the findings from the data analysis
and forecasting phases.
Practical Session:
Create a comprehensive report that includes
key insights, visualizations, and forecasts.
Use Power BI to design an executive summary
dashboard.
2. Presentation of Results
Task: Present the final analysis and recommendations
to stakeholders.
Practical Session:
Prepare a presentation that highlights the key
findings, visualizations, and actionable insights.
Demonstrate the interactive Power BI dashboards
and discuss the forecasting results.
By completing this capstone project, participants will gain
practical experience in integrating Python, SQL, and Power BI
to perform end-to-end data analytics. They will be equipped
with the skills needed to analyze complex datasets, create
FITA Academy
insightful visualizations, and make data-driven decisions,
making them valuable assets in any data-driven organization.
Follow FITA Academy in
Instagram for More Updates
FITA Academy
@fita_academy
