Monday, Friday
7:30 pm – 9:30 pm
42 lessons + 4 exams
Why participate in the Data Analytics course?
Data analytics is applied in many fields of any business that has data. It empowers companies to make efficient decisions regarding their strategy and tactics, analyzing market demand, customers, competitors, and other available data.
The course is designed for complete training in data analysis, during which you will learn for 5 months how to collect and analyze data, as well as how to automate these processes.
The course is based on practical projects, which you will carry out with specialists with many years of experience in the fields of finance, economics, and tech industry.
The Data Analytics full course helps also to develop your analytical and mathematical skills,
At the end of the course, you will acquire data analysis, collection, and evaluation skills, and master the necessary tools (Excel, SQL, Power BI, Tableau, Python, etc.), to start your career as a junior Data analyst.
Individual consultation
before and after the course
Who is the course intended for?
The admission to the course is done through an interview and a test
What are you going to study?
Basic knowledge on Excel
Advanced knowledge on Excel
Power BI & Intro to Tableau
Data driven decision making
SQL for Data Analytics
Automating Data Analytics with Python
Trainers
Course program
- Course Introduction
- Data Analytics in Different Sectors
Calculation and Tables, Home Tab
Page Layout, Review, View
Most frequently used functions
- Spreadsheet analytical techniques: Overview
- The Fill Handle & Autocorrect
- Data Validation
- Conditional Formatting
Circular References: Iterations
- What-If Controls: The Goal Seek Command & Solver: Introduction
- What-If Controls: One & Two-Dimensional Data Tables
- What-If Controls: Using the Scenario Manager for Sensitivity Analysis
- Charts & Graphics: Plotting Data
- Combining Chart Types: Falling ball speed
- Measures of Central Tendency, Asymmetry, and Variability
- Correlation & Predictability
- Integration & Differentiation
- Regression and Curve Fitting
- Multiple Regression: Linear Estimates
- Nonlinear Regression, Dealing with Categorical Data
- Confidence Intervals & Hypothesis Testing
- Linear algebra: Reiterations and Matrixes
- Linear algebra: Solving Equations
- Types of Distributions: Sampling distribution
- Sampling Techniques
- Types of Random variables: Discrete & Continuous
- Probability Distributions
- “Frequestist” Probability: Monte Carlo Simulations, Bayesian probability
- Profitability Analysis
- Time Series Analysis and Forecasting
- Marketing strategy analysis: Demand curve & Pricing
- Value at Risk: Non Parametric (Historical) VaR
- Variance-Covariance, Risk modeling
- Probabilities in action: Calculating an Optimal Bid
- Excel exam
- SQL for Data Analytics
- What is a Database? — Definition, Meaning, Types, Example
- Describing the fundamental building blocks: tables, columns, primary keys, and foreign keys
- Relational Databases and SQL
- Basic Data Types of SQL
- Numeric
- Character
- Boolean
- Datetime
- Learn to write common SQL commands including SELECT and FROM
- Retrieving data with SELECT
- Specifying column expressions
- Sorting the result with ORDER BY – DESC ,ASC Query with EXAMPLE
- Handling NULL values in expressions
- Restricting rows with the WHERE filter AND, OR, IN, NOT IN Query
- Testing for equality or inequality
- Applying wildcard characters — Like, NOT Like, Escape, ( % ), ( _ )
- Avoiding NULL value pitfalls – IS NULL , IS NOT NULL
- LIMIT , OFFSET — Learn with Example
- Introduction to single row functions
- Character Functions
- Numeric Functions
- Conversion Functions
- Date Functions
- Conditional formatting with the CASE expression
- • Utilizing the CASE expression to simulate IF tests
- Date Functions
- Utilizing the CASE expression to simulate IF tests
- Building the Database Schema and SQL Basics
- Building tables with CREATE TABLE
- Modifying table structure with ALTER TABLE
- Adding columns to an existing table
- Removing tables with DROP TABLE
- Protecting data integrity with constraints
- Guaranteeing uniqueness with primary key constraints
- Enforcing integrity with foreign key constraints
- Improving performance with indexes
- Manipulating Data
- Adding table rows with INSERT
- Changing row content with UPDATE
- Removing rows with DELETE
- Learn to write INNER JOINs to combine data from multiple tables
- Learn to write LEFT JOINs and RIGHT JOINs to combine data from multiple tables
- Creating a Cartesian product with CROSS JOIN
- Stacking results with UNION
- Identifying matching rows with INTERSECT
- Testing the existence of rows
- Placing subqueries in the column list
- Creating complex expressions containing subqueries
- Selecting data from a query result set
- Summarizing data using SUM, AVG and COUNT
- Finding the highest/lowest values with MAX and MIN
- Defining the summary level with GROUP BY
- Applying filter conditions with HAVING
- Introduction to Analytic functions
- Syntax for Analytic functions
- the Partition Clause
- Order By Clause
- Row number Functions
- Rank Function
- Dense_rank Function
- Lag Function
- ListAgg Function
- Lead Function
SQL exam
- Introduction
- Downloading Power BI & adjusting settings
- Exploring the Power BI Desktop interface & workflow
- Helpful Power BI resources
- Connecting and Shaping Data with Power BI Desktop
- Connect to data sources
- Types of data connectors in Power BI Desktop
- Change the data source settings
- The Power BI Query editor (aka Power Query)
- Basic table transformations in Power BI
- Working with text tools
- Working with numerical values
- Working with date & time tools
- Shape and transform tables
- User-friendly naming conventions
- Resolving inconsistencies & nulls
- Evaluate and transform column data types
- Append queries
- Merge queries and expand table
- Merge queries with group by, and different types of joins”
- Pivot & Unpivot
- Conditional columns
- Columns from examples
- Transpose
- Data profiling
- Resolve data import errors
- Files from folders
- What is a “Data Model”?
- Principles of data normalization
- Understanding data tables vs. lookup tables
- Creating table relationships in Power BI Desktop
- Design a data model that uses a “Star” schema
- “Snowflake” schemas in Power BI
- Managing & editing table relationships in Power BI Desktop
- Managing active vs. inactive relationships
- Understanding relationship cardinality
- Understanding filter flow
- Two-way filters in Power BI Desktop (USE WITH CAUTION!)
- Hiding fields from the Power BI report view
- Table and column properties
- Common date table (using DAX and Power Query)
- Hierarchies and data granularity
- Role playing dimensions
- Power BI data model best practices
- Intro to Data Analysis Expressions (DAX)
- Intro to DAX calculated columns
- Basic operators IF, BLANK and ISBLANK
- Measures -an introduction, with standard aggregations including COUNTBLANK
- Aggregation of calculations
- Other statistical functions
- Rounding functions
- Division functions – MOD and QUOTIENT SIGN (and use with SWITCH) and ABS
- Text searching
- Text extraction and substitution
- Text conversion
- Other text functions
- ISERROR and LOOKUPVALUE
- Other information functions
- RELATED – Flatten out a parent-child hierarchy
- RELATEDTABLE and COUNTROWS
- ALL, FILTER, CALCULATE, ALLEXCEPT, ALLSELECTED
- Date and time functions, FIRSTDATE, LASTDATE
- Start of… and End of…, Previous… and Next…
- DATESINPERIOD, DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD
- Opening Balance and Closing Balance
- Semi-additive measures
- SAMEPERIODLASTYEAR and PARALLELPERIOD
- Other Time Intelligence Functions
- Quick measures
- Exploring the “Report” view in Power BI Desktop
- Table and matrix
- Column charts, line charts and area charts
- Combo charts and treemaps
- Card, multi-row card, and gauge visual
- Pie chart, donut chart and funnel
- Scatter chart, waterfall chart and maps
- Customize and configure visuals
- Custom tool tips
- Configure report page
- Conditional formatting
- Applying slicing and filtering
- Sorting
- Synch slicers
- Using themes
- Bookmarks
- Page navigation
- Edit interactions
- Analyze feature, Identify outliers
- Create groups, bins and clusters
- Analytics pane, Forecast feature
- Logging into Power BI Service and a quick look around
- Power BI terminology
- Datasets and Reports in Power BI Service
- Publish reports and export data
- Create a workplace
- Manage tiles in a dashboard
- Analyze in Excel feature
- Connect to data sources
- Prepare data for analysis
- Customize fields
- Understand dimensions and measures
- Understand discrete and continuous fields
- Understand aggregations
- Create basic charts
- Create and use filters
- Create parameters to enable interactivity
- Create calculated fields
- Create table calculations
- Structure the data
- Map data geographically
- Create dashboards and stories
- Summarize, model, and customize data by using the Analytics feature
Power BI exam
Python basics
- Syntax
- Variables & Data Types (Strings, Numbers)
- Getting Input from Users
- If Statement
- Lists, Tuples, Sets, Dictionaries
- Loops
- Functions, Lambda
- Error handling (Try / Except)
- Built-in packages (random, os, request, math)
- Python for data analysis
- Data frames, reading data from csv, html, json
- Filtering, and sorting
- Adding/removing columns
- Updating Rows and Columns
- Conditional changes
- Join, merge, append
- Indexing
- Aggregation
- Cleaning data
- Casting datatypes
- Working with datetime
- Line plot
- Bar chart
- Pie chart
- Histogram
- Time series
- Subplots
Python exam
Get a free consultation
Why BDG?
15 years of experience in the field
Professional trainers
Individual consultation
Assistance in finding a job
Courses for all levels
30,000+ graduates
Permanent discount for further lessons
450 successful students per year
Application of successful methods
An objective procedure for selecting students
3 types of certificates
Permanent contact with the student
Special benefits for
BDG students
Providing internship opportunities or job search assistance, from CV consultation to interview preparation
Individual approach in case of not understanding the topic, having a technical problem or any other issue
BDG community membership, joining 25,000 BDG members and creating network with them.
Special conditions for participating in other online and offline courses and events
These certificates are proof of your knowledge
3 types of certification
Certificate of participation
It is given in case of 30-49% progress
Certificate of completion
It is given in case of 50-79% progress
Certificate of excellence
It is given in case of 80% + progress
How do we help
our students
find a job?
Compilation of a competent CV
Professional Linkedin Page Design
Preparation for the interview with the employer
Mentoring partner organizations in the relevant position
Contact with Talent Success Manager
Leave your details if you are from the BDG community
BDG in 2023
Students
0+
Trainers
0+
Projects
0+
Collaborations
0+
What do students think about this course?
Maria Sinanyan
I recently completed the BDG SMM Architecture program, and I want to express my gratitude to the entire team, particularly Arman Chilingaryan, for their significant contributions. It’s challenging to put into words the level of competence demonstrated in their teaching. I highly recommend BDG training to anyone interested.
Mariam Tunyan
Hasmik Hakobyan
Artin Alexanyan
I have just completed the Graphic Design Advanced course at BDG. The course comprised 7 modules. Our main mentor throughout was Shushan Tonoyan, although each module had its own mentor. We were taught by such skilled professionals as Shushan Tonoyan, Ruben Malayan, Hasmik Avetisyan, Mariam Kanayan, Ara Aslanyan, and Varsine Gevorgyan. The course was fantastic and highly informative. I thoroughly enjoyed the organization and professionalism of the course. It provided me with new skills and a wealth of useful information. I can definitely recommend taking this course for a very good education.
Masha Keheyan
Amazing organization! Great support from all of the team members. I would recommend them unreservedly. Thank you Arman Chilingaryan jaaan for your kind attention, for your patience. Thank you for creating an #educated_professional in me. I love you BDG team.
Syuzanna Sargsyan
Thank you BDG team for well-organized training. Special thanks to Susanna Amiryan, You really gave me good knowledge and skills. You’re a wonderful person!
Gayana Gasparyan
Thank you to the entire BDG team for your competent and professional work. I would definitely recommend BDG, because if you participate in one of the courses, you can become a member of the BDG family, where you will always be supported. During the lessons we received not only theoretical information, but also systematic practical knowledge, due to which the courses became more interesting and effective. Trust me, if you want to get “cool knowledge”, meet happy and positive people, then this is your place. I would like to thank the BDG family for the friends and lecturers I have gained through lessons, who have become advisors on professional achievements.
Manana Melqonyan
HIGHLY RECOMMENDED!!! 5 stars! I have attended the course of HR Management. Professional and supportive team, the trainer Anush Manucharyan is just fantastic. Whole programm is very informative, proactive and amazingly organized. Happy to have such great experience. I recommend it to everyone who wants to start new career in HR. Thank you BDG team; Tigran, Shant and, of course, Anush Manucharyan jan. Hope to participate in other trainings as well.
Ruben Harutyunyan
It’s a pity that one of the colorful periods of our lives is over. A period when we gained practical knowledge, a wonderful environment and friends. I want to express special thanks to Vahagn, due to whose efforts we will become successful professionals in life. And there are no words about Sona. Always friendly, smiling and ready to help. Who knows where our roads will cross, where we will meet again, smile and greet each other warmly. We are leaving each other with the expectations of meetings, and may success accompany us on our future road. Dear Vahagn Karamyan, many thanks.
Bella Mihranyan
Recently finished the Agile Project Management course organized by BDG. I would like to express my deep gratitude to BDG staff for organizing it effectively and, most importantly, for choosing such a unique trainer for us, Siranush Kostanyan. I admire her knowledge, professionalism and compassion. A personality whose students fully master the material, due to lovingly sharing his vast knowledge. Dear Siranush, I am proud that there are experts like you in our country and I am sure that their number will increase with your own help and support.
Narek
It was my great pleasure to work with BDG. I took 2 courses: “UX/UI for Beginners” and “Motion Design”.
I not only gained much knowledge and practical skills but also made great connections. The learning process here is very much motivating which is due to the amazing team.
I surely recommend Business Development Group
Hranush Araqelyan
I really loved studying here. Our online lessons were well-organized and informative!
Suren Shamamyan
After successfully completing the “Manual QA” and “Automation QA” courses at BDG, I had more than 10 interviews in 2 months and got a couple of job offers from famous IT companies.
Great thanks to all the employees, my trainers and the management of the company for organizing and conducting the courses I have completed and if you are not tired of me, I`ll be back.
Ruz Gasparyan
Thanks for the best customer service ever and good recommendation! I really appreciate your thoughtfulness and professionalism to each student. Really love and enjoy classes. Armas is my marketing class trainer! Huge thanks to him, for individual assistance and limitless tolerance!
Amali Grigoryan
Thank you for the warm atmosphere and great education. Special thanks to Arman, who, in addition to a good education, showed a specific approach and kind attitude to each of us.
Johnny Zgchanian
I studied UX|UI Design for the second time and really liked it. I wish it lasted more, though.
Anna Mkrtchyan
I chose the course organized by BDG from the torrent of offers to learn SMM, and from the very first day I was sure I made the right decision. Trainer Arman Chilingaryan’s lessons were full of theory, practice and humor, for which I am very grateful. I am very glad that I trusted the first stage of discovering new professional field in BDG. There is no need to talk about the professionalism of the staff and the positive atmosphere.
Narine Hakobyan
HIGHLY RECOMMENDED! I have attended the course Manual QA Engineer. Professional and supportive team, the trainer Almast Amiryan is just AMAZING. Happy to have such a great experience and new opportunities. Thank you BDG team you are AWESOME. Looking forward to participating in other training courses as well.
Sus Sargsyan
I have taken the ”Agile Project Management Essentials” course with Siranush Kostanyan. It has been a great experience for me.
Ani Gharibyan
If you want to be a Quality assurance (QA) engineer, set a goal and BDG will help to achieve your goal. It’s a very good training center with excellent staff and highly-qualified trainers.
Ani Vardanyan
I have taken the course of Agile Project Management Essentials. Everything was organized at a high level. The course consists of not only theory but also effective workshops.
Maria Sarkisova
Great and organized staff, warm atmosphere and helpful coaches. Thanks a lot for the given information.
Adel Michaelyan
I have recently completed my UX/UI intermediate level design course, and I want to say a big thank you to the lovely staff of BDG for their professionalism and wonderfulness. Thanks to these lessons I have deepened my knowledge in UX/UI design, and become more confident in the world of design. I am confident that after this course, if I work hard I’ll find job that I dream.
We Collaborate with the best ones
We are trusted by well-established, successful companies that prioritize education. We are certain that education will lead us to success․
