Data Analysis Bootcamp

SQL

• Master the fundamentals of relational databases and understand their importance in data management.
• Gain proficiency in writing SQL queries to retrieve specific data from databases.
• Create, modify, and manage tables, including defining data types and constraints.
• Explore techniques for filtering, sorting, and aggregating data using SQL.
• Acquire the skills to perform complex data manipulations using subqueries and joins.
• Dive into advanced topics such as window functions to perform complex analytical operations on data.
• Indexing and optimization techniques to improve query performance.
• Working with SQL Server and other relational database management systems (RDBMS).
• Design and implement databases that adhere to best practices.
• Leveraging SQL for data extraction and transformation.
• Understand how SQL fits into the broader landscape of data analysis and data science.
• Gain practical knowledge in troubleshooting common SQL errors and issues.
• Build a strong foundation for further specialization in database administration or data analytics.
• Prepare for real-world challenges by simulating various data-related scenarios.

Python

• Learn core Python syntax, coding, and execution.
• Define variables and work with diverse data types.
• Perform operations on data using assignments.
• Take user input and create meaningful outputs.
• Explore arithmetic, comparison, and logical operators.
• Use conditional statements for decision-making.
• Define, call functions, and grasp their parameters.
• Master lists, dictionaries, and tuples for data storage.
• Utilize loops for iteration, with control statements.
• Learn Pandas, NumPy for data manipulation.
• Create plots charts and beautiful visuals using Matplotlib, Seaborn, and Plotly.
• Apply Python for large data analysis and decision-making.

Power BI

• Understanding key features of Power BI.
• Move from Novice to Intermediate User in Power BI.
• Understand the fundamentals of Querying and Transforming of Data
• Understand the Importance of Data Modelling and Relationship.
• Data Analysis Expression (DAX) and Techniques to Master DAX.
• Reporting and Data Visualization.
• Create Powerful Insights and Dashboard that creates value.
• Learn how to build analytical Dashboard.

Excel

• Understanding of the Excel interface and basic navigation tools
• Knowledge of basic cell formatting, data manipulation, and formula creation
• Ability to create and format spreadsheets including tables, charts, and graphs
• Understanding of data analysis tools such as sorting, filtering, and pivot tables
• Knowledge of conditional formatting, data validation and advanced Excel functions
• Ability to create and manage macros to automate tasks and streamline work processes
• Knowledge of Excel security and collaboration features, such as sharing and password protection
• Understanding of advanced Excel topics such as data consolidation, lookup functions, and text functions.

Tableau

• Data Import, Cleaning, and Preparation
• Creating Basic Visualizations
• Advanced Visualization Techniques
• Connecting to Various Data Sources
• Utilizing Calculations and Expressions
• Interactive Dashboard Design
• Data Exploration and Pattern Recognition
• Integration with Data Analysis Toolkit
• Build end-to-end analytics dashboard
• Recognize the synergy between Tableau and other data analysis tools