Hands-on Data Analysis training with 3 months internship.
Enrol Here👉
Training Duration: 3months
Number of Modules: 21
Total Hours: 54hours
Number of Case Studies: 13
Technologies:
Azure DevOps, Excel, SQL Server, T-SQL, MySQL, SSMS, Visio, Figma, Lucid chart, Miro, Power BI, Microsoft Teams, Jira/Atlasian Confluence, Power Query, DAX, M-Language, Power Point, Microsoft Office Word,
Capstone Projects: 1
Overview:
Embark on an immersive journey into the world of data analytics with our intensive 3-month training program, meticulously designed to transform beginners into job-ready professionals.
With a curriculum infused with practical insights and hands-on experience, participants will navigate through 21 comprehensive modules, dedicating 54 hours to master the essential tools and technologies vital for a successful career as a data analyst.
Course Highlights:
- Training Duration: A 3-month intensive program, tailored to instill a blend of theoretical knowledge and practical skills.
- Modules: Engage in 21 in-depth modules that cover a spectrum of topics including SQL, Excel, Power BI, data visualization, ETL processes, and more, each designed to offer a step-by-step learning experience.
- Total Hours: Dedicate 54 hours of interactive learning, where expert instructors facilitate sessions marked by personalized attention, ensuring each participant garners a holistic understanding of the topics.
- Case Studies: Apply learned concepts to 13 real-world case studies, each curated to offer hands-on experience, simulating challenges, and scenarios that professionals encounter in the business world.
- Capstone Project: Culminate your learning journey by undertaking a capstone project, a practical opportunity to showcase and apply the skills and knowledge amassed throughout the course
Who Should Enroll?
This course is tailored for aspiring data analysts, students, professionals looking to pivot their career into data analytics, and anyone passionate about harnessing the power of data to drive decision-making and business insights.
Outcome:
Upon completion, graduates will emerge fully equipped with the skills, knowledge, and confidence to delve into the professional world, armed with a portfolio that demonstrates their capability to transform data into actionable insights. Join us, and let’s journey together into the exhilarating world of data analytics, where every data tells a story and every insight is a step closer to business excellence!
Module 1: Introduction to Data Analysis & Case Study
Module 2: Introduction to SQL and SQL Server (2 hours)
- Understanding SQL (30 minutes)
- Introduction to SQL Server (30 minutes)
- Basic Database Concepts (1 hour)
- Case Study: Setting Up a Small Business Database
Module 3: Introduction to Excel (1 Hour)
- Overview of Excel Interface (20 mins)
- Basic Operations (40 mins)
- Case Study: Organizing a Small Business Inventory
Module 4: Requirement Gathering and Stakeholder Interaction (3hours)
- Requirement Gathering Techniques
- Interaction with Stakeholders
- Day 3: Collaboration Tools
- Case Study: Organizing interview and brainstorming sections
Module 5: Basic SQL Queries (4 hours)
- Data Retrieval (1 hour)
- Advanced Data Retrieval (2 hours)
- Practicum- Hands-on Exercises (1 hour)
- Case Study: Retail Sales Data Retrieval
Module 6: Data Handling and Management in Excel(3 Hours)
- Data Sorting and Filtering (1 Hour)
- Data Cleaning (1 Hour)
- Data Validation and Protection (1 Hour)
- Case Study: Cleaning a Sales Leads Database
Module 7: Data Manipulation in SQL (4 hours)
- Data Insertion (1 hour)
- Data Update and Deletion (1 hour)
- Data Integrity (1 hour)
- Practicum-Hands-on Exercises (1 hour)
- Case Study: Customer Data Management for an E-Commerce Company
Module 8: Formulas and Functions Excel (4 Hours)
- Basic Formulas (1 Hour)
- Logical Functions (1 Hour)
- Lookup Functions (1 Hour)
- Date and Time Functions (1 Hour)
- Case Study: Budget Analysis for an SME
Module 9: Advanced SQL Concepts (3 hours)
- Subqueries and Nested Queries (1 hour)
- Stored Procedures and Functions (1 hour)
- Error Handling and Transactions (1 hour)
- Case Study: Financial Reporting for a Fintech Firm
Module 10: Data Visualization And Storytelling in Excel(3 Hours)
- Conditional Formatting (1 Hour)
- Charts and Graphs (2 Hours)
- Case Study: Sales Data Visualization for an E-Commerce Store
Module 11: Pivot Tables and Pivot Charts in Excel(2 Hours)
- Creating Pivot Tables (1 Hour)
- Creating Pivot Charts (1 Hour)
- Case Study: Customer Segmentation for a Retail Store
Module 12: Introduction to Power BI (1 Hour)
- Overview of Power BI (20 mins)
- Power BI Components (40 mins)
Module 13: Getting Started with Power BI (2 Hours)
- Installing Power BI Desktop (30 mins)
- Navigating Power BI Interface (45 mins)
- Connect to Data Sources (45 mins)
Module 14: Data Transformation with Power Query (3 Hours)
- Power Query (1 hour)
- Advanced Data Transformation (2 hours)
Module 15: Advanced Excel Techniques (1 Hour)
- Power Query (30 mins)
- Macros and VBA (30 mins)
- Case Study: Automating Report Generation for a Financial Firm
Module 16: Data Modeling and DAX Power BI (3 Hours)
- Creating Data Models (1 hour)
- Data Analysis Expression – DAX (2 hours)
Module 17: Data Analysis with SQL (4 hours)
- Creating Views (1 hour)
- Indexes and Performance Tuning (1 hour)
- Analytical Functions (1 hour)
- Practicum – Hands-on Exercises (1 hour)
- Case Study: Market Analysis for a Marketing Agency
Module 18: Data Visualization and Storytelling Power BI (4 Hours)
- Creating Reports Choosing the Right Chart (2 hours)
- Power BI Visuals (1 hour)
- Interactive Reports (1 hour)
Module 19: Publishing and Sharing Power BI (3 Hours)
- Power BI Service (1 hour)
- Collaboration (1 hour)
- Security (1 hour)
Module 20: Monitoring, Governance, and Data Management
- Monitoring
- Data Governance
- Data Management
- Hands-on Creating Data Governance Plan and Implementing Data Management Practises