Monday, Friday
7:30 pm – 9:30 pm
42 lessons + 4 exams
Why participate in the Data Analytics course?
In this course, you’ll learn the basics of data science, such as analyzing data, making predictions with machine learning, and even building neural networks. You’ll build projects to help you get ready for working in the field of Data Analytics. Data Analytics course provides all the necessary skills and knowledge to become a data analyst. During the course, the student will gain knowledge about Excel, SQL, Power BI, Tableau, Python, and learn to work with data, analyze and make reports using these tools.
If you want to:
- develop analytical thinking skills,
- gain knowledge necessary to become a data analytics professional,
- work with big data,
- acquire an in-demand profession,
then this course is for you.
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
- Subtotals
- Data Validation
- Conditional Formatting
- Filtering Tools and Removing Duplicates
- Consolidating Data
- 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
- Pivot Table & Pivot Chart
- Un-pivot Data, Slicers & Timelines
- Calculated Field, Grouping & External connections (i.e. SQL Statements)
- Charts & Graphics: Plotting Data
- Combining Chart Types: Falling ball speed
- Descriptive Statistics, working with Trends
- Measures of Central Tendency, Asymmetry, and Variability
- Correlation & Predictability
- Regression and Curve Fitting
- Multiple Regression: Linear Estimates
- Nonlinear Regression, Dealing with Categorical Data
- Curve Fitting: Sigmoid Curves
- Confidence Intervals & Hypothesis Testing
- Linear algebra: Reiterations and Matrixes
- Linear algebra: Solving Equations
- Types of Distributions: Sampling distribution
- Sampling Techniques
- Decision trees: Option Pricing
- Monte Carlo Simulations
- Formulas for Financial Applications and Modeling: Profitability Analysis
- Time Series Analysis and Forecasting
- Marketing strategy analysis: Demand curve & Pricing
- Solving LP Problems in Excel with Solver for business modeling (with sensitivity analysis)
- Value at Risk: Non Parametric (Historical) VaR
- Variance-Covariance, Risk modeling
- Probabilities in action: Calculating an Optimal Bid
- Relational Databases and SQL
- Numeric
- Character
- Boolean
- Date time
- The SELECT Query
- Basic Anatomy and Working of a SELECT Query
- Basic Keywords in a SELECT Query
- Filtering, Ordering, Alias
- Views and Index
- String Functions
- Mathematical Functions
- Date – Time Functions
Creating Tables
- Creating Blank Tables
- Creating Tables with SELECT
- The COPY Command
- Import data from Excel
- Exporting Data to a File for Further Processing in Excel
Updating Tables
- Adding and Removing Columns
- Adding New Data
- Updating Existing Rows
Deleting Data and Tables
- Deleting Values from a Row
- Deleting Rows from a Table
- Deleting Tables
- Types of Joins
- Subqueries
- Unions
- Using the CASE WHEN Function
- Aggregate Functions
- Aggregate Functions with GROUP BY
- GROUP BY
- Multiple Column GROUP BY
- The HAVING Clause
- Window Functions
- The Basics of Window Functions
- Statistics with Window Functions
- 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
- Data loading with parameters
- 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
- AND, OR and NOT
- SWITCH
- 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
- COUNT functions (COUNTA, DISTINCTCOUNT, COUNTROWS), exponential function
- 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
Introduction to Tableau. Understanding Tableau Concepts
- 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
- Intro to programming, Python Interpreters
- Syntax
- Variables & Data Types (Strings, Numbers)
- Getting Input from Users
- If Statement
- Lists, Tuples, Sets, Dictionaries
- Loops
- Functions, Lambda
- Error handling (Try / Except)
- Reading and Writing Files
- Object oriented programming (Classes & Objects, Inheritance) Part1
Built-in packages (random, os, request, math)
- NumPy Arrays & Array Properties
- Array Creation
- Random Number Generation
- Indexing & Slicing Arrays
- Array Operations
- Filtering Arrays & Modifying Array Values
- The Where Function
- Array Aggregation
- Array Functions
- Sorting Arrays
- Vectorization
- Broadcasting
- 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
Get a free consultation
Why BDG?
14 years of experience in the field
Professional trainers
Individual consultation
Assistance in finding a job
Courses for all levels
24,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 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
Yearly Data
Students
0+
Trainers
0+
Projects
0+
Collaborations
0+
What do students think about this course?
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․
