Online course
Data Analytics & Business Storytelling
Learn data analytics, data processing, and data visualization with SQL and Power BI through practical training built around real business use cases.
Bridge the gap between basic knowledge and applicable analytical techniques, improving your analytical maturity to confidently “tell the story” of your business through data.
Start
March 2025
Duration
70 hours (28 classes and workshops)
Schedule
Monday (17:30-20:00)
Wednesday (17:30-20:00)
Every other Friday (17:30-20:00)
Technical workshop
After every 5th class (17:30-20:00)
Consultations
Two individual classes (30 minutes each) online or on-premises
Price
39.000 MKD
Course Description
Data Analytics & Data Storytelling for Business Professionals is a practical training for data analysis. It was created to help professionals from different business domains fully utilize their existing data knowledge.
This 70-hour course helps participants master the fundamentals of SQL programming and Power BI through interactive lectures and hands-on exercises.
This course bridges the gap between basic knowledge and applicable analytical skills and addresses the needs of professionals in fields like retail, finance, insurance, banking, and marketing.
Starting with foundational concepts, participants will progress to data analysis techniques with SQL and data modeling and visualization with Power BI. This structured program allows learners to make data-driven decisions and improve their analytical capabilities.
Modules
Introduction to Data Analysis
- Introduction to Data Analysis and Business Intelligence
- Importance of data in business and data-driven decisions
- Future of Data Analytics and why it’s important
- Introduction to SQL and Power BI
SQL for Data Analysis
- Data query using SQL Server
- SQL syntax relevant to data analysis tasks
- Techniques essential for extracting, manipulating, and analyzing data in a relational database environment
Power BI Concepts
- Introduction and navigation in Power BI
- Connections and Data Sources
- Data Modeling
- Power Query Editor and Data Transformation
DAX for Data Analysis and Visualizations in Power BI
- Introduction to DAX, calculated columns and measures
- CALCULATE function and aggregations
- Time intelligence functions
- Advanced DAX techniques for measures and columns (VAR, SUMX, MAXX)
Power BI Service
- Introduction to Power BI Service
- Sharing, collaborating, and managing reports online in Power BI Service
- RLS (Row-Level Security) in Power BI
- Creating, organizing, and deploying Power BI content to workspaces
Use Cases & Knowledge Checks
- Four different use cases from multiple business domains that include different data sources, data transformation, and solving a business challenge
- Knowledge checks of the covered material and skills throughout the program
Introduction to Data Analysis
- Introduction to Data Analysis and Business Intelligence
- Importance of data in business and data-driven decisions
- Future of Data Analytics and why it's important
- Introduction to SQL and Power BI
SQL for Data Analysis
- Query data using SQL Server
- SQL syntax relevant to data analysis tasks
- Techniques essential for extracting, manipulating, and analyzing data in a relational database environment
Power BI Concepts
- Introduction and Navigation in Power BI
- Connections and Data Sources
- Data Modeling
- Power Query Editor and Data Transformation
DAX and Visualizations in Power BI
- Introduction to DAX, calculated columns and measures
- CALCULATE function and aggregations
- Time intelligence functions
- Advanced DAX techniques for measures and columns (VAR, SUMX, MAXX)
Power BI Service
- Introduction to Power BI Service
- Sharing, collaborating, and managing reports online in Power BI Service
- RLS (Row-Level Security) in Power BI
- Creating, organizing, and deploying Power BI content to workspaces
Use Cases & Knowledge Checks
- Four different use cases from multiple business domains that include different data sources, data transformation, and solving a business challenge
- Knowledge checks of the covered material and skills throughout the program
Why Data Masters?
- The training was developed by experienced consultants at Data Masters, who bring their expertise from working on different consulting projects and apply numerous analytics techniques on a daily basis.
- This program is the third iteration of our introductory training in data analytics, refined based on past experiences and tailored to meet the growing needs of the market and individuals seeking to improve data usability.
- The lectures focus on interaction and collaborative problem-solving, encouraging participants to actively engage with the program. The workshops and exercises are designed to immerse participants fully in the learning process.
- A Holistic Approach: In addition to sharing their technical and business expertise, Data Masters consultants will train participants to apply their newly acquired skills in their current workplace or use them to pursue a complete career change.
Student Testimonials
A few words from the co-founder
Martina Naumovska, co-founder of the Academy and Head of Data Science at Data Masters
“From our experience so far, everyone who decided to improve their career did not regret the decision. Investing in yourself and your future is the best gift you can give to yourself. We as Data Maters are ready to selflessly transfer our knowledge and guide our students to achieve their goals.“
This course is for you if:
- You want to automate and improve your daily work in Excel.
- You deal with creating manual reports on a daily, weekly, monthly, or yearly basis.
- You have essential domain knowledge of the business you work in, but you lack analytical and technical skills.
- You want to upgrade your career and make decisions based on data, transitioning into analytical roles.
The Lecturers
Make the next step toward your future – apply now!
