Welcome to
Your Path to Mastering Data Analytics
MS Excel
SQL
Power BI
Whether you aspire to become a data analyst, enhance your career prospects, or simply explore the fascinating world of data analytics, Datalitico is here to support your goals. Start your learning journey today and gain the skills and confidence to harness the power of data and become a Data Analyst.
LESSONS
Bite-sized beginner to advanced lessons which will help you learn Data Analysis from scratch.
- Introduction to Excel
- Essential Formulas and Functions
- Formatting and Styling
- Working with Data
- Basic Charts and Graphs
- Working with Tables
- Conditional Logic and Functions
- Data Analysis Tools
- Advanced Formulas and Functions
- Automation and Macros
- Introduction to SQL
- Filtering and Sorting Data
- Working with Multiple Tables
- Aggregating Data with Functions
- Data Manipulation
- Advanced Queries and Subqueries
- Data Modification and Transaction Control
- Views and Stored Procedures
- Advanced Query Optimization
- Advanced Database Concepts
- Introduction to Power BI
- Data Modeling in Power BI
- Building Visualizations
- Advanced Data Transformations and Query Editor
- Power BI DAX
- Power BI Visualizations and Interactivity
- Power Query Advanced Techniques
- Data Modeling and Relationships
- Power BI Administration and Collaboration
- Advanced Analytics and Insights