0
+
Google Reviews
0
+
4.5 (2459 Ratings)
The Data Analytics Combo (Without Python) course is designed for learners who want to build practical data analysis skills using SQL, Advanced Excel, and Microsoft Power BI. The training covers data cleaning, SQL queries, Excel analysis, dashboards, data visualization, reporting, and business insights through practical exercises and real-world datasets. Learners gain the skills to work with data, identify useful trends, and present findings clearly for better decision-making. This course is ideal for freshers, students, business analysts, finance professionals, MIS executives, and working professionals looking to start or advance their career in data analytics without learning Python.
Duration of Training : 60 Hours
Batch type : Weekdays/Weekends
Mode of Training : Classroom/Online/Corporate Training
Detailed Syllabus • Hands-on Labs • Assignments • Support-Focused • Implementation
Curriculum Designed by Experts
• Recommended Duration: 140–180 Hours
• Level: Beginner to Advanced
• Primary Stack: SQL | Advanced Excel | Power Query | Power Pivot | Power BI | DAX
• Learning Model: Concepts + Hands-On Labs + Assignments + Mini Projects + Capstone + Job Scenarios
• Target Roles: Data Analyst, BI Analyst, Reporting Analyst, MIS Analyst, Power BI Analyst, SQL Analyst,
Junior BI Developer
• End-to-end workflow: understand business questions, profile and clean data, query with SQL, analyze
with Excel, transform with Power Query, model data, build DAX measures, create dashboards, validate
results and communicate insights.
• Every major module includes practical work, assignments and workplace scenarios. Learners work with
raw, inconsistent and multi-source datasets and produce portfolio-ready deliverables.
1. Course Overview & Career Roadmap
• 1. Analytics fundamentals
• 2. Excel fundamentals
• 3. Advanced Excel
• 4. PivotTables & dashboards
• 5. Power Query
• 6. Power Pivot/data modeling
• 7. SQL fundamentals
• 8. SQL joins, CTEs and subqueries
• 9. Advanced SQL and window functions
• 10. Power BI fundamentals
• 11. Power BI modeling
• 12. DAX
• 13. Advanced DAX
• 14. Power BI Service, security and governance
• 15. Integrated projects
• 16. Capstone and interview preparation
• Analyze business data
• Write analytical SQL
• Build advanced Excel models
• Automate preparation with Power Query
• Design Power BI semantic models
• Create DAX KPIs and time intelligence
• Troubleshoot reporting issues
• Present insights to technical and non-technical stakeholders
• SQL query portfolio
• Advanced Excel workbooks
• Power BI dashboards
• Data model documentation
• KPI dictionary
• Project presentations
3. Prerequisites & Analytics Fundamentals
• Reconcile two reports with different revenue totals
• Explain a sales decline despite increased order volume
• Define daily operational KPIs for management
• Descriptive, diagnostic, predictive and prescriptive analytics
• Structured vs semi-structured data
• Dimensions, measures and attributes
• KPIs, metrics, targets and benchmarks
• Data quality: accuracy, completeness, consistency, uniqueness and timeliness
• Data profiling and validation
• Business questions vs analytical questions
• Mean, median, mode, variance and standard deviation
• Outliers, trends, seasonality
• Correlation vs causation
• Data storytelling
• Sales KPI Definition Lab
• Data Quality Profiling Lab
• Outlier Identification Lab
• Business Question-to-KPI Mapping Lab
• Create a KPI dictionary, analytical questions and data-validation checklist.
• Retail Sales Diagnostic Analysis — identify revenue trends, weak products, regions and customer
segments.
• Reconcile two reports with different revenue totals
• Explain a sales decline despite increased order volume
• Define daily operational KPIs for management
4. Excel Fundamentals For Data Analytics
• Workbook and worksheet management
• Tables and structured references
• Relative, absolute and mixed references
• Sorting, filtering and advanced filtering
• Data validation
• Text-to-Columns and Flash Fill
• Remove duplicates and data cleaning
• Conditional formatting
• Charts and visual selection
• Formula auditing
• CSV and text imports
• SUM, AVERAGE, MIN, MAX, COUNT, COUNTA
• IF, AND, OR
• SUMIF/SUMIFS, COUNTIF/COUNTIFS, AVERAGEIF/AVERAGEIFS
• ROUND, ROUNDUP, ROUNDDOWN
• LEFT, RIGHT, MID, LEN, TRIM, CLEAN, SUBSTITUTE
• CONCAT, TEXTJOIN, TEXT, DATE, YEAR, MONTH, DAY
• Sales Data Cleaning Lab
• Employee Attendance Analysis Lab
• Customer Master Cleanup Lab
• Monthly MIS Report Lab
• Build a sales tracker with validation and KPI formulas
• Clean a 10,000-row customer dataset and document the process
• Monthly Sales MIS Dashboard — revenue, orders, target achievement and regional performance
• Prepare daily MIS from CSV exports
• Identify duplicate customer records
• Create exception reports for invalid transactions
5. Advanced Excel Analytics
• XLOOKUP
• INDEX + MATCH
• Multi-criteria lookups
• Nested logical formulas
• Dynamic arrays: FILTER, SORT, UNIQUE
• LET
• Advanced date calculations
• Text standardization
• IFERROR
• Scenario and sensitivity analysis
• Goal Seek
• Data Tables
• Scenario Manager
• Forecasting concepts
• Advanced Lookup & Reconciliation Lab
• Dynamic Array Reporting Lab
• Target vs Actual Variance Lab
• Sales Forecasting Lab
• What-If Pricing Model Lab
• Build a multi-source reconciliation workbook
• Create a dynamic region/product/month report
• Build a price-volume-margin scenario model
• Financial Planning & Variance Analysis — actual vs budget, variance drivers and scenarios
• Finance month-end reconciliation
• Dynamic management report by region/product
• Revenue impact of multiple pricing scenarios
6. Pivottables, Pivotcharts & Exce Dashboards
• PivotTables
• Calculated fields
• Date grouping
• Slicers and timelines
• PivotCharts
• KPI cards
• Dashboard layout and visual hierarchy
• Conditional formatting for exceptions
• Presentation-ready reporting
• Sales Pivot Analysis Lab
• Customer Segmentation Lab
• Inventory Aging Lab
• Executive Excel Dashboard Lab
• Create a regional sales PivotTable with slicers
• Build an executive dashboard with at least five KPIs and three analytical views
• Retail Executive Dashboard — sales, margin, product mix, customer segment and monthly trend
• Weekly business review dashboard
• Slow-moving inventory analysis
• Refreshable monthly management report
7. Power Query & Data Preparation
• ETL workflow
• Excel, CSV, folder and database connections
• Data profiling and data types
• Remove/replace/split/merge
• Fill and group
• Merge and append
• Pivot and unpivot
• Conditional/custom columns
• Parameters
• Refreshable transformations
• Introduction to M language
• Folder-Based Monthly Consolidation
• Customer Master Cleaning
• Sales-Product Merge
• Operational Report Unpivot
• Parameterized Data Load
• Combine 12 monthly files into one refreshable dataset
• Standardize customer and product data
• Build a reusable monthly refresh process
• Automated Sales Data Preparation Pipeline using Power Query
• Consolidate files from 20 branches
• Handle changing date/currency formats
• Replace manual daily copying with a refreshable process
8. Power Pivot & Data Modeling
• Fact and dimension tables
• Primary and foreign keys
• Relationships
• Star schema
• One-to-many relationships
• Date dimension
• Calculated columns vs measures
• Power Pivot model
• Model size and performance
• Relationship validation
• Sales Star Schema Lab
• Date Dimension Lab
• Customer-Product Model Lab
• Power Pivot KPI Model Lab
• Design an e-commerce star schema
• Build a sales model
• Correct duplicate keys and relationship issues
• Multi-Table Retail Analytics Model — transactions, customers, products and calendar
• Incorrect totals caused by relationships
• Reusable model design
• Optimize a slow workbook
9. Sql Fundamentals
• Relational database concepts
• Tables, rows, columns and keys
• SELECT and DISTINCT
• WHERE and ORDER BY
• Aliases and calculated columns
• CASE
• NULL handling
• LIKE, IN and BETWEEN
• Aggregate functions
• GROUP BY and HAVING
• Date and string functions
• Customer Database Exploration
• Sales Filtering & Aggregation
• KPI Query
• Date-Based Sales Analysis
• Write 30 retail SQL queries
• Calculate revenue, order count, AOV and top products
• Identify invalid and duplicate records
• SQL Retail Sales Analysis — answer management questions using SQL
• Top 10 customers by revenue
• Month-wise sales and target comparison
• High-volume but low-revenue products
10. Sql Joins, Subqueries & Intermediate
Analytics
• INNER JOIN
• LEFT JOIN
• RIGHT/FULL OUTER JOIN concepts
• Self and cross joins
• Multi-table joins
• Subqueries and correlated subqueries
• EXISTS/NOT EXISTS
• UNION and UNION ALL
• INTERSECT/EXCEPT concepts
• CTEs
• Conditional aggregation
• Date analysis
• Cohort concepts
• Multi-Table Sales Join
• Customer 360 SQL
• Product Profitability Query
• CTE-Based KPI
• Join five related business tables
• Find customers absent from a comparison period
• Build a CTE-based monthly product report
• Customer 360 Analysis — customer, order, product and support data
• Preserve unmatched customers
• Find customers inactive for 90 days
• Identify high-revenue/low-margin products
11. Advanced Sql For Analytics
• Window functions
• ROW_NUMBER, RANK, DENSE_RANK
• LAG and LEAD
• Running totals and moving averages
• PARTITION BY
• Advanced CTEs
• Views
• Stored procedure concepts
• Temporary tables
• Transactions and ACID concepts
• Indexes and execution-plan concepts
• Duplicate detection
• Data reconciliation
• Query optimization fundamentals
• Top-N per Category
• Customer Ranking
• Running Sales Total
• Month-over-Month Growth
• Deduplication
• SQL Performance Investigation
• Regional ranking query
• Month-over-month growth using windows
• Duplicate detection/resolution
• Optimize a deliberately slow query
• Advanced SQL Business Performance Analysis — executive KPIs, ranking, trends and exceptions
• Second/third-highest performer by region
• Previous vs current purchase analysis
• First and latest transaction per customer
12. Power Bi Fundamentals & Data Acquisition
• Power BI Desktop and Service
• Reports, dashboards and semantic models
• Excel, CSV, SQL and folder connections
• Import vs DirectQuery concepts
• Power Query in Power BI
• Basic transformations
• Visual selection
• Filters and slicers
• Formatting and themes
• Interactions
• Publishing
• Power BI Desktop Setup
• Excel-to-Power BI Import
• SQL-to-Power BI Connectivity
• Basic Sales Dashboard
• Connect Power BI to a relational sales database
• Create a three-page summary, trend and detail report
• Power BI Sales Performance Dashboard
• Convert Excel MIS to Power BI
• Build a SQL-driven management report
• Create drillable sales reporting
13. Power Bi Data Transformation & Modeling
• Merge and append
• Query folding concepts
• Parameters
• Fact/dimension design
• Star schema
• Cardinality
• Filter direction
• Date tables
• Import vs DirectQuery decisions
• Model validation and performance
• Multi-Source Integration
• Star Schema Modeling
• Date Table
• Relationship Troubleshooting
• Model Optimization
• Transform five raw sources
• Design a retail star schema
• Correct relationship-driven totals
• Enterprise Sales Semantic Model — reusable sales/customer/product/region/calendar model
• Duplicate totals
• Automated monthly appends
• Reusable semantic model across reports
14. Dax Fundamentals
• Measures vs calculated columns
• SUM, AVERAGE, COUNT, DISTINCTCOUNT
• CALCULATE
• FILTER and ALL
• IF and SWITCH
• DIVIDE
• Variables
• Date tables
• YTD, MTD and QTD
• Previous-period analysis
• Variance and growth
• KPI Measures
• Revenue & Margin
• Target vs Actual
• YTD/MTD/QTD
• Dynamic KPI
• Create 20 business measures
• Build revenue, margin, target and growth measures
• Create time-intelligence measures
• Sales KPI Semantic Model
• Same-period-last-year comparison
• Region-sensitive KPI
• Target achievement without double counting
15. Advanced Dax & Power Bi Analytics
• Filter context and row context
• Context transition
• SUMX and AVERAGEX
• Advanced ranking
• Top-N
• Dynamic titles
• Disconnected tables
• What-if parameters
• Dynamic segmentation
• Retention/cohort concepts
• Pareto analysis
• Rolling averages
• Advanced time intelligence
• DAX performance
• Top-N Product Analysis
• Pareto Customer Analysis
• Rolling 12-Month Sales
• Dynamic Segmentation
• What-If Parameter
• Dynamic Top-N selector
• Rolling 12-month KPI
• Customer segmentation measure
• 80/20 cumulative-revenue analysis
• Customer & Product Profitability Analytics
• Dynamic Top 10
• Rolling revenue trend
• Identify customers contributing 80% of revenue
16. Power Bi Dashboards, Service & Governance
• Executive dashboard design
• Drill-down and drill-through
• Tooltips
• Bookmarks and buttons
• Page navigation
• Conditional formatting
• Custom visuals
• Mobile layout concepts
• Power BI Service
• Workspaces
• Publishing and sharing
• Scheduled refresh concepts
• Gateway concepts
• Row-Level Security
• Governance concepts
• Executive Dashboard
• Drill-Through
• Tooltip Page
• Bookmark Navigation
• Row-Level Security
• Publish & Refresh
• Build a five-page executive report
• Implement regional RLS
• Create refresh and deployment checklist
• Regional Sales Command Center
• Regional data restriction
• Executive drill-through to root cause
• Investigate a failed refresh
17. Integrated Projects & Business Case Studies
• Retail Sales Analytics — Excel + SQL + Power BI
• HR Workforce Analytics — Excel + Power BI
• Inventory & Supply Chain Dashboard — SQL + Power BI
• Banking Customer Analytics — SQL + Excel
• E-Commerce Customer 360 — SQL + Power BI
• Finance Budget vs Actual — Advanced Excel + Power BI
• Marketing Campaign Performance — SQL + Power BI
• Service Desk KPI Analytics — Excel + SQL + Power BI
• Requirement gathering
• KPI definition
• Source identification
• Data profiling
• Cleaning
• SQL extraction and validation
• Excel reconciliation
• Power Query
• Data modeling
• DAX measures
• Dashboard design
• UAT
• Documentation
• Stakeholder presentation
• Business Requirement Document
• KPI Dictionary
• Source-to-Target Mapping
• SQL Query Pack
• Excel Workbook
• Power BI Semantic Model
• Interactive Dashboard
• Test Checklist
• User Guide
• Project Presentation
• Stakeholder changes a KPI definition
• Late or missing source data
• Business users challenge dashboard numbers and the analyst traces calculations to source
18. Capstone Project & Real-time Job Scenarios
• Enterprise Sales & Profitability Analytics
• E-Commerce Customer 360
• Financial Performance & Budget Analytics
• Supply Chain & Inventory Intelligence
• HR Workforce Analytics
• Marketing Campaign & Conversion Analytics
• Service Desk KPI Dashboard
• Enterprise Sales & Profitability Analytics Platform using SQL + Excel/CSV + Power Query + Power BI
• SQL extraction, joins, validation and advanced analysis
• Excel reconciliation and exception analysis
• Power Query automation
• Star-schema semantic model
• DAX KPIs for revenue, margin, growth, targets and rankings
• Executive dashboard with regional/product/customer drill-through
• Regional security concept and documentation
• Daily sales dashboard
• Month-end revenue reconciliation
• Sales target and incentive analysis
• Customer retention analysis
• Inventory aging
• Marketing ROI
• Finance variance reporting
• Operations SLA reporting
• Executive KPI reporting
• Ad-hoc SQL analysis
• Power BI refresh investigation
• Dashboard performance optimization
• Excel/SQL/Power BI mismatch investigation
• New KPI implementation
19. Troubleshooting, Industry Tools & Best Practices
• Duplicate SQL joins
• NULL-related analytical errors
• Slow SQL queries
• Broken Excel lookups
• Formula errors after source changes
• Power Query refresh/type issues
• Duplicate rows after merge/append
• Power BI relationship ambiguity
• Many-to-many issues
• Incorrect DAX totals/filter context
• Date intelligence problems
• Refresh/gateway issues
• RLS validation problems
• Slow Power BI visuals
• Microsoft Excel / Microsoft 365
• Power Query
• Power Pivot
• Power BI Desktop
• Power BI Service
• SQL Server / Azure SQL concepts
• MySQL / PostgreSQL concepts
• SQL Server Management Studio (SSMS)
• Visual Studio Code
• Git / GitHub
• Jira / Azure DevOps
• Microsoft Teams
• Define KPIs before visuals
• Validate source data
• Use consistent naming
• Build reusable transformations
• Prefer star-schema modeling
• Use measures efficiently
• Document business definitions
• Reconcile dashboards to source totals
• Avoid visual clutter
• Optimize SQL and data models
• Protect sensitive data
• Maintain versioned documentation
20. Certifications, Interviews, Resume & Placement
• Microsoft Certified: Power BI Data Analyst Associate (PL-300)
• Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) — MO-211
• Microsoft Certified: Azure Data Fundamentals (DP-900) as a complementary credential
• Relevant vendor SQL certifications for the target database platform
• SQL technical rounds
• Advanced Excel problem-solving
• Power BI/DAX scenarios
• Dashboard case studies
• Data validation scenarios
• Stakeholder communication
• Live SQL coding/debugging
• Power BI model review
• ATS-friendly Data Analyst resume
• Project-focused descriptions
• SQL + Excel + Power BI skill positioning
• Power BI portfolio guidance
• GitHub/project documentation
• LinkedIn optimization
• Achievement-oriented bullets
• Job-role mapping
• Resume screening and optimization
• Mock interviews
• Technical assessment preparation
• Portfolio presentation support
• Job application strategy
• Mentoring and career counseling
• Data Analyst
• Business Intelligence Analyst
• Power BI Analyst
• Reporting Analyst
• MIS Analyst
• SQL Analyst
• Business Analyst
• Junior BI Developer
• Data Visualization Analyst
• Reporting & Dashboard Specialist
• Learners should be able to take a business requirement, clean and validate data, write analytical SQL,
perform advanced Excel analysis, build a Power BI model, develop DAX measures, create executive
dashboards, troubleshoot reporting issues and present actionable insights.
Radical Technologies is the leading IT certification institute in Bangalore, offering a wide range of globally recognized certifications across various domains. With expert trainers and comprehensive course materials, it ensures that students gain in-depth knowledge and hands-on experience to excel in their careers. The institute’s certification programs are tailored to meet industry standards, helping professionals enhance their skillsets and boost their career prospects. From cloud technologies to data science, Radical Technologies covers it all, empowering individuals to stay ahead in the ever-evolving tech landscape. Achieve your professional goals with certifications that matter.
At Radical Technologies, we are committed to your success beyond the classroom. Our 100% Job Assistance program ensures that you are not only equipped with industry-relevant skills but also guided through the job placement process. With personalized resume building, interview preparation, and access to our extensive network of hiring partners, we help you take the next step confidently into your IT career. Join us and let your journey to a successful future begin with the right support.
At Radical Technologies, we ensure you’re ready to shine in any interview. Our comprehensive Interview Preparation program includes mock interviews, expert feedback, and tailored coaching sessions to build your confidence. Learn how to effectively communicate your skills, handle technical questions, and make a lasting impression on potential employers. With our guidance, you’ll walk into your interviews prepared and poised for success.
At Radical Technologies, we believe that a strong professional profile is key to standing out in the competitive IT industry. Our Profile Building services are designed to highlight your unique skills and experiences, crafting a resume and LinkedIn profile that resonate with employers. From tailored advice on showcasing your strengths to tips on optimizing your online presence, we provide the tools you need to make a lasting impression. Let us help you build a profile that opens doors to your dream career.
Basavanagudi | HSR Layout | Sadashivanagar | Jayanagar | Koramangala | Whitefield | Banashankari | Marathahalli | BTM Layout | Electronic City | Rajajinagar | Domlur | Indiranagar | Malleshwaram | Yelahanka | Cooke Town | Nagarbhavi | Bannerghatta Road | Chandapura | Dasarahalli | Devanahalli | Anandnagar | Avenue Road | Byatarayanapura
At Radical Technologies, we are committed to providing world-class Azure Data Engineer Training in Bangalore, helping aspiring data professionals master the skills needed to excel in the rapidly growing field of cloud data engineering. As the leading institute for Azure Data Engineer Course In Bangalore, we offer comprehensive, hands-on training designed to meet the demands of today’s data-driven organizations.
Our Azure Data Engineer Training Bangalore program covers every aspect of the Azure Data Engineer Syllabus, ensuring that students receive in-depth knowledge of data architecture, data processing, and data storage on Microsoft Azure. Whether you prefer attending classes in-person or via Azure Data Engineer Online Training, Radical Technologies provides flexible learning options to suit your needs.
Our Azure Data Engineering Training is renowned for its practical, real-world approach. Students have access to an industry-leading Azure Data Engineer Bootcamp, which combines theory and hands-on labs to ensure they are fully prepared for their certification exams. The Microsoft Azure Data Engineer Training is tailored to cover all key topics, from data integration to security, and is led by experienced professionals who are experts in their field.
For professionals and organizations seeking Azure Data Engineering Corporate Training, we offer tailored courses that address specific business needs. Our Azure Data Engineering Corporate Training Course ensures that teams gain practical experience in building scalable, secure, and efficient data solutions on Azure.
At Radical Technologies, our Azure Data Engineer Courses are structured to ensure that both beginners and experienced professionals alike can enhance their knowledge. The Azure Data Engineer Certification Training offered here equips students with the skills and credentials needed to stand out in a competitive job market.
Our institute also offers the Azure Data Engineer Full Course, which provides a comprehensive pathway for mastering Azure Data Engineering concepts and techniques. We take pride in being one of the top Azure Data Engineer Institutes in Bangalore, with a proven track record of helping students achieve their Azure Data Engineering Certification.
Whether you are looking for Azure Data Engineer Training Online or prefer our in-person classes in Bangalore, Radical Technologies is your trusted partner for career advancement in data engineering. Join us today to enroll in the Best Azure Data Engineer Course and kick-start your journey towards becoming a certified data engineer.
(Our Team will call you to discuss the Fees)
(Our Team will call you to discuss the Fees)