- The course provides the complete preparation you need to become a data analyst.
- Understand different data types and their memory usage.
- A Beginner's Guide to Microsoft Excel - Microsoft Excel, Learn Excel, Spreadsheets, Formulas, Shortcuts.
- Quick analysis tools and work using features.
Data analytics provides companies with enhanced visibility and a thorough understanding of their processes and services. It offers detailed insights into customer experiences and identifies customer issues. By moving beyond mere data collection to transforming insights into actionable steps, companies can personalize customer experiences, develop relevant digital products, optimize operations, and boost employee productivity.
- Aspiring data analysts and data scientists.
- IT professionals looking to transition into data analytics.
- Graduates and postgraduates aiming for a career in data analytics
- Anyone interested in leveraging data for business insights and decision-making
- An overview of the screen, navigation and basic spreadsheet operations.
- Understanding workbooks, worksheets, rows, columns, cells.
- Various selection techniques.
- Entering, Editing and Deleting Text, Numbers, Dates.
- Moving and copying data.
- Inserting, Deleting and Hiding Rows & Columns.
- Inserting, Deleting, Moving and Copying Sheets.
- Fill series.
- Formatting Cells with Number formats, Font formats, Alignment, Borders and Patterns.
- Basic conditional formatting.
- Copying and Clearing Formats.
- Working with Styles.
- Spell Check, Find & Replace and AutoCorrect.
- Creating Bar Chart, Column Chart, Pie Chart, Line chart.
- Changing Chart elements, Style, Filter.
- Formatting Chart area, Plot area, Gridlines etc.
- Sorting.
- Filters.
- Subtotal.
- Concept of Formulae.
- Creating Formulae, Editing Formulae, Copying Formulae.
- Using Functions - Sum, Average, Max, Min, Count, Counta, Countif, Sumif, Now etc.
- Applying Absolute (Fixed) Referencing.
- Paste special.
- Page Orientation.
- Adding Headers and Footers.
- Printing a selection.
- Shrink to Fit.
- Repeating columns and rows.
- AImporting data into Excel.
- Protecting specific data and formulae.
- Tracking changes in a workbook.
- Hiding elements of a workbook.
- Workbook security.
- Merging and sharing workbooks.
- Connecting with hyperlinks.
- Preparing workbooks for distribution and review.
- Sharing Excel data externally.
- Using name ranges in formulae.
- Text functions (upper, lower, proper, transpose, concatenate etc.)
- Time & date functions.
- Logical formulae (and, if, not, or, etc.).
- Array formulae.
- Lookup formulae (vlookup, hlookup, index, match etc.).
- Statistical formulae (round, average, max, min, sumif, countif, counta, etc.).
- Complex nested formulae.
- Circular references and other errors.
- Formulae auditing.
- Creating & maintaining data tables.
- Sorting & subtotalling data.
- Auto filter and custom filtering.
- What-if analysis.
- Scenario manager.
- Goal seeker function.
- Solver function.
- Pivot Tables & Charts.
- Creating a pivot table.
- Defining the layout and the presentation of a pivot table.
- Pivoting data elements.
- Selecting, copying, moving or deleting in a pivot table.
- Filtering, sorting and slicing data in a pivot table.
- Pivot charts.
- Selecting the right chart.
- Formatting the labels, titles and legends.
- Managing the axis, data series and scale.
- Modifying and updating source data.
- Saving custom charts.
- Inserting graphic objects.
- Formatting dates, numbers and text.
- Using functions to format text and data.
- Creating and applying custom formats.
- Conditional formatting.
- Installed templates and workbook design.
- Styles & themes.
- Splitting windows and freezing panes.
- Headers, footers and repeated rows/columns.
- Page setup and printing.
- What is a macro?.
- Recording a macro.
- Running a macro.
- Assigning a macro to a button.
- Macro security.
- Editing a macro using VBA.
- Macro security.
- Editing a macro using VBA.
- Writing a macro in the Visual Basic Editor.
- Creating custom functions using VBA.
- Design of dashboard applications.
- What is MySQL?.
- History and versions of MySQL..
- Installation and configuration of MySQL.
- Introduction to MySQL Workbench and other client tools.
- Basic SQL syntax.
- Data types in MySQL.
- Creating and deleting databases.
- Creating, modifying, and dropping tables.
- Updating existing data.
- Deleting data from tables.
- Filtering results with WHERE clause.
- Sorting results with ORDER BY.
- Limiting results with LIMIT.
- Writing and executing basic queries.
- COUNT, SUM, AVG, MAX, MIN.
- Grouping results with GROUP BY.
- Filtering groups with HAVING.
- INNER JOIN, OUTER JOIN.
- LEFT JOIN, RIGHT JOIN, FULL JOIN.
- Writing queries with different types of joins.
- Using subqueries in SELECT, FROM, WHERE, and HAVING clauses.
- Writing and executing subqueries.
- Introductory Remarks about Python.
- Strengths and Weaknesses.
- A Brief History of Python.
- Python Versions.
- Installing Python.
- Environment Variables.
- Executing Python from the Command Line.
- IDLE.
- Editing Python Files.
- Getting Help.
- Dynamic Types.
- Python Reserved Words.
- Naming Conventions.
- Introduction.
- Basic Syntax.
- Comments.
- String Values.
- String Operations.
- The format Method.
- String Slices.
- String Operators.
- Numeric Data Types.
- Conversions.
- Simple Input and Output .
- The print Function.
- Introduction.
- Control Flow and Syntax.
- Indenting.
- The if Statement.
- Relational Operators.
- Logical Operators.
- True or False.
- Bit Wise Operators.
- The while Loop.
- Break and continue.
- The for Loop.
- Introduction.
- Lists.
- Tuples.
- Sets.
- Dictionaries.
- Sorting Dictionaries.
- Copying Collections.
- Summary.
- Introduction.
- Defining Your Own Functions.
- Parameters.
- Function Documentation.
- Keyword and Optional Parameters.
- Passing Collections to a Function.
- Variable Number of Arguments.
- Scope.
- Functions - "First Class Citizens".
- Passing Functions to a Function.
- Mapping Functions in a Dictionary.
- Lambda.
- Closures.
- Overview of Business Intelligence (BI) and Power BI.
- Understanding the Power BI ecosystem.
- Installation and setup of Power BI Desktop.
- Power BI Service overview.
- "GET DATA" from various sources.
- Data Transformation, Benefits of Data Transformation.
- Shape or Transform Data using Power Query.
- Overview of Power Query / Query Editor, Query Editor User Interface.
- Ribbon (Home, Transform, Add Column, View Tabs).
- The Queries Pane, The Data View / Results Pane, The Query Settings Pane, Formula Bar.
- Saving the Work.
- Datatypes, Changing the Datatype of a Column Filter in Power Query.
- Copy Pasting Data.
- Auto Filter / Basic Filtering.
- Filter a Column (Text Filters, Number Filters, Date Filters).
- Filter Multiple Columns.
- Add, Remove, Merge, Name/Rename, Re-Order, PIVOT/UN-PIVOT, Transpose Columns.
- Header Row Promotion.
- Keep Top, Bottom, Range of Rows, Duplicates.
- Remove Top, Bottom, Range of Rows, Duplicates.
- Group Rows / Group By.
- ETL Operations with Power Query.
- Replace Nulls, Fill Up, Fill Down.
- Date and Time Transformations.
- Deriving Year, Quarter, Month, Day.
- Conditional Column transformation.
- Consolidate and Append Data.
- Append data from Excel tables within same Excel file.
- Text functions in Power Query.
- Date functions in Power Query.
- Conditional Functions in Power Query.
- Query Step Inserts and Step Edits.
- Using RELATED function - the lookup of Power Pivot.
- Modeling Data.
- Report View Options: Full, Fit Page, Width Scale.
- Report Design using Databases & Queries.
- Navigation Options and Report Refresh.
- Charts in Power BI (Line, Bar, Pie, Scatter, Waterfall, Funnel).
- Slicers in Power BI.
- Tables.
- Matrix.
- Cards.
- Map Visualizations, for Creating Dynamic Maps Connected to Location Mentioned in Data.
- Gauges and Single Number Cards.
- Understanding Multipliers.
- Field Properties: Axis, Legend, Value, Tooltip.
- Field Properties: Color Saturation, Filters Types.
- Formats: Legend, Axis, Data Labels, Plot Area.
- Data Labels: Visibility, Color and Display Units.
- Data Labels: Precision, Position, Text Options.
- Analytics: Constant Line, Position, Labels.
- Modifying Legends and Visual Filters - Options.
- Map Reports: Working with Map Reports.
- Hierarchies: Grouping Multiple Report Fields.
- Hierarchy Levels and Usages in Visualizations.
- Using Field Hierarchies with Chart Reports.
- Administer and manage Windows Server IaaS virtual machines remotely.
- Manage hybrid workloads with Azure Arc.
- Configure and manage Hyper-V.
- Configure and manage Hyper-V virtual machines.
- Secure Hyper-V workloads.
- Run containers on Windows Server.
- Orchestrate containers on Windows Server using Kubernetes.
