Data Analytic Principles/Habits

Learn Excel, MySQL, Python, PowerBI, ChatGPT for A-Z Data Analysis. Become a Full-Packed Data Analyst. [5 Courses in 1]

Created by: Shahriar's Sight Academy
Empowering Tomorrow's Data Leaders

What Will I Learn?

• Gain proficiency in Excel, SQL, Python, Power BI and ChatGPT to prepare for a career as a data analyst with essential skills and knowledge.
• Learn facts and theories for Data analysis, Statistical analysis, Hypothesis testing, and Machine learning for foundations of data analytics.
• Learn Excel for data Cleaning and Manipulation methods, Sorting and conditional Filtering, Formulas, and Functions, Graphs and Charts.
• Learn Excel for advanced analysis in PIVOT tables and charts, Data Analysis ToolPak for statistical analysis and interactive Dashboard.
• Learn RDBMS fundamentals, covering key concepts such as Primary and Foreign keys, Data types, and the various types of RDBMS and more.
• Learn MySQL for manipulation of Tables, Columns, Constraints, Indices, Null values, Filtering, Joining methods.
• Learn the important Python basics such as Variables, Data types, Lists, Dictionaries, Dataframes, Sets, Loops, Functions etc.
• Master Python for data Cleaning, data Manipulation, data Analysis, Transformation, and data Preprocessing.
• Learn to use Python for data Visualizations, Exploratory data analysis, Statistical analysis, and Machine learning models.
• Utilize ChatGPT for advanced data manipulation tasks, such as merging datasets, creating pivot tables, and applying conditional logic.
• Learn to apply ChatGPT for predictive analytics, including random forest regressor and other machine learning models.
• Learn Power Bi for data manipulation, analysis and extract significant insight and prepare for attractive dashboard.
• Use Power BI to create a professional, informative and amazing dashboard that tells story about your data and provide insights.
• Overcome 50+ practical assignments, 140+ coding exercises, 10 quizzes with 100+ questions, on all the topics over the entire career track.
• Accomplish THREE capstone projects: Bank churn analysis, Sports data analytics and Website performance analysis.

Requirements

• Access to computer and internet
• Basic computer literacy
• No coding experience required
• Dedication, patience and perseverance

Target audience

• Those who are interested in entering the field of data analytics and want to learn the complete tools and techniques used in the industry.
• Those who are highly interested in learning complete data analytics using Excel, SQL, Power BI, Python and ChatGPT.
• This course is NOT for those who are interested to learn data science or advanced machine learning application.